I tried it. If I use ":", I can query the results. If I use "," ,it will fail
[image: image.png] and I found that the problem may lie here, the obtained dbname does not remove the catalog name. I'm not sure if it's a problem. [image: image.png] -- Best Regards ------------ Liugddx liug...@gmail.com Mingyu Chen <morning...@163.com> 于2023年10月5日周四 22:25写道： > 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. > [image: image.png] > > 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 > >
