You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ga...@apache.org on 2014/08/18 19:05:07 UTC
svn commit: r1618664 [6/13] - in /hive/trunk:
hcatalog/streaming/src/java/org/apache/hive/hcatalog/streaming/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/mr/
ql/src/java/org/apache/hadoop/hive/ql/io/ ql/src/ja...
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out Mon Aug 18 17:05:02 2014
@@ -24,10 +24,10 @@ STAGE PLANS:
outputColumnNames: key, value
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -49,10 +49,10 @@ STAGE PLANS:
function name: explode
outer lateral view: true
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -116,10 +116,10 @@ STAGE PLANS:
outputColumnNames: key, value
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: int)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -141,10 +141,10 @@ STAGE PLANS:
function name: explode
outer lateral view: true
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: int)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -213,10 +213,10 @@ STAGE PLANS:
outputColumnNames: key, value
Statistics: Num rows: 500 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: array<string>), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: array<string>), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -238,10 +238,10 @@ STAGE PLANS:
function name: explode
outer lateral view: true
Lateral View Join Operator
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: array<string>), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: array<string>), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
Limit
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out Mon Aug 18 17:05:02 2014
@@ -23,10 +23,10 @@ STAGE PLANS:
outputColumnNames: value
Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -44,10 +44,10 @@ STAGE PLANS:
Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -106,10 +106,10 @@ STAGE PLANS:
outputColumnNames: value
Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -130,10 +130,10 @@ STAGE PLANS:
predicate: (col = 1) (type: boolean)
Statistics: Num rows: 14 Data size: 1427 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -183,10 +183,10 @@ STAGE PLANS:
outputColumnNames: value
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col6
+ outputColumnNames: _col1, _col7
Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col6 (type: int)
+ expressions: _col1 (type: string), _col7 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -207,10 +207,10 @@ STAGE PLANS:
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col1, _col6
+ outputColumnNames: _col1, _col7
Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col6 (type: int)
+ expressions: _col1 (type: string), _col7 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -277,19 +277,19 @@ STAGE PLANS:
outputColumnNames: value
Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
- outputColumnNames: _col1, _col4
+ expressions: _col1 (type: string), _col5 (type: int)
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4, _col5
+ outputColumnNames: _col1, _col5, _col6
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -307,10 +307,10 @@ STAGE PLANS:
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col1, _col4, _col5
+ outputColumnNames: _col1, _col5, _col6
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -328,19 +328,19 @@ STAGE PLANS:
Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
- outputColumnNames: _col1, _col4
+ expressions: _col1 (type: string), _col5 (type: int)
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4, _col5
+ outputColumnNames: _col1, _col5, _col6
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -358,10 +358,10 @@ STAGE PLANS:
Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col1, _col4, _col5
+ outputColumnNames: _col1, _col5, _col6
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -440,10 +440,10 @@ STAGE PLANS:
outputColumnNames: value
Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -464,10 +464,10 @@ STAGE PLANS:
predicate: (col > 1) (type: boolean)
Statistics: Num rows: 9 Data size: 917 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col1, _col4
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col4 (type: int)
+ expressions: _col1 (type: string), _col5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out Mon Aug 18 17:05:02 2014
@@ -43,10 +43,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Limit
Modified: hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out Mon Aug 18 17:05:02 2014
@@ -72,10 +72,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -198,10 +198,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out Mon Aug 18 17:05:02 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out Mon Aug 18 17:05:02 2014
@@ -75,10 +75,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -172,10 +172,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -275,10 +275,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: struct<key:string,value:string>)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: struct<key:string,value:string>)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -366,10 +366,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -461,10 +461,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -559,10 +559,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: struct<key:string,value:string>)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: struct<key:string,value:string>)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Limit
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out Mon Aug 18 17:05:02 2014
@@ -134,10 +134,10 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
2 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
@@ -298,10 +298,10 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
2 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out Mon Aug 18 17:05:02 2014
@@ -74,10 +74,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 5 Data size: 38 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 5 Data size: 38 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out Mon Aug 18 17:05:02 2014
@@ -145,10 +145,10 @@ STAGE PLANS:
keys:
0 id (type: int)
1 id (type: int)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col5 (type: int), _col4 (type: string), _col0 (type: int), _col1 (type: string)
+ expressions: _col6 (type: int), _col5 (type: string), _col0 (type: int), _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Map Join Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out Mon Aug 18 17:05:02 2014
@@ -304,10 +304,10 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
2 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
@@ -1137,10 +1137,10 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
2 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out Mon Aug 18 17:05:02 2014
@@ -110,7 +110,7 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
3 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -128,7 +128,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col12 (type: int), _col13 (type: int)
+ value expressions: _col0 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int), _col15 (type: int), _col16 (type: int)
TableScan
alias: e
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -146,12 +146,12 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12}
+ 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10} {VALUE._col14} {VALUE._col15}
1 {VALUE._col0} {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13, _col16, _col17
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16, _col20, _col21
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col12 (type: int), _col13 (type: int), _col16 (type: int), _col17 (type: int)
+ expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int), _col15 (type: int), _col16 (type: int), _col20 (type: int), _col21 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -222,10 +222,10 @@ STAGE PLANS:
0
1 {(KEY.reducesinkkey0 < 10)}
2
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (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
Modified: hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out Mon Aug 18 17:05:02 2014
@@ -73,10 +73,10 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
3 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -154,10 +154,10 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
3 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -235,10 +235,10 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
3 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -316,10 +316,10 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
3 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -389,7 +389,7 @@ STAGE PLANS:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -403,11 +403,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col10 (type: string), _col11 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -422,12 +422,12 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col15 (type: string), _col16 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -495,7 +495,7 @@ STAGE PLANS:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -509,11 +509,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col10 (type: string), _col11 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -528,12 +528,12 @@ STAGE PLANS:
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col15 (type: string), _col16 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -601,7 +601,7 @@ STAGE PLANS:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -615,11 +615,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col10 (type: string), _col11 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -634,12 +634,12 @@ STAGE PLANS:
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col15 (type: string), _col16 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -705,7 +705,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -719,11 +719,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -738,9 +738,9 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -767,18 +767,18 @@ 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: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -842,7 +842,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -856,11 +856,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -875,9 +875,9 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -904,18 +904,18 @@ 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: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -979,7 +979,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -993,11 +993,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1012,9 +1012,9 @@ STAGE PLANS:
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -1041,18 +1041,18 @@ 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: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1116,7 +1116,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -1130,11 +1130,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1149,9 +1149,9 @@ STAGE PLANS:
condition map:
Right Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -1178,18 +1178,18 @@ 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: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1254,7 +1254,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -1286,24 +1286,24 @@ STAGE PLANS:
value expressions: value (type: string)
TableScan
Reduce Output Operator
- key expressions: _col5 (type: string)
+ key expressions: _col6 (type: string)
sort order: +
- Map-reduce partition columns: _col5 (type: string)
+ Map-reduce partition columns: _col6 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
Left Outer Join1 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out Mon Aug 18 17:05:02 2014
@@ -885,9 +885,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -1382,9 +1382,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -1428,10 +1428,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -1706,10 +1706,10 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
@@ -2010,10 +2010,10 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
@@ -2367,9 +2367,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -2864,9 +2864,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -2910,10 +2910,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
File Output Operator