You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@paimon.apache.org by "zhongtiancai (via GitHub)" <gi...@apache.org> on 2024/03/22 16:25:52 UTC

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

zhongtiancai opened a new issue, #3080:
URL: https://github.com/apache/paimon/issues/3080

   ### Search before asking
   
   - [X] I searched in the [issues](https://github.com/apache/incubator-paimon/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!


-- 
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: issues-unsubscribe@paimon.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

Posted by "zhongtiancai (via GitHub)" <gi...@apache.org>.
zhongtiancai commented on issue #3080:
URL: https://github.com/apache/paimon/issues/3080#issuecomment-2015475219

   ![微信图片_20240323003433](https://github.com/apache/paimon/assets/16176046/0c666d58-ccb6-4478-b66b-10ab7e59e689)
   code snippet


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

Posted by "zhongtiancai (via GitHub)" <gi...@apache.org>.
zhongtiancai closed issue #3080: [Bug] Using two different hive catalogs, create the same database and table, and the final data will enter the same table
URL: https://github.com/apache/paimon/issues/3080


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

Posted by "zhuangchong (via GitHub)" <gi...@apache.org>.
zhuangchong commented on issue #3080:
URL: https://github.com/apache/paimon/issues/3080#issuecomment-2017250231

   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.


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

Posted by "zhongtiancai (via GitHub)" <gi...@apache.org>.
zhongtiancai commented on issue #3080:
URL: https://github.com/apache/paimon/issues/3080#issuecomment-2017819350

   ![微信图片_20240323003433](https://github.com/apache/paimon/assets/16176046/89b2e3b1-a862-436d-8646-bc723caad222)
   ![微信图片_20240325193515](https://github.com/apache/paimon/assets/16176046/ff654b9e-d72e-4592-bd10-8ce7035e0064)
   
   @zhuangchong  I use the same hive-config-dir, but with different warehouse parameters in the code. Is this situation considered the same on hive?


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

Posted by "zhuangchong (via GitHub)" <gi...@apache.org>.
zhuangchong commented on issue #3080:
URL: https://github.com/apache/paimon/issues/3080#issuecomment-2017857358

   Yes, because hive has only one metadata database.
   
   


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org