You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I really need help on this error. It requires me to put hive. on all my table on the query. I am using ipython-sql to send my connection string and this error comes up on my jupyter notebook. If I put hive. on all my table on the query, it works.
DatabaseError: (pyhive.exc.DatabaseError) {'message': 'line 1:15: Catalog must be specified when session catalog is not set', 'errorCode': 56, 'errorName': 'MISSING_CATALOG_NAME', 'errorType': 'USER_ERROR', 'errorLocation': {'lineNumber': 1, 'columnNumber': 15}, 'failureInfo': {'type': 'io.trino.spi.TrinoException', 'message': 'line 1:15: Catalog must be specified when session catalog is not set', 'suppressed': [], 'stack': ['io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:48)', 'io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:43)', 'io.trino.metadata.MetadataUtil.lambda$createQualifiedObjectName$4(MetadataUtil.java:152)', 'java.base/java.util.Optional.orElseThrow(Optional.java:408)', 'io.trino.metadata.MetadataUtil.createQualifiedObjectName(MetadataUtil.java:151)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:1474)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:404)', 'io.trino.sql.tree.Table.accept(Table.java:60)', 'io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:421)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeFrom(StatementAnalyzer.java:3402)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:2141)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:404)', 'io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155)', 'io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:421)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:429)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1344)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:404)', 'io.trino.sql.tree.Query.accept(Query.java:107)', 'io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)', 'io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:421)', 'io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:384)', 'io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:79)', 'io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:71)', 'io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:257)', 'io.trino.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:181)', 'io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:771)', 'io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:135)', 'io.trino.$gen.Trino_372____20220404_223155_2.call(Unknown Source)', 'com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)', 'com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:74)', 'com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)', 'java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)', 'java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)', 'java.base/java.lang.Thread.run(Thread.java:829)'], 'errorLocation': {'lineNumber': 1, 'columnNumber': 15}}}
The text was updated successfully, but these errors were encountered:
I really need help on this error. It requires me to put
hive.
on all my table on the query. I am using ipython-sql to send my connection string and this error comes up on my jupyter notebook. If I puthive.
on all my table on the query, it works.The text was updated successfully, but these errors were encountered: