You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/10/28 06:50:03 UTC
svn commit: r1028183 [3/4] - in /hive/trunk: ./
ql/src/test/results/clientpositive/
Modified: hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out?rev=1028183&r1=1028182&r2=1028183&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out Thu Oct 28 04:50:02 2010
@@ -44,10 +44,7 @@ STAGE PLANS:
TableScan
alias: x
GatherStats: false
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
+ JDBM Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -57,16 +54,12 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col5, _col9, _col10, _col11
Position of Big Table: 2
y
TableScan
alias: y
GatherStats: false
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
+ JDBM Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -76,7 +69,6 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[key]]
2 [Column[key]]
- outputColumnNames: _col0, _col5, _col9, _col10, _col11
Position of Big Table: 2
Stage: Stage-1
@@ -91,7 +83,7 @@ STAGE PLANS:
predicate:
expr: ((ds = '2008-04-08') and (hr = 11))
type: boolean
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
@@ -136,9 +128,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10002
+ directory: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -148,12 +140,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, string val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287179185
+ transient_lastDdlTime 1288215315
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -163,9 +155,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
Path -> Partition:
- pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -179,13 +171,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/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287175206
+ transient_lastDdlTime 1288212591
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -196,13 +188,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/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287175206
+ transient_lastDdlTime 1288212591
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -214,14 +206,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10002
- destination: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10000
+ source: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10002
+ destination: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10000
+ source: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -231,28 +223,28 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, string val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287179185
+ transient_lastDdlTime 1288215315
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10001
+ tmp directory: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10002
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10000
+ directory: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -263,12 +255,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, string val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287179185
+ transient_lastDdlTime 1288215315
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -276,9 +268,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10002 [pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10002]
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10002 [pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10002]
Path -> Partition:
- pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-25_565_4458155958654291457/-ext-10002
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-15_336_1336721351939648686/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -289,12 +281,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, string val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287179185
+ transient_lastDdlTime 1288215315
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -305,12 +297,12 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, string val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287179185
+ transient_lastDdlTime 1288215315
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -342,11 +334,11 @@ POSTHOOK: Lineage: dest_j1.value SIMPLE
PREHOOK: query: select * from dest_j1 x order by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_14-46-33_967_3390466593997914415/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-35-20_630_3517475653926100304/-mr-10000
POSTHOOK: query: select * from dest_j1 x order by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_14-46-33_967_3390466593997914415/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-35-20_630_3517475653926100304/-mr-10000
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
@@ -549,10 +541,7 @@ STAGE PLANS:
TableScan
alias: x
GatherStats: false
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
+ JDBM Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -562,16 +551,12 @@ STAGE PLANS:
0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
2 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- outputColumnNames: _col0, _col5, _col9, _col10, _col11
Position of Big Table: 2
y
TableScan
alias: y
GatherStats: false
- Common Join Operator
- condition map:
- Inner Join 0 to 1
- Inner Join 0 to 2
+ JDBM Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -581,7 +566,6 @@ STAGE PLANS:
0 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
1 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
2 [class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge(Column[key]()]
- outputColumnNames: _col0, _col5, _col9, _col10, _col11
Position of Big Table: 2
Stage: Stage-1
@@ -596,7 +580,7 @@ STAGE PLANS:
predicate:
expr: ((ds = '2008-04-08') and (hr = 11))
type: boolean
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
@@ -641,9 +625,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10002
+ directory: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -653,7 +637,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -662,7 +646,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1287179193
+ transient_lastDdlTime 1288215320
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -672,9 +656,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
Path -> Partition:
- pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -688,13 +672,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/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287175206
+ transient_lastDdlTime 1288212591
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -705,13 +689,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/liyintang/trunk_os/build/ql/test/data/warehouse/srcpart
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/srcpart
name srcpart
partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1287175206
+ transient_lastDdlTime 1288212591
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -723,14 +707,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10002
- destination: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10000
+ source: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10002
+ destination: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10000
+ source: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -740,7 +724,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -749,23 +733,23 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1287179193
+ transient_lastDdlTime 1288215320
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10001
+ tmp directory: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10002
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10000
+ directory: pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -776,7 +760,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -785,7 +769,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1287179193
+ transient_lastDdlTime 1288215320
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -793,9 +777,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10002 [pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10002]
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10002 [pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10002]
Path -> Partition:
- pfile:/data/users/liyintang/trunk_os/build/ql/scratchdir/hive_2010-10-15_14-46-49_066_8646032217905227141/-ext-10002
+ pfile:/data/users/heyongqiang/hive-indexing/build/ql/scratchdir/hive_2010-10-27_14-35-31_518_8323624306284645862/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -806,7 +790,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -815,7 +799,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1287179193
+ transient_lastDdlTime 1288215320
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -826,7 +810,7 @@ STAGE PLANS:
columns.types string:string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/liyintang/trunk_os/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/heyongqiang/hive-indexing/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -835,7 +819,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1287179193
+ transient_lastDdlTime 1288215320
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -874,11 +858,11 @@ POSTHOOK: Lineage: src_copy.value SIMPLE
PREHOOK: query: select * from dest_j1 x order by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_14-46-57_402_5384425936145554197/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-35-38_043_2750643574384770263/-mr-10000
POSTHOOK: query: select * from dest_j1 x order by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_14-46-57_402_5384425936145554197/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-35-38_043_2750643574384770263/-mr-10000
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src1_copy)x.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out?rev=1028183&r1=1028182&r2=1028183&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out Thu Oct 28 04:50:02 2010
@@ -23,9 +23,7 @@ STAGE PLANS:
src
TableScan
alias: src
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {key}
1
@@ -33,7 +31,6 @@ STAGE PLANS:
keys:
0 [Column[value]]
1 [Column[value]]
- outputColumnNames: _col0
Position of Big Table: 0
Stage: Stage-1
@@ -42,7 +39,7 @@ STAGE PLANS:
srcpart
TableScan
alias: srcpart
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -73,9 +70,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {_col0}
1
@@ -83,19 +78,18 @@ STAGE PLANS:
keys:
0 [Column[_col0]]
1 [Column[key]]
- outputColumnNames: _col0
Position of Big Table: 0
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-17_18-28-58_205_3059857123809567795/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_639_5385690485575219943/-mr-10002
Select Operator
expressions:
expr: _col0
type: string
outputColumnNames: _col0
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -157,9 +151,7 @@ STAGE PLANS:
src
TableScan
alias: src
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {key} {ds}
1
@@ -167,7 +159,6 @@ STAGE PLANS:
keys:
0 [Column[value]]
1 [Column[value]]
- outputColumnNames: _col0, _col2
Position of Big Table: 0
Stage: Stage-1
@@ -176,7 +167,7 @@ STAGE PLANS:
srcpart
TableScan
alias: srcpart
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -207,9 +198,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {_col2}
1
@@ -217,13 +206,12 @@ STAGE PLANS:
keys:
0 [Column[_col0]]
1 [Column[key]]
- outputColumnNames: _col2
Position of Big Table: 0
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-17_18-28-58_559_4154233080683989694/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_758_5972659942965972745/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -231,7 +219,7 @@ STAGE PLANS:
expr: _col2
type: string
outputColumnNames: _col0, _col2
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -255,7 +243,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-17_18-28-58_559_4154233080683989694/-mr-10003
+ file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_758_5972659942965972745/-mr-10003
Select Operator
expressions:
expr: _col2
@@ -321,7 +309,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: file:/tmp/liyintang/hive_2010-10-17_18-28-58_899_5613342207704467139/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_877_634052141369406072/-mr-10000
POSTHOOK: query: select /*+MAPJOIN(src, src1) */ count(*) from srcpart join src src on (srcpart.value=src.value) join src src1 on (srcpart.key=src1.key) group by ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -329,6 +317,6 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-17_18-28-58_899_5613342207704467139/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_877_634052141369406072/-mr-10000
5308
5308
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out?rev=1028183&r1=1028182&r2=1028183&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out Thu Oct 28 04:50:02 2010
@@ -34,9 +34,7 @@ STAGE PLANS:
subq:x
TableScan
alias: x
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {key}
1
@@ -44,7 +42,6 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0
Position of Big Table: 1
z
TableScan
@@ -61,9 +58,7 @@ STAGE PLANS:
predicate:
expr: (hr = 11)
type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {_col0}
1 {value}
@@ -71,7 +66,6 @@ STAGE PLANS:
keys:
0 [Column[_col0]]
1 [Column[key]]
- outputColumnNames: _col0, _col5
Position of Big Table: 0
Stage: Stage-1
@@ -80,7 +74,7 @@ STAGE PLANS:
subq:y
TableScan
alias: y
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -102,7 +96,7 @@ STAGE PLANS:
expr: _col0
type: string
outputColumnNames: _col0
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -151,7 +145,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-47_409_128786361280541785/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-46-44_452_445213667214370288/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
FROM
(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2
@@ -161,7 +155,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-47_409_128786361280541785/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-46-44_452_445213667214370288/-mr-10000
238 val_238
238 val_238
311 val_311
@@ -308,9 +302,7 @@ STAGE PLANS:
subq:x
TableScan
alias: x
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {key}
1
@@ -318,7 +310,6 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0
Position of Big Table: 1
z
TableScan
@@ -335,9 +326,7 @@ STAGE PLANS:
predicate:
expr: (hr = 11)
type: boolean
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {_col0}
1 {value}
@@ -345,7 +334,6 @@ STAGE PLANS:
keys:
0 [Column[_col0]]
1 [Column[key]]
- outputColumnNames: _col0, _col5
Position of Big Table: 0
Stage: Stage-1
@@ -354,7 +342,7 @@ STAGE PLANS:
subq:y
TableScan
alias: y
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -376,7 +364,7 @@ STAGE PLANS:
expr: _col0
type: string
outputColumnNames: _col0
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -400,7 +388,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-15_15-04-53_319_3769577272445368796/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_14-46-48_345_6547752928820986559/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -450,7 +438,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-53_504_7399621961470089400/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-46-48_451_5103197118611190766/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
FROM
(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2
@@ -461,7 +449,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-04-53_504_7399621961470089400/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_14-46-48_451_5103197118611190766/-mr-10000
128 val_128
128 val_128
128 val_128
Modified: hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out?rev=1028183&r1=1028182&r2=1028183&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/select_transform_hint.q.out Thu Oct 28 04:50:02 2010
@@ -29,9 +29,7 @@ STAGE PLANS:
a
TableScan
alias: a
- Common Join Operator
- condition map:
- Inner Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {key} {value}
1
@@ -39,7 +37,6 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[key]]
- outputColumnNames: _col0, _col1
Position of Big Table: 1
Stage: Stage-1
@@ -48,7 +45,7 @@ STAGE PLANS:
b
TableScan
alias: b
- Common Join Operator
+ Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -99,14 +96,14 @@ FROM src a join src b
on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-13_781_8569397391886762548/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-02-57_632_2812838087751245658/-mr-10000
POSTHOOK: query: SELECT /*+MAPJOIN(a)*/
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-13_781_8569397391886762548/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-02-57_632_2812838087751245658/-mr-10000
238 val_238
238 val_238
86 val_86
@@ -1226,14 +1223,14 @@ FROM src a join src b
on a.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-19_149_1815239476955309395/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-01_031_3277101842984747988/-mr-10000
POSTHOOK: query: SELECT /*+STREAMTABLE(a)*/
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-15_15-28-19_149_1815239476955309395/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-01_031_3277101842984747988/-mr-10000
0 val_0
0 val_0
0 val_0
Modified: hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out?rev=1028183&r1=1028182&r2=1028183&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out Thu Oct 28 04:50:02 2010
@@ -8,11 +8,11 @@ POSTHOOK: Output: default@t1
PREHOOK: query: select * from t1 sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-48_453_7580246906147447007/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-07_317_2567121123918340747/-mr-10000
POSTHOOK: query: select * from t1 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-48_453_7580246906147447007/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-07_317_2567121123918340747/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -34,11 +34,11 @@ POSTHOOK: Output: default@t2
PREHOOK: query: select * from t2 sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-55_870_6093540767773075041/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-12_609_8186818336637614021/-mr-10000
POSTHOOK: query: select * from t2 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-54-55_870_6093540767773075041/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-12_609_8186818336637614021/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -62,11 +62,11 @@ POSTHOOK: Output: default@t3
PREHOOK: query: select * from t3 sort by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-06_872_5514286542584251869/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-20_412_6858946112655112787/-mr-10000
POSTHOOK: query: select * from t3 sort by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-06_872_5514286542584251869/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-20_412_6858946112655112787/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -97,11 +97,11 @@ POSTHOOK: Output: default@t4
PREHOOK: query: select * from t4
PREHOOK: type: QUERY
PREHOOK: Input: default@t4
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_517_8043595902141289587/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-23_040_6896567563297871765/-mr-10000
POSTHOOK: query: select * from t4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_517_8043595902141289587/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-23_040_6896567563297871765/-mr-10000
PREHOOK: query: explain select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
@@ -185,7 +185,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-10_683_6224851131670102704/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-23_122_1418801017341736948/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -217,12 +217,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_800_2513299296698295975/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-23_188_6557146902672307691/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-10_800_2513299296698295975/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-23_188_6557146902672307691/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -312,7 +312,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-17_836_5547579604305564817/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-28_893_6723532886712811629/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -344,12 +344,12 @@ PREHOOK: query: select * from t2 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-17_952_8107824929568696805/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-28_959_3762364132590482286/-mr-10000
POSTHOOK: query: select * from t2 a left semi join t1 b on b.key=a.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-17_952_8107824929568696805/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-28_959_3762364132590482286/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -441,7 +441,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-25_023_4437489275956384567/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-34_570_7889009522221032190/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -473,12 +473,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t4
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-25_142_359943279087785463/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-34_654_5556420496433395304/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t4 b on b.key=a.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t4
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-25_142_359943279087785463/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-34_654_5556420496433395304/-mr-10000
PREHOOK: query: explain select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
@@ -568,7 +568,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-32_006_1648677446700970744/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-40_011_3808833152580249248/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -596,12 +596,12 @@ PREHOOK: query: select a.value from t1 a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-32_125_2593078127467219576/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-40_079_1282941878916492070/-mr-10000
POSTHOOK: query: select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-32_125_2593078127467219576/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-40_079_1282941878916492070/-mr-10000
val_0
val_0
val_0
@@ -708,7 +708,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-40_123_4389202735836518462/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-45_730_7298072930043033983/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -740,12 +740,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-40_243_7850910287841643376/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-45_804_5294995386951265093/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key = b.key and b.value < "val_10" sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-40_243_7850910287841643376/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-45_804_5294995386951265093/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -841,7 +841,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-48_323_8119296433999603117/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-51_407_427333938274086877/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -869,12 +869,12 @@ PREHOOK: query: select a.value from t1 a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-48_445_7415332140514709784/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-51_486_1315085131198914442/-mr-10000
POSTHOOK: query: select a.value from t1 a left semi join (select key from t3 where key > 5) b on a.key = b.key sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-48_445_7415332140514709784/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-51_486_1315085131198914442/-mr-10000
val_10
val_8
val_9
@@ -980,7 +980,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-55-56_537_2903311238836289590/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-03-57_031_4644400431266147309/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1008,12 +1008,12 @@ PREHOOK: query: select a.value from t1 a
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-56_664_5020769161087651831/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-57_105_2695825645438377544/-mr-10000
POSTHOOK: query: select a.value from t1 a left semi join (select key , value from t2 where key > 5) b on a.key = b.key and b.value <= 'val_20' sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-55-56_664_5020769161087651831/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-03-57_105_2695825645438377544/-mr-10000
PREHOOK: query: explain select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
@@ -1110,7 +1110,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-04_059_355987900517518175/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-02_466_725728290759835787/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1142,12 +1142,12 @@ PREHOOK: query: select * from t2 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-04_183_8670610688043673425/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-02_537_8369733971186993079/-mr-10000
POSTHOOK: query: select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-04_183_8670610688043673425/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-02_537_8369733971186993079/-mr-10000
4 val_2
8 val_4
10 val_5
@@ -1189,9 +1189,7 @@ STAGE PLANS:
type: int
mode: hash
outputColumnNames: _col0
- Common Join Operator
- condition map:
- Left Semi Join 0 to 1
+ JDBM Sink Operator
condition expressions:
0 {key}
1
@@ -1199,7 +1197,6 @@ STAGE PLANS:
keys:
0 [Column[key]]
1 [Column[_col0]]
- outputColumnNames: _col0
Position of Big Table: 0
Stage: Stage-1
@@ -1208,7 +1205,7 @@ STAGE PLANS:
a
TableScan
alias: a
- Common Join Operator
+ Map Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -1232,7 +1229,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-12_336_1953660551209643271/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-08_036_2910952596121389668/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -1270,12 +1267,12 @@ PREHOOK: query: select /*+ mapjoin(b) */
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-12_453_4269654069294497779/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-08_109_4473865912549348136/-mr-10000
POSTHOOK: query: select /*+ mapjoin(b) */ a.key from t3 a left semi join t1 b on a.key = b.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-12_453_4269654069294497779/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-08_109_4473865912549348136/-mr-10000
0
0
0
@@ -1378,7 +1375,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-19_517_1787680149236807917/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-13_353_2384479425001200067/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1410,12 +1407,12 @@ PREHOOK: query: select * from t1 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-19_645_8738010680958797763/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-13_420_5777699289863486696/-mr-10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key = 2*b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-19_645_8738010680958797763/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-13_420_5777699289863486696/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1526,7 +1523,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-27_826_6825405805902610028/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-18_912_2891401415653997089/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1563,13 +1560,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-27_976_3972434369204782156/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-18_988_5010287233526168835/-mr-10000
POSTHOOK: query: select * from t1 a join t2 b on a.key = b.key left semi join t3 c on b.key = c.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-27_976_3972434369204782156/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-18_988_5010287233526168835/-mr-10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
@@ -1679,7 +1676,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-36_330_6779914873043487516/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-24_617_6131522087162404256/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1711,12 +1708,12 @@ PREHOOK: query: select * from t3 a left
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-36_446_531074999473537299/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-24_685_7575816128654858988/-mr-10000
POSTHOOK: query: select * from t3 a left semi join t1 b on a.key = b.key and a.value=b.value sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-36_446_531074999473537299/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-24_685_7575816128654858988/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1770,10 +1767,7 @@ STAGE PLANS:
type: int
mode: hash
outputColumnNames: _col0
- Common Join Operator
- condition map:
- Left Semi Join 0 to 1
- Left Semi Join 0 to 2
+ JDBM Sink Operator
condition expressions:
0 {key}
1
@@ -1783,7 +1777,6 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[_col0]]
2 [Column[_col0]]
- outputColumnNames: _col0
Position of Big Table: 0
c
TableScan
@@ -1800,10 +1793,7 @@ STAGE PLANS:
type: int
mode: hash
outputColumnNames: _col0
- Common Join Operator
- condition map:
- Left Semi Join 0 to 1
- Left Semi Join 0 to 2
+ JDBM Sink Operator
condition expressions:
0 {key}
1
@@ -1813,7 +1803,6 @@ STAGE PLANS:
0 [Column[key]]
1 [Column[_col0]]
2 [Column[_col0]]
- outputColumnNames: _col0
Position of Big Table: 0
Stage: Stage-1
@@ -1822,7 +1811,7 @@ STAGE PLANS:
a
TableScan
alias: a
- Common Join Operator
+ Map Join Operator
condition map:
Left Semi Join 0 to 1
Left Semi Join 0 to 2
@@ -1849,7 +1838,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-43_461_1825225512272201729/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-30_183_6165676837426268350/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -1888,13 +1877,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-43_597_7730476012893391191/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-30_260_2433281365180402598/-mr-10000
POSTHOOK: query: select /*+ mapjoin(b, c) */ a.key from t3 a left semi join t1 b on a.key = b.key left semi join t2 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-43_597_7730476012893391191/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-30_260_2433281365180402598/-mr-10000
0
0
0
@@ -2002,7 +1991,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-51_193_4971480791101556085/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-35_797_2333906634777100148/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2031,13 +2020,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-51_329_5949380496953796907/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-35_871_7897675469131546389/-mr-10000
POSTHOOK: query: select a.key from t3 a left outer join t1 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-51_329_5949380496953796907/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-35_871_7897675469131546389/-mr-10000
0
0
0
@@ -2157,7 +2146,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-56-59_679_8191924060733337482/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-41_608_2220388568134618866/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2186,13 +2175,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-59_811_3831038390861954254/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-41_682_2882263810051097750/-mr-10000
POSTHOOK: query: select a.key from t1 a right outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-56-59_811_3831038390861954254/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-41_682_2882263810051097750/-mr-10000
NULL
NULL
NULL
@@ -2315,7 +2304,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-57-08_142_4862659123810822662/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-48_006_8185934732491634852/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2344,13 +2333,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-08_274_1271914331764289510/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-48_081_2028444012866190155/-mr-10000
POSTHOOK: query: select a.key from t1 a full outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-08_274_1271914331764289510/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-48_081_2028444012866190155/-mr-10000
NULL
NULL
NULL
@@ -2473,7 +2462,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-57-16_618_1799543107598292752/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-53_653_9010857136935696124/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2502,13 +2491,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-16_749_4595962962752839059/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-53_728_7613723015009146650/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-16_749_4595962962752839059/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-53_728_7613723015009146650/-mr-10000
0
0
0
@@ -2631,7 +2620,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-57-25_108_1492275708770566570/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-04-59_367_1281949091297790008/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2660,13 +2649,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-25_243_1263591880561616930/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-59_442_8906799826368408100/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key right outer join t1 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-25_243_1263591880561616930/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-04-59_442_8906799826368408100/-mr-10000
NULL
NULL
NULL
@@ -2791,7 +2780,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-57-33_674_2234020911596435252/-mr-10002
+ file:/tmp/heyongqiang/hive_2010-10-27_15-05-08_027_9057656913862672973/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2820,13 +2809,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-33_808_3288750373349451656/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-05-08_102_1904204088263319648/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t1 b on a.key = b.key full outer join t2 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-33_808_3288750373349451656/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-05-08_102_1904204088263319648/-mr-10000
NULL
NULL
NULL
@@ -2995,7 +2984,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/liyintang/hive_2010-10-16_20-57-42_172_571318165223667427/-mr-10003
+ file:/tmp/heyongqiang/hive_2010-10-27_15-05-13_732_1908006251522430032/-mr-10003
Reduce Output Operator
key expressions:
expr: _col0
@@ -3024,13 +3013,13 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-42_311_595775460689974599/-mr-10000
+PREHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-05-13_810_2454226698258102980/-mr-10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.value = c.value sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/tmp/liyintang/hive_2010-10-16_20-57-42_311_595775460689974599/-mr-10000
+POSTHOOK: Output: file:/tmp/heyongqiang/hive_2010-10-27_15-05-13_810_2454226698258102980/-mr-10000
0
0
0