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
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
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...@gm
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 |
+---++---+
| cust
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 i
Try this *SHOW FULL TABLES FROM `hive:cvm`;*
--
Best Regards
Liugddx
liug...@gmail.com
Joice Jacob 于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.
>
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 "
*
