MrDannyWu commented on issue #6021: URL: https://github.com/apache/iceberg/issues/6021#issuecomment-1286361800
> Flink SQL> CREATE CATALOG hc WITH ( > > > 'type'='iceberg', > > 'catalog-type'='hive', > > 'uri'='thrift://xxx:9083', > > 'clients'='5', > > 'property-version'='1', > > 'warehouse'='hdfs://xxx:8020/user/iceberg/warehouse5' > > ); > > [INFO] Execute statement succeed. > > Flink SQL> use hc; [ERROR] Could not execute SQL statement. Reason: org.apache.flink.table.catalog.exceptions.CatalogException: A database with name [hc] does not exist in the catalog: [default_catalog]. > > Flink SQL> use catalog hc; [INFO] Execute statement succeed. > > Flink SQL> create database db1; [INFO] Execute statement succeed. > > Flink SQL> use db1; [INFO] Execute statement succeed. > > Flink SQL> create table t1(id int ,name string); [INFO] Execute statement succeed. > > Flink SQL> show tables; +------------+ | table name | +------------+ | t1 | +------------+ 1 row in set > > Flink SQL> > > -------------------- hive client ------------------- WARNING: Hive CLI is deprecated and migration to Beeline is recommended. hive> add jar /root/ iceberg-hive-runtime-1.0.0.jar > ; Added [/root/, iceberg-hive-runtime-1.0.0.jar] to class path Added resources: [/root/, iceberg-hive-runtime-1.0.0.jar] hive> show databases; OK db db1 default migrate one_hdfs test x_baili Time taken: 1.344 seconds, Fetched: 7 row(s) hive> use db1; OK Time taken: 0.045 seconds hive> show tables; OK t1 Time taken: 0.07 seconds, Fetched: 1 row(s) hive> > > **I have the same configuration with you, but I can also check it. I think there is something wrong with my hive operation. My Hive version is lower than 2.1.1** Okay, thanks a lot,looking forward to your reply again, I am also looking for a solution at the same time. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
