[FLINK-16421] Changing default catalog to hive without changing default database fails

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: 1.10.0
• Component/s: Table SQL / Client
• Labels: auto-deprioritized-major
• Assignee: Unassigned
• Reporter: Gyula Fora
• Created: 04/Mar/20 11:48
• Updated: 26/Jul/21 12:50
• Resolved: 26/Jul/21 12:50

Description

The default database in Hive is caled "default" not "default_database". This causes an error when starting the SQL CLI with hive set as default catalog:

Caused by: org.apache.flink.table.catalog.exceptions.CatalogException: A database with name [default_database] does not exist in the catalog: [hive].Caused by: org.apache.flink.table.catalog.exceptions.CatalogException: A database with name [default_database] does not exist in the catalog: [hive]. at org.apache.flink.table.catalog.CatalogManager.setCurrentDatabase(CatalogManager.java:174) at org.apache.flink.table.api.internal.TableEnvironmentImpl.useDatabase(TableEnvironmentImpl.java:631) at java.util.Optional.ifPresent(Optional.java:159) at org.apache.flink.table.client.gateway.local.ExecutionContext.initializeCatalogs(ExecutionContext.java:561) at org.apache.flink.table.client.gateway.local.ExecutionContext.initializeTableEnvironment(ExecutionContext.java:494) at org.apache.flink.table.client.gateway.local.ExecutionContext.<init>(ExecutionContext.java:159) at org.apache.flink.table.client.gateway.local.ExecutionContext.<init>(ExecutionContext.java:118) at org.apache.flink.table.client.gateway.local.ExecutionContext$Builder.build(ExecutionContext.java:744)

Issue Links

• is related to: FLINK-22540 Remove YAML environment file support in SQL Client