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 *[image: image.png] Best regards Joice
