This is an automated email from the ASF dual-hosted git repository. yamamuro pushed a commit to branch pull/31899 in repository https://gitbox.apache.org/repos/asf/spark.git
commit 1d157ed7209b355294b8e07e672ba8b5916e93f5 Author: Niklas Riekenbrauck <nikr...@gmail.com> AuthorDate: Sat Mar 27 15:17:26 2021 +0100 Update to eaasier KV syntax --- docs/sql-ref-syntax-ddl-alter-database.md | 2 +- docs/sql-ref-syntax-ddl-alter-table.md | 8 ++++---- docs/sql-ref-syntax-ddl-alter-view.md | 2 +- docs/sql-ref-syntax-ddl-create-database.md | 4 ++-- docs/sql-ref-syntax-ddl-create-table-datasource.md | 4 ++-- docs/sql-ref-syntax-ddl-create-table-hiveformat.md | 2 +- docs/sql-ref-syntax-ddl-create-table-like.md | 2 +- 7 files changed, 12 insertions(+), 12 deletions(-) diff --git a/docs/sql-ref-syntax-ddl-alter-database.md b/docs/sql-ref-syntax-ddl-alter-database.md index fbc454e..2de9675 100644 --- a/docs/sql-ref-syntax-ddl-alter-database.md +++ b/docs/sql-ref-syntax-ddl-alter-database.md @@ -31,7 +31,7 @@ for a database and may be used for auditing purposes. ```sql ALTER { DATABASE | SCHEMA } database_name - SET DBPROPERTIES ( property_name = property_value [ , ... ] ) + SET DBPROPERTIES ( ( property_name [=] property_value [ , ... ] | ( property_name property_value [ , ... ] ) ``` ### Parameters diff --git a/docs/sql-ref-syntax-ddl-alter-table.md b/docs/sql-ref-syntax-ddl-alter-table.md index 2d42eb4..912de0f 100644 --- a/docs/sql-ref-syntax-ddl-alter-table.md +++ b/docs/sql-ref-syntax-ddl-alter-table.md @@ -169,7 +169,7 @@ this overrides the old value with the new one. ```sql -- Set Table Properties -ALTER TABLE table_identifier SET TBLPROPERTIES ( key1 = val1, key2 = val2, ... ) +ALTER TABLE table_identifier SET TBLPROPERTIES ( ( key1 [=] val1, key2 [=] val2, ... ) ) -- Unset Table Properties ALTER TABLE table_identifier UNSET TBLPROPERTIES [ IF EXISTS ] ( key1, key2, ... ) @@ -184,10 +184,10 @@ ALTER TABLE table_identifier UNSET TBLPROPERTIES [ IF EXISTS ] ( key1, key2, ... ```sql -- Set SERDE Properties ALTER TABLE table_identifier [ partition_spec ] - SET SERDEPROPERTIES ( key1 = val1, key2 = val2, ... ) + SET SERDEPROPERTIES ( ( key1 = val1, key2 = val2, ... ) | ( key1 val1, key2 val2, ... ) ) ALTER TABLE table_identifier [ partition_spec ] SET SERDE serde_class_name - [ WITH SERDEPROPERTIES ( key1 = val1, key2 = val2, ... ) ] + [ WITH SERDEPROPERTIES ( ( key1 = val1, key2 = val2, ... ) | ( key1 val1, key2 val2, ... ) ) ] ``` #### SET LOCATION And SET FILE FORMAT @@ -221,7 +221,7 @@ ALTER TABLE table_identifier [ partition_spec ] SET LOCATION 'new_location' **Syntax:** `PARTITION ( partition_col_name = partition_col_val [ , ... ] )` -* **SERDEPROPERTIES ( key1 = val1, key2 = val2, ... )** +* **SERDEPROPERTIES ( ( key1 = val1, key2 = val2, ... ) | ( key1 val1, key2 val2, ... ) ) ** Specifies the SERDE properties to be set. diff --git a/docs/sql-ref-syntax-ddl-alter-view.md b/docs/sql-ref-syntax-ddl-alter-view.md index d69f246..25280c4 100644 --- a/docs/sql-ref-syntax-ddl-alter-view.md +++ b/docs/sql-ref-syntax-ddl-alter-view.md @@ -49,7 +49,7 @@ the properties. #### Syntax ```sql -ALTER VIEW view_identifier SET TBLPROPERTIES ( property_key = property_val [ , ... ] ) +ALTER VIEW view_identifier SET TBLPROPERTIES ( property_key [=] property_val [ , ... ] ) ``` #### Parameters diff --git a/docs/sql-ref-syntax-ddl-create-database.md b/docs/sql-ref-syntax-ddl-create-database.md index 9d8bf47..7db410e 100644 --- a/docs/sql-ref-syntax-ddl-create-database.md +++ b/docs/sql-ref-syntax-ddl-create-database.md @@ -29,7 +29,7 @@ Creates a database with the specified name. If database with the same name alrea CREATE { DATABASE | SCHEMA } [ IF NOT EXISTS ] database_name [ COMMENT database_comment ] [ LOCATION database_directory ] - [ WITH DBPROPERTIES ( property_name = property_value [ , ... ] ) ] + [ WITH DBPROPERTIES ( property_name [=] property_value [ , ... ] ) ] ``` ### Parameters @@ -50,7 +50,7 @@ CREATE { DATABASE | SCHEMA } [ IF NOT EXISTS ] database_name Specifies the description for the database. -* **WITH DBPROPERTIES ( property_name=property_value [ , ... ] )** +* **WITH DBPROPERTIES ( property_name [=] property_value [ , ... ] )** Specifies the properties for the database in key-value pairs. diff --git a/docs/sql-ref-syntax-ddl-create-table-datasource.md b/docs/sql-ref-syntax-ddl-create-table-datasource.md index 9926bc6..7d8e692 100644 --- a/docs/sql-ref-syntax-ddl-create-table-datasource.md +++ b/docs/sql-ref-syntax-ddl-create-table-datasource.md @@ -29,14 +29,14 @@ The `CREATE TABLE` statement defines a new table using a Data Source. CREATE TABLE [ IF NOT EXISTS ] table_identifier [ ( col_name1 col_type1 [ COMMENT col_comment1 ], ... ) ] USING data_source - [ OPTIONS ( ( key1=val1, key2=val2, ... ) | ( key1 val1, key2 val2, ... ) ) ] + [ OPTIONS ( key1 [=] val1, key2 [=] val2, ... ) ] [ PARTITIONED BY ( col_name1, col_name2, ... ) ] [ CLUSTERED BY ( col_name3, col_name4, ... ) [ SORTED BY ( col_name [ ASC | DESC ], ... ) ] INTO num_buckets BUCKETS ] [ LOCATION path ] [ COMMENT table_comment ] - [ TBLPROPERTIES ( ( key1=val1, key2=val2, ... ) | ( key1 val1, key2 val2, ... ) ) ] + [ TBLPROPERTIES ( key1 [=] val1, key2 [=] val2, ... ) ] [ AS select_statement ] ``` diff --git a/docs/sql-ref-syntax-ddl-create-table-hiveformat.md b/docs/sql-ref-syntax-ddl-create-table-hiveformat.md index 2e05e64..48d089d 100644 --- a/docs/sql-ref-syntax-ddl-create-table-hiveformat.md +++ b/docs/sql-ref-syntax-ddl-create-table-hiveformat.md @@ -37,7 +37,7 @@ CREATE [ EXTERNAL ] TABLE [ IF NOT EXISTS ] table_identifier [ ROW FORMAT row_format ] [ STORED AS file_format ] [ LOCATION path ] - [ TBLPROPERTIES ( ( key1=val1, key2=val2, ... ) | ( key1 val1, key2 val2, ... ) ) ] + [ TBLPROPERTIES ( ( key1 [=] val1, key2 [=] val2, ... ) ] [ AS select_statement ] ``` diff --git a/docs/sql-ref-syntax-ddl-create-table-like.md b/docs/sql-ref-syntax-ddl-create-table-like.md index 772b299..01a59c2 100644 --- a/docs/sql-ref-syntax-ddl-create-table-like.md +++ b/docs/sql-ref-syntax-ddl-create-table-like.md @@ -30,7 +30,7 @@ CREATE TABLE [IF NOT EXISTS] table_identifier LIKE source_table_identifier USING data_source [ ROW FORMAT row_format ] [ STORED AS file_format ] - [ TBLPROPERTIES ( ( key1=val1, key2=val2, ... ) | ( key1 val1, key2 val2, ... ) ) ] + [ TBLPROPERTIES ( key1 [=] val1, key2 [=] val2, ... ) ] [ LOCATION path ] ``` --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org