Try this *SHOW FULL TABLES FROM `hive:cvm`;* --
Best Regards ------------ Liugddx liug...@gmail.com Joice Jacob <joicejacob1...@gmail.com> 于2023年10月5日周四 16:52写道: > 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 >