Doris is compatible with MySQL syntax. In MySQL, the backticks is used like:
select `tbl1`.`col1` from `catalog1`.`db`.`tbl1`; It quotes each single identifier, not the whole part of them. So do you mean you want to support syntax like: select `tbl1.col1` from `catalog1.db.tbl1`? which is using backticks to quoto the whole part of indentifier? -- Best Regards Mingyu Chen Email: morning...@apache.org 在 2023-10-05 23:26:24，"Joice Jacob" <joicejacob1...@gmail.com> 写道： Hi Mingyu Chen, I wanted to share an exciting development regarding our project to integrate Apache Calcite with Hive Catalog in Doris. Our primary goal is to leverage the capabilities of the Apache Calcite framework to seamlessly access and process metadata about tables and columns in our Doris data environment. We believe that this integration will significantly enhance our query processing capabilities and streamline our data access procedures. One notable feature of this integration is that Apache Calcite, by default, sends backticks (``) characters with queries. This behavior is expected and aligns with the way Calcite handles quoting identifiers. It's important to note that these backticks are commonly used in SQL to quote identifiers like table and column names, especially when they contain special characters or spaces. We are excited about the possibilities this integration offers and believe it will contribute to the efficiency and flexibility of our data processing workflows. Thank you for your continued support, and we look forward to sharing further updates as our integration efforts continue. Best regards, Joice On Thu, Oct 5, 2023 at 7:55 PM Mingyu Chen <morning...@163.com> wrote: 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. 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
