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

["Zili Chen (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17041698#comment-17041698 ] 

Zili Chen edited comment on FLINK-10231 at 2/21/20 10:22 AM:
-------------------------------------------------------------

Hi here, is this issue belongs to [FLIP-71|https://cwiki.apache.org/confluence/display/FLINK/FLIP-71+-+E2E+View+support+in+FLINK+SQL]?


was (Author: tison):
Hi here, is this issue belongs to FLIP-71?

> 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: Critical
>
> 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)