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 07:12:47 UTC
svn commit: r1034276 [12/14] - in /hive/trunk: ./
ql/src/gen-javabean/org/apache/hadoop/hive/ql/plan/api/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/
ql/src/java/org/apache/hadoop/hive/ql/optimize...
Modified: hive/trunk/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join34.q.out Fri Nov 12 06:12:44 2010
@@ -47,7 +47,7 @@ STAGE PLANS:
TableScan
alias: x
GatherStats: false
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {_col1}
1 {key} {value}
@@ -115,9 +115,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -127,12 +127,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/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288205743
+ transient_lastDdlTime 1288897939
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -193,9 +193,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -205,12 +205,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/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288205743
+ transient_lastDdlTime 1288897939
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -220,9 +220,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x, null-subquery2:subq1-subquery2:x1]
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x, null-subquery2:subq1-subquery2:x1]
Path -> Partition:
- pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/src
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -233,12 +233,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/njain/hive-commit1/build/ql/test/data/warehouse/src
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205427
+ transient_lastDdlTime 1288894219
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -249,12 +249,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/njain/hive-commit1/build/ql/test/data/warehouse/src
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205427
+ transient_lastDdlTime 1288894219
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -266,14 +266,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002
- destination: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -283,28 +283,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/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288205743
+ transient_lastDdlTime 1288897939
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10001
+ tmp directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10001
Stage: Stage-2
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10000/
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10000
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -315,12 +315,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/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288205743
+ transient_lastDdlTime 1288897939
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -328,9 +328,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002 [pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002]
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002 [pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002]
Path -> Partition:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-43_964_5226296681156041746/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-19_150_396302363179050554/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -341,12 +341,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/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288205743
+ transient_lastDdlTime 1288897939
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -357,12 +357,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/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288205743
+ transient_lastDdlTime 1288897939
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -398,11 +398,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/njain/hive_2010-10-27_11-55-49_613_5191052733380652366/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-12-29_322_6593405909163555482/-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/njain/hive_2010-10-27_11-55-49_613_5191052733380652366/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-12-29_322_6593405909163555482/-mr-10000
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.val2 EXPRESSION [(src)x.FieldSchema(name:value, type:string, comment:default), (src)x1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join35.q.out Fri Nov 12 06:12:44 2010
@@ -83,9 +83,9 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x]
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x]
Path -> Partition:
- pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/src
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -96,12 +96,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/njain/hive-commit1/build/ql/test/data/warehouse/src
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205427
+ transient_lastDdlTime 1288894219
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -112,12 +112,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/njain/hive-commit1/build/ql/test/data/warehouse/src
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205427
+ transient_lastDdlTime 1288894219
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -141,7 +141,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10002
+ directory: file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -165,7 +165,7 @@ STAGE PLANS:
TableScan
alias: x
GatherStats: false
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {_col1}
1 {key} {value}
@@ -178,7 +178,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10002
Union
Map Join Operator
condition map:
@@ -222,9 +222,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -234,18 +234,18 @@ STAGE PLANS:
columns.types string:string:int
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, i32 val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205754
+ transient_lastDdlTime 1288897953
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
GatherStats: true
MultiFileSpray: false
- file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10004
+ file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10004
Union
Map Join Operator
condition map:
@@ -289,9 +289,9 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -301,12 +301,12 @@ STAGE PLANS:
columns.types string:string:int
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, i32 val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205754
+ transient_lastDdlTime 1288897953
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -316,10 +316,10 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10002 [file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10002]
- file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10004 [file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10004]
+ file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10002 [file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10002]
+ file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10004 [file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10004]
Path -> Partition:
- file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10002
Partition
base file name: -mr-10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -335,7 +335,7 @@ STAGE PLANS:
columns _col0,_col1
columns.types string,bigint
escape.delim \
- file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10004
+ file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10004
Partition
base file name: -mr-10004
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -359,14 +359,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003
- destination: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -376,28 +376,28 @@ STAGE PLANS:
columns.types string:string:int
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, i32 val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205754
+ transient_lastDdlTime 1288897953
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10001
+ tmp directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10001
Stage: Stage-3
Stats-Aggr Operator
- Stats Aggregation Key Prefix: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10000/
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10000
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -408,12 +408,12 @@ STAGE PLANS:
columns.types string:string:int
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, i32 val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205754
+ transient_lastDdlTime 1288897953
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -421,9 +421,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003 [pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003]
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003 [pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003]
Path -> Partition:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-55-54_179_6477900064401201039/-ext-10003
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-12-33_932_3206165386907828885/-ext-10003
Partition
base file name: -ext-10003
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -434,12 +434,12 @@ STAGE PLANS:
columns.types string:string:int
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, i32 val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205754
+ transient_lastDdlTime 1288897953
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -450,12 +450,12 @@ STAGE PLANS:
columns.types string:string:int
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
serialization.ddl struct dest_j1 { string key, string value, i32 val2}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205754
+ transient_lastDdlTime 1288897953
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -505,9 +505,9 @@ STAGE PLANS:
type: bigint
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/src [null-subquery2:subq1-subquery2:x1]
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src [null-subquery2:subq1-subquery2:x1]
Path -> Partition:
- pfile:/data/users/njain/hive-commit1/build/ql/test/data/warehouse/src
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -518,12 +518,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/njain/hive-commit1/build/ql/test/data/warehouse/src
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205427
+ transient_lastDdlTime 1288894219
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -534,12 +534,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/njain/hive-commit1/build/ql/test/data/warehouse/src
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1288205427
+ transient_lastDdlTime 1288894219
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -563,7 +563,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/njain/hive_2010-10-27_11-55-54_179_6477900064401201039/-mr-10004
+ directory: file:/tmp/liyintang/hive_2010-11-04_12-12-33_932_3206165386907828885/-mr-10004
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -607,11 +607,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/njain/hive_2010-10-27_11-56-06_687_1264215794989002476/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-12-57_316_845546887873454795/-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/njain/hive_2010-10-27_11-56-06_687_1264215794989002476/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-12-57_316_845546887873454795/-mr-10000
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.val2 EXPRESSION [(src)x.null, (src)x1.null, ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/join36.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join36.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join36.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join36.q.out Fri Nov 12 06:12:44 2010
@@ -76,7 +76,7 @@ STAGE PLANS:
x
TableScan
alias: x
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key} {cnt}
1 {cnt}
@@ -140,7 +140,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-56-20_127_6380703738706956749/-ext-10000
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-13-17_369_4823166777089074004/-ext-10000
Stage: Stage-0
Move Operator
@@ -158,7 +158,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-56-20_127_6380703738706956749/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-13-17_369_4823166777089074004/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -193,11 +193,11 @@ POSTHOOK: Lineage: tmp2.key EXPRESSION [
PREHOOK: query: select * from dest_j1 x order by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-56-26_754_2259038051216019843/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-27_195_6659028372004858698/-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/njain/hive_2010-10-27_11-56-26_754_2259038051216019843/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-27_195_6659028372004858698/-mr-10000
POSTHOOK: Lineage: dest_j1.key SIMPLE [(tmp1)x.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(tmp2)y.FieldSchema(name:cnt, type:int, comment:null), ]
POSTHOOK: Lineage: dest_j1.value SIMPLE [(tmp1)x.FieldSchema(name:cnt, type:int, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/join37.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join37.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join37.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join37.q.out Fri Nov 12 06:12:44 2010
@@ -36,7 +36,7 @@ STAGE PLANS:
x
TableScan
alias: x
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key} {value}
1 {value}
@@ -109,7 +109,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-56-29_885_2306134457319021637/-ext-10000
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-13-32_000_1610023662261116132/-ext-10000
Stage: Stage-0
Move Operator
@@ -127,7 +127,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-56-29_885_2306134457319021637/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-13-32_000_1610023662261116132/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -158,11 +158,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/njain/hive_2010-10-27_11-56-34_279_5727082010829048557/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-42_031_8017880576006388638/-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/njain/hive_2010-10-27_11-56-34_279_5727082010829048557/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-42_031_8017880576006388638/-mr-10000
POSTHOOK: Lineage: dest_j1.key EXPRESSION [(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 [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join38.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join38.q.out Fri Nov 12 06:12:44 2010
@@ -26,11 +26,11 @@ POSTHOOK: Lineage: tmp.col9 EXPRESSION [
PREHOOK: query: select * from tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-04_133_1536500479311783598/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-52_842_1951454920482464680/-mr-10000
POSTHOOK: query: select * from tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-04_133_1536500479311783598/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-52_842_1951454920482464680/-mr-10000
POSTHOOK: Lineage: tmp.col0 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tmp.col1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tmp.col10 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -89,7 +89,7 @@ STAGE PLANS:
a
TableScan
alias: a
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {value}
1 {col5} {col11}
@@ -133,7 +133,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/njain/hive_2010-10-27_11-58-04_322_8814213860188537568/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-13-53_269_4711133131177071929/-mr-10002
Select Operator
expressions:
expr: _col1
@@ -221,7 +221,7 @@ group by a.value, b.col5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@tmp
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-04_499_6020968433330491483/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-53_398_7677851135191109830/-mr-10000
POSTHOOK: query: FROM src a JOIN tmp b ON (a.key = b.col11)
SELECT /*+ MAPJOIN(a) */ a.value, b.col5, count(1) as count
where b.col11 = 111
@@ -229,7 +229,7 @@ group by a.value, b.col5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@tmp
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-04_499_6020968433330491483/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-13-53_398_7677851135191109830/-mr-10000
POSTHOOK: Lineage: tmp.col0 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tmp.col1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tmp.col10 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/join39.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join39.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join39.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join39.q.out Fri Nov 12 06:12:44 2010
@@ -51,7 +51,7 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key} {value}
1 {_col0} {_col1}
@@ -119,7 +119,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-58-12_180_546438697212415855/-ext-10000
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-14-05_003_6546778973100053760/-ext-10000
Stage: Stage-0
Move Operator
@@ -137,7 +137,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- pfile:/data/users/njain/hive-commit1/build/ql/scratchdir/hive_2010-10-27_11-58-12_180_546438697212415855/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-04_12-14-05_003_6546778973100053760/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
@@ -167,11 +167,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/njain/hive_2010-10-27_11-58-17_368_425948306842908675/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-14_819_2106628094710415660/-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/njain/hive_2010-10-27_11-58-17_368_425948306842908675/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-14_819_2106628094710415660/-mr-10000
POSTHOOK: Lineage: dest_j1.key SIMPLE [(src)x.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.key1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/join40.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join40.q.out?rev=1034276&r1=1034275&r2=1034276&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join40.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join40.q.out Fri Nov 12 06:12:44 2010
@@ -100,12 +100,12 @@ PREHOOK: query: SELECT x.key, x.value, y
FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-27_869_8594307870019576114/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-28_326_3972885048921144262/-mr-10000
POSTHOOK: query: SELECT x.key, x.value, y.key, y.value
FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-27_869_8594307870019576114/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-28_326_3972885048921144262/-mr-10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
@@ -751,12 +751,12 @@ PREHOOK: query: select src1.key, src2.va
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-32_224_2628641681553791073/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-36_619_6415824732118440282/-mr-10000
POSTHOOK: query: select src1.key, src2.value
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-32_224_2628641681553791073/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-36_619_6415824732118440282/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -1904,7 +1904,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/njain/hive_2010-10-27_11-58-37_240_1047427345351102102/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-14-46_832_624292527665996520/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1952,12 +1952,12 @@ PREHOOK: query: SELECT * FROM src src1 J
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-37_348_2776356054970751573/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-46_969_1334858435022180797/-mr-10000
POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-37_348_2776356054970751573/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-14-46_969_1334858435022180797/-mr-10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 100 val_100
NULL NULL NULL NULL 100 val_100
@@ -2633,7 +2633,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/njain/hive_2010-10-27_11-58-44_576_3870847117030797031/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-15-01_848_4481484445896033624/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2681,12 +2681,12 @@ PREHOOK: query: SELECT * FROM src src1 J
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-44_694_461427396890734084/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-15-02_041_1716373562559394449/-mr-10000
POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-44_694_461427396890734084/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-15-02_041_1716373562559394449/-mr-10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 100 val_100
NULL NULL NULL NULL 100 val_100
@@ -3277,7 +3277,7 @@ STAGE PLANS:
expr: value
type: string
outputColumnNames: _col0, _col1
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key} {value}
1 {_col0} {_col1}
@@ -3345,12 +3345,12 @@ PREHOOK: query: SELECT /*+ MAPJOIN(y) */
FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-51_016_2800726535361834663/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-15-12_928_5277225703166373723/-mr-10000
POSTHOOK: query: SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value
FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-51_016_2800726535361834663/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-15-12_928_5277225703166373723/-mr-10000
238 val_238 NULL NULL
86 val_86 86 val_86
311 val_311 NULL NULL
@@ -3984,7 +3984,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/njain/hive_2010-10-27_11-58-54_107_7492093354536600513/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-15-20_303_498904788302590605/-mr-10002
Reduce Output Operator
sort order:
tag: -1
@@ -4018,9 +4018,9 @@ STAGE PLANS:
PREHOOK: query: SELECT COUNT(1) FROM SRC A JOIN SRC B ON (A.KEY=B.KEY)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-54_187_249714887699251169/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-15-20_419_6110829774550991242/-mr-10000
POSTHOOK: query: SELECT COUNT(1) FROM SRC A JOIN SRC B ON (A.KEY=B.KEY)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/njain/hive_2010-10-27_11-58-54_187_249714887699251169/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-15-20_419_6110829774550991242/-mr-10000
1028
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=1034276&r1=1034275&r2=1034276&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 Fri Nov 12 06:12:44 2010
@@ -44,7 +44,7 @@ STAGE PLANS:
TableScan
alias: x
GatherStats: false
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -59,7 +59,7 @@ STAGE PLANS:
TableScan
alias: y
GatherStats: false
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -123,9 +123,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_15-50-39_603_533413961679906692/-ext-10002
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -135,12 +135,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288392639
+ transient_lastDdlTime 1289272690
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -150,9 +150,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/liyintang/hive-1754/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
@@ -166,13 +166,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/srcpart
+ location pfile:/data/users/liyintang/hive-1754/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 1288389287
+ transient_lastDdlTime 1289268000
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -183,13 +183,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/srcpart
+ location pfile:/data/users/liyintang/hive-1754/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 1288389287
+ transient_lastDdlTime 1289268000
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -201,14 +201,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10002
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10002
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -218,28 +218,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288392639
+ transient_lastDdlTime 1289272690
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10001
+ tmp directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-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_15-50-39_603_533413961679906692/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-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_15-50-39_603_533413961679906692/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10000
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -250,12 +250,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288392639
+ transient_lastDdlTime 1289272690
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -263,9 +263,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10002]
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10002 [pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-39_603_533413961679906692/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-10_467_2293155916770670069/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -276,12 +276,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288392639
+ transient_lastDdlTime 1289272690
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -292,12 +292,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/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 1288392639
+ transient_lastDdlTime 1289272690
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -329,11 +329,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/sdong/hive_2010-10-29_15-50-46_099_4098924361433737950/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-08_19-18-20_736_2131780804835036352/-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/sdong/hive_2010-10-29_15-50-46_099_4098924361433737950/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-08_19-18-20_736_2131780804835036352/-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), ]
@@ -536,7 +536,7 @@ STAGE PLANS:
TableScan
alias: x
GatherStats: false
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -551,7 +551,7 @@ STAGE PLANS:
TableScan
alias: y
GatherStats: false
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key}
1 {value}
@@ -615,9 +615,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_15-50-58_503_3505008876681402750/-ext-10002
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10002
NumFilesPerFileSink: 1
- Stats Publishing Key Prefix: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10000/
+ Stats Publishing Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10000/
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -627,7 +627,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -636,7 +636,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1288392646
+ transient_lastDdlTime 1289272700
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -646,9 +646,9 @@ STAGE PLANS:
Map Reduce Local Work
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
+ pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ pfile:/data/users/liyintang/hive-1754/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
@@ -662,13 +662,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/srcpart
+ location pfile:/data/users/liyintang/hive-1754/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 1288389287
+ transient_lastDdlTime 1289268000
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -679,13 +679,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/srcpart
+ location pfile:/data/users/liyintang/hive-1754/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 1288389287
+ transient_lastDdlTime 1289268000
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -697,14 +697,14 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10002
- destination: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10002
+ destination: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10000
Stage: Stage-0
Move Operator
tables:
replace: true
- source: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10000
+ source: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -714,7 +714,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -723,23 +723,23 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1288392646
+ transient_lastDdlTime 1289272700
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10001
+ tmp directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-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_15-50-58_503_3505008876681402750/-ext-10000/
+ Stats Aggregation Key Prefix: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-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_15-50-58_503_3505008876681402750/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
- directory: pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10000
+ directory: pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10000
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -750,7 +750,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -759,7 +759,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1288392646
+ transient_lastDdlTime 1289272700
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
TotalFiles: 1
@@ -767,9 +767,9 @@ STAGE PLANS:
MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10002 [pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10002]
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10002 [pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10002]
Path -> Partition:
- pfile:/data/users/sdong/www/hive-trunk/build/ql/scratchdir/hive_2010-10-29_15-50-58_503_3505008876681402750/-ext-10002
+ pfile:/data/users/liyintang/hive-1754/build/ql/scratchdir/hive_2010-11-08_19-18-37_907_7726137335023848601/-ext-10002
Partition
base file name: -ext-10002
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -780,7 +780,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -789,7 +789,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1288392646
+ transient_lastDdlTime 1289272700
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -800,7 +800,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/sdong/www/hive-trunk/build/ql/test/data/warehouse/dest_j1
+ location pfile:/data/users/liyintang/hive-1754/build/ql/test/data/warehouse/dest_j1
name dest_j1
numFiles 1
numPartitions 0
@@ -809,7 +809,7 @@ STAGE PLANS:
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
totalSize 2125
- transient_lastDdlTime 1288392646
+ transient_lastDdlTime 1289272700
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -848,11 +848,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/sdong/hive_2010-10-29_15-51-06_013_6248158911838781364/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-08_19-18-49_147_7316712558387738462/-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/sdong/hive_2010-10-29_15-51-06_013_6248158911838781364/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-08_19-18-49_147_7316712558387738462/-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=1034276&r1=1034275&r2=1034276&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 Fri Nov 12 06:12:44 2010
@@ -23,7 +23,7 @@ STAGE PLANS:
src
TableScan
alias: src
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key}
1
@@ -70,7 +70,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {_col0}
1
@@ -83,7 +83,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_639_5385690485575219943/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-50-21_401_1192194208773335423/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -151,7 +151,7 @@ STAGE PLANS:
src
TableScan
alias: src
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {key} {ds}
1
@@ -198,7 +198,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
- JDBM Sink Operator
+ HashTable Sink Operator
condition expressions:
0 {_col2}
1
@@ -211,7 +211,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_758_5972659942965972745/-mr-10002
+ file:/tmp/liyintang/hive_2010-11-04_12-50-21_619_1359331938520049914/-mr-10002
Select Operator
expressions:
expr: _col0
@@ -243,7 +243,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/tmp/heyongqiang/hive_2010-10-27_14-46-32_758_5972659942965972745/-mr-10003
+ file:/tmp/liyintang/hive_2010-11-04_12-50-21_619_1359331938520049914/-mr-10003
Select Operator
expressions:
expr: _col2
@@ -309,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/heyongqiang/hive_2010-10-27_14-46-32_877_634052141369406072/-mr-10000
+PREHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-50-21_821_3740258359127333333/-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
@@ -317,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/heyongqiang/hive_2010-10-27_14-46-32_877_634052141369406072/-mr-10000
+POSTHOOK: Output: file:/tmp/liyintang/hive_2010-11-04_12-50-21_821_3740258359127333333/-mr-10000
5308
5308