[FLINK-35708] Allow defining a schema in REPLACE TABLE AS (RTAS)

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Sergio Peña
• Reporter: Sergio Peña
• Created: 3 days ago 19:56
• Updated: 2 days ago 06:46

Description

Allow a schema definition on RTAS statements.

For following syntax should be allowed:

[CREATE OR] REPLACE TABLE table_name [( { <schema_definition> } )]
WITH (table_properties)AS SELECT query_expression; 

<schema_definition>:  
  [ <column_definition>[, ...n] ],  
  [ <watermark_definition> ],  
  [ <table_constraint>[, ...n] ]

The behavior is similar to the CTAS statement (see https://issues.apache.org/jira/browse/FLINK-35707)

Issue Links

• Dependent: FLINK-35709 Allow reordering source column names in CTAS / RTAS