2.0.0-alpha1版本, 使用multi catalog方式读取数据存储在华为云OBS上的hive数据, 报错: [INVALID_ARGUMENT]S3 properties are incorrect, hive表存储在obs上的数据格式为ORC
详情报错:
2023-05-31 19:02:34,242 WARN (mysql-nio-pool-11|396) [StmtExecutor.executeByLegacy():731] execute Exception. stmt[197, 5a82cc8817d24d77-8c703c4b1912b11f]
org.apache.doris.common.UserException: errCode = 2, detailMessage = (10.11.32.57)[INTERNAL_ERROR]failed to init reader for file obs://xxx-obs/user/hive/warehouse/test.db/test_table/p_date=2023-05-11/tmptyyesgzi, err: [INVALID_ARGUMENT]S3 properties are incorrect, please check properties.
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:1207) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:1350) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1316) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleQueryWithRetry(StmtExecutor.java:582) ~[doris-fe.jar:1.2-SNAPSHOT]
创建catalog语句
CREATE CATALOG hive PROPERTIES (
'type'='hms',
'hive.metastore.uris' = 'thrift://1xx:9083,thrift://1xxx:9083',
'fs.obs.access.key' = 'xxx',
'fs.obs.secret.key' = 'xxx',
'fs.obs.endpoint' = 'obs.cn-north-4.myhuaweicloud.com'
);