You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by he...@apache.org on 2010/08/18 00:33:46 UTC
svn commit: r986512 [7/9] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientnegative/ ql/src/test/queries/clientpositive/
ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out Tue Aug 17 22:33:43 2010
@@ -107,11 +107,11 @@ POSTHOOK: Lineage: dest1.e SIMPLE [(src_
PREHOOK: query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-47_206_1738690132485609113/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-36_002_6394574811571020120/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-47_206_1738690132485609113/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-36_002_6394574811571020120/-mr-10000
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
@@ -131,11 +131,11 @@ null null null 0 NULL
PREHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-49_829_7164503488670177874/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-39_505_1202718209239610725/-mr-10000
POSTHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-49_829_7164503488670177874/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-39_505_1202718209239610725/-mr-10000
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
@@ -154,8 +154,11 @@ POSTHOOK: Lineage: dest1.e SIMPLE [(src_
NULL NULL NULL 0 NULL
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@dest1
+PREHOOK: Output: default@dest1
POSTHOOK: query: DROP TABLE dest1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@dest1
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
@@ -189,11 +192,11 @@ POSTHOOK: Lineage: dest1.e SIMPLE [(src_
PREHOOK: query: SELECT * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-54_936_8554551256357567949/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-47_026_3993263922773820549/-mr-10000
POSTHOOK: query: SELECT * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-54_936_8554551256357567949/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-47_026_3993263922773820549/-mr-10000
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
@@ -213,8 +216,11 @@ POSTHOOK: Lineage: dest1.e SIMPLE [(src_
null
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@dest1
+PREHOOK: Output: default@dest1
POSTHOOK: query: DROP TABLE dest1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@dest1
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
@@ -251,11 +257,11 @@ POSTHOOK: Lineage: dest1.e SIMPLE [(src_
PREHOOK: query: SELECT * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-57_561_6501047538497175840/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-51_790_8751887109831886457/-mr-10000
POSTHOOK: query: SELECT * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-57_561_6501047538497175840/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-00-51_790_8751887109831886457/-mr-10000
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out Tue Aug 17 22:33:43 2010
@@ -27,7 +27,7 @@ key string
value string
ds string
-Detailed Table Information Table(tableName:inputddl6, dbName:default, owner:jssarma, createTime:1279737060, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/inputddl6, 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:ds, type:string, comment:null)], parameters:{transient_lastDdlTime=1279737060}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:inputddl6, dbName:default, owner:njain, createTime:1282028549, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/inputddl6, 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:ds, type:string, comment:null)], parameters:{transient_lastDdlTime=1282028549}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08')
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-08')
@@ -36,7 +36,7 @@ key string
value string
ds string
-Detailed Partition Information Partition(values:[2008-04-08], dbName:default, tableName:inputddl6, createTime:1279737060, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/inputddl6/ds=2008-04-08, 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=1279737060})
+Detailed Partition Information Partition(values:[2008-04-08], dbName:default, tableName:inputddl6, createTime:1282028551, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/inputddl6/ds=2008-04-08, 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=1282028551})
PREHOOK: query: SHOW PARTITIONS INPUTDDL6
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS INPUTDDL6
@@ -45,8 +45,11 @@ ds=2008-04-08
ds=2008-04-09
PREHOOK: query: ALTER TABLE INPUTDDL6 DROP PARTITION (ds='2008-04-08')
PREHOOK: type: ALTERTABLE_DROPPARTS
+PREHOOK: Input: default@inputddl6
+PREHOOK: Output: default@inputddl6@ds=2008-04-08
POSTHOOK: query: ALTER TABLE INPUTDDL6 DROP PARTITION (ds='2008-04-08')
POSTHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: Input: default@inputddl6
POSTHOOK: Output: default@inputddl6@ds=2008-04-08
PREHOOK: query: SHOW PARTITIONS INPUTDDL6
PREHOOK: type: SHOWPARTITIONS
@@ -55,8 +58,11 @@ POSTHOOK: type: SHOWPARTITIONS
ds=2008-04-09
PREHOOK: query: DROP TABLE INPUTDDL6
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@inputddl6
+PREHOOK: Output: default@inputddl6
POSTHOOK: query: DROP TABLE INPUTDDL6
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@inputddl6
POSTHOOK: Output: default@inputddl6
PREHOOK: query: EXPLAIN
DESCRIBE EXTENDED INPUTDDL6 PARTITION (ds='2008-04-09')
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/insertexternal1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/insertexternal1.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/insertexternal1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/insertexternal1.q.out Tue Aug 17 22:33:43 2010
@@ -3,10 +3,12 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table texternal(key string, val string) partitioned by (insertdate string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@texternal
-PREHOOK: query: alter table texternal add partition (insertdate='2008-01-01') location 'file:///tmp/texternal/2008-01-01'
+PREHOOK: query: alter table texternal add partition (insertdate='2008-01-01') location 'pfile:///tmp/texternal/2008-01-01'
PREHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: query: alter table texternal add partition (insertdate='2008-01-01') location 'file:///tmp/texternal/2008-01-01'
+PREHOOK: Input: default@texternal
+POSTHOOK: query: alter table texternal add partition (insertdate='2008-01-01') location 'pfile:///tmp/texternal/2008-01-01'
POSTHOOK: type: ALTERTABLE_ADDPARTS
+POSTHOOK: Input: default@texternal
POSTHOOK: Output: default@texternal@insertdate=2008-01-01
PREHOOK: query: from src insert overwrite table texternal partition (insertdate='2008-01-01') select *
PREHOOK: type: QUERY
@@ -21,11 +23,11 @@ POSTHOOK: Lineage: texternal PARTITION(i
PREHOOK: query: select * from texternal where insertdate='2008-01-01'
PREHOOK: type: QUERY
PREHOOK: Input: default@texternal@insertdate=2008-01-01
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-31-18_438_8696467469328137226/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-03-00_762_9033730690799638856/-mr-10000
POSTHOOK: query: select * from texternal where insertdate='2008-01-01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@texternal@insertdate=2008-01-01
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-31-18_438_8696467469328137226/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-03-00_762_9033730690799638856/-mr-10000
POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).val SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
238 val_238 2008-01-01
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out Tue Aug 17 22:33:43 2010
@@ -94,7 +94,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-41-11_754_2355902204761904023/-ext-10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_00-21-35_748_3025262250034787862/-ext-10000
Stage: Stage-0
Move Operator
@@ -109,7 +109,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-41-11_754_2355902204761904023/-ext-10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_00-21-35_748_3025262250034787862/-ext-10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -148,11 +148,11 @@ POSTHOOK: Lineage: dest1.val EXPRESSION
PREHOOK: query: select * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-08-10_14-41-14_599_1474799090825578288/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-21-40_109_458886899479352139/-mr-10000
POSTHOOK: query: select * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-08-10_14-41-14_599_1474799090825578288/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-21-40_109_458886899479352139/-mr-10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.val EXPRESSION [(src)src.null, ]
0 3
@@ -466,8 +466,11 @@ POSTHOOK: Lineage: dest1.val EXPRESSION
98 2
PREHOOK: query: drop table dest1
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@dest1
+PREHOOK: Output: default@dest1
POSTHOOK: query: drop table dest1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@dest1
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.val EXPRESSION [(src)src.null, ]
@@ -561,7 +564,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-41-20_436_8449567630117985977/-ext-10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_00-21-48_756_6621702958877285726/-ext-10000
Stage: Stage-0
Move Operator
@@ -576,7 +579,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-41-20_436_8449567630117985977/-ext-10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_00-21-48_756_6621702958877285726/-ext-10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -666,7 +669,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-41-25_717_6823551420020401280/-ext-10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_00-21-57_114_2919638816536107892/-ext-10000
Stage: Stage-0
Move Operator
@@ -681,7 +684,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/heyongqiang/hive-trunk-clean/build/ql/scratchdir/hive_2010-08-10_14-41-25_717_6823551420020401280/-ext-10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_00-21-57_114_2919638816536107892/-ext-10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out Tue Aug 17 22:33:43 2010
@@ -74,12 +74,12 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl@ds=2008-04-08
PREHOOK: Input: default@tstparttbl@ds=2008-04-09
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-11_573_4565213151672229951/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-16_782_400043420949497617/-mr-10000
POSTHOOK: query: select count(1) from tstparttbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-11_573_4565213151672229951/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-16_782_400043420949497617/-mr-10000
500
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
@@ -157,17 +157,20 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-14_641_615139224470628595/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-22_475_3755322603416219894/-mr-10000
POSTHOOK: query: select count(1) from tstparttbl2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-14_641_615139224470628595/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-22_475_3755322603416219894/-mr-10000
0
PREHOOK: query: DROP TABLE tstparttbl
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tstparttbl
+PREHOOK: Output: default@tstparttbl
POSTHOOK: query: DROP TABLE tstparttbl
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tstparttbl
POSTHOOK: Output: default@tstparttbl
PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
@@ -245,17 +248,20 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl@ds=2008-04-08
PREHOOK: Input: default@tstparttbl@ds=2008-04-09
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-17_697_2205434267515314781/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-28_557_293556059240399525/-mr-10000
POSTHOOK: query: select count(1) from tstparttbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-17_697_2205434267515314781/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-28_557_293556059240399525/-mr-10000
500
PREHOOK: query: DROP TABLE tstparttbl2
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tstparttbl2
+PREHOOK: Output: default@tstparttbl2
POSTHOOK: query: DROP TABLE tstparttbl2
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tstparttbl2
POSTHOOK: Output: default@tstparttbl2
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
@@ -333,10 +339,10 @@ PREHOOK: query: select count(1) from tst
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-20_708_4976141185424807073/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-35_611_7617453415628310797/-mr-10000
POSTHOOK: query: select count(1) from tstparttbl2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-44-20_708_4976141185424807073/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-26-35_611_7617453415628310797/-mr-10000
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out Tue Aug 17 22:33:43 2010
@@ -15,6 +15,8 @@ POSTHOOK: Lineage: partition_vs_table PA
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: alter table partition_vs_table add columns (newcol string)
PREHOOK: type: ALTERTABLE_ADDCOLS
+PREHOOK: Input: default@partition_vs_table
+PREHOOK: Output: default@partition_vs_table
POSTHOOK: query: alter table partition_vs_table add columns (newcol string)
POSTHOOK: type: ALTERTABLE_ADDCOLS
POSTHOOK: Input: default@partition_vs_table
@@ -39,13 +41,13 @@ order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_vs_table@ds=100
PREHOOK: Input: default@partition_vs_table@ds=101
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-45-18_342_8996179008267998708/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-35_949_706393903088310087/-mr-10000
POSTHOOK: query: select key, value, newcol from partition_vs_table
order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_vs_table@ds=100
POSTHOOK: Input: default@partition_vs_table@ds=101
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-45-18_342_8996179008267998708/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-35_949_706393903088310087/-mr-10000
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=100).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_vs_table PARTITION(ds=101).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out Tue Aug 17 22:33:43 2010
@@ -20,8 +20,8 @@ POSTHOOK: type: SHOW_TABLESTATUS
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -32,7 +32,7 @@ totalFileSize:216
maxFileSize:216
minFileSize:216
lastAccessTime:0
-lastUpdateTime:1281167892000
+lastUpdateTime:1282030124000
PREHOOK: query: show table extended like partition_test_partitioned partition(dt=100)
PREHOOK: type: SHOW_TABLESTATUS
@@ -41,8 +41,8 @@ POSTHOOK: type: SHOW_TABLESTATUS
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=100
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=100
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -53,16 +53,16 @@ totalFileSize:216
maxFileSize:216
minFileSize:216
lastAccessTime:0
-lastUpdateTime:1281167892000
+lastUpdateTime:1282030124000
PREHOOK: query: select key from partition_test_partitioned where dt=100
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-12_540_2239548703782463764/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-45_751_169876228483688017/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-12_540_2239548703782463764/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-45_751_169876228483688017/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
238
@@ -93,11 +93,11 @@ POSTHOOK: Lineage: partition_test_partit
PREHOOK: query: select key from partition_test_partitioned
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-16_365_1091922344087311950/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-49_132_7250201183436014876/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-16_365_1091922344087311950/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-49_132_7250201183436014876/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
238
@@ -127,6 +127,8 @@ POSTHOOK: Lineage: partition_test_partit
PREHOOK: query: alter table partition_test_partitioned set fileformat rcfile
PREHOOK: type: ALTERTABLE_FILEFORMAT
+PREHOOK: Input: default@partition_test_partitioned
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: alter table partition_test_partitioned set fileformat rcfile
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@partition_test_partitioned
@@ -154,8 +156,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { string key, string value}
@@ -166,7 +168,7 @@ totalFileSize:586
maxFileSize:370
minFileSize:216
lastAccessTime:0
-lastUpdateTime:1281167904000
+lastUpdateTime:1282030136000
PREHOOK: query: show table extended like partition_test_partitioned partition(dt=100)
PREHOOK: type: SHOW_TABLESTATUS
@@ -177,8 +179,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=100
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=100
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -189,7 +191,7 @@ totalFileSize:216
maxFileSize:216
minFileSize:216
lastAccessTime:0
-lastUpdateTime:1281167904000
+lastUpdateTime:1282030136000
PREHOOK: query: show table extended like partition_test_partitioned partition(dt=101)
PREHOOK: type: SHOW_TABLESTATUS
@@ -200,8 +202,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { string key, string value}
@@ -212,16 +214,16 @@ totalFileSize:370
maxFileSize:370
minFileSize:370
lastAccessTime:0
-lastUpdateTime:1281167904000
+lastUpdateTime:1282030136000
PREHOOK: query: select key from partition_test_partitioned where dt=100
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-25_092_6856625830670881694/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-57_738_4221917279395084924/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-25_092_6856625830670881694/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-28-57_738_4221917279395084924/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -254,11 +256,11 @@ POSTHOOK: Lineage: partition_test_partit
PREHOOK: query: select key from partition_test_partitioned where dt=101
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=101
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-29_018_4189228390799385358/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-01_104_7633460107807770575/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=101
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=101
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-29_018_4189228390799385358/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-01_104_7633460107807770575/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -292,12 +294,12 @@ PREHOOK: query: select key from partitio
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
PREHOOK: Input: default@partition_test_partitioned@dt=101
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-32_962_5959761298152062/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-04_462_387937014678398458/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
POSTHOOK: Input: default@partition_test_partitioned@dt=101
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-32_962_5959761298152062/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-04_462_387937014678398458/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -354,6 +356,8 @@ POSTHOOK: Lineage: partition_test_partit
PREHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
PREHOOK: type: ALTERTABLE_FILEFORMAT
+PREHOOK: Input: default@partition_test_partitioned
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@partition_test_partitioned
@@ -387,8 +391,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string key, string value}
@@ -399,7 +403,7 @@ totalFileSize:1474
maxFileSize:888
minFileSize:216
lastAccessTime:0
-lastUpdateTime:1281167921000
+lastUpdateTime:1282030151000
PREHOOK: query: show table extended like partition_test_partitioned partition(dt=100)
PREHOOK: type: SHOW_TABLESTATUS
@@ -412,8 +416,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=100
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=100
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -424,7 +428,7 @@ totalFileSize:216
maxFileSize:216
minFileSize:216
lastAccessTime:0
-lastUpdateTime:1281167921000
+lastUpdateTime:1282030151000
PREHOOK: query: show table extended like partition_test_partitioned partition(dt=101)
PREHOOK: type: SHOW_TABLESTATUS
@@ -437,8 +441,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { string key, string value}
@@ -449,7 +453,7 @@ totalFileSize:370
maxFileSize:370
minFileSize:370
lastAccessTime:0
-lastUpdateTime:1281167921000
+lastUpdateTime:1282030151000
PREHOOK: query: show table extended like partition_test_partitioned partition(dt=102)
PREHOOK: type: SHOW_TABLESTATUS
@@ -462,8 +466,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=102
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=102
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string key, string value}
@@ -474,16 +478,16 @@ totalFileSize:888
maxFileSize:888
minFileSize:888
lastAccessTime:0
-lastUpdateTime:1281167921000
+lastUpdateTime:1282030151000
PREHOOK: query: select key from partition_test_partitioned where dt=100
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-42_663_3677129000804574570/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-13_648_4852070201967333188/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-42_663_3677129000804574570/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-13_648_4852070201967333188/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -518,11 +522,11 @@ POSTHOOK: Lineage: partition_test_partit
PREHOOK: query: select key from partition_test_partitioned where dt=101
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=101
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-46_288_5985616954285711901/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-16_874_2144423925129213549/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=101
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=101
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-46_288_5985616954285711901/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-16_874_2144423925129213549/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -557,11 +561,11 @@ POSTHOOK: Lineage: partition_test_partit
PREHOOK: query: select key from partition_test_partitioned where dt=102
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=102
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-50_080_1123984711773684734/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-20_202_7935828228211072259/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=102
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=102
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-50_080_1123984711773684734/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-20_202_7935828228211072259/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -598,13 +602,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
PREHOOK: Input: default@partition_test_partitioned@dt=101
PREHOOK: Input: default@partition_test_partitioned@dt=102
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-54_055_5906737999229998851/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-23_498_1472831792275217567/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
POSTHOOK: Input: default@partition_test_partitioned@dt=101
POSTHOOK: Input: default@partition_test_partitioned@dt=102
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-54_055_5906737999229998851/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-23_498_1472831792275217567/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -691,13 +695,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
PREHOOK: Input: default@partition_test_partitioned@dt=101
PREHOOK: Input: default@partition_test_partitioned@dt=102
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-59_207_1542640067535172047/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-26_942_5352511744427811614/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt >=100 and dt <= 102
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
POSTHOOK: Input: default@partition_test_partitioned@dt=101
POSTHOOK: Input: default@partition_test_partitioned@dt=102
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-58-59_207_1542640067535172047/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-26_942_5352511744427811614/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out Tue Aug 17 22:33:43 2010
@@ -15,6 +15,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: alter table partition_test_partitioned set fileformat rcfile
PREHOOK: type: ALTERTABLE_FILEFORMAT
+PREHOOK: Input: default@partition_test_partitioned
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: alter table partition_test_partitioned set fileformat rcfile
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@partition_test_partitioned
@@ -35,6 +37,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
PREHOOK: type: ALTERTABLE_FILEFORMAT
+PREHOOK: Input: default@partition_test_partitioned
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@partition_test_partitioned
@@ -62,13 +66,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=100
PREHOOK: Input: default@partition_test_partitioned@dt=101
PREHOOK: Input: default@partition_test_partitioned@dt=102
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-59-19_214_8947184382877860008/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-43_260_5442200232343655466/-mr-10000
POSTHOOK: query: select * from partition_test_partitioned where dt >=100 and dt <= 102
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=100
POSTHOOK: Input: default@partition_test_partitioned@dt=101
POSTHOOK: Input: default@partition_test_partitioned@dt=102
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-59-19_214_8947184382877860008/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-43_260_5442200232343655466/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out Tue Aug 17 22:33:43 2010
@@ -5,6 +5,8 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@partition_test_partitioned
PREHOOK: query: alter table partition_test_partitioned set fileformat rcfile
PREHOOK: type: ALTERTABLE_FILEFORMAT
+PREHOOK: Input: default@partition_test_partitioned
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: alter table partition_test_partitioned set fileformat rcfile
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@partition_test_partitioned
@@ -26,8 +28,8 @@ POSTHOOK: type: SHOW_TABLESTATUS
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { string key, string value}
@@ -38,10 +40,12 @@ totalFileSize:370
maxFileSize:370
minFileSize:370
lastAccessTime:0
-lastUpdateTime:1281167964000
+lastUpdateTime:1282030189000
PREHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
PREHOOK: type: ALTERTABLE_FILEFORMAT
+PREHOOK: Input: default@partition_test_partitioned
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@partition_test_partitioned
@@ -69,8 +73,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=102
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=102
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string key, string value}
@@ -81,16 +85,16 @@ totalFileSize:888
maxFileSize:888
minFileSize:888
lastAccessTime:0
-lastUpdateTime:1281167969000
+lastUpdateTime:1282030193000
PREHOOK: query: select key from partition_test_partitioned where dt=102
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=102
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-59-29_952_4034031846702868123/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-54_035_3465387967141592899/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=102
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=102
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-59-29_952_4034031846702868123/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-54_035_3465387967141592899/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
@@ -145,8 +149,8 @@ POSTHOOK: Lineage: partition_test_partit
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
tableName:partition_test_partitioned
-owner:heyongqiang
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
+owner:njain
+location:pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/test/data/warehouse/partition_test_partitioned/dt=101
inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
columns:struct columns { string key, string value}
@@ -157,16 +161,16 @@ totalFileSize:888
maxFileSize:888
minFileSize:888
lastAccessTime:0
-lastUpdateTime:1281167979000
+lastUpdateTime:1282030201000
PREHOOK: query: select key from partition_test_partitioned where dt=101
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_partitioned@dt=101
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-59-39_288_1071363340396075185/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-30-01_709_7422795570962759074/-mr-10000
POSTHOOK: query: select key from partition_test_partitioned where dt=101
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_test_partitioned@dt=101
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-07_00-59-39_288_1071363340396075185/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-30-01_709_7422795570962759074/-mr-10000
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
Modified: 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=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out Tue Aug 17 22:33:43 2010
@@ -18,21 +18,23 @@ POSTHOOK: Output: default@tbl1
PREHOOK: query: select * from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-26_216_1861575226305357293/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-47_882_345822340790651676/-mr-10000
POSTHOOK: query: select * from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-26_216_1861575226305357293/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-47_882_345822340790651676/-mr-10000
PREHOOK: query: select col from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-26_303_314132828589488793/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-48_026_4569994021296856299/-mr-10000
POSTHOOK: query: select col from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-26_303_314132828589488793/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-48_026_4569994021296856299/-mr-10000
PREHOOK: query: alter table tbl1 enable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: default@tbl1
POSTHOOK: query: alter table tbl1 enable offline
POSTHOOK: type: ALTERTABLE_PROTECTMODE
POSTHOOK: Input: default@tbl1
@@ -43,9 +45,11 @@ POSTHOOK: query: desc extended tbl1
POSTHOOK: type: DESCTABLE
col string
-Detailed Table Information Table(tableName:tbl1, dbName:default, owner:heyongqiang, createTime:1281598046, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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=heyongqiang, last_modified_time=1281598050, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1281598050}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1282030307, 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/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=1282030311, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1282030311}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl1 disable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: default@tbl1
POSTHOOK: query: alter table tbl1 disable offline
POSTHOOK: type: ALTERTABLE_PROTECTMODE
POSTHOOK: Input: default@tbl1
@@ -56,23 +60,23 @@ POSTHOOK: query: desc extended tbl1
POSTHOOK: type: DESCTABLE
col string
-Detailed Table Information Table(tableName:tbl1, dbName:default, owner:heyongqiang, createTime:1281598046, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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=heyongqiang, last_modified_time=1281598051, transient_lastDdlTime=1281598051}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:tbl1, dbName:default, owner:njain, createTime:1282030307, 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/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=1282030311, transient_lastDdlTime=1282030311}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: select * from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-31_372_5012483727356659460/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-51_568_4690377861294328852/-mr-10000
POSTHOOK: query: select * from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-31_372_5012483727356659460/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-51_568_4690377861294328852/-mr-10000
PREHOOK: query: select col from tbl1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-31_447_5673193703065796896/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-51_719_2669398894679440279/-mr-10000
POSTHOOK: query: select col from tbl1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-31_447_5673193703065796896/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-51_719_2669398894679440279/-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)
@@ -80,39 +84,49 @@ 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 drop partition (p='not_exist')
PREHOOK: type: ALTERTABLE_DROPPARTS
+PREHOOK: Input: default@tbl2
POSTHOOK: query: alter table tbl2 drop partition (p='not_exist')
POSTHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: Input: default@tbl2
PREHOOK: query: select * from tbl2 where p='p1'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-36_149_4688727430731909803/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-55_288_5009122664008890670/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-36_149_4688727430731909803/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-55_288_5009122664008890670/-mr-10000
PREHOOK: query: select * from tbl2 where p='p2'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p2
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-36_255_4935812033407851529/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-55_468_198651221231416854/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p2
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-36_255_4935812033407851529/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-55_468_198651221231416854/-mr-10000
PREHOOK: query: alter table tbl2 partition (p='p1') enable offline
PREHOOK: type: ALTERPARTITION_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 partition (p='p1') enable offline
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: default@tbl2
POSTHOOK: Output: default@tbl2@p=p1
PREHOOK: query: desc extended tbl2 partition (p='p1')
PREHOOK: type: DESCTABLE
@@ -121,9 +135,11 @@ POSTHOOK: type: DESCTABLE
col string
p string
-Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1281598056, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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:{last_modified_by=heyongqiang, last_modified_time=1281598056, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1281598056})
+Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1282030315, lastAccessTime: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/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:{last_modified_by=njain, last_modified_time=1282030315, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1282030315})
PREHOOK: query: alter table tbl2 enable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 enable offline
POSTHOOK: type: ALTERTABLE_PROTECTMODE
POSTHOOK: Input: default@tbl2
@@ -135,9 +151,11 @@ POSTHOOK: type: DESCTABLE
col string
p string
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:heyongqiang, createTime:1281598055, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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=heyongqiang, last_modified_time=1281598056, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1281598056}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1282030314, 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/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=1282030315, PROTECT_MODE=OFFLINE, transient_lastDdlTime=1282030315}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl2 enable no_drop
PREHOOK: type: ALTERTABLE_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 enable no_drop
POSTHOOK: type: ALTERTABLE_PROTECTMODE
POSTHOOK: Input: default@tbl2
@@ -149,9 +167,11 @@ POSTHOOK: type: DESCTABLE
col string
p string
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:heyongqiang, createTime:1281598055, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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=heyongqiang, last_modified_time=1281598056, PROTECT_MODE=OFFLINE,NO_DROP, transient_lastDdlTime=1281598056}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1282030314, 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/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=1282030316, PROTECT_MODE=OFFLINE,NO_DROP, transient_lastDdlTime=1282030316}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl2 disable offline
PREHOOK: type: ALTERTABLE_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 disable offline
POSTHOOK: type: ALTERTABLE_PROTECTMODE
POSTHOOK: Input: default@tbl2
@@ -163,9 +183,11 @@ POSTHOOK: type: DESCTABLE
col string
p string
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:heyongqiang, createTime:1281598055, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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=heyongqiang, last_modified_time=1281598056, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1281598056}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1282030314, 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/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=1282030316, PROTECT_MODE=NO_DROP, transient_lastDdlTime=1282030316}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: alter table tbl2 disable no_drop
PREHOOK: type: ALTERTABLE_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 disable no_drop
POSTHOOK: type: ALTERTABLE_PROTECTMODE
POSTHOOK: Input: default@tbl2
@@ -177,28 +199,32 @@ POSTHOOK: type: DESCTABLE
col string
p string
-Detailed Table Information Table(tableName:tbl2, dbName:default, owner:heyongqiang, createTime:1281598055, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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=heyongqiang, last_modified_time=1281598056, transient_lastDdlTime=1281598056}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:tbl2, dbName:default, owner:njain, createTime:1282030314, 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/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=1282030316, transient_lastDdlTime=1282030316}, 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:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-37_053_7873172252253514243/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-56_684_3044267555024428489/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p2
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-37_053_7873172252253514243/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-56_684_3044267555024428489/-mr-10000
PREHOOK: query: select col from tbl2 where p='p2'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p2
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-37_163_8143630238931563584/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-56_865_5659313889717699465/-mr-10000
POSTHOOK: query: select col from tbl2 where p='p2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p2
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-37_163_8143630238931563584/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-31-56_865_5659313889717699465/-mr-10000
PREHOOK: query: alter table tbl2 partition (p='p1') disable offline
PREHOOK: type: ALTERPARTITION_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 partition (p='p1') disable offline
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: default@tbl2
POSTHOOK: Output: default@tbl2@p=p1
PREHOOK: query: desc extended tbl2 partition (p='p1')
PREHOOK: type: DESCTABLE
@@ -207,23 +233,23 @@ POSTHOOK: type: DESCTABLE
col string
p string
-Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1281598056, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:col, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/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:{last_modified_by=heyongqiang, last_modified_time=1281598061, transient_lastDdlTime=1281598061})
+Detailed Partition Information Partition(values:[p1], dbName:default, tableName:tbl2, createTime:1282030315, lastAccessTime: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/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:{last_modified_by=njain, last_modified_time=1282030320, transient_lastDdlTime=1282030320})
PREHOOK: query: select * from tbl2 where p='p1'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-42_299_4005199216406886655/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-32-01_137_2604041819153026498/-mr-10000
POSTHOOK: query: select * from tbl2 where p='p1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-42_299_4005199216406886655/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-32-01_137_2604041819153026498/-mr-10000
PREHOOK: query: select col from tbl2 where p='p1'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p1
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-42_501_6954393846640741211/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-32-01_326_194698586482359849/-mr-10000
POSTHOOK: query: select col from tbl2 where p='p1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl2@p=p1
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-08-12_00-27-42_501_6954393846640741211/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-32-01_326_194698586482359849/-mr-10000
PREHOOK: query: insert overwrite table tbl1 select col from tbl2 where p='p1'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl2@p=p1
@@ -245,54 +271,79 @@ POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl
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: ALTERPARTITION_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 partition (p='p1') enable no_drop
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: default@tbl2
POSTHOOK: Output: default@tbl2@p=p1
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, 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: ALTERPARTITION_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 partition (p='p1') disable no_drop
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Input: default@tbl2@p=p1
+POSTHOOK: Output: default@tbl2
POSTHOOK: Output: default@tbl2@p=p1
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, 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: ALTERPARTITION_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 partition (p='p2') enable no_drop
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Input: default@tbl2@p=p2
+POSTHOOK: Output: default@tbl2
POSTHOOK: Output: default@tbl2@p=p2
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, 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
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2@p=p1
POSTHOOK: query: alter table tbl2 drop partition (p='p1')
POSTHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: Input: default@tbl2
POSTHOOK: Output: default@tbl2@p=p1
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, 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: ALTERPARTITION_PROTECTMODE
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: alter table tbl2 partition (p='p2') disable no_drop
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Input: default@tbl2@p=p2
+POSTHOOK: Output: default@tbl2
POSTHOOK: Output: default@tbl2@p=p2
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, 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
+PREHOOK: Input: default@tbl1
+PREHOOK: Output: default@tbl1
POSTHOOK: query: drop table tbl1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tbl1
POSTHOOK: Output: default@tbl1
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, 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
+PREHOOK: Input: default@tbl2
+PREHOOK: Output: default@tbl2
POSTHOOK: query: drop table tbl2
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tbl2
POSTHOOK: Output: default@tbl2
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl2)tbl2.FieldSchema(name:col, type:string, comment:null), ]
POSTHOOK: Lineage: tbl1.col SIMPLE [(tbl1)tbl1.FieldSchema(name:col, type:string, comment:null), ]