【已解决】通过 SELECT INTO OUTFILE 导出结果集到阿里云OSS报错

Viewed 35
2.0

查询Doris2.0.6中的表，将查询得到的数据导入到OSS对象存储，报错信息如下：

ERROR 1105 (HY000): errCode = 2, detailMessage = (10.0.1.214)[INTERNAL_ERROR]IOError: [IO_ERROR]failed to create multipart upload(bucket=loyin-file, key=oss-cn-shanghai.aliyuncs.com/loyin-file/4bb0dd8f3c6f45c7-8f54b549f02ed262_0.parquet, upload_id=): curlCode: 77, Problem with the SSL CA cert (path? access rights?), exception , error code -1

	0#  doris::io::S3FileWriter::_create_multi_upload_request() at /home/zcp/repo_center/doris_enterprise/doris/be/src/common/status.h:379
	1#  doris::io::S3FileWriter::appendv(doris:

查询脚本如图所示：
image.png

图图17
2 Answers

检查下CA证书的连接和访问权限问题

徐振超@SelectDB6756

翻了下aliyun官方文档，修改下传参就可以了

"s3.endpoint" = "http://oss-cn-shanghai-internal.aliyuncs.com"
图图17