[FLINK-35709] Allow reordering source column names in CTAS / RTAS

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0-preview
• Labels: pull-request-available
• Assignee: Sergio Peña
• Reporter: Sergio Peña
• Created: 26/Jun/24 21:16
• Updated: 03/Oct/24 07:40
• Resolved: 03/Oct/24 07:39

Description

Allow reordering the source columns of the resulted schema in CTAS when defined as column names. This feature should not be allowed with the support of new columns.

The syntax to support is:

CREATE TABLE table_name [( col_name1 [, column_name2, ...] )]
[WITH (table_properties)]
AS SELECT query_expression; 

The columns specified must match the names and number of columns in the SELECT  part. This feature is equivalent to the INSERT INTO  statement.

Issue Links

• Dependent: FLINK-35707 Allow column definition in CREATE TABLE AS (CTAS)
• Dependent: FLINK-35708 Allow defining a schema in REPLACE TABLE AS (RTAS)
• links to: GitHub Pull Request #25247
• links to: GitHub Pull Request #25401