You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@flink.apache.org by ja...@apache.org on 2020/06/23 09:27:08 UTC

[flink] branch release-1.11 updated: [FLINK-18313][docs] Update Hive dialect doc about VIEW

This is an automated email from the ASF dual-hosted git repository.

jark pushed a commit to branch release-1.11
in repository https://gitbox.apache.org/repos/asf/flink.git


The following commit(s) were added to refs/heads/release-1.11 by this push:
     new 37a1c41  [FLINK-18313][docs] Update Hive dialect doc about VIEW
37a1c41 is described below

commit 37a1c4162560ec355723acce5406f6e8125ae65a
Author: Rui Li <li...@apache.org>
AuthorDate: Tue Jun 23 17:22:42 2020 +0800

    [FLINK-18313][docs] Update Hive dialect doc about VIEW
    
    This closes #12666
---
 docs/dev/table/hive/hive_dialect.md    | 3 +++
 docs/dev/table/hive/hive_dialect.zh.md | 3 +++
 2 files changed, 6 insertions(+)

diff --git a/docs/dev/table/hive/hive_dialect.md b/docs/dev/table/hive/hive_dialect.md
index 3ac1177..c5c039c 100644
--- a/docs/dev/table/hive/hive_dialect.md
+++ b/docs/dev/table/hive/hive_dialect.md
@@ -272,6 +272,8 @@ CREATE VIEW [IF NOT EXISTS] view_name [(column_name, ...) ]
 
 #### Alter
 
+**NOTE**: Altering view only works in Table API, but not supported via SQL client.
+
 ##### Rename
 
 {% highlight sql %}
@@ -345,3 +347,4 @@ location is only supported in Hive-2.4.0 or later.
 - Hive and Calcite have different sets of reserved keywords. For example, `default` is a reserved keyword in Calcite and
 a non-reserved keyword in Hive. Even with Hive dialect, you have to quote such keywords with backtick ( ` ) in order to
 use them as identifiers.
+- Due to expanded query incompatibility, views created in Flink cannot be queried in Hive.
diff --git a/docs/dev/table/hive/hive_dialect.zh.md b/docs/dev/table/hive/hive_dialect.zh.md
index d65d458..1236ad8 100644
--- a/docs/dev/table/hive/hive_dialect.zh.md
+++ b/docs/dev/table/hive/hive_dialect.zh.md
@@ -272,6 +272,8 @@ CREATE VIEW [IF NOT EXISTS] view_name [(column_name, ...) ]
 
 #### Alter
 
+**NOTE**: Altering view only works in Table API, but not supported via SQL client.
+
 ##### Rename
 
 {% highlight sql %}
@@ -345,3 +347,4 @@ location is only supported in Hive-2.4.0 or later.
 - Hive and Calcite have different sets of reserved keywords. For example, `default` is a reserved keyword in Calcite and
 a non-reserved keyword in Hive. Even with Hive dialect, you have to quote such keywords with backtick ( ` ) in order to
 use them as identifiers.
+- Due to expanded query incompatibility, views created in Flink cannot be queried in Hive.