You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by st...@apache.org on 2022/10/18 00:14:42 UTC
[impala] 04/04: IMPALA-11420: [DOCS] Document CREATE/ALTER VIEW SET/UNSET TBLPROPERTIES syntax
This is an automated email from the ASF dual-hosted git repository.
stigahuang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git
commit 6a1a871fb7f014be0ab9dbc0ac450416b897a263
Author: xiabaike <xi...@163.com>
AuthorDate: Fri Oct 14 08:58:28 2022 +0000
IMPALA-11420: [DOCS] Document CREATE/ALTER VIEW SET/UNSET TBLPROPERTIES syntax
Update document for
[ CREATE VIEW ... TBLPROPERTIES ('key' = 'value', ...) ]
and
[ ALTER VIEW view_name SET/UNSET TBLPROPERTIES... ] syntax.
Change-Id: Ief1d6bb525ba85a58b8123a0cb712d83523daaec
Reviewed-on: http://gerrit.cloudera.org:8080/19143
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: Quanlong Huang <hu...@gmail.com>
---
docs/topics/impala_alter_view.xml | 24 ++++++++++++++++++++++++
docs/topics/impala_create_view.xml | 4 ++++
2 files changed, 28 insertions(+)
diff --git a/docs/topics/impala_alter_view.xml b/docs/topics/impala_alter_view.xml
index 75a243cac..a9bbefc44 100644
--- a/docs/topics/impala_alter_view.xml
+++ b/docs/topics/impala_alter_view.xml
@@ -68,6 +68,12 @@ ALTER VIEW [<varname>database_name</varname>.]<varname>view_name</varname>
RENAME TO [<varname>database_name</varname>.]<varname>view_name</varname>;
ALTER VIEW [<varname>database_name</varname>.]<varname>view_name</varname> SET OWNER USER user_name;
+
+ALTER VIEW [<varname>database_name</varname>.]<varname>view_name</varname>
+ SET TBLPROPERTIES ('<varname>name</varname>' = '<varname>value</varname>'[, '<varname>name</varname>' = '<varname>value</varname>' ...]);
+
+ALTER VIEW [<varname>database_name</varname>.]<varname>view_name</varname>
+ UNSET TBLPROPERTIES ('<varname>name</varname>'[, ...]);
</codeblock>
<ul>
@@ -110,6 +116,24 @@ ALTER VIEW db1.v1 RENAME TO db2.v1; -- Move the view to a difference database wi
<codeph>CREATE VIEW</codeph> statement.
</p>
</li>
+
+ <li rev="IMPALA-11420">
+ The <codeph>SET TBLPROPERTIES</codeph> clause is primarily a way to associate arbitrary
+ user-specified data items with a particular view.
+ <p>
+ You can associate arbitrary items of metadata with a table by specifying the
+ <codeph>TBLPROPERTIES</codeph> clause. This clause takes a comma-separated list of
+ key-value pairs and stores those items in the metastore database. You can also unset the
+ view properties later with an <codeph>UNSET TBLPROPERTIES</codeph> clause.
+ </p>
+
+ <p>
+ For example:
+<codeblock>ALTER VIEW v1 SET TBLPROPERTIES ('tblp1' = '1', 'tblp2' = '2');
+ALTER VIEW v1 UNSET TBLPROPERTIES ('tblp1', 'tblp2');
+</codeblock>
+ </p>
+ </li>
</ul>
<p conref="../shared/impala_common.xml#common/ddl_blurb"/>
diff --git a/docs/topics/impala_create_view.xml b/docs/topics/impala_create_view.xml
index 8a5cca266..56591d765 100644
--- a/docs/topics/impala_create_view.xml
+++ b/docs/topics/impala_create_view.xml
@@ -61,6 +61,7 @@ under the License.
<codeblock>CREATE VIEW [IF NOT EXISTS] <varname>view_name</varname>
[(<varname>column_name</varname> [COMMENT '<varname>column_comment</varname>'][, ...])]
[COMMENT '<varname>view_comment</varname>']
+ [TBLPROPERTIES ('<varname>name</varname>' = '<varname>value</varname>'[, ...])]
AS <varname>select_statement</varname></codeblock>
<p conref="../shared/impala_common.xml#common/ddl_blurb"/>
@@ -160,6 +161,9 @@ CREATE VIEW v6 AS SELECT t1.c1, t2.c2 FROM t1 JOIN t2 ON t1.id = t2.id;
-- Create a view with a column comment and a table comment.
CREATE VIEW v7 (c1 COMMENT 'Comment for c1', c2) COMMENT 'Comment for v7' AS SELECT t1.c1, t1.c2 FROM t1;
+
+-- Create a view with tblproperties.
+CREATE VIEW v7 (c1 , c2) TBLPROPERTIES ('tblp1' = '1', 'tblp2' = '2') AS SELECT t1.c1, t1.c2 FROM t1;
</codeblock>
<p conref="../shared/impala_common.xml#common/related_info"/>