Hi, Robin and Hang.
This Flip is not finished yet. Although the syntax `DESCRIBE CATALOG xxx` can 
be parsed 
successfully, but cannot continue to process it at a later stage. 


I have added a jira[1] for it.



[1] https://issues.apache.org/jira/browse/FLINK-34254




--

    Best!
    Xuyang




在 2024-01-29 10:47:18,"Hang Ruan" <ruanhang1...@gmail.com> 写道:

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