blob: b4e508ff98180b2b37d3c5400b3c055a851f9304 [file] [log] [blame]
-- protect mode: syntax to change protect mode works and queries to drop partitions are blocked if it is marked no drop
drop table tbl_protectmode_no_drop;
create table tbl_protectmode_no_drop (c1 string,c2 string) partitioned by (p string);
alter table tbl_protectmode_no_drop add partition (p='p1');
alter table tbl_protectmode_no_drop partition (p='p1') enable no_drop;
desc extended tbl_protectmode_no_drop partition (p='p1');
alter table tbl_protectmode_no_drop drop partition (p='p1');