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
