PREHOOK: query: drop table tbl1 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table tbl1 POSTHOOK: type: DROPTABLE PREHOOK: query: create table tbl1 (col string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table tbl1 (col string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tbl1 PREHOOK: query: alter table tbl1 enable no_drop cascade PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl1 PREHOOK: Output: default@tbl1 POSTHOOK: query: alter table tbl1 enable no_drop cascade POSTHOOK: type: ALTERTABLE_PROTECTMODE POSTHOOK: Input: default@tbl1 POSTHOOK: Output: default@tbl1 PREHOOK: query: desc extended tbl1 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl1 POSTHOOK: type: DESCTABLE col string Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1322077526, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive1/build/ql/test/data/warehouse/tbl1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=njain, last_modified_time=1322077527, PROTECT_MODE=NO_DROP_CASCADE, transient_lastDdlTime=1322077527}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl1 enable no_drop PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl1 PREHOOK: Output: default@tbl1 POSTHOOK: query: alter table tbl1 enable no_drop POSTHOOK: type: ALTERTABLE_PROTECTMODE POSTHOOK: Input: default@tbl1 POSTHOOK: Output: default@tbl1 PREHOOK: query: desc extended tbl1 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl1 POSTHOOK: type: DESCTABLE col string Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1322077526, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive1/build/ql/test/data/warehouse/tbl1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=njain, last_modified_time=1322077527, PROTECT_MODE=NO_DROP,NO_DROP_CASCADE, transient_lastDdlTime=1322077527}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl1 disable no_drop cascade PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl1 PREHOOK: Output: default@tbl1 POSTHOOK: query: alter table tbl1 disable no_drop cascade POSTHOOK: type: ALTERTABLE_PROTECTMODE POSTHOOK: Input: default@tbl1 POSTHOOK: Output: default@tbl1 PREHOOK: query: desc extended tbl1 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl1 POSTHOOK: type: DESCTABLE col string Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1322077526, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive1/build/ql/test/data/warehouse/tbl1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=njain, last_modified_time=1322077527, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1322077527}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl1 disable no_drop PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl1 PREHOOK: Output: default@tbl1 POSTHOOK: query: alter table tbl1 disable no_drop POSTHOOK: type: ALTERTABLE_PROTECTMODE POSTHOOK: Input: default@tbl1 POSTHOOK: Output: default@tbl1 PREHOOK: query: drop table tbl1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@tbl1 PREHOOK: Output: default@tbl1 POSTHOOK: query: drop table tbl1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@tbl1 POSTHOOK: Output: default@tbl1 PREHOOK: query: drop table tbl2 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table tbl2 POSTHOOK: type: DROPTABLE PREHOOK: query: create table tbl2 (col string) partitioned by (p string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table tbl2 (col string) partitioned by (p string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tbl2 PREHOOK: query: alter table tbl2 add partition (p='p1') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@tbl2 POSTHOOK: query: alter table tbl2 add partition (p='p1') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@tbl2 POSTHOOK: Output: default@tbl2@p=p1 PREHOOK: query: alter table tbl2 add partition (p='p2') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@tbl2 POSTHOOK: query: alter table tbl2 add partition (p='p2') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@tbl2 POSTHOOK: Output: default@tbl2@p=p2 PREHOOK: query: alter table tbl2 add partition (p='p3') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@tbl2 POSTHOOK: query: alter table tbl2 add partition (p='p3') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@tbl2 POSTHOOK: Output: default@tbl2@p=p3 PREHOOK: query: alter table tbl2 enable no_drop cascade PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl2 PREHOOK: Output: default@tbl2 POSTHOOK: query: alter table tbl2 enable no_drop cascade POSTHOOK: type: ALTERTABLE_PROTECTMODE POSTHOOK: Input: default@tbl2 POSTHOOK: Output: default@tbl2 PREHOOK: query: desc extended tbl2 PREHOOK: type: DESCTABLE POSTHOOK: query: desc extended tbl2 POSTHOOK: type: DESCTABLE col string p string Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1322077528, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null), FieldSchema(name:p, type:string, comment:null)], location:pfile:/data/users/njain/hive1/build/ql/test/data/warehouse/tbl2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:p, type:string, comment:null)], parameters:{last_modified_by=njain, last_modified_time=1322077529, PROTECT_MODE=NO_DROP_CASCADE, transient_lastDdlTime=1322077529}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) PREHOOK: query: alter table tbl2 disable no_drop cascade PREHOOK: type: ALTERTABLE_PROTECTMODE PREHOOK: Input: default@tbl2 PREHOOK: Output: default@tbl2 POSTHOOK: query: alter table tbl2 disable no_drop cascade POSTHOOK: type: ALTERTABLE_PROTECTMODE POSTHOOK: Input: default@tbl2 POSTHOOK: Output: default@tbl2 PREHOOK: query: drop table tbl2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@tbl2 PREHOOK: Output: default@tbl2 POSTHOOK: query: drop table tbl2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@tbl2 POSTHOOK: Output: default@tbl2