[
https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16923094#comment-16923094
]
Qi commented on FLINK-10231:
----------------------------
Hi [~phoenixjiangnan] [~danny0405] are you already working on this issue?
We've implemented this feature in our internal Flink distribution and would
like to contribute it back if you don't have time :)
> 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)
