You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "Sergio Peña (Jira)" <ji...@apache.org> on 2024/06/26 21:17:00 UTC

[jira] [Created] (FLINK-35709) Allow reordering source column names in CTAS / RTAS

Sergio Peña created FLINK-35709:
-----------------------------------

             Summary: Allow reordering source column names in CTAS / RTAS
                 Key: FLINK-35709
                 URL: https://issues.apache.org/jira/browse/FLINK-35709
             Project: Flink
          Issue Type: Sub-task
            Reporter: Sergio Peña


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:
{noformat}
CREATE TABLE table_name [( col_name1 [, column_name2, ...] )]
[WITH (table_properties)]
AS SELECT query_expression; {noformat}
The columns specified must match the names and number of columns in the {{SELECT}}  part. This feature is equivalent to the {{INSERT INTO}}  statement.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)