Versions Compared

Old Version 43

changes.mady.by.user Mang Zhang

Saved on

compared with

New Version 44

changes.mady.by.user ron liu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The current syntax/features of Flink SQL is very perfect in both stream mode and batch mode. But there are still some usability to improve. for For example, If the user wants to insert data into a new table, 2 steps are required:

  • First, prepare the DDL statement of the table named t1;
  • Second, insert the data into t1;

These two steps seem to be normal, but if there are many fields, spelling DDL statements can be difficult, and  and write out these columns in the following insert statement. Therefore, we can support CTAS (CREATE TABLE AS SELECT) like MySQL, Oracle, Microsoft SQL Server, Hive, Spark, etc ... It will be more user friendly. In addition, the Hive dialect already has some support for CTAS. My suggestion would be to support a variation of an optional Feature T172, “AS subquery clause in table definition”, of SQL standard.

...