[jira] [Comment Edited] (FLINK-10231) Add a view SQL DDL
[
https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Comment Edited] (FLINK-10231) Add a view SQL DDL
[ https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668093#comment-16668093 ] winifredtang edited comment on FLINK-10231 at 10/31/18 2:50 AM: [~fhueske] Hello, could you give more details about it? I try to achieve a view SQL DDL. I wonder if the TableEnvironment.registerTableInternal(name: String, table: AbstractTable) might be deprecated too. Thanks a lot. was (Author: winipanda): Fabian Hueske Hello, could you give more details about it? I try to achieve a view SQL DDL. I wonder if the TableEnvironment.registerTableInternal(name: String, table: AbstractTable) might be deprecated too. Thanks a lot. > 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 API SQL >Reporter: Timo Walther >Assignee: winifredtang >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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (FLINK-10231) Add a view SQL DDL
[ https://issues.apache.org/jira/browse/FLINK-10231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668093#comment-16668093 ] winifredtang edited comment on FLINK-10231 at 10/31/18 2:47 AM: Fabian Hueske Hello, could you give more details about it? I try to achieve a view SQL DDL. I wonder if the TableEnvironment.registerTableInternal(name: String, table: AbstractTable) might be deprecated too. Thanks a lot. was (Author: winipanda): [~fhueske] Hello, could you give more details about it? I try to achieve a view SQL DDL. I wonder if it would better for me to use the TableEnvironment.registerTableInternal(name: String, table: AbstractTable) instead of the TableEnvironment.registerTable(name: String, table: Table). Thanks a lot. > 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 API SQL >Reporter: Timo Walther >Assignee: winifredtang >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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
