Last year, I worked with Apache Doris version 2.0.1 alongside Apache Calcite, focusing on the integration of Calcite's algebra builder, particularly the use of RelBuilder as detailed in Calcite's documentation ( https://calcite.apache.org/docs/algebra.html). During this endeavor, I encountered a compatibility issue related to the retrieval of column details. Specifically, Calcite attempts to gather the necessary column information by executing the "SHOW FULL COLUMNS" query (e.g., "SHOW FULL COLUMNS FROM baby from cvm"). However, I found that this operation is unsupported for External catalogs in Doris, leading to an error that indicates the External catalog 'hive' is not allowed in 'ShowColumnStmt'. Understanding the importance of this feature, I have already raised this concern with the Doris community. Upon further investigation, I noticed that there has been some development work that appears to address this issue:
- PR #28173: https://github.com/apache/doris/pull/28173 - PR #28919: https://github.com/apache/doris/pull/28919 In particular, PR #28919, which has been merged, caught my attention and leads me to inquire whether this development has effectively resolved the compatibility issue in the latest version of Doris. I would greatly appreciate any insights or updates you could provide regarding this matter. Your guidance will be invaluable in helping us leverage the full potential of Doris in conjunction with Apache Calcite's algebra builder. Thank you for your attention to this request. I look forward to your response. Best regards, Joice
