Now I use trino to connect to kudu and execute the following script。
trino:default> create schema cdr;
CREATE SCHEMA
trino:default> use cdr;
USE
trino:cdr> show schemas;
Schema
--------------------
cdr
default
information_schema
(3 rows)Query 20211118_033415_00020_4gwuw, FINISHED, 3 nodes
Splits: 36 total, 36 done (100.00%)
0.22 [3 rows, 43B] [13 rows/s, 195B/s]
trino:cdr> CREATE TABLE kudu.cdr.users (
-> user_id int WITH (primary_key = true),
-> first_name varchar,
-> last_name varchar
-> ) WITH (
-> partition_by_hash_columns = ARRAY['user_id'],
-> partition_by_hash_buckets = 2
-> );
->
W1118 13:56:00.671370 31226 catalog_manager.cc:1959] Remote error: failed to create HMS catalog entry for table [id=3490249b929842509d3364a18f07a4e5]: failed to create Hive MetaStore table: TException - service has thrown: MetaException(message=NoSuchObjectException(message:cdr))
kudu master log:
W1118 13:56:00.671370 31226 catalog_manager.cc:1959] Remote error: failed to create HMS catalog entry for table [id=3490249b929842509d3364a18f07a4e5]: failed to create Hive MetaStore table: TException - service has thrown: MetaException(message=NoSuchObjectException(message:cdr))
Schemas Failed to synchronize to hive metadata,If I create this database in hive,the error log:
W1118 13:30:00.148990 31226 catalog_manager.cc:1959] Remote error: failed to create HMS catalog entry for table [id=4a40e0c12d9a4d26a11fcce0cf259d35]: failed to create Hive MetaStore table: TException - service has thrown: MetaException(message=java.lang.IllegalArgumentException: Can not create a Path from an empty string)
I follow this page config . It looks as if the configuration was successful.
https://kudu.apache.org/docs/hive_metastore.html#enabling-the-hive-metastore-integration
Now I use trino to connect to kudu and execute the following script。
kudu master log:
W1118 13:56:00.671370 31226 catalog_manager.cc:1959] Remote error: failed to create HMS catalog entry for table [id=3490249b929842509d3364a18f07a4e5]: failed to create Hive MetaStore table: TException - service has thrown: MetaException(message=NoSuchObjectException(message:cdr))
Schemas Failed to synchronize to hive metadata,If I create this database in hive,the error log:
W1118 13:30:00.148990 31226 catalog_manager.cc:1959] Remote error: failed to create HMS catalog entry for table [id=4a40e0c12d9a4d26a11fcce0cf259d35]: failed to create Hive MetaStore table: TException - service has thrown: MetaException(message=java.lang.IllegalArgumentException: Can not create a Path from an empty string)
follow this page https://trino.io/docs/current/connector/kudu.html![image](https://user-images.githubusercontent.com/10862577/150710970-c118a45f-23d9-4bc0-8e6e-c805237f24ce.png)