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/11/12 01:11:26 UTC
svn commit: r1034219 [3/5] - in /hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/hooks/
ql/src/java/org/apache/hadoop/hive/ql/lockmgr/zookeeper/
ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/org...
Modified: hive/trunk/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge3.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge3.q.out Fri Nov 12 00:11:24 2010
@@ -24,6 +24,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: default@merge_src_part
POSTHOOK: query: insert overwrite table merge_src_part partition(ds) select key, value, ds from srcpart where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
@@ -77,9 +78,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
+ directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001/
+ Stats Publishing Key Prefix: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -92,9 +93,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src [merge_src]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src [merge_src]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src
Partition
base file name: merge_src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -105,12 +106,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src
name merge_src
serialization.ddl struct merge_src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393780
+ transient_lastDdlTime 1289454110
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -121,12 +122,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src
name merge_src
serialization.ddl struct merge_src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393780
+ transient_lastDdlTime 1289454110
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src
name: merge_src
@@ -138,15 +139,15 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001
+ source: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10002
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10001
Stage: Stage-0
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001
- destination: pfile:///data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src2
+ source: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10001
+ destination: pfile:///data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src2
Stage: Stage-5
Create Table Operator:
@@ -162,11 +163,11 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10001
+ directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10001
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -180,9 +181,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002]
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10002 [pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-48_857_8226805934470604516/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-01_163_8855372425957877493/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -216,11 +217,10 @@ POSTHOOK: Lineage: merge_src_part PARTIT
PREHOOK: query: select * from merge_src2
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src2
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-09-56_418_6812893088145650163/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-42-09_717_694531801987422048/-mr-10000
POSTHOOK: query: select * from merge_src2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src2
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-09-56_418_6812893088145650163/-mr-10000
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -2284,9 +2284,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
+ directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2296,13 +2296,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393796
+ transient_lastDdlTime 1289454130
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -2310,10 +2310,10 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2326,7 +2326,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2336,7 +2336,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2347,7 +2347,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2357,11 +2357,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
Partition
base file name: ds=2008-04-09
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2374,7 +2374,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2384,7 +2384,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2395,7 +2395,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -2405,7 +2405,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
@@ -2417,8 +2417,8 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000
+ source: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10002
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10000
Stage: Stage-0
Move Operator
@@ -2426,7 +2426,7 @@ STAGE PLANS:
partition:
ds
replace: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000
+ source: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2436,29 +2436,29 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393796
+ transient_lastDdlTime 1289454130
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
- tmp directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10001
+ tmp directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10000
+ directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2469,13 +2469,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393796
+ transient_lastDdlTime 1289454130
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -2483,9 +2483,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002]
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10002 [pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-09-56_894_7061888284179345199/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-10_192_7350266745211428565/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2496,13 +2496,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393796
+ transient_lastDdlTime 1289454130
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -2513,13 +2513,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393796
+ transient_lastDdlTime 1289454130
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
name: merge_src_part2
@@ -2531,6 +2531,7 @@ where ds is not null
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src_part@ds=2008-04-08
PREHOOK: Input: default@merge_src_part@ds=2008-04-09
+PREHOOK: Output: default@merge_src_part2
POSTHOOK: query: insert overwrite table merge_src_part2 partition(ds)
select key, value, ds from merge_src_part
where ds is not null
@@ -2565,12 +2566,11 @@ PREHOOK: query: select * from merge_src_
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src_part2@ds=2008-04-08
PREHOOK: Input: default@merge_src_part2@ds=2008-04-09
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-09_585_5952318912198434145/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-42-26_758_4308514117864932351/-mr-10000
POSTHOOK: query: select * from merge_src_part2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-08
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-09_585_5952318912198434145/-mr-10000
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -4674,10 +4674,10 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [s:merge_src_part]
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [s:merge_src_part]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [s:merge_src_part]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [s:merge_src_part]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
Partition
base file name: ds=2008-04-08
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4690,7 +4690,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4700,7 +4700,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4711,7 +4711,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4721,11 +4721,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
Partition
base file name: ds=2008-04-09
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4738,7 +4738,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4748,7 +4748,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4759,7 +4759,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part
name merge_src_part
numFiles 4
numPartitions 2
@@ -4769,7 +4769,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 23248
- transient_lastDdlTime 1288393788
+ transient_lastDdlTime 1289454120
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part
name: merge_src_part
@@ -4787,9 +4787,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
+ directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4799,13 +4799,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393810
+ transient_lastDdlTime 1289454147
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -4819,8 +4819,8 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000
+ source: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10002
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10000
Stage: Stage-0
Move Operator
@@ -4828,7 +4828,7 @@ STAGE PLANS:
partition:
ds
replace: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000
+ source: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4838,29 +4838,29 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393810
+ transient_lastDdlTime 1289454147
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
- tmp directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10001
+ tmp directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10000
+ directory: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4871,13 +4871,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393810
+ transient_lastDdlTime 1289454147
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
TotalFiles: 1
@@ -4885,9 +4885,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002]
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10002 [pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-10_626_1744796538862904462/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-27_945_6969234973394510647/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4898,13 +4898,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393810
+ transient_lastDdlTime 1289454147
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4915,13 +4915,13 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/merge_src_part2
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_src_part2
name merge_src_part2
partition_columns ds
serialization.ddl struct merge_src_part2 { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288393810
+ transient_lastDdlTime 1289454147
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: merge_src_part2
name: merge_src_part2
@@ -4932,6 +4932,7 @@ select key, value, ds
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src_part@ds=2008-04-08
PREHOOK: Input: default@merge_src_part@ds=2008-04-09
+PREHOOK: Output: default@merge_src_part2
POSTHOOK: query: from (select * from merge_src_part where ds is not null distribute by ds) s
insert overwrite table merge_src_part2 partition(ds)
select key, value, ds
@@ -4974,12 +4975,11 @@ PREHOOK: query: select * from merge_src_
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_src_part2@ds=2008-04-08
PREHOOK: Input: default@merge_src_part2@ds=2008-04-09
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-22_845_6936272381319043085/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-42-43_560_3339774644672299186/-mr-10000
POSTHOOK: query: select * from merge_src_part2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-08
POSTHOOK: Input: default@merge_src_part2@ds=2008-04-09
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-22_845_6936272381319043085/-mr-10000
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/merge4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge4.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge4.q.out Fri Nov 12 00:11:24 2010
@@ -56,7 +56,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-24_826_9060381908424669122/-ext-10000
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-45_598_664322384125179870/-ext-10000
Stage: Stage-0
Move Operator
@@ -77,7 +77,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-24_826_9060381908424669122/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-42-45_598_664322384125179870/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -92,6 +92,7 @@ PREHOOK: query: insert overwrite table n
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Output: default@nzhang_part@ds=2010-08-15
POSTHOOK: query: insert overwrite table nzhang_part partition (ds='2010-08-15', hr) select key, value, hr from srcpart where ds='2008-04-08'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
@@ -106,12 +107,11 @@ PREHOOK: query: select * from nzhang_par
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-35_018_1318380414009166085/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-42-59_458_523212255193350255/-mr-10000
POSTHOOK: query: select * from nzhang_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-35_018_1318380414009166085/-mr-10000
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -1171,7 +1171,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-35_790_5693124847092356313/-ext-10000
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-43-00_160_6210397902575365347/-ext-10000
Stage: Stage-0
Move Operator
@@ -1192,7 +1192,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-35_790_5693124847092356313/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-43-00_160_6210397902575365347/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1223,12 +1223,11 @@ PREHOOK: query: select * from nzhang_par
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-44_292_3708871835977595256/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-43-11_115_1003991296778317216/-mr-10000
POSTHOOK: query: select * from nzhang_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=11
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-10-44_292_3708871835977595256/-mr-10000
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -2798,7 +2797,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/sdong/hive_2010-10-29_16-10-45_065_691354792932908947/-mr-10002
+ file:/tmp/njain/hive_2010-11-10_21-43-12_061_4308593628015089245/-mr-10002
Union
Select Operator
expressions:
@@ -2817,7 +2816,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: nzhang_part
- file:/tmp/sdong/hive_2010-10-29_16-10-45_065_691354792932908947/-mr-10004
+ file:/tmp/njain/hive_2010-11-10_21-43-12_061_4308593628015089245/-mr-10004
Union
Select Operator
expressions:
@@ -2844,7 +2843,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-45_065_691354792932908947/-ext-10000
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-43-12_061_4308593628015089245/-ext-10000
Stage: Stage-0
Move Operator
@@ -2865,7 +2864,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_16-10-45_065_691354792932908947/-ext-10003
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-43-12_061_4308593628015089245/-ext-10003
File Output Operator
compressed: false
GlobalTableId: 0
@@ -2921,6 +2920,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Output: default@nzhang_part@ds=2010-08-15
POSTHOOK: query: insert overwrite table nzhang_part partition (ds='2010-08-15', hr)
select * from (
select key, value, hr from srcpart where ds='2008-04-08'
@@ -2967,11 +2967,10 @@ ds=2010-08-15/hr=file,
PREHOOK: query: select * from nzhang_part where hr = 'file,'
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=file,
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-11-03_825_5284968767554728986/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-43-36_851_2285015947672308698/-mr-10000
POSTHOOK: query: select * from nzhang_part where hr = 'file,'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_part@ds=2010-08-15/hr=file,
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-11-03_825_5284968767554728986/-mr-10000
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_part PARTITION(ds=2010-08-15,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out Fri Nov 12 00:11:24 2010
@@ -91,6 +91,7 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table merge_dynamic_part partition (ds='2008-04-08', hr) select key, value, hr from srcpart_merge_dp where ds='2008-04-08'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_merge_dp@ds=2008-04-08/hr=11
+PREHOOK: Output: default@merge_dynamic_part@ds=2008-04-08
POSTHOOK: query: insert overwrite table merge_dynamic_part partition (ds='2008-04-08', hr) select key, value, hr from srcpart_merge_dp where ds='2008-04-08'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_merge_dp@ds=2008-04-08/hr=11
@@ -100,11 +101,10 @@ POSTHOOK: Lineage: merge_dynamic_part PA
PREHOOK: query: select * from merge_dynamic_part order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-05_18-12-01_114_8805428539349020136/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-43-53_940_2634395367591841528/-mr-10000
POSTHOOK: query: select * from merge_dynamic_part order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-05_18-12-01_114_8805428539349020136/-mr-10000
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
0 val_0 2008-04-08 11
@@ -615,7 +615,7 @@ POSTHOOK: Lineage: merge_dynamic_part PA
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
tableName:merge_dynamic_part
owner:null
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/test/data/warehouse/merge_dynamic_part
+location:pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_dynamic_part
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -626,7 +626,7 @@ totalFileSize:5812
maxFileSize:1612
minFileSize:1358
lastAccessTime:0
-lastUpdateTime:1289005920000
+lastUpdateTime:1289454233000
PREHOOK: query: explain
insert overwrite table merge_dynamic_part partition (ds='2008-04-08', hr=11) select key, value from srcpart_merge_dp where ds='2008-04-08'
@@ -681,7 +681,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/scratchdir/hive_2010-11-05_18-12-08_788_1359475585417326040/-ext-10000
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-43-59_740_209003009979096611/-ext-10000
Stage: Stage-0
Move Operator
@@ -702,7 +702,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/scratchdir/hive_2010-11-05_18-12-08_788_1359475585417326040/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-43-59_740_209003009979096611/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -728,11 +728,10 @@ POSTHOOK: Lineage: merge_dynamic_part PA
PREHOOK: query: select * from merge_dynamic_part order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-05_18-12-16_991_5577266524250121238/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-44-07_937_1316260934052203711/-mr-10000
POSTHOOK: query: select * from merge_dynamic_part order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-05_18-12-16_991_5577266524250121238/-mr-10000
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
@@ -1247,7 +1246,7 @@ POSTHOOK: Lineage: merge_dynamic_part PA
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
tableName:merge_dynamic_part
owner:null
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/test/data/warehouse/merge_dynamic_part
+location:pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_dynamic_part
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -1258,7 +1257,7 @@ totalFileSize:5812
maxFileSize:5812
minFileSize:5812
lastAccessTime:0
-lastUpdateTime:1289005934000
+lastUpdateTime:1289454245000
PREHOOK: query: explain
insert overwrite table merge_dynamic_part partition (ds, hr) select key, value, ds, hr from srcpart_merge_dp where ds='2008-04-08' and hr=11
@@ -1319,7 +1318,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/scratchdir/hive_2010-11-05_18-12-23_364_9192825881118405522/-ext-10000
+ destination: pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-44-12_145_2577288331870219341/-ext-10000
Stage: Stage-0
Move Operator
@@ -1340,7 +1339,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/scratchdir/hive_2010-11-05_18-12-23_364_9192825881118405522/-ext-10002
+ pfile:/data/users/njain/hive1/hive1/build/ql/scratchdir/hive_2010-11-10_21-44-12_145_2577288331870219341/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1354,6 +1353,7 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table merge_dynamic_part partition (ds, hr) select key, value, ds, hr from srcpart_merge_dp where ds='2008-04-08' and hr=11
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_merge_dp@ds=2008-04-08/hr=11
+PREHOOK: Output: default@merge_dynamic_part
POSTHOOK: query: insert overwrite table merge_dynamic_part partition (ds, hr) select key, value, ds, hr from srcpart_merge_dp where ds='2008-04-08' and hr=11
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_merge_dp@ds=2008-04-08/hr=11
@@ -1367,11 +1367,10 @@ POSTHOOK: Lineage: merge_dynamic_part PA
PREHOOK: query: select * from merge_dynamic_part order by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-05_18-12-32_058_2313143722524503533/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-44-21_897_7437398250505351661/-mr-10000
POSTHOOK: query: select * from merge_dynamic_part order by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@merge_dynamic_part@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-11-05_18-12-32_058_2313143722524503533/-mr-10000
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:key, type:string, comment:default), ]
@@ -1890,7 +1889,7 @@ POSTHOOK: Lineage: merge_dynamic_part PA
POSTHOOK: Lineage: merge_dynamic_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart_merge_dp)srcpart_merge_dp.FieldSchema(name:value, type:string, comment:default), ]
tableName:merge_dynamic_part
owner:null
-location:pfile:/Users/heyongqiang/Documents/workspace/Hive-Trunk/build/ql/test/data/warehouse/merge_dynamic_part
+location:pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/merge_dynamic_part
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { string key, string value}
@@ -1901,5 +1900,5 @@ totalFileSize:5812
maxFileSize:5812
minFileSize:5812
lastAccessTime:0
-lastUpdateTime:1289005949000
+lastUpdateTime:1289454258000
Modified: hive/trunk/ql/src/test/results/clientpositive/mi.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mi.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mi.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mi.q.out Fri Nov 12 00:11:24 2010
@@ -19,6 +19,8 @@ GROUP BY key, value, ds, hr
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Output: default@nzhang_t1
+PREHOOK: Output: default@nzhang_t2
POSTHOOK: query: FROM srcpart
INSERT OVERWRITE TABLE nzhang_t1 PARTITION (ds, hr)
SELECT key, value, ds, hr
@@ -57,11 +59,10 @@ ds=2008-04-08/hr=12
PREHOOK: query: select * from nzhang_t1
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_t1@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-10-14_11-25-55_663_1494101770785059016/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-44-41_192_2058167652893187841/-mr-10000
POSTHOOK: query: select * from nzhang_t1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_t1@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-10-14_11-25-55_663_1494101770785059016/-mr-10000
POSTHOOK: Lineage: nzhang_t1 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_t1 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_t2 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -569,11 +570,10 @@ POSTHOOK: Lineage: nzhang_t2 PARTITION(d
PREHOOK: query: select * from nzhang_t2
PREHOOK: type: QUERY
PREHOOK: Input: default@nzhang_t2@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-10-14_11-25-56_038_6378066642448367317/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-44-41_677_3321618811039862289/-mr-10000
POSTHOOK: query: select * from nzhang_t2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@nzhang_t2@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-10-14_11-25-56_038_6378066642448367317/-mr-10000
POSTHOOK: Lineage: nzhang_t1 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_t1 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_t2 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/null_column.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/null_column.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/null_column.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/null_column.q.out Fri Nov 12 00:11:24 2010
@@ -11,11 +11,11 @@ POSTHOOK: Output: default@temp_null
PREHOOK: query: select null, null from temp_null
PREHOOK: type: QUERY
PREHOOK: Input: default@temp_null
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-29_063_5497458015896967287/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-14-49_487_7607181113788396396/-mr-10000
POSTHOOK: query: select null, null from temp_null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@temp_null
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-29_063_5497458015896967287/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-14-49_487_7607181113788396396/-mr-10000
NULL NULL
NULL NULL
NULL NULL
@@ -40,11 +40,11 @@ POSTHOOK: Lineage: tt.b SIMPLE []
PREHOOK: query: select * from tt
PREHOOK: type: QUERY
PREHOOK: Input: default@tt
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-34_033_7899160687995145341/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-14-59_216_44980331280819545/-mr-10000
POSTHOOK: query: select * from tt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tt
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-34_033_7899160687995145341/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-14-59_216_44980331280819545/-mr-10000
POSTHOOK: Lineage: tt.a EXPRESSION []
POSTHOOK: Lineage: tt.b SIMPLE []
NULL NULL
@@ -75,11 +75,11 @@ POSTHOOK: Lineage: tt_b.b EXPRESSION []
PREHOOK: query: select * from tt_b
PREHOOK: type: QUERY
PREHOOK: Input: default@tt_b
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-36_556_8509051297680496039/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-05_616_6282647228666922140/-mr-10000
POSTHOOK: query: select * from tt_b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tt_b
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-36_556_8509051297680496039/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-05_616_6282647228666922140/-mr-10000
POSTHOOK: Lineage: tt.a EXPRESSION []
POSTHOOK: Lineage: tt.b SIMPLE []
POSTHOOK: Lineage: tt_b.a EXPRESSION []
@@ -134,11 +134,11 @@ POSTHOOK: Lineage: tt_b.b EXPRESSION []
PREHOOK: query: select * from temp_null2 where ds is not null
PREHOOK: type: QUERY
PREHOOK: Input: default@temp_null2@ds=2010-04-01
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-41_617_3166554512331390680/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-16_850_8493919717464195530/-mr-10000
POSTHOOK: query: select * from temp_null2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@temp_null2@ds=2010-04-01
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-43-41_617_3166554512331390680/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-16_850_8493919717464195530/-mr-10000
POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE []
POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE []
POSTHOOK: Lineage: tt.a EXPRESSION []
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Fri Nov 12 00:11:24 2010
@@ -251,11 +251,11 @@ POSTHOOK: Lineage: mi3 PARTITION(ds=2008
PREHOOK: query: SELECT mi1.* FROM mi1
PREHOOK: type: QUERY
PREHOOK: Input: default@mi1
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-14_17-17-46_120_3503771906127933196/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-27_727_3572542851489673202/-mr-10000
POSTHOOK: query: SELECT mi1.* FROM mi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi1
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-14_17-17-46_120_3503771906127933196/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-27_727_3572542851489673202/-mr-10000
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
@@ -412,11 +412,11 @@ POSTHOOK: Lineage: mi3 PARTITION(ds=2008
PREHOOK: query: SELECT mi2.* FROM mi2
PREHOOK: type: QUERY
PREHOOK: Input: default@mi2
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-14_17-17-46_510_8315931585077418228/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-28_023_307854968020208171/-mr-10000
POSTHOOK: query: SELECT mi2.* FROM mi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi2
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-14_17-17-46_510_8315931585077418228/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-28_023_307854968020208171/-mr-10000
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
@@ -636,11 +636,11 @@ POSTHOOK: Lineage: mi3 PARTITION(ds=2008
PREHOOK: query: SELECT mi3.* FROM mi3
PREHOOK: type: QUERY
PREHOOK: Input: default@mi3@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/tmp/nzhang/hive_2010-09-14_17-17-46_947_8456541918849361288/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-28_324_6189844014644056674/-mr-10000
POSTHOOK: query: SELECT mi3.* FROM mi3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi3@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/tmp/nzhang/hive_2010-09-14_17-17-46_947_8456541918849361288/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-11-11_09-15-28_324_6189844014644056674/-mr-10000
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/sample10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample10.q.out?rev=1034219&r1=1034218&r2=1034219&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample10.q.out Fri Nov 12 00:11:24 2010
@@ -13,6 +13,7 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: default@srcpartbucket
POSTHOOK: query: insert overwrite table srcpartbucket partition(ds, hr) select * from srcpart where ds is not null and key < 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
@@ -103,12 +104,12 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=11/000000_0 [srcpartbucket]
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=12/000000_0 [srcpartbucket]
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=11/000000_0 [srcpartbucket]
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=12/000000_0 [srcpartbucket]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=11/000000_0 [srcpartbucket]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=12/000000_0 [srcpartbucket]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=11/000000_0 [srcpartbucket]
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=12/000000_0 [srcpartbucket]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=11/000000_0
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=11/000000_0
Partition
base file name: 000000_0
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -123,7 +124,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -133,7 +134,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -145,7 +146,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -155,11 +156,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: srcpartbucket
name: srcpartbucket
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=12/000000_0
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-08/hr=12/000000_0
Partition
base file name: 000000_0
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -174,7 +175,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -184,7 +185,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -196,7 +197,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -206,11 +207,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: srcpartbucket
name: srcpartbucket
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=11/000000_0
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=11/000000_0
Partition
base file name: 000000_0
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -225,7 +226,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -235,7 +236,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -247,7 +248,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -257,11 +258,11 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: srcpartbucket
name: srcpartbucket
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=12/000000_0
+ pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket/ds=2008-04-09/hr=12/000000_0
Partition
base file name: 000000_0
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -276,7 +277,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -286,7 +287,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
@@ -298,7 +299,7 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.hive.ql.io.RCFileInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- location pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpartbucket
+ location pfile:/data/users/njain/hive1/hive1/build/ql/test/data/warehouse/srcpartbucket
name srcpartbucket
numFiles 16
numPartitions 4
@@ -308,7 +309,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
totalSize 2748
- transient_lastDdlTime 1288394712
+ transient_lastDdlTime 1289454630
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: srcpartbucket
name: srcpartbucket
@@ -332,9 +333,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/sdong/hive_2010-10-29_16-25-12_794_4931538152370108383/-ext-10001
+ directory: file:/tmp/njain/hive_2010-11-10_21-50-30_237_6456899979504390679/-ext-10001
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: file:/tmp/sdong/hive_2010-10-29_16-25-12_794_4931538152370108383/-ext-10001/
+ Stats Publishing Key Prefix: file:/tmp/njain/hive_2010-11-10_21-50-30_237_6456899979504390679/-ext-10001/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -357,14 +358,13 @@ PREHOOK: Input: default@srcpartbucket@ds
PREHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-25-14_236_6806821458011946674/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-50-31_589_3688459449074450497/-mr-10000
POSTHOOK: query: select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 4 on key) where ds is not null group by ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-25-14_236_6806821458011946674/-mr-10000
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -381,14 +381,13 @@ PREHOOK: Input: default@srcpartbucket@ds
PREHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-25-20_656_2072312926933274964/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-50-40_846_194213387409754762/-mr-10000
POSTHOOK: query: select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 2 on key) where ds is not null group by ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-25-20_656_2072312926933274964/-mr-10000
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -405,14 +404,13 @@ PREHOOK: Input: default@srcpartbucket@ds
PREHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=12
-PREHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-25-30_541_4304569505825344243/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-11-10_21-50-55_151_7435896620054029141/-mr-10000
POSTHOOK: query: select * from srcpartbucket where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpartbucket@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/sdong/hive_2010-10-29_16-25-30_541_4304569505825344243/-mr-10000
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: srcpartbucket PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]