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