Hi devs,
I'd like to start a discussion about FLIP-436: Introduce "SHOW CREATE
CATALOG" Syntax [1].
At present, the `SHOW CREATE TABLE` statement provides strong support for
users to easily
reuse created tables. However, despite the increasing importance of the
`Catalog` in user's
business, there is no similar statement for users to use.
According to the online discussion in FLINK-24939 [2] with Jark Wu and Feng
Jin, since `CatalogStore`
has been introduced in FLIP-295 [3], we could use this component to
implement such a long-awaited
feature, Please refer to the document [1] for implementation details.
examples as follows:
Flink SQL> create catalog cat2 WITH ('type'='generic_in_memory',
> 'default-database'='db');
> [INFO] Execute statement succeeded.
> Flink SQL> show create catalog cat2;
>
> +----------------------------------------------------------------------------------------+
> | result |
>
> +----------------------------------------------------------------------------------------+
> | CREATE CATALOG `cat2` WITH (
> 'default-database' = 'db',
> 'type' = 'generic_in_memory'
> )
> |
>
> +----------------------------------------------------------------------------------------+
> 1 row in set
Looking forward to hearing from you, thanks!
Best regards,
Yubin
[1]
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=296290756
[2] https://issues.apache.org/jira/browse/FLINK-24939
[3]
https://cwiki.apache.org/confluence/display/FLINK/FLIP-295%3A+Support+lazy+initialization+of+catalogs+and+persistence+of+catalog+configurations
