You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by ya...@apache.org on 2021/05/06 01:16:17 UTC
[spark] 04/09: Update to eaasier KV syntax
This is an automated email from the ASF dual-hosted git repository.
yamamuro pushed a commit to branch pr31899
in repository https://gitbox.apache.org/repos/asf/spark.git
commit 1d157ed7209b355294b8e07e672ba8b5916e93f5
Author: Niklas Riekenbrauck <ni...@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-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org