[FLINK-30433] HiveDialectITCase#testCreateDatabase fails with "Could not execute CREATE DATABASE"

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.17.0, 1.16.1, 1.18.0
• Component/s: Connectors / Hive
• Labels: auto-deprioritized-critical test-stability
• Assignee: Unassigned
• Reporter: Martijn Visser
• Created: 16/Dec/22 08:22
• Updated: 08/Jan/24 00:18

Description

Feb 14 02:38:16 [ERROR] Tests run: 27, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 341.271 s <<< FAILURE! - in org.apache.flink.connectors.hive.HiveDialectITCase
Feb 14 02:38:16 [ERROR] org.apache.flink.connectors.hive.HiveDialectITCase.testTemporaryFunctionUDTF  Time elapsed: 49.997 s  <<< ERROR!
Feb 14 02:38:16 org.apache.flink.table.api.TableException: Could not execute CREATE DATABASE: (catalogDatabase: [{}], catalogName: [test-catalog], databaseName: [db1], ignoreIfExists: [false])
Feb 14 02:38:16 	at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1125)
Feb 14 02:38:16 	at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:730)
Feb 14 02:38:16 	at org.apache.flink.connectors.hive.HiveDialectITCase.testTemporaryFunctionUDTF(HiveDialectITCase.java:838)
Feb 14 02:38:16 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Feb 14 02:38:16 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Feb 14 02:38:16 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Feb 14 02:38:16 	at java.lang.reflect.Method.invoke(Method.java:498)
[...]
Feb 14 02:38:16 	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:548)
Feb 14 02:38:16 Caused by: org.apache.flink.table.catalog.exceptions.CatalogException: Failed to create database db1
Feb 14 02:38:16 	at org.apache.flink.table.catalog.hive.HiveCatalog.createDatabase(HiveCatalog.java:376)
Feb 14 02:38:16 	at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1117)
Feb 14 02:38:16 	... 47 more
Feb 14 02:38:16 Caused by: InvalidObjectException(message:No such catalog hive)
Feb 14 02:38:16 	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database_core(HiveMetaStore.java:1251)
Feb 14 02:38:16 	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:1325)
Feb 14 02:38:16 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Feb 14 02:38:16 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Feb 14 02:38:16 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Feb 14 02:38:16 	at java.lang.reflect.Method.invoke(Method.java:498)
Feb 14 02:38:16 	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
Feb 14 02:38:16 	at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108)
Feb 14 02:38:16 	at com.sun.proxy.$Proxy35.create_database(Unknown Source)
Feb 14 02:38:16 	at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createDatabase(HiveMetaStoreClient.java:809)
Feb 14 02:38:16 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Feb 14 02:38:16 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Feb 14 02:38:16 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Feb 14 02:38:16 	at java.lang.reflect.Method.invoke(Method.java:498)
Feb 14 02:38:16 	at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:208)
Feb 14 02:38:16 	at com.sun.proxy.$Proxy36.createDatabase(Unknown Source)
Feb 14 02:38:16 	at org.apache.flink.table.catalog.hive.client.HiveMetastoreClientWrapper.createDatabase(HiveMetastoreClientWrapper.java:179)
Feb 14 02:38:16 	at org.apache.flink.table.catalog.hive.HiveCatalog.createDatabase(HiveCatalog.java:369)
Feb 14 02:38:16 	... 48 more

https://dev.azure.com/apache-flink/apache-flink/_build/results?buildId=43954&view=logs&j=245e1f2e-ba5b-5570-d689-25ae21e5302f&t=d04c9862-880c-52f5-574b-a7a79fef8e0f&l=25508

Issue Links

• duplicates: FLINK-31340 HiveTableSourceStatisticsReportTest.testFlinkParquetFormatHiveTableSourceStatisticsReport failed with InvalidObjectException
• duplicates: FLINK-30011 HiveCatalogGenericMetadataTest azure CI failed due to catalog does not exist
• duplicates: FLINK-30634 HiveTableSourceITCase.setupSourceDatabaseAndData fails with InvalidObjectException