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 [8/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/h...
Modified: hive/trunk/ql/src/test/results/clientpositive/join11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join11.q.out Thu Jun 5 18:28:07 2014
@@ -53,14 +53,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 19 Data size: 1903 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}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col3
Statistics: Num rows: 20 Data size: 2093 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join12.q.out Thu Jun 5 18:28:07 2014
@@ -59,7 +59,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -81,8 +80,8 @@ STAGE PLANS:
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
2
outputColumnNames: _col0, _col3
Statistics: Num rows: 13 Data size: 1322 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join13.q.out Thu Jun 5 18:28:07 2014
@@ -44,7 +44,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -60,14 +60,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 19 Data size: 1903 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}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col2, _col3
Statistics: Num rows: 20 Data size: 2093 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -86,7 +85,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: (_col0 + _col2) (type: double)
Statistics: Num rows: 20 Data size: 2093 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col3 (type: string), _col0 (type: string)
+ value expressions: _col0 (type: string), _col3 (type: string)
TableScan
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -107,12 +106,12 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col2}
+ 0 {VALUE._col0} {VALUE._col3}
1
- outputColumnNames: _col1, _col2
+ outputColumnNames: _col0, _col3
Statistics: Num rows: 22 Data size: 2302 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col2 (type: string), _col1 (type: string)
+ expressions: _col0 (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 22 Data size: 2302 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join14.q.out Thu Jun 5 18:28:07 2014
@@ -49,14 +49,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 19 Data size: 1903 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}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 2093 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out Thu Jun 5 18:28:07 2014
@@ -49,14 +49,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 19 Data size: 1903 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}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 2093 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join15.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join15.q.out Thu Jun 5 18:28:07 2014
@@ -21,7 +21,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -30,14 +30,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE 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: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -59,9 +59,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
sort order: ++++
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/join16.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join16.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join16.q.out Thu Jun 5 18:28:07 2014
@@ -25,7 +25,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: tab
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -37,14 +36,13 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey1}
outputColumnNames: _col0, _col3
Statistics: Num rows: 3 Data size: 661 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join17.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/join17.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/join17.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/join18.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join18.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join18.q.out Thu Jun 5 18:28:07 2014
@@ -79,21 +79,21 @@ STAGE PLANS:
sort order: +
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: bigint)
+ value expressions: _col1 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Join Operator
condition map:
Outer 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, _col2, _col3
Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out Thu Jun 5 18:28:07 2014
@@ -58,7 +58,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint), _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0), count(DISTINCT KEY._col1:1._col0)
@@ -86,21 +85,21 @@ STAGE PLANS:
sort order: +
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: bigint), _col2 (type: bigint)
+ value expressions: _col1 (type: bigint), _col2 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join19.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join19.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join19.q.out Thu Jun 5 18:28:07 2014
@@ -174,15 +174,14 @@ STAGE PLANS:
sort order: +
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)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
2 {VALUE._col0}
outputColumnNames: _col0, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -202,7 +201,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col3 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col3 (type: string), _col0 (type: string), _col2 (type: string)
+ value expressions: _col0 (type: string), _col2 (type: string)
TableScan
alias: t5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -240,10 +239,10 @@ STAGE PLANS:
Inner Join 0 to 1
Inner Join 1 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col2} {VALUE._col4}
+ 0 {VALUE._col0} {VALUE._col2} {KEY.reducesinkkey0}
1
- 2 {VALUE._col1}
- outputColumnNames: _col0, _col2, _col4, _col7
+ 2 {VALUE._col0}
+ outputColumnNames: _col0, _col2, _col3, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -277,18 +276,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col7 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col2 (type: string), _col4 (type: string), _col7 (type: string)
+ value expressions: _col0 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col3} {VALUE._col5} {VALUE._col7}
- 1 {VALUE._col1}
- outputColumnNames: _col0, _col3, _col5, _col7, _col9
+ 0 {VALUE._col0} {VALUE._col2} {VALUE._col3} {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
+ outputColumnNames: _col0, _col2, _col3, _col7, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col3 (type: string), _col5 (type: string), _col0 (type: string), _col7 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col2 (type: string), _col3 (type: string), _col7 (type: string), _col9 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join2.q.out Thu Jun 5 18:28:07 2014
@@ -31,7 +31,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: src1
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -40,14 +39,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 58 Data size: 5812 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}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col4
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -81,12 +79,12 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col4}
+ 0 {VALUE._col0}
1 {VALUE._col1}
- outputColumnNames: _col4, _col9
+ outputColumnNames: _col0, _col9
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col4) (type: int), _col9 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col9 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join20.q.out Thu Jun 5 18:28:07 2014
@@ -26,7 +26,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -35,7 +35,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -47,20 +47,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE 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}
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(KEY.reducesinkkey0 < 20)}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -82,9 +82,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 63 Data size: 12786 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)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -686,7 +687,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -695,7 +696,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -707,20 +708,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE 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}
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(KEY.reducesinkkey0 < 20)}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -742,9 +743,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 63 Data size: 12786 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)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join21.q.out Thu Jun 5 18:28:07 2014
@@ -24,7 +24,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -33,7 +33,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -42,20 +42,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE 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
Right Outer Join1 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}
filter predicates:
- 0 {(VALUE._col0 < 10)}
+ 0 {(KEY.reducesinkkey0 < 10)}
1
- 2 {(VALUE._col0 < 10)}
+ 2 {(KEY.reducesinkkey0 < 10)}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -77,9 +77,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 63 Data size: 12786 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)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join22.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join22.q.out Thu Jun 5 18:28:07 2014
@@ -29,13 +29,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE 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}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -74,7 +74,7 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0
- 1 {VALUE._col3}
+ 1 {VALUE._col2}
outputColumnNames: _col7
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join23.q.out Thu Jun 5 18:28:07 2014
@@ -62,9 +62,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
sort order: ++++
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/join29.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join29.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join29.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join29.q.out Thu Jun 5 18:28:07 2014
@@ -198,14 +198,14 @@ 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), _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join3.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join3.q.out Thu Jun 5 18:28:07 2014
@@ -47,16 +47,15 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
- 2 {VALUE._col1}
+ 2 {VALUE._col0}
outputColumnNames: _col0, _col9
Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join31.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join31.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join31.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join31.q.out Thu Jun 5 18:28:07 2014
@@ -238,13 +238,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: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/join32.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/join33.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join4.q.out Thu Jun 5 18:28:07 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -75,14 +75,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 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, _col2, _col3
Statistics: Num rows: 3 Data size: 661 Basic stats: COMPLETE Column stats: NONE
Select Operator
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=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join40.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join40.q.out Thu Jun 5 18:28:07 2014
@@ -20,7 +20,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -36,14 +36,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 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: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -671,14 +671,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 58 Data size: 5812 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}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col5
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1765,7 +1764,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1774,7 +1773,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1786,20 +1785,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE 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}
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(KEY.reducesinkkey0 < 20)}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1821,9 +1820,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 63 Data size: 12786 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)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -2425,7 +2425,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2434,7 +2434,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2446,20 +2446,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE 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}
filter predicates:
0
1
- 2 {(VALUE._col0 < 20)}
+ 2 {(KEY.reducesinkkey0 < 20)}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -2481,9 +2481,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 63 Data size: 12786 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)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/join41.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join41.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join41.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join41.q.out Thu Jun 5 18:28:07 2014
@@ -30,7 +30,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE Column stats: NONE
@@ -39,14 +39,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE 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}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 3 Data size: 23 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -105,7 +105,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: src1
Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE Column stats: NONE
@@ -114,14 +114,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE 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}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 3 Data size: 23 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join5.q.out Thu Jun 5 18:28:07 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -75,14 +75,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 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, _col2, _col3
Statistics: Num rows: 3 Data size: 661 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join6.q.out Thu Jun 5 18:28:07 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -75,14 +75,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer 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, _col2, _col3
Statistics: Num rows: 3 Data size: 661 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join7.q.out Thu Jun 5 18:28:07 2014
@@ -69,7 +69,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -85,7 +85,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -101,16 +101,16 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer 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, _col2, _col3, _col4, _col5
Statistics: Num rows: 6 Data size: 1322 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join8.q.out Thu Jun 5 18:28:07 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: src2
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -75,14 +75,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 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, _col2, _col3
Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/join9.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/join9.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/join_alt_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_alt_syntax.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_alt_syntax.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_alt_syntax.q.out Thu Jun 5 18:28:07 2014
@@ -119,7 +119,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
TableScan
alias: p2
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -128,7 +127,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
TableScan
alias: p1
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -137,16 +135,15 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 1 to 2
condition expressions:
- 0 {VALUE._col1}
- 1 {VALUE._col1}
- 2 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
+ 2 {KEY.reducesinkkey0}
outputColumnNames: _col1, _col12, _col23
Statistics: Num rows: 68 Data size: 6980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -198,7 +195,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: p3
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -207,7 +203,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
TableScan
alias: p1
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -216,16 +211,15 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Inner Join 1 to 2
condition expressions:
- 0 {VALUE._col1}
- 1 {VALUE._col0}
- 2 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
+ 2 {KEY.reducesinkkey0}
outputColumnNames: _col1, _col11, _col13
Statistics: Num rows: 68 Data size: 6980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -311,28 +305,27 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
TableScan
Reduce Output Operator
key expressions: _col12 (type: string)
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 16 Data size: 1692 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col11 (type: int), _col12 (type: string), _col0 (type: int), _col1 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col11 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {VALUE._col12}
- 1 {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col11, _col12, _col23
Statistics: Num rows: 34 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col0 + _col11) = _col11) and (_col23 = _col1)) (type: boolean)
+ predicate: (((_col11 + _col0) = _col0) and (_col23 = _col12)) (type: boolean)
Statistics: Num rows: 8 Data size: 821 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col12 (type: string), _col1 (type: string), _col23 (type: string)
+ expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 8 Data size: 821 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -377,7 +370,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: p_name (type: string), p_partkey (type: int)
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (type: string)
TableScan
alias: p1
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -386,14 +378,13 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: p_name (type: string), p_partkey (type: int)
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (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.reducesinkkey1} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col11, _col12
Statistics: Num rows: 33 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -414,21 +405,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
TableScan
Reduce Output Operator
key expressions: _col12 (type: string)
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 33 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col11 (type: int), _col12 (type: string), _col0 (type: int), _col1 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col11 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {VALUE._col12}
- 1 {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col11, _col12, _col23
Statistics: Num rows: 36 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -449,28 +439,28 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (type: string)
+ value expressions: p_name (type: string)
TableScan
Reduce Output Operator
- key expressions: _col11 (type: int)
+ key expressions: _col0 (type: int)
sort order: +
- Map-reduce partition columns: _col11 (type: int)
+ Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 36 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col23 (type: string), _col0 (type: int), _col1 (type: string), _col11 (type: int), _col12 (type: string)
+ value expressions: _col1 (type: string), _col11 (type: int), _col12 (type: string), _col23 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col11} {VALUE._col12} {VALUE._col22} {VALUE._col23}
- 1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col1, _col11, _col12, _col22, _col23, _col33, _col34
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col10} {VALUE._col11} {VALUE._col22}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col11, _col12, _col23, _col33, _col34
Statistics: Num rows: 39 Data size: 4222 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col12 = _col1) and (_col22 = _col33)) and (_col22 = _col11)) (type: boolean)
+ predicate: (((_col12 = _col23) and (_col0 = _col33)) and (_col0 = _col11)) (type: boolean)
Statistics: Num rows: 4 Data size: 433 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col23 (type: string), _col12 (type: string), _col1 (type: string), _col34 (type: string)
+ expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string), _col34 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 4 Data size: 433 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -515,7 +505,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: p_name (type: string), p_partkey (type: int)
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (type: string)
TableScan
alias: p1
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -524,14 +513,13 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: p_name (type: string), p_partkey (type: int)
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (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.reducesinkkey1} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col11, _col12
Statistics: Num rows: 33 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -552,21 +540,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_name (type: string)
Statistics: Num rows: 31 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_name (type: string)
TableScan
Reduce Output Operator
key expressions: _col12 (type: string)
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 33 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col11 (type: int), _col12 (type: string), _col0 (type: int), _col1 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col11 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {VALUE._col12}
- 1 {VALUE._col1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col11, _col12, _col23
Statistics: Num rows: 36 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -587,28 +574,28 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (type: string)
+ value expressions: p_name (type: string)
TableScan
Reduce Output Operator
- key expressions: _col11 (type: int)
+ key expressions: _col0 (type: int)
sort order: +
- Map-reduce partition columns: _col11 (type: int)
+ Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 36 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col23 (type: string), _col0 (type: int), _col1 (type: string), _col11 (type: int), _col12 (type: string)
+ value expressions: _col1 (type: string), _col11 (type: int), _col12 (type: string), _col23 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col11} {VALUE._col12} {VALUE._col22} {VALUE._col23}
- 1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col1, _col11, _col12, _col22, _col23, _col33, _col34
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col10} {VALUE._col11} {VALUE._col22}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col11, _col12, _col23, _col33, _col34
Statistics: Num rows: 39 Data size: 4222 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col12 = _col1) and (_col22 = _col33)) and (_col22 = _col11)) (type: boolean)
+ predicate: (((_col12 = _col23) and (_col0 = _col33)) and (_col0 = _col11)) (type: boolean)
Statistics: Num rows: 4 Data size: 433 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col23 (type: string), _col12 (type: string), _col1 (type: string), _col34 (type: string)
+ expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string), _col34 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 4 Data size: 433 Basic stats: COMPLETE Column stats: NONE
File Output Operator