pyhive.exc.DatabaseError MISSING_CATALOG_NAME

No repository file or test is named. Start by reproducing the query through the PyHive connection from ipython-sql in a Jupyter notebook, then inspect how the connection establishes the Trino session catalog. Done means identifying whether PyHive can set the catalog for unqualified tables and documenting the required configuration or confirming the limitation.

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}}}