doris导出oss间歇性成功,一会成功一会失败

Viewed 51

使用S3协议

EXPORT TABLE test_database.xxxx 
TO "s3://xxxx/xxxx" 
PROPERTIES(
    "format" = "csv",
    "max_file_size" = "2048MB",
    "label" = "export_xxxxx_test"
) WITH s3 (
    "s3.endpoint" = "xxxxx",
    "s3.region" = "xxxx",
    "s3.secret_key"="xxxx",
    "s3.access_key" = "xxxx"
);

通过更换label,然后执行该SQL,一会成功,一会失败。
失败的时候报如下错误:

type:RUN_FAIL; msg:errCode = 2, detailMessage = (192.168.23.211)[INTERNAL_ERROR]failed to put object s3://xxxx.oss-cn-hangzhou.aliyuncs.com/xxxx/205344-6045254d4fe5db2644d9c-b810ceeb797f6b0f_0.csv, upload_id=: InvalidBucketName Unable to parse ExceptionName: InvalidBucketName Message: The specified bucket is not valid. code=400 type=100, request_id=671A3E921AFF6535313CC2C8

有的时候还会报这个错误:

type:RUN_FAIL; msg:errCode = 2, detailMessage = (192.168.25.189)[E-256]failed to put object s3://xxxx.oss-cn-hangzhou.aliyuncs.com/xxxx/205344-8ec98cef566629787413b-8ff9825a8c4042cf_0.csv, upload_id=: InvalidAccessKeyId The OSS Access Key Id you provided does not exist in our records. type=23, request_id=671A3E150747933131C88102

有的时候再换一下label,又成功了。。。

0 Answers