liunaijie opened a new issue, #3424: URL: https://github.com/apache/paimon/issues/3424
### Search before asking - [X] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Paimon version hi team, i am new to here. and i have few question about paimon intergration with hive I has successed created hive catalog with flink sql. 1. in flink sql client, i can see all the database that created in hive, but i can't see the table that already created in hive. How can i see all the table that already created in hive? 2. in hive, i follow the guide to create table without partition and primary key, it can work. But it only has 1 bucket, so the query with hive MR, it will be very slow. (1 bucket can only have 1 parallelism right?) is there any way to create table with partition key and primary key? i try to create table like this: ```sql CREATE EXTERNAL TABLE external_test_table STORED BY 'org.apache.paimon.hive.PaimonStorageHandler' LOCATION '/path/to/table/store/warehouse/default.db/test_table'; ``` but got `org.apache.hadoop.hive.ql.parse.SemanticException: Either list of columns or a custom serializer should be specified` error. my hive version is `2.1.1-cdh6.3.2` 4. i created the partition and primary table in flink sql client. want sync some data from hive table to compare the query proformance. but in flink sql client i can't see the exist hive table, so i can't run insert query in flink cli. in hive cli, when i run `insert into <table> partition (xxx) select` it will got ArrayIndexOutOfBoundsException issue. (i find this is an exist issue https://github.com/apache/paimon/issues/3189) ### Compute Engine Hive / Flink ### Minimal reproduce step 1. in flink sql client, create hive catalog, run `show databases` and `show tables in xxx` 2. in hive cli, insert data to paimon partiton table from hive table ### What doesn't meet your expectations? 1. see/query all the hive exist table in flink sql client 2. insert into partiton table in hive cli ### Anything else? do we has wechat group? ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- 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]
