You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/08/05 07:36:50 UTC
svn commit: r982476 [2/2] - in /hadoop/hive/trunk: ./
metastore/src/java/org/apache/hadoop/hive/metastore/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/metadata/
ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/j...
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part2.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part2.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part2.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,28 @@
+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_protectmode6
+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_protectmode6
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode6 (c1 string,c2 string) partitioned by (p string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode6 (c1 string,c2 string) partitioned by (p string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode6
+PREHOOK: query: alter table tbl_protectmode6 add partition (p='p1')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: query: alter table tbl_protectmode6 add partition (p='p1')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl_protectmode6@p=p1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' OVERWRITE INTO TABLE tbl_protectmode6 partition (p='p1')
+PREHOOK: type: LOAD
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' OVERWRITE INTO TABLE tbl_protectmode6 partition (p='p1')
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@tbl_protectmode6@p=p1
+PREHOOK: query: alter table tbl_protectmode6 partition (p='p1') enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode6 partition (p='p1') enable offline
+POSTHOOK: type: null
+FAILED: Error in semantic analysis: org.apache.hadoop.hive.ql.parse.SemanticException: Query against an offline table or partition tbl_protectmode6:p=p1
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_part_no_drop.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,35 @@
+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_protectmode_no_drop
+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_protectmode_no_drop
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode_no_drop (c1 string,c2 string) partitioned by (p string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_no_drop (c1 string,c2 string) partitioned by (p string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_no_drop
+PREHOOK: query: alter table tbl_protectmode_no_drop add partition (p='p1')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: query: alter table tbl_protectmode_no_drop add partition (p='p1')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl_protectmode_no_drop@p=p1
+PREHOOK: query: alter table tbl_protectmode_no_drop partition (p='p1') enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_no_drop partition (p='p1') enable no_drop
+POSTHOOK: type: null
+PREHOOK: query: desc extended tbl_protectmode_no_drop partition (p='p1')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl_protectmode_no_drop partition (p='p1')
+POSTHOOK: type: DESCTABLE
+c1 string
+c2 string
+p string
+
+Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl_protectmode_no_drop, createTime:1280951430, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:c1, type:string, comment:null), FieldSchema(name:c2, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/build/ql/test/data/warehouse/tbl_protectmode_no_drop/p=p1, 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:{}), parameters:{PROTECT_MODE=NO_DROP, transient_lastDdlTime=1280951430})
+PREHOOK: query: drop table tbl_protectmode_no_drop
+PREHOOK: type: DROPTABLE
+FAILED: Error in metadata: Table tbl_protectmode_no_drop Partitionp=p1 is protected from being dropped
+FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl1.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl1.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl1.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,28 @@
+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_protectmode_1
+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_protectmode_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode_1 (col string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_1 (col string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_1
+PREHOOK: query: select * from tbl_protectmode_1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_protectmode_1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_15-57-58_359_6963528649235778507/-mr-10000
+POSTHOOK: query: select * from tbl_protectmode_1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_protectmode_1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_15-57-58_359_6963528649235778507/-mr-10000
+PREHOOK: query: alter table tbl_protectmode_1 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_1 enable offline
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_1
+POSTHOOK: Output: default@tbl_protectmode_1
+FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_1
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl2.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,45 @@
+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_protectmode2
+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_protectmode2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode2 (col string) partitioned by (p string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode2 (col string) partitioned by (p string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode2
+PREHOOK: query: alter table tbl_protectmode2 add partition (p='p1')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: query: alter table tbl_protectmode2 add partition (p='p1')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl_protectmode2@p=p1
+PREHOOK: query: alter table tbl_protectmode2 enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode2 enable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode2
+POSTHOOK: Output: default@tbl_protectmode2
+PREHOOK: query: alter table tbl_protectmode2 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode2 enable offline
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode2
+POSTHOOK: Output: default@tbl_protectmode2
+PREHOOK: query: alter table tbl_protectmode2 disable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode2 disable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode2
+POSTHOOK: Output: default@tbl_protectmode2
+PREHOOK: query: desc extended tbl_protectmode2
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl_protectmode2
+POSTHOOK: type: DESCTABLE
+col string
+p string
+
+Detailed Table Information Table(tableName:tbl_protectmode2, dbName:default, owner:sdong, createTime:1280964330, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/build/ql/test/data/warehouse/tbl_protectmode2, 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=sdong, last_modified_time=1280964330, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280964330}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode2
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl3.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,35 @@
+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_protectmode_4
+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_protectmode_4
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode_4 (col string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_4 (col string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_4
+PREHOOK: query: select col from tbl_protectmode_4
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_protectmode_4
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_15-57-59_668_7963898681822155966/-mr-10000
+POSTHOOK: query: select col from tbl_protectmode_4
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_protectmode_4
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_15-57-59_668_7963898681822155966/-mr-10000
+PREHOOK: query: alter table tbl_protectmode_4 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_4 enable offline
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_4
+POSTHOOK: Output: default@tbl_protectmode_4
+PREHOOK: query: desc extended tbl_protectmode_4
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl_protectmode_4
+POSTHOOK: type: DESCTABLE
+col string
+
+Detailed Table Information Table(tableName:tbl_protectmode_4, dbName:default, owner:sdong, createTime:1280962679, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/build/ql/test/data/warehouse/tbl_protectmode_4, 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=sdong, last_modified_time=1280962682, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280962682}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_4
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl4.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,54 @@
+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_protectmode_tbl4
+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_protectmode_tbl4
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table tbl_protectmode_tbl4_src
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tbl_protectmode_tbl4_src
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode_tbl4_src (col string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_tbl4_src (col string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_tbl4_src
+PREHOOK: query: create table tbl_protectmode_tbl4 (col string) partitioned by (p string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_tbl4 (col string) partitioned by (p string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_tbl4
+PREHOOK: query: alter table tbl_protectmode_tbl4 add partition (p='p1')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: query: alter table tbl_protectmode_tbl4 add partition (p='p1')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl_protectmode_tbl4@p=p1
+PREHOOK: query: alter table tbl_protectmode_tbl4 enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_tbl4 enable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_tbl4
+POSTHOOK: Output: default@tbl_protectmode_tbl4
+PREHOOK: query: alter table tbl_protectmode_tbl4 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_tbl4 enable offline
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_tbl4
+POSTHOOK: Output: default@tbl_protectmode_tbl4
+PREHOOK: query: alter table tbl_protectmode_tbl4 disable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_tbl4 disable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_tbl4
+POSTHOOK: Output: default@tbl_protectmode_tbl4
+PREHOOK: query: desc extended tbl_protectmode_tbl4
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl_protectmode_tbl4
+POSTHOOK: type: DESCTABLE
+col string
+p string
+
+Detailed Table Information Table(tableName:tbl_protectmode_tbl4, dbName:default, owner:njain, createTime:1280986404, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/tbl_protectmode_tbl4, 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=1280986404, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280986404}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_tbl4
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl5.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,54 @@
+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_protectmode_tbl5
+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_protectmode_tbl5
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table tbl_protectmode_tbl5_src
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tbl_protectmode_tbl5_src
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode_tbl5_src (col string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_tbl5_src (col string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_tbl5_src
+PREHOOK: query: create table tbl_protectmode_tbl5 (col string) partitioned by (p string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode_tbl5 (col string) partitioned by (p string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode_tbl5
+PREHOOK: query: alter table tbl_protectmode_tbl5 add partition (p='p1')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: query: alter table tbl_protectmode_tbl5 add partition (p='p1')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl_protectmode_tbl5@p=p1
+PREHOOK: query: alter table tbl_protectmode_tbl5 enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_tbl5 enable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_tbl5
+POSTHOOK: Output: default@tbl_protectmode_tbl5
+PREHOOK: query: alter table tbl_protectmode_tbl5 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_tbl5 enable offline
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_tbl5
+POSTHOOK: Output: default@tbl_protectmode_tbl5
+PREHOOK: query: alter table tbl_protectmode_tbl5 disable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode_tbl5 disable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode_tbl5
+POSTHOOK: Output: default@tbl_protectmode_tbl5
+PREHOOK: query: desc extended tbl_protectmode_tbl5
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl_protectmode_tbl5
+POSTHOOK: type: DESCTABLE
+col string
+p string
+
+Detailed Table Information Table(tableName:tbl_protectmode_tbl5, dbName:default, owner:njain, createTime:1280986496, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/tbl_protectmode_tbl5, 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=1280986496, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280986496}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+FAILED: Error in semantic analysis: Query against an offline table or partition Table tbl_protectmode_tbl5
Added: hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientnegative/protectmode_tbl_no_drop.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,38 @@
+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_protectmode__no_drop
+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_protectmode__no_drop
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tbl_protectmode__no_drop (col string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tbl_protectmode__no_drop (col string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tbl_protectmode__no_drop
+PREHOOK: query: select * from tbl_protectmode__no_drop
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl_protectmode__no_drop
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-03_19-02-13_062_1358034933662934792/-mr-10000
+POSTHOOK: query: select * from tbl_protectmode__no_drop
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl_protectmode__no_drop
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-03_19-02-13_062_1358034933662934792/-mr-10000
+PREHOOK: query: alter table tbl_protectmode__no_drop enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl_protectmode__no_drop enable no_drop
+POSTHOOK: type: null
+POSTHOOK: Input: default@tbl_protectmode__no_drop
+POSTHOOK: Output: default@tbl_protectmode__no_drop
+PREHOOK: query: desc extended tbl_protectmode__no_drop
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl_protectmode__no_drop
+POSTHOOK: type: DESCTABLE
+col string
+
+Detailed Table Information Table(tableName:tbl_protectmode__no_drop, dbName:default, owner:sdong, createTime:1280887333, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/build/ql/test/data/warehouse/tbl_protectmode__no_drop, 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=sdong, last_modified_time=1280887333, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1280887333}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: drop table tbl_protectmode__no_drop
+PREHOOK: type: DROPTABLE
+FAILED: Error in metadata: Table tbl_protectmode__no_drop is protected from being dropped
+FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out?rev=982476&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out Thu Aug 5 05:36:48 2010
@@ -0,0 +1,286 @@
+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 tbl1
+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 tbl1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table tbl2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tbl2
+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: select * from tbl1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-16_084_5868788449948187519/-mr-10000
+POSTHOOK: query: select * from tbl1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-16_084_5868788449948187519/-mr-10000
+PREHOOK: query: select col from tbl1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-16_303_5881584661921655666/-mr-10000
+POSTHOOK: query: select col from tbl1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-16_303_5881584661921655666/-mr-10000
+PREHOOK: query: alter table tbl1 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl1 enable offline
+POSTHOOK: type: null
+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:sdong, createTime:1280962816, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/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=sdong, last_modified_time=1280962819, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280962819}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: alter table tbl1 disable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl1 disable offline
+POSTHOOK: type: null
+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:sdong, createTime:1280962816, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/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=sdong, last_modified_time=1280962819, transient_lastDdlTime=1280962819}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: select * from tbl1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-19_785_3387037181104157417/-mr-10000
+POSTHOOK: query: select * from tbl1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-19_785_3387037181104157417/-mr-10000
+PREHOOK: query: select col from tbl1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-19_991_7208412460463641915/-mr-10000
+POSTHOOK: query: select col from tbl1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-19_991_7208412460463641915/-mr-10000
+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
+POSTHOOK: query: alter table tbl2 add partition (p='p1')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl2@p=p1
+PREHOOK: query: alter table tbl2 add partition (p='p2')
+PREHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: query: alter table tbl2 add partition (p='p2')
+POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Output: default@tbl2@p=p2
+PREHOOK: query: alter table tbl2 drop partition (p='not_exist')
+PREHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: query: alter table tbl2 drop partition (p='not_exist')
+POSTHOOK: type: ALTERTABLE_DROPPARTS
+PREHOOK: query: select * from tbl2 where p='p1'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-23_396_4211977439004283750/-mr-10000
+POSTHOOK: query: select * from tbl2 where p='p1'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-23_396_4211977439004283750/-mr-10000
+PREHOOK: query: select * from tbl2 where p='p2'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p2
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-23_617_4676355123590038305/-mr-10000
+POSTHOOK: query: select * from tbl2 where p='p2'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p2
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-23_617_4676355123590038305/-mr-10000
+PREHOOK: query: alter table tbl2 partition (p='p1') enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 partition (p='p1') enable offline
+POSTHOOK: type: null
+PREHOOK: query: desc extended tbl2 partition (p='p1')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl2 partition (p='p1')
+POSTHOOK: type: DESCTABLE
+col string
+p string
+
+Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1280962823, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/build/ql/test/data/warehouse/tbl2/p=p1, 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:{}), parameters:{PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280962823})
+PREHOOK: query: alter table tbl2 enable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 enable offline
+POSTHOOK: type: null
+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:sdong, createTime:1280962823, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/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=sdong, last_modified_time=1280962824, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1280962824}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: alter table tbl2 enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 enable no_drop
+POSTHOOK: type: null
+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:sdong, createTime:1280962823, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/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=sdong, last_modified_time=1280962824, PROTECT_MODE=OFFLINE,NO_DROP, transient_lastDdlTime=1280962824}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: alter table tbl2 disable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 disable offline
+POSTHOOK: type: null
+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:sdong, createTime:1280962823, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/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=sdong, last_modified_time=1280962824, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1280962824}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: alter table tbl2 disable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 disable no_drop
+POSTHOOK: type: null
+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:sdong, createTime:1280962823, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/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=sdong, last_modified_time=1280962824, transient_lastDdlTime=1280962824}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+PREHOOK: query: select * from tbl2 where p='p2'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p2
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-24_808_6663194749606163260/-mr-10000
+POSTHOOK: query: select * from tbl2 where p='p2'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p2
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-24_808_6663194749606163260/-mr-10000
+PREHOOK: query: select col from tbl2 where p='p2'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p2
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-24_975_1396047242551851951/-mr-10000
+POSTHOOK: query: select col from tbl2 where p='p2'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p2
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-24_975_1396047242551851951/-mr-10000
+PREHOOK: query: alter table tbl2 partition (p='p1') disable offline
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 partition (p='p1') disable offline
+POSTHOOK: type: null
+PREHOOK: query: desc extended tbl2 partition (p='p1')
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc extended tbl2 partition (p='p1')
+POSTHOOK: type: DESCTABLE
+col string
+p string
+
+Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1280962823, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/data/users/sdong/hive-vendor-trunk-git/build/ql/test/data/warehouse/tbl2/p=p1, 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:{}), parameters:{transient_lastDdlTime=1280962828})
+PREHOOK: query: select * from tbl2 where p='p1'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-28_142_3955301982627210591/-mr-10000
+POSTHOOK: query: select * from tbl2 where p='p1'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-28_142_3955301982627210591/-mr-10000
+PREHOOK: query: select col from tbl2 where p='p1'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p1
+PREHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-28_295_5354583470260616394/-mr-10000
+POSTHOOK: query: select col from tbl2 where p='p1'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: file:/tmp/sdong/hive_2010-08-04_16-00-28_295_5354583470260616394/-mr-10000
+PREHOOK: query: insert overwrite table tbl1 select col from tbl2 where p='p1'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl2@p=p1
+PREHOOK: Output: default@tbl1
+POSTHOOK: query: insert overwrite table tbl1 select col from tbl2 where p='p1'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: default@tbl1
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+PREHOOK: query: insert overwrite table tbl1 select col from tbl1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: default@tbl1
+POSTHOOK: query: insert overwrite table tbl1 select col from tbl1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tbl1
+POSTHOOK: Output: default@tbl1
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: alter table tbl2 partition (p='p1') enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 partition (p='p1') enable no_drop
+POSTHOOK: type: null
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: alter table tbl2 partition (p='p1') disable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 partition (p='p1') disable no_drop
+POSTHOOK: type: null
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: alter table tbl2 partition (p='p2') enable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 partition (p='p2') enable no_drop
+POSTHOOK: type: null
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: alter table tbl2 drop partition (p='p1')
+PREHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: query: alter table tbl2 drop partition (p='p1')
+POSTHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: Output: default@tbl2@p=p1
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: alter table tbl2 partition (p='p2') disable no_drop
+PREHOOK: type: null
+POSTHOOK: query: alter table tbl2 partition (p='p2') disable no_drop
+POSTHOOK: type: null
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: drop table tbl1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tbl1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@tbl1
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]
+PREHOOK: query: drop table tbl2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tbl2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Output: default@tbl2
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:p, type:string, comment:null), ]
+POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]