cloud-fan commented on code in PR #47097:
URL: https://github.com/apache/spark/pull/47097#discussion_r1663681639
##########
docs/sql-ref-syntax-ddl-alter-table.md:
##########
@@ -236,20 +236,28 @@ ALTER TABLE table_identifier DROP [ IF EXISTS ]
partition_spec [PURGE]
### SET AND UNSET
-#### SET TABLE PROPERTIES
+#### SET PROPERTIES
`ALTER TABLE SET` command is used for setting the table properties. If a
particular property was already set,
this overrides the old value with the new one.
-`ALTER TABLE UNSET` is used to drop the table property.
-
##### Syntax
```sql
--- Set Table Properties
+-- Set Properties
ALTER TABLE table_identifier SET TBLPROPERTIES ( key1 = val1, key2 = val2, ...
)
+```
+
+#### UNSET PROPERTIES
+
+`ALTER TABLE UNSET` command is used to drop the table property.
--- Unset Table Properties
+**Note:** If the specified property key does not exist, whether specify `IF
EXISTS` or not, the command will ignore it and finally succeed.
+
+##### Syntax
+
+```sql
+-- Unset Properties
ALTER TABLE table_identifier UNSET TBLPROPERTIES [ IF EXISTS ] ( key1, key2,
... )
Review Comment:
let's remove `[ IF EXISTS ]` as a way to deprecate. It's no longer effective.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
