Yubin Li created FLINK-34915:
--------------------------------
Summary: Introduce `DESCRIBE CATALOG` syntax
Key: FLINK-34915
URL: https://issues.apache.org/jira/browse/FLINK-34915
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Affects Versions: 1.20.0
Reporter: Yubin Li
Describe the metadata of an existing catalog. The metadata information includes
the catalog’s name, type, and comment. If the optional {{EXTENDED}} option is
specified, catalog properties are also returned.
NOTICE: The parser part of this syntax has been implemented in FLIP-69 , and it
is not actually available. we can complete the syntax in this FLIP.
{{Flink SQL> describe catalog cat2;}}
{{+--------------------------+---------------------------+}}
{{| catalog_description_item | catalog_description_value |}}
{{+--------------------------+---------------------------+}}
{{| Name | cat2 |}}
{{| Type | generic_in_memory |}}
{{| Comment | |}}
{{+--------------------------+---------------------------+}}
{{3 rows }}{{in}} {{set}}
{{Flink SQL> describe catalog extended cat2;}}
{{+--------------------------+-------------------------------------------------+}}
{{| catalog_description_item | catalog_description_value
|}}
{{+--------------------------+-------------------------------------------------+}}
{{| Name | cat2
|}}
{{| Type | generic_in_memory
|}}
{{| Comment |
|}}
{{{}| Properties | (default-database,db),
({}}}{{{}type{}}}{{{},generic_in_memory) |{}}}
{{+--------------------------+-------------------------------------------------+}}
{{4 rows }}{{in}} {{set}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
