doris用catalog连接max_compute时,用select查询报错The specified project or table name is not valid or missing. #50989
Unanswered
LT-Hub
asked this question in
A - General / Q&A
Replies: 1 comment
-
我采用的这种方式创建catalog: |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
doris用catalog连接max_compute时,用select查询报错The specified project or table name is not valid or missing.
我用desc 表 能查看到表,用select * from 表, 如果这个表是空表也能查询,但是如果这个表不是空表的话,就会报错
select setl_time,fix_blng_admdvs from dwd_fin_setl_d where etl_date = '202505' limit 10;
java.lang.RuntimeException: java.io.IOException: The specified project or table name is not valid or missing.
at org.apache.doris.nereids.glue.translator.PhysicalPlanTranslator.translatePlan(PhysicalPlanTranslator.java:287) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.splitFragments(NereidsPlanner.java:441) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.distribute(NereidsPlanner.java:527) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.lambda$plan$0(NereidsPlanner.java:149) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.planWithLock(NereidsPlanner.java:225) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.plan(NereidsPlanner.java:145) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:833) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:614) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.queryRetry(StmtExecutor.java:576) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:561) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:350) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:250) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:207) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:235) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:415) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
at java.lang.Thread.run(Thread.java:842) ~[?:?]
Caused by: java.lang.RuntimeException: java.io.IOException: The specified project or table name is not valid or missing.
at org.apache.doris.datasource.maxcompute.source.MaxComputeScanNode.getSplits(MaxComputeScanNode.java:653) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.createScanRangeLocations(FileQueryScanNode.java:368) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.doFinalize(FileQueryScanNode.java:222) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.finalizeForNereids(FileQueryScanNode.java:213) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.glue.translator.PhysicalPlanTranslator.translatePlan(PhysicalPlanTranslator.java:285) ~[doris-fe.jar:1.2-SNAPSHOT]
... 18 more
Caused by: java.io.IOException: The specified project or table name is not valid or missing.
at com.aliyun.odps.table.read.impl.batch.TableBatchReadSessionImpl.planInputSplits(TableBatchReadSessionImpl.java:206) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.batch.TableBatchReadSessionBase.(TableBatchReadSessionBase.java:92) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.batch.TableBatchReadSessionImpl.(TableBatchReadSessionImpl.java:96) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.TableReadSessionProviderImpl.createBatchReadSession(TableReadSessionProviderImpl.java:47) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.TableReadSessionBuilder.buildBatchReadSession(TableReadSessionBuilder.java:194) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at org.apache.doris.datasource.maxcompute.source.MaxComputeScanNode.createTableBatchReadSession(MaxComputeScanNode.java:207) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.maxcompute.source.MaxComputeScanNode.getSplits(MaxComputeScanNode.java:650) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.createScanRangeLocations(FileQueryScanNode.java:368) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.doFinalize(FileQueryScanNode.java:222) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.finalizeForNereids(FileQueryScanNode.java:213) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.glue.translator.PhysicalPlanTranslator.translatePlan(PhysicalPlanTranslator.java:285) ~[doris-fe.jar:1.2-SNAPSHOT]
... 18 more
Caused by: com.aliyun.odps.OdpsException: The specified project or table name is not valid or missing.
at com.aliyun.odps.rest.RestClient.handleErrorResponse(RestClient.java:411) ~[odps-sdk-core-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.rest.RestClient.request(RestClient.java:344) ~[odps-sdk-core-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.rest.RestClient.request(RestClient.java:302) ~[odps-sdk-core-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.rest.RestClient.stringRequest(RestClient.java:278) ~[odps-sdk-core-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.batch.TableBatchReadSessionImpl.planInputSplits(TableBatchReadSessionImpl.java:140) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.batch.TableBatchReadSessionBase.(TableBatchReadSessionBase.java:92) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.batch.TableBatchReadSessionImpl.(TableBatchReadSessionImpl.java:96) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.impl.TableReadSessionProviderImpl.createBatchReadSession(TableReadSessionProviderImpl.java:47) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at com.aliyun.odps.table.read.TableReadSessionBuilder.buildBatchReadSession(TableReadSessionBuilder.java:194) ~[odps-sdk-table-api-0.49.0-public.jar:0.49.0-public]
at org.apache.doris.datasource.maxcompute.source.MaxComputeScanNode.createTableBatchReadSession(MaxComputeScanNode.java:207) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.maxcompute.source.MaxComputeScanNode.getSplits(MaxComputeScanNode.java:650) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.createScanRangeLocations(FileQueryScanNode.java:368) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.FileQueryScanNode.doFinalize(FileQueryScanNode.java:222) ~[doris-fe.jar:1.2-SNAPSHOT]
Beta Was this translation helpful? Give feedback.
All reactions