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