[FLINK-35707] Allow column definition in CREATE TABLE AS (CTAS) - ASF JIRA

Attach files

Attach Screenshot

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Sub-task
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 2.0-preview
Component/s: None
Labels:
- pull-request-available

Description

Allow defining new columns or overriding source column types on CTAS statements.

For following syntax should be allowed:

CREATE TABLE table_name [( <column_definition>[, ...n] )]
[WITH (table_properties)]
AS SELECT query_expression;

If new columns are defined in the create clause, then the columns should appear at the beginning of the resulted sink schema. Columns of the query source schema should appear at the end.

If source columns are re-defined in the create clause, then the columns should appear in the same order as the query schema. Column types may be overridden, but implicit casting rules should be validated and applied (similar to iNSERT/SELECT statements) to make sure the SELECT query will be able to run and write the data to the sink table.