[jira] [Updated] (FLINK-10231) Add a view SQL DDL

["Aljoscha Krettek (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aljoscha Krettek updated FLINK-10231:
-------------------------------------
    Priority: Major  (was: Critical)

> 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
>            Assignee: Danny Chen
>            Priority: Major
>
> 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)