+1 for this. We are missing a series of catalog related syntaxes. Especially after the introduction of catalog store. [1]
[1] https://cwiki.apache.org/confluence/display/FLINK/FLIP-295%3A+Support+lazy+initialization+of+catalogs+and+persistence+of+catalog+configurations Best, Jingsong On Wed, Mar 13, 2024 at 5:09 PM Yubin Li <lyb5...@gmail.com> wrote: > > 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
