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 [4/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/cluster.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cluster.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cluster.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cluster.q.out Thu Jun 5 18:28:07 2014
@@ -27,9 +27,11 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -83,9 +85,11 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -139,9 +143,11 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -195,9 +201,11 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -251,9 +259,11 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -307,9 +317,11 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -363,9 +375,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -419,21 +433,19 @@ STAGE PLANS:
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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -476,7 +488,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: x
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -488,14 +499,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 14 Data size: 2805 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}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col4
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -518,9 +529,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ value expressions: _col0 (type: string), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -571,7 +584,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: x
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -583,14 +596,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 14 Data size: 2805 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: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -613,9 +626,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ value expressions: _col0 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -666,7 +681,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: x
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -678,14 +693,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 14 Data size: 2805 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: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -708,9 +723,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -761,7 +778,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: x
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -773,14 +789,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 14 Data size: 2805 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}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col4
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -803,9 +819,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ value expressions: _col1 (type: string), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -877,7 +895,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 18 Data size: 3606 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: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -899,9 +917,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/column_access_stats.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/column_access_stats.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/column_access_stats.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/column_access_stats.q.out Thu Jun 5 18:28:07 2014
@@ -421,13 +421,12 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL 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}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
@@ -526,7 +525,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
TableScan
alias: t1
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
@@ -538,14 +537,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), val (type: string)
+ value expressions: val (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: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -629,13 +628,12 @@ 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
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
@@ -729,13 +727,12 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL 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: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
@@ -761,21 +758,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 5 Data size: 16 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, _col1, _col2
Statistics: Num rows: 5 Data size: 17 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out Thu Jun 5 18:28:07 2014
@@ -39,7 +39,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 1606 Basic stats: PARTIAL Column stats: NONE
value expressions: _col0 (type: array<int>), _col1 (type: array<string>), _col2 (type: map<string,string>), _col3 (type: int), _col4 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: array<int>), VALUE._col1 (type: array<string>), VALUE._col2 (type: map<string,string>), VALUE._col3 (type: int), VALUE._col4 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 0 Data size: 1606 Basic stats: PARTIAL Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer1.q.out Thu Jun 5 18:28:07 2014
@@ -38,7 +38,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -52,7 +51,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -184,7 +183,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -200,7 +198,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
@@ -470,7 +468,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -493,7 +490,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -625,7 +622,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -650,7 +646,7 @@ STAGE PLANS:
condition map:
Left Semi 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
@@ -767,7 +763,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -781,7 +776,7 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -913,7 +908,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -929,7 +923,7 @@ STAGE PLANS:
condition map:
Left Outer Join0 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
@@ -1054,14 +1048,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:
Left Outer Join0 to 1
condition expressions:
0
- 1 {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col4
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1201,14 +1194,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:
Left Outer Join0 to 1
condition expressions:
0
- 1 {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col4
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1343,7 +1335,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
TableScan
alias: x
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1352,14 +1343,13 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey1}
outputColumnNames: _col0, _col5
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1471,7 +1461,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
TableScan
alias: x
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1480,14 +1469,13 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey1}
outputColumnNames: _col0, _col5
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1616,14 +1604,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:
Right Outer Join0 to 1
condition expressions:
0
- 1 {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col4
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1762,7 +1749,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)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 60 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
@@ -1771,7 +1757,7 @@ STAGE PLANS:
Right Outer Join0 to 1
condition expressions:
0
- 1 {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col4
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -1887,7 +1873,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1901,7 +1886,7 @@ STAGE PLANS:
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2034,7 +2019,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2048,7 +2032,7 @@ STAGE PLANS:
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2189,7 +2173,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2203,7 +2186,7 @@ STAGE PLANS:
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2336,7 +2319,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2350,7 +2332,7 @@ STAGE PLANS:
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2485,7 +2467,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2499,7 +2481,7 @@ STAGE PLANS:
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
@@ -2632,7 +2614,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2646,7 +2628,7 @@ STAGE PLANS:
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
@@ -2781,7 +2763,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2795,7 +2776,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2928,7 +2909,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2942,7 +2922,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer10.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer10.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer10.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer10.q.out Thu Jun 5 18:28:07 2014
@@ -50,7 +50,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -64,7 +63,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 2 Data size: 237 Basic stats: COMPLETE Column stats: NONE
@@ -139,13 +138,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 1 Data size: 118 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:
Left Semi 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
@@ -248,7 +247,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -264,7 +262,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
@@ -290,7 +288,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -311,7 +309,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -423,7 +421,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -440,7 +437,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 6 Data size: 661 Basic stats: COMPLETE Column stats: NONE
@@ -477,13 +474,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 216 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 Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 6 Data size: 727 Basic stats: COMPLETE Column stats: NONE
@@ -578,7 +575,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -598,7 +594,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 13 Data size: 1418 Basic stats: COMPLETE Column stats: NONE
@@ -608,7 +604,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -627,7 +623,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
@@ -641,7 +637,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -743,7 +739,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -760,7 +755,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 6 Data size: 661 Basic stats: COMPLETE Column stats: NONE
@@ -797,13 +792,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:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -910,7 +905,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 6 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: y
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -930,7 +924,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)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 41 Data size: 7014 Basic stats: COMPLETE Column stats: NONE
@@ -940,7 +934,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -959,7 +953,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
@@ -973,7 +967,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer11.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer11.q.out Thu Jun 5 18:28:07 2014
@@ -82,13 +82,12 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 100 Data size: 1070 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}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 110 Data size: 1177 Basic stats: COMPLETE Column stats: NONE
@@ -205,7 +204,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 100 Data size: 1070 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 125 Data size: 1261 Basic stats: COMPLETE Column stats: NONE
@@ -213,7 +211,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
@@ -317,13 +315,12 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 25 Data size: 191 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}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
@@ -451,7 +448,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 50 Data size: 382 Basic stats: COMPLETE Column stats: NONE
@@ -459,7 +455,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
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer12.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer12.q.out Thu Jun 5 18:28:07 2014
@@ -58,21 +58,21 @@ 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: _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: 29 Data size: 5812 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._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer13.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer13.q.out Thu Jun 5 18:28:07 2014
@@ -105,21 +105,21 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: bigint)
+ value expressions: _col2 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: bigint)
+ value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {KEY.reducesinkkey1} {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -141,9 +141,10 @@ STAGE PLANS:
key expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: bigint), _col5 (type: bigint)
sort order: ++++++
Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int), _col3 (type: string), _col4 (type: bigint), _col5 (type: bigint)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: int), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: bigint), KEY.reducesinkkey5 (type: bigint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer14.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer14.q.out Thu Jun 5 18:28:07 2014
@@ -55,7 +55,9 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -73,21 +75,21 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -118,7 +120,9 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -172,9 +176,11 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -192,21 +198,21 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -235,9 +241,11 @@ 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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -292,9 +300,11 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -312,21 +322,21 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -356,9 +366,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -466,7 +478,7 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: x
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -479,11 +491,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 30 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 30 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
Mux Operator
Statistics: Num rows: 60 Data size: 12056 Basic stats: COMPLETE Column stats: NONE
@@ -491,8 +505,8 @@ STAGE PLANS:
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, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -506,7 +520,9 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 30 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
Mux Operator
Statistics: Num rows: 60 Data size: 12056 Basic stats: COMPLETE Column stats: NONE
@@ -514,8 +530,8 @@ STAGE PLANS:
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, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -635,9 +651,11 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -655,21 +673,21 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -699,9 +717,11 @@ STAGE PLANS:
sort order: -
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -757,9 +777,11 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -777,21 +799,21 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -820,9 +842,11 @@ 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: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -877,9 +901,11 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -897,21 +923,21 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -941,9 +967,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1051,7 +1079,7 @@ 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: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: x
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1064,11 +1092,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 30 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 30 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
Mux Operator
Statistics: Num rows: 60 Data size: 12056 Basic stats: COMPLETE Column stats: NONE
@@ -1076,8 +1106,8 @@ STAGE PLANS:
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, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -1091,7 +1121,9 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 30 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
Mux Operator
Statistics: Num rows: 60 Data size: 12056 Basic stats: COMPLETE Column stats: NONE
@@ -1099,8 +1131,8 @@ STAGE PLANS:
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, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -1254,21 +1286,21 @@ 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)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 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:
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, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1298,9 +1330,11 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1427,11 +1461,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
Demux Operator
Statistics: Num rows: 31 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
Mux Operator
Statistics: Num rows: 46 Data size: 8944 Basic stats: COMPLETE Column stats: NONE
@@ -1439,8 +1475,8 @@ STAGE PLANS:
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, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -1470,8 +1506,8 @@ STAGE PLANS:
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, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator