Hi Doris Community,
I am trying to use Apache Calcite's algebra builder with Apache Doris, and
I have a query related to query compatibility.
My goal is to use the algebra builder/RelBuilder(
https://calcite.apache.org/docs/algebra.html). Calcite will gather all the
necessary column details for creating RelBuilder by calling the
getColumns() method in MySQL connector which executes SHOW FULL COLUMNS
query eg: "SHOW FULL COLUMNS FROM instant_cdr from cvm". But SHOW FULL
COLUMNS isn't supported for the External catalog(throwing error External
catalog 'hive' is not allowed in 'ShowColumnStmt'). I want to inquire
whether supporting the "SHOW FULL COLUMNS" for the External catalog is
possible. Because the query cannot be changed in getColumns method since it
is generated by the MySQL connector

Error message : ERROR 1105 (HY000): errCode = 2, detailMessage = External
catalog 'hive' is not allowed in 'ShowColumnStmt'

Thanks
Joice

Reply via email to