[
https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16911615#comment-16911615
]
Bowen Li commented on FLINK-10231:
----------------------------------
Hi [~danny0405], can you lead this effort if wenhui doesn't have time for it?
Thanks!
cc [~ykt836] [~xuefuz]
> 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: TANG Wen-hui
> Priority: Critical
> Fix For: 1.10.0
>
>
> 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.2#803003)
