Actually catalogs are more of system settings than of user objects that a user might create or drop constantly. Thus, it's probably sufficient to set up catalog information in the config file, at least for now.
Thanks, Xuefu On Tue, Sep 24, 2019 at 7:10 PM Terry Wang <zjuwa...@gmail.com> wrote: > Thanks Bowen for your insightful comments, I’ll think twice and do > corresponding improvement. > After finished, I’ll update in this mailing thread again. > Best, > Terry Wang > > > > > 在 2019年9月25日，上午8:28，Bowen Li <bowenl...@gmail.com> 写道： > > > > BTW, will there be a "CREATE/DROP CATALOG" DDL? > > > > Though it's not SQL standard, I can see it'll be useful and handy for > our end users in many cases. > > > > On Mon, Sep 23, 2019 at 12:28 PM Bowen Li <bowenl...@gmail.com <mailto: > bowenl...@gmail.com>> wrote: > > Hi Terry, > > > > Thanks for driving the effort! I left some comments in the doc. > > > > AFAIU, the biggest motivation is to support DDLs in sql parser so that > both Table API and SQL CLI can share the stack, despite that SQL CLI has > already supported some commands itself. However, I don't see details on how > SQL CLI would migrate and depend on sql parser, and how Table API and SQL > CLI would actually share SQL parser. I'm not sure yet how much work that > will take, just want to double check that you didn't include them because > they are very trivial according to your estimate? > > > > > > On Mon, Sep 16, 2019 at 1:46 AM Terry Wang <zjuwa...@gmail.com <mailto: > zjuwa...@gmail.com>> wrote: > > Hi everyone, > > > > In flink 1.9, we have introduced some awesome features such as complete > catalog support[1] and sql ddl support[2]. These features have been a > critical integration for Flink to be able to manage data and metadata like > a classic RDBMS and make developers more easy to construct their > real-time/off-line warehouse or sth similar base on flink. > > > > But there is still a lack of support on how Flink SQL DDL to manage > metadata and data like classic RDBMS such as `alter table rename` and so on. > > > > So I’d like to kick off a discussion on enhancing Flink Sql Ddls: > > > https://docs.google.com/document/d/1mhZmx1h2ecfL0x8OzYD1n-nVRn4yE7pwk4jGed4k7kc/edit?usp=sharing > < > https://docs.google.com/document/d/1mhZmx1h2ecfL0x8OzYD1n-nVRn4yE7pwk4jGed4k7kc/edit?usp=sharing> > < > https://docs.google.com/document/d/1mhZmx1h2ecfL0x8OzYD1n-nVRn4yE7pwk4jGed4k7kc/edit?usp=sharing > < > https://docs.google.com/document/d/1mhZmx1h2ecfL0x8OzYD1n-nVRn4yE7pwk4jGed4k7kc/edit?usp=sharing > >> > > > > In short, it: > > - Add Catalog DDL enhancement support: show catalogs / describe > catalog / use catalog > > - Add Database DDL enhancement support: show databses / create > database / drop database/ alter database > > - Add Table DDL enhancement support: show tables/ describe > table / alter table > > - Add Function DDL enhancement support: show functions/ create > function /drop function > > > > Looking forward to your opinions. > > > > Best, > > Terry Wang > > > > > > > > [1]:https://issues.apache.org/jira/browse/FLINK-11275 < > https://issues.apache.org/jira/browse/FLINK-11275> < > https://issues.apache.org/jira/browse/FLINK-11275 < > https://issues.apache.org/jira/browse/FLINK-11275>> > > [2]:https://issues.apache.org/jira/browse/FLINK-1 < > https://issues.apache.org/jira/browse/FLINK-1> < > https://issues.apache.org/jira/browse/FLINK-11275 < > https://issues.apache.org/jira/browse/FLINK-11275>>0232 > > <https://issues.apache.org/jira/browse/FLINK-11275 < > https://issues.apache.org/jira/browse/FLINK-11275>> > > -- Xuefu Zhang "In Honey We Trust!"
