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> 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 > > > > 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> > [2]:https://issues.apache.org/jira/browse/FLINK-1 < > https://issues.apache.org/jira/browse/FLINK-11275>0232 > <https://issues.apache.org/jira/browse/FLINK-11275>
