CREATE TABLE testTable(col1 INT, col2 INT); | |
ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3'); | |
SHOW TBLPROPERTIES testTable; | |
-- unset a subset of the properties and some non-existed properties without if exists | |
ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'x', 'y', 'z'); |