Re:Re: Re: DESCRIBE CATALOG not available?

2024-02-05 Thread Xuyang
Hi, Yunhong.
Thanks for your volunteering :)



--

Best!
Xuyang




在 2024-02-06 09:26:55,"yh z"  写道:

Hi, Xuyang, I hope I can also participate in the development of the remaining 
flip features. Please cc me if there are any further developments. Thank you !


Xuyang  于2024年1月29日周一 13:54写道:

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"  写道:

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  于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


Re: DESCRIBE CATALOG not available?

2024-01-28 Thread Hang Ruan
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  于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
>