joice1910 opened a new issue, #25899: URL: https://github.com/apache/doris/issues/25899
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description I would like to request the addition of support for the "SHOW FULL COLUMNS" query in the External Hive catalog in Doris. This feature would be highly beneficial for our use case and would improve the integration with external Hive metadata. ### Use case I am trying to use Apache Calcite's algebra builder with Apache Doris, and I have a issue 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'). ### Related issues _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
