ql/src/test/queries/clientnegative/unset_table_property.q - hive - Git at Google

 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');
	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');