ql/src/test/queries/clientnegative/unset_view_property.q

--! qt:dataset:src
CREATE VIEW testView AS SELECT value FROM src WHERE key=86;
ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200');
SHOW TBLPROPERTIES testView;

-- unset a subset of the properties and some non-existed properties without if exists
ALTER VIEW testView UNSET TBLPROPERTIES ('propB', 'propX', 'propY', 'propZ');