[FLINK-13661] Add a stream specific CREATE TABLE SQL DDL

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: Jark Wu
• Created: 09/Aug/19 05:26
• Updated: 27/Dec/20 14:17
• Resolved: 27/Dec/20 14:17

Description

FLINK-6962 has introduced a basic SQL DDL to create a table. However, it doesn't support stream specific features, for example, watermark definition, changeflag definition, computed columns, primary keys and so on.

We started a design doc[1] to discuss the concepts of source and sink to help us have a well-defined DDL. Once the FLIP is accepted, we can start the work.

[1]: https://docs.google.com/document/d/1yrKXEIRATfxHJJ0K3t6wUgXAtZq8D-XgvEnvl2uUcr0/edit#heading=h.c05t427gfgxa

Considering the streaming DDL is a huge topic, we decided to split it into separate FLIPs. Here comes the first one.
FLIP-66: Support time attribute in SQL DDL: https://docs.google.com/document/d/1-SecocBqzUh7zY6HBYcfMlG_0z-JAcuZkCvsmN3LrOw/edit#