PREHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode drop table tbl_protectmode3 PREHOOK: type: DROPTABLE POSTHOOK: query: -- protect mode: syntax to change protect mode works and queries are not blocked if a table or partition is not in protect mode drop table tbl_protectmode3 POSTHOOK: type: DROPTABLE PREHOOK: query: create table tbl_protectmode3 (col string) partitioned by (p string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table tbl_protectmode3 (col string) partitioned by (p string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tbl_protectmode3 PREHOOK: query: alter table tbl_protectmode3 add partition (p='p1') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@tbl_protectmode3 POSTHOOK: query: alter table tbl_protectmode3 add partition (p='p1') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@tbl_protectmode3 POSTHOOK: Output: default@tbl_protectmode3@p=p1 PREHOOK: query: alter table tbl_protectmode3 add partition (p='p2') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@tbl_protectmode3 POSTHOOK: query: alter table tbl_protectmode3 add partition (p='p2') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@tbl_protectmode3 POSTHOOK: Output: default@tbl_protectmode3@p=p2 PREHOOK: query: select * from tbl_protectmode3 where p='p1' PREHOOK: type: QUERY PREHOOK: Input: default@tbl_protectmode3@p=p1 PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-37_899_8567164411727057325/-mr-10000 POSTHOOK: query: select * from tbl_protectmode3 where p='p1' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl_protectmode3@p=p1 POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-37_899_8567164411727057325/-mr-10000 PREHOOK: query: select * from tbl_protectmode3 where p='p2' PREHOOK: type: QUERY PREHOOK: Input: default@tbl_protectmode3@p=p2 PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_124_6078196023007251883/-mr-10000 POSTHOOK: query: select * from tbl_protectmode3 where p='p2' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl_protectmode3@p=p2 POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_124_6078196023007251883/-mr-10000 PREHOOK: query: alter table tbl_protectmode3 partition (p='p1') enable offline PREHOOK: type: ALTERPARTITION_PROTECTMODE PREHOOK: Input: default@tbl_protectmode3 PREHOOK: Output: default@tbl_protectmode3@p=p1 POSTHOOK: query: alter table tbl_protectmode3 partition (p='p1') enable offline POSTHOOK: type: ALTERPARTITION_PROTECTMODE POSTHOOK: Input: default@tbl_protectmode3 POSTHOOK: Input: default@tbl_protectmode3@p=p1 POSTHOOK: Output: default@tbl_protectmode3@p=p1 PREHOOK: query: select * from tbl_protectmode3 where p='p2' PREHOOK: type: QUERY PREHOOK: Input: default@tbl_protectmode3@p=p2 PREHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_569_2255610848316200687/-mr-10000 POSTHOOK: query: select * from tbl_protectmode3 where p='p2' POSTHOOK: type: QUERY POSTHOOK: Input: default@tbl_protectmode3@p=p2 POSTHOOK: Output: file:/tmp/njain/hive_2010-11-16_18-47-38_569_2255610848316200687/-mr-10000 FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode3 Partition p=p1