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
