That is strange, I test it in my own env and it works:
mysql> show full tables from hive.tpch100_orc; +-----------------------+--------------------+---------------+ | Tables_in_tpch100_orc | Table_type | StorageFormat | +-----------------------+--------------------+---------------+ | customer | HMS_EXTERNAL_TABLE | NONE | | customer_orc | HMS_EXTERNAL_TABLE | NONE | | lineitem | HMS_EXTERNAL_TABLE | NONE | | nation | HMS_EXTERNAL_TABLE | NONE | | orders | HMS_EXTERNAL_TABLE | NONE | | orders_par | HMS_EXTERNAL_TABLE | NONE | | part | HMS_EXTERNAL_TABLE | NONE | | partsupp | HMS_EXTERNAL_TABLE | NONE | | region | HMS_EXTERNAL_TABLE | NONE | | supplier | HMS_EXTERNAL_TABLE | NONE | +-----------------------+--------------------+---------------+ Have you try to NOT use ``, just hive.cvm? -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-10-05 21:58:19, "Joice Jacob" <joicejacob1...@gmail.com> wrote: Hi, Thank you for the suggestion and for trying to help resolve the issue. I appreciate your assistance in troubleshooting the problem. I followed your recommendation and added the configuration infodb_support_ext_catalog=true to the fe.conf file. However, after restarting the Frontend (FE), the issue still persists. Unfortunately, it hasn't had the desired effect. I will continue to investigate the issue further to find a resolution, and I'm open to any additional suggestions or insights that may help in resolving this matter. Once again, thank you for your support, and I'll keep you updated on my progress. Best regards, Joice On Thu, Oct 5, 2023 at 6:57 PM Mingyu Chen <morning...@163.com> wrote: Hi Joice, You may try add this in fe.conf, and restart FE and try again: infodb_support_ext_catalog=true -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-10-05 16:52:15, "Joice Jacob" <joicejacob1...@gmail.com> wrote: Dear Doris Community, I am writing to seek assistance with an issue I've encountered when working with Doris involving catalog and database names. In my doris setup, there is an internal catalog containing a database named "demo," and an external catalog named "hive" with a database named "cvm" The following queries execute successfully without any issues: SHOW FULL TABLES FROM demo; SHOW FULL TABLES FROM `demo`; However, when I run the following query: SHOW FULL TABLES FROM hive.cvm; It executes without errors. However, attempting to execute the same query using backticks (``) as shown below: SHOW FULL TABLES FROM `hive.cvm`; Results in the following error message: ERROR 1049 (42000): errCode = 2, detailMessage = Unknown database 'default_cluster:hive.cvm' I am perplexed by this inconsistency in behavior, and I am unsure how to resolve this issue. The external catalog "hive" should allow querying tables within its database, including the "cvm" database. I would greatly appreciate any insights, recommendations, or potential solutions from the Doris community. If anyone has encountered a similar issue or has expertise in managing catalogs and databases within Doris, your assistance would be invaluable. Thank you for taking the time to read this message, and I look forward to your guidance on resolving this challenge. Doris version: 2.0.1.1 Best regards Joice
