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
