[
https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bowen Li updated FLINK-10231:
-----------------------------
Description:
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}
was: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.
> 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)
