[FLINK-10231] Add a view SQL DDL

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Component/s: Table SQL / API
• Labels: auto-unassigned
• Assignee: Unassigned
• Reporter: Timo Walther
• Created: 28/Aug/18 08:08
• Updated: 30/Apr/21 04:18
• Resolved: 30/Apr/21 04:18

Description

FLINK-10163 added initial view support for the SQL Client. However, for supporting the full definition of views (with schema, comments, etc.) we need to support native support for views in the Table API.

CREATE VIEW [IF NOT EXISTS] [catalog_name.db_name.]view_name [COMMENT comment] AS SELECT ....;
DROP VIEW[IF EXISTS] [catalog_name.db_name.]view_name;
ALTER VIEW [IF EXISTS] [catalog_name.db_name.]view_name AS SELECT ....;
ALTER VIEW [IF EXISTS] [catalog_name.db_name.]view_name RENAME TO ....;
ALTER VIEW [IF EXISTS] [catalog_name.db_name.]view_name SET COMMENT =  ....;

Issue Links

• links to: Flink SQL DDL design doc