使用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,又成功了。。。