danhuawang opened a new issue, #10926: URL: https://github.com/apache/gravitino/issues/10926
### Version main branch ### Describe what's wrong ``` trino --server http://34.138.225.171:8080 --debug trino> SELECT * FROM remote_irc.test.sales_performance_view; Query 20260430_103628_00078_p5mkp failed: line 1:15: Failed analyzing stored view 'remote_irc.test.sales_performance_view': line 7:3: Schema 'test' does not exist io.trino.spi.TrinoException: line 1:15: Failed analyzing stored view 'remote_irc.test.sales_performance_view': line 7:3: Schema 'test' does not exist at io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:58) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeView(StatementAnalyzer.java:5175) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.createScopeForView(StatementAnalyzer.java:2600) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.createScopeForView(StatementAnalyzer.java:2550) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:2306) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:531) at io.trino.sql.tree.Table.accept(Table.java:70) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:550) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeFrom(StatementAnalyzer.java:5085) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:3142) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:531) at io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:550) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:558) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1587) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:531) at io.trino.sql.tree.Query.accept(Query.java:130) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:550) at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:510) at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:499) at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:98) at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:87) at io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:283) at io.trino.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:218) at io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:882) at io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:158) at io.trino.$gen.Trino_478____20260430_050040_2.call(Unknown Source) at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:128) at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74) at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:80) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1090) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) at java.base/java.lang.Thread.run(Thread.java:1474) Caused by: io.trino.spi.TrinoException: line 7:3: Schema 'test' does not exist at io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:58) at io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:52) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:2318) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:531) at io.trino.sql.tree.Table.accept(Table.java:70) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:550) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeFrom(StatementAnalyzer.java:5085) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:3142) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:531) at io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:550) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:558) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1587) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:531) at io.trino.sql.tree.Query.accept(Query.java:130) at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:550) at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:510) at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:499) at io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeView(StatementAnalyzer.java:5171) ... 34 more SELECT * FROM remote_irc.test.sales_performance_view trino> exit ``` While I switch to a local IRC catalog ``` trino --server http://35.190.166.193:8080 --debug trino> SELECT * FROM gravitino_irc.test.sales_performance_view; name | salary | expected_bonus | hire_date ---------+---------+----------------+------------ Alice | 55000.0 | 5500.0 | 2022-01-15 Charlie | 62000.0 | 6200.0 | 2023-03-20 (2 rows) Query 20260430_103543_00007_y6e9q, FINISHED, 1 node http://35.190.166.193:8080/ui/query.html?20260430_103543_00007_y6e9q Splits: 1 total, 1 done (100.00%) CPU Time: 0.0s total, 117 rows/s, 25KB/s, 89% active Per Node: 0.0 parallelism, 1 rows/s, 274B/s Parallelism: 0.0 Peak Memory: 246B 3.19 [4 rows, 872B] [1 rows/s, 274B/s] ``` ### Error message and/or stacktrace N/A ### How to reproduce 1. Trino using a remote IRC catalog ``` SELECT * FROM remote_irc.test.sales_performance_view; ``` ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
