You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/06/05 20:28:15 UTC
svn commit: r1600719 [12/40] - in /hive/trunk:
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/
ql/src/java/org/apache/...
Modified: hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out Thu Jun 5 18:28:07 2014
@@ -33,7 +33,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -42,7 +42,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -51,7 +51,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -60,7 +60,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -68,10 +68,10 @@ STAGE PLANS:
Left Outer Join1 to 2
Left Outer Join0 to 3
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
- 3 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
+ 3 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -114,7 +114,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -123,7 +123,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -132,7 +132,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -141,7 +141,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -149,10 +149,10 @@ STAGE PLANS:
Left Outer Join1 to 2
Right Outer Join0 to 3
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
- 3 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
+ 3 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -195,7 +195,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -204,7 +204,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -213,7 +213,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -222,7 +222,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -230,10 +230,10 @@ STAGE PLANS:
Right Outer Join1 to 2
Left Outer Join0 to 3
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
- 3 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
+ 3 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -276,7 +276,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -285,7 +285,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -294,7 +294,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -303,7 +303,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -311,10 +311,10 @@ STAGE PLANS:
Right Outer Join1 to 2
Right Outer Join0 to 3
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
- 3 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
+ 3 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -360,7 +360,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -369,7 +369,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -378,16 +378,16 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Left Outer Join0 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -406,7 +406,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -415,18 +415,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col0 (type: string), _col1 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -466,7 +466,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -475,7 +475,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -484,16 +484,16 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Right Outer Join0 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -512,7 +512,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -521,18 +521,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col0 (type: string), _col1 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -572,7 +572,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -581,7 +581,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -590,16 +590,16 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Outer Join 0 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -618,7 +618,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -627,18 +627,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col0 (type: string), _col1 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -681,7 +681,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -690,14 +690,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -716,7 +716,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -725,14 +725,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -753,25 +753,25 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
Reduce Output Operator
- key expressions: _col4 (type: string)
+ key expressions: _col0 (type: string)
sort order: +
- Map-reduce partition columns: _col4 (type: string)
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -812,7 +812,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -821,14 +821,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -847,7 +847,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -856,14 +856,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -884,25 +884,25 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
Reduce Output Operator
- key expressions: _col4 (type: string)
+ key expressions: _col0 (type: string)
sort order: +
- Map-reduce partition columns: _col4 (type: string)
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -943,7 +943,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -952,14 +952,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -978,7 +978,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -987,14 +987,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1015,25 +1015,25 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
Reduce Output Operator
- key expressions: _col4 (type: string)
+ key expressions: _col0 (type: string)
sort order: +
- Map-reduce partition columns: _col4 (type: string)
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1074,7 +1074,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1083,14 +1083,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1109,7 +1109,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1118,14 +1118,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1146,25 +1146,25 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
Reduce Output Operator
- key expressions: _col4 (type: string)
+ key expressions: _col0 (type: string)
sort order: +
- Map-reduce partition columns: _col4 (type: string)
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1206,7 +1206,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1215,14 +1215,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1243,7 +1243,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1252,27 +1252,27 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
Reduce Output Operator
key expressions: _col5 (type: string)
sort order: +
Map-reduce partition columns: _col5 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
Left Outer Join1 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out Thu Jun 5 18:28:07 2014
@@ -850,8 +850,8 @@ STAGE PLANS:
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col5
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
compressed: false
table:
@@ -876,7 +876,7 @@ STAGE PLANS:
alias: smalltbl2
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -890,7 +890,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -1089,7 +1089,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 6655 Data size: 96070 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string)
TableScan
alias: smalltbl4
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
@@ -1098,14 +1098,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6}
- 1 {VALUE._col0}
+ 0 {VALUE._col0} {VALUE._col1} {KEY.reducesinkkey0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 7320 Data size: 105677 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1177,7 +1176,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 6050 Data size: 87337 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col0 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
TableScan
alias: smalltbl3
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
@@ -1186,14 +1185,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0}
+ 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Statistics: Num rows: 6655 Data size: 96070 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1218,7 +1216,7 @@ STAGE PLANS:
TableScan
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -1233,7 +1231,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -1269,13 +1267,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col3 (type: string)
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {KEY.reducesinkkey0} {KEY.reducesinkkey0}
1 {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 6050 Data size: 87337 Basic stats: COMPLETE Column stats: NONE
@@ -1324,8 +1322,8 @@ STAGE PLANS:
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col5
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
compressed: false
table:
@@ -1346,7 +1344,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key1 (type: string)
Statistics: Num rows: 5000 Data size: 72180 Basic stats: COMPLETE Column stats: NONE
- value expressions: key1 (type: string), key2 (type: string), value (type: string)
+ value expressions: key2 (type: string), value (type: string)
TableScan
alias: smalltbl1
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
@@ -1355,19 +1353,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col2, _col5
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1583,7 +1580,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -1629,14 +1626,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col5
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -1900,7 +1897,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -1924,14 +1921,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col5
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -2270,8 +2267,8 @@ STAGE PLANS:
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col5
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
compressed: false
table:
@@ -2296,7 +2293,7 @@ STAGE PLANS:
alias: smalltbl2
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -2310,7 +2307,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -2509,7 +2506,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 6655 Data size: 96070 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string)
TableScan
alias: smalltbl4
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
@@ -2518,14 +2515,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6}
- 1 {VALUE._col0}
+ 0 {VALUE._col0} {VALUE._col1} {KEY.reducesinkkey0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 7320 Data size: 105677 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -2597,7 +2593,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 6050 Data size: 87337 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col0 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
TableScan
alias: smalltbl3
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
@@ -2606,14 +2602,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0}
+ 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Statistics: Num rows: 6655 Data size: 96070 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -2638,7 +2633,7 @@ STAGE PLANS:
TableScan
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -2653,7 +2648,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
+ 0 {_col0} {_col1} {_col2} {_col3} {_col3}
1 {key}
keys:
0 _col3 (type: string)
@@ -2689,13 +2684,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col3 (type: string)
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {KEY.reducesinkkey0} {KEY.reducesinkkey0}
1 {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 6050 Data size: 87337 Basic stats: COMPLETE Column stats: NONE
@@ -2744,8 +2739,8 @@ STAGE PLANS:
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col5
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
File Output Operator
compressed: false
table:
@@ -2766,7 +2761,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key1 (type: string)
Statistics: Num rows: 5000 Data size: 72180 Basic stats: COMPLETE Column stats: NONE
- value expressions: key1 (type: string), key2 (type: string), value (type: string)
+ value expressions: key2 (type: string), value (type: string)
TableScan
alias: smalltbl1
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
@@ -2775,19 +2770,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col2, _col5
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 5500 Data size: 79398 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out Thu Jun 5 18:28:07 2014
@@ -84,7 +84,6 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 126 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: x1
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -113,11 +112,12 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 126 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0
Statistics: Num rows: 126 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -345,7 +345,6 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 126 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: x2
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -374,11 +373,12 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 126 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0
Statistics: Num rows: 126 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -589,7 +589,6 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 64 Data size: 6501 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: x2
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -618,11 +617,12 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 64 Data size: 6501 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0
Statistics: Num rows: 64 Data size: 6501 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -922,9 +922,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: bigint)
sort order: ++
Statistics: Num rows: 17 Data size: 1729 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: bigint)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 17 Data size: 1729 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -997,13 +998,12 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
@@ -1302,7 +1302,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1343,7 +1343,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1378,9 +1378,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: bigint)
sort order: ++
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: bigint)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -1619,9 +1620,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: bigint)
sort order: ++
Statistics: Num rows: 17 Data size: 1729 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: bigint)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 17 Data size: 1729 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1694,13 +1696,12 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 1 Data size: 108 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
@@ -1973,7 +1974,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2014,7 +2015,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2049,9 +2050,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: bigint)
sort order: ++
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: bigint)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert.q.out Thu Jun 5 18:28:07 2014
@@ -848,6 +848,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
+POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
@@ -1084,6 +1088,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
+POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
@@ -1232,6 +1240,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
+POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
@@ -1468,6 +1480,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_multi1
POSTHOOK: Output: default@src_multi2
+POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select * from src_multi1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_multi1
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby.q.out Thu Jun 5 18:28:07 2014
@@ -146,8 +146,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@e1
POSTHOOK: Output: default@e2
-POSTHOOK: Lineage: e1.count EXPRESSION []
-POSTHOOK: Lineage: e2.count EXPRESSION []
+POSTHOOK: Lineage: e1.count EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: e1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: e2.count EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: e2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: select * from e1
PREHOOK: type: QUERY
PREHOOK: Input: default@e1
@@ -323,8 +325,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@e1
POSTHOOK: Output: default@e2
-POSTHOOK: Lineage: e1.count EXPRESSION []
-POSTHOOK: Lineage: e2.count EXPRESSION []
+POSTHOOK: Lineage: e1.count EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: e1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: e2.count EXPRESSION [(src)src.null, ]
+POSTHOOK: Lineage: e2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: select * from e1
PREHOOK: type: QUERY
PREHOOK: Input: default@e1
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby2.q.out Thu Jun 5 18:28:07 2014
@@ -53,18 +53,16 @@ STAGE PLANS:
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: double)
+ outputColumnNames: _col1
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col1 (type: double)
- outputColumnNames: _col1
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Stage: Stage-3
Map Reduce
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby3.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_gby3.q.out Thu Jun 5 18:28:07 2014
@@ -56,20 +56,18 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double), _col2 (type: string)
+ value expressions: _col1 (type: double), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: double), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: double), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Stage: Stage-3
Map Reduce
@@ -184,20 +182,18 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double), _col2 (type: string)
+ value expressions: _col1 (type: double), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: double), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: double), _col2 (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Stage: Stage-3
Map Reduce
@@ -1768,9 +1764,11 @@ STAGE PLANS:
sort order: ++++
Map-reduce partition columns: _col0 (type: string), _col1 (type: double), _col2 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double), _col2 (type: string)
+ value expressions: _col1 (type: double), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: double), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double), _col2 (type: string)