aliyun-maxcompute-data-collectors icon indicating copy to clipboard operation
aliyun-maxcompute-data-collectors copied to clipboard

trino connector访问MaxCompute报schema不存在

Open ChenShuai1981 opened this issue 1 year ago • 0 comments

$ bin/trino-cli --server localhost:19090 --catalog odps; trino> show schemas; Schema

hyq_prd
information_schema (2 rows)

Query 20231129_025900_00012_dw5sy, FINISHED, 1 node Splits: 19 total, 19 done (100.00%) 0.22 [2 rows, 35B] [9 rows/s, 163B/s]

trino> use hyq_prd; Query 20231129_025904_00013_dw5sy failed: Schema does not exist: odps.hyq_prd

trino> use information_schema; USE trino:information_schema>

odps.properties内容如下

connector.name=odps odps.project.name=hyq_prd odps.access.id=xxx odps.access.key=xxx odps.end.point=http://service.cn-shanghai.maxcompute.aliyun-inc.com/api odps.input.split.size=64

明明show schemas时列出来的schema,use 语句执行报schema不存在 补充一点,odps项目没有开启三层模型,即没有申请开启schema公测

ChenShuai1981 avatar Nov 29 '23 03:11 ChenShuai1981