Hi everyone, Can we identify if this proposed syntax is part of the SQL standard?
Best regards, Martijn Visser https://twitter.com/MartijnVisser82 https://github.com/MartijnVisser On Fri, 29 Apr 2022 at 11:19, yuxia <luoyu...@alumni.sjtu.edu.cn> wrote: > Thanks for for driving this work, it's to be a useful feature. > About the flip-218, I have some questions. > > 1: Does our CTAS syntax support specify target table's schema including > column name and data type? I think it maybe a useful fature in case we want > to change the data types in target table instead of always copy the source > table's schema. It'll be more flexible with this feature. > Btw, MySQL's "CREATE TABLE ... SELECT Statement"[1] support this feature. > > 2: Seems it'll requre sink to implement an public interface to drop table, > so what's the interface will look like? > > [1] https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html > > Best regards, > Yuxia > > ----- 原始邮件 ----- > 发件人: "Mang Zhang" <zhangma...@163.com> > 收件人: "dev" <dev@flink.apache.org> > 发送时间: 星期四, 2022年 4 月 28日 下午 4:57:24 > 主题: [DISCUSS] FLIP-218: Support SELECT clause in CREATE TABLE(CTAS) > > Hi, everyone > > > I would like to open a discussion for support select clause in CREATE > TABLE(CTAS), > With the development of business and the enhancement of flink sql > capabilities, queries become more and more complex. > Now the user needs to use the Create Table statement to create the target > table first, and then execute the insert statement. > However, the target table may have many columns, which will bring a lot of > work outside the business logic to the user. > At the same time, ensure that the schema of the created target table is > consistent with the schema of the query result. > Using a CTAS syntax like Hive/Spark can greatly facilitate the user. > > > > You can find more details in FLIP-218[1]. Looking forward to your feedback. > > > > [1] > https://cwiki.apache.org/confluence/display/FLINK/FLIP-218%3A+Support+SELECT+clause+in+CREATE+TABLE(CTAS) > > > > > -- > > Best regards, > Mang Zhang >
