[Bug] Using two different hive catalogs, create the same database and table, and the final data will enter the same table

[zhongtiancai]

Search before asking

• I searched in the issues and found nothing similar.

Paimon version

0.7.0-incubating

Compute Engine

Flink hive-connect

Minimal reproduce step

Step 1

create catalog test;
use catalog test;
create database test_db;
use database test_db;
create table test_table;
insert data in test_table;

Step 2

create catalog test1;
use catalog test1;
create database test_db;
use database test_db;
create table test_table;
insert data in test_table;

Step 3

select * from test1.testdb.test_table;
select * from test.testdb.test_table;

What doesn't meet your expectations?

The results are different on hive hdfs://and file://.

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[zhongtiancai]

code snippet

[zhuangchong]

I understand that this is not a bug. You use the same Hive Metastore, you can only have a test_db database, a test_table table.

In your code example, your if Not Exist statement, your Step 2 does not really go to create a database or table.

[zhongtiancai]

@zhuangchong I use the same hive-config-dir, but with different warehouse parameters in the code. Is this situation considered the same on hive?

[zhuangchong]

Yes, because hive has only one metadata database.