Hi, Robin.

I see that the `DESCRIBE CATALOG` sql is not list in the DESCRIBE
document[1]. It is not available.
Besides this, I checked the changes in Catalog.java from commits on May 9,
2019. I cannot find the method `explainCatalog` introduced from this FLIP.
This FLIP is not finished yet.

Best,
Hang

[1]
https://nightlies.apache.org/flink/flink-docs-release-1.18/docs/dev/table/sql/describe/

Robin Moffatt via user <user@flink.apache.org> 于2024年1月27日周六 01:01写道:

> In FLIP-69 [1] it looks like DESCRIBE CATALOG was added, but when I
> try it from SQL Client in 1.18.1 it doesn't seem to work
>
> Flink SQL> SHOW CATALOGS;
> +-----------------+
> |    catalog name |
> +-----------------+
> |           c_new |
> | default_catalog |
> +-----------------+
> 2 rows in set
>
> Flink SQL> DESCRIBE CATALOG default_catalog;
> [ERROR] Could not execute SQL statement. Reason:
> org.apache.calcite.sql.validate.SqlValidatorException: Column
> 'default_catalog' not found in any table
>
> Poking around I found the JIRA that implemented it [2] and can see the
> code present today [3]
>
> Any ideas?
>
> Thanks, Robin.
>
> [1]
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-69%3A+Flink+SQL+DDL+Enhancement
> [2] https://issues.apache.org/jira/browse/FLINK-14689
> [3]
> https://github.com/apache/flink/blob/master/flink-table/flink-sql-parser/src/main/java/org/apache/flink/sql/parser/dql/SqlDescribeCatalog.java
>

Reply via email to