[ https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Leonard Xu resolved FLINK-10231. -------------------------------- Resolution: Implemented Has been supported inĀ FLINK-17105 > Add a view SQL DDL > ------------------ > > Key: FLINK-10231 > URL: https://issues.apache.org/jira/browse/FLINK-10231 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Reporter: Timo Walther > Priority: Major > Labels: auto-unassigned > > FLINK-10163 added initial view support for the SQL Client. However, for > supporting the [full definition of > views|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterView] > (with schema, comments, etc.) we need to support native support for views in > the Table API. > {code} > 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 = ....; > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)