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
>

Reply via email to