xuzhiwen1255 commented on issue #6021:
URL: https://github.com/apache/iceberg/issues/6021#issuecomment-1286334384
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**
--
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]
