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 <[email protected]> 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 <[email protected]> Reviewed-by: Quanlong Huang <[email protected]> --- 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"/>
