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/12/11 21:28:08 UTC
svn commit: r1644752 [9/14] - in /hive/trunk:
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/
ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
ql/s...
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=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out Thu Dec 11 20:28:02 2014
@@ -68,11 +68,11 @@ STAGE PLANS:
Inner Join 0 to 1
Left Outer Join1 to 2
Left Outer Join0 to 3
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
- 3 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+ 3 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -149,11 +149,11 @@ STAGE PLANS:
Inner Join 0 to 1
Left Outer Join1 to 2
Right Outer Join0 to 3
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
- 3 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+ 3 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -230,11 +230,11 @@ STAGE PLANS:
Inner Join 0 to 1
Right Outer Join1 to 2
Left Outer Join0 to 3
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
- 3 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+ 3 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -311,11 +311,11 @@ STAGE PLANS:
Inner Join 0 to 1
Right Outer Join1 to 2
Right Outer Join0 to 3
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
- 3 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+ 3 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -385,10 +385,10 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
Left Outer Join0 to 2
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -421,9 +421,9 @@ STAGE PLANS:
Join Operator
condition map:
Left Outer Join0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -491,10 +491,10 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
Right Outer Join0 to 2
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -527,9 +527,9 @@ STAGE PLANS:
Join Operator
condition map:
Right Outer Join0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -597,10 +597,10 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
Outer Join 0 to 2
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -633,9 +633,9 @@ STAGE PLANS:
Join Operator
condition map:
Outer Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -702,9 +702,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -737,9 +737,9 @@ STAGE PLANS:
Join Operator
condition map:
Left Outer Join0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -772,9 +772,9 @@ STAGE PLANS:
Join Operator
condition map:
Right Outer Join0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -839,9 +839,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -874,9 +874,9 @@ STAGE PLANS:
Join Operator
condition map:
Left Outer Join0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -909,9 +909,9 @@ STAGE PLANS:
Join Operator
condition map:
Outer Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -976,9 +976,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1011,9 +1011,9 @@ STAGE PLANS:
Join Operator
condition map:
Right Outer Join0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1046,9 +1046,9 @@ STAGE PLANS:
Join Operator
condition map:
Left Outer Join0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -1113,9 +1113,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1148,9 +1148,9 @@ STAGE PLANS:
Join Operator
condition map:
Right Outer Join0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1183,9 +1183,9 @@ STAGE PLANS:
Join Operator
condition map:
Outer Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
@@ -1251,9 +1251,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -1296,10 +1296,10 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
Left Outer Join1 to 2
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col6 (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out Thu Dec 11 20:28:02 2014
@@ -866,9 +866,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1
+ keys:
+ 0 ds (type: string)
+ 1 _col0 (type: string)
Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
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=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out Thu Dec 11 20:28:02 2014
@@ -204,9 +204,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {value}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -218,9 +215,6 @@ STAGE PLANS:
predicate: value is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 _col1 (type: string)
1 value (type: string)
@@ -237,9 +231,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {value}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -248,9 +239,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1
keys:
0 _col1 (type: string)
1 value (type: string)
@@ -363,9 +351,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {value}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -377,9 +362,6 @@ STAGE PLANS:
predicate: value is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 _col1 (type: string)
1 value (type: string)
@@ -396,9 +378,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {value}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -407,9 +386,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1
keys:
0 _col1 (type: string)
1 value (type: string)
@@ -526,9 +502,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {value}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -540,9 +513,6 @@ STAGE PLANS:
predicate: value is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1 {key}
keys:
0 _col1 (type: string)
1 value (type: string)
@@ -559,9 +529,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {value}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -570,9 +537,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1 {key}
keys:
0 _col1 (type: string)
1 value (type: string)
@@ -842,9 +806,6 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {key1} {key2} {value}
- 1
keys:
0 key1 (type: string)
1 key (type: string)
@@ -859,9 +820,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key1} {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -894,9 +852,6 @@ STAGE PLANS:
Filter Operator
predicate: value is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -908,9 +863,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -943,9 +895,6 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -957,9 +906,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -992,9 +938,6 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -1006,9 +949,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -1065,9 +1005,6 @@ STAGE PLANS:
$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -1082,9 +1019,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -1130,9 +1064,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {KEY.reducesinkkey0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 _col2 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1161,9 +1095,6 @@ STAGE PLANS:
join3:$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -1178,9 +1109,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -1222,9 +1150,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 _col1 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1248,9 +1176,6 @@ STAGE PLANS:
join3:join2:$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -1265,9 +1190,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -1310,9 +1232,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {KEY.reducesinkkey0} {VALUE._col3}
- 1 {VALUE._col0}
+ keys:
+ 0 _col3 (type: string)
+ 1 value (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1339,9 +1261,6 @@ STAGE PLANS:
Filter Operator
predicate: ((key1 is not null and value is not null) and key2 is not null) (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -1356,9 +1275,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key1} {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -1405,9 +1321,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 key1 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1619,9 +1535,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key1} {key2} {value}
- 1
keys:
0 key1 (type: string)
1 key (type: string)
@@ -1633,9 +1546,6 @@ STAGE PLANS:
predicate: value is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -1647,9 +1557,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -1661,9 +1568,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -1680,9 +1584,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key1} {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -1695,9 +1596,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -1710,9 +1608,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -1725,9 +1620,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -1951,9 +1843,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key1} {key2} {value}
- 1
keys:
0 key1 (type: string)
1 key (type: string)
@@ -1965,9 +1854,6 @@ STAGE PLANS:
predicate: value is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -1984,9 +1870,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key1} {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -1999,9 +1882,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -2038,9 +1918,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -2052,9 +1929,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -2066,9 +1940,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -2081,9 +1952,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -2324,9 +2192,6 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {key1} {key2} {value}
- 1
keys:
0 key1 (type: string)
1 key (type: string)
@@ -2341,9 +2206,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key1} {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -2376,9 +2238,6 @@ STAGE PLANS:
Filter Operator
predicate: value is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -2390,9 +2249,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -2425,9 +2281,6 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -2439,9 +2292,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -2474,9 +2324,6 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -2488,9 +2335,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -2547,9 +2391,6 @@ STAGE PLANS:
$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -2564,9 +2405,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5} {_col6}
- 1 {key}
keys:
0 _col2 (type: string)
1 key (type: string)
@@ -2612,9 +2450,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {KEY.reducesinkkey0} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 _col2 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 913 Data size: 13207 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -2643,9 +2481,6 @@ STAGE PLANS:
join3:$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -2660,9 +2495,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4} {_col5}
- 1 {key}
keys:
0 _col1 (type: string)
1 key (type: string)
@@ -2704,9 +2536,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 _col1 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Statistics: Num rows: 830 Data size: 12007 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -2730,9 +2562,6 @@ STAGE PLANS:
join3:join2:$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -2747,9 +2576,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col2} {_col3} {_col4}
- 1 {key}
keys:
0 _col3 (type: string)
1 value (type: string)
@@ -2792,9 +2618,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {KEY.reducesinkkey0} {VALUE._col3}
- 1 {VALUE._col0}
+ keys:
+ 0 _col3 (type: string)
+ 1 value (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 755 Data size: 10916 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -2821,9 +2647,6 @@ STAGE PLANS:
Filter Operator
predicate: ((key1 is not null and value is not null) and key2 is not null) (type: boolean)
HashTable Sink Operator
- condition expressions:
- 0 {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -2838,9 +2661,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key1} {key2} {value}
- 1 {key}
keys:
0 key1 (type: string)
1 key (type: string)
@@ -2887,9 +2707,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 key1 (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out Thu Dec 11 20:28:02 2014
@@ -38,9 +38,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -52,9 +49,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -71,9 +65,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -94,9 +85,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -274,9 +262,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -293,9 +278,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -325,9 +307,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -351,9 +330,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -559,9 +535,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -585,9 +558,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -763,9 +733,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -782,9 +749,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -828,9 +792,6 @@ STAGE PLANS:
$INTNAME1
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0}
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -842,9 +803,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -918,9 +876,6 @@ STAGE PLANS:
$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -932,9 +887,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -972,9 +924,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0}
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
@@ -1005,9 +957,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1024,9 +973,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1172,9 +1118,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1186,9 +1129,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1205,9 +1145,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1232,9 +1169,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1265,9 +1199,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0}
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Mux Operator
@@ -1294,9 +1228,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0}
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Mux Operator
@@ -1485,9 +1419,6 @@ STAGE PLANS:
$INTNAME1
TableScan
HashTable Sink Operator
- condition expressions:
- 0 {_col0}
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -1499,9 +1430,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -1575,9 +1503,6 @@ STAGE PLANS:
$INTNAME
TableScan
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -1589,9 +1514,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0}
- 1
keys:
0 _col0 (type: string)
1 _col0 (type: string)
@@ -1629,9 +1551,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0}
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
Group By Operator
@@ -1662,9 +1584,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1681,9 +1600,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1825,9 +1741,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1860,9 +1773,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -1893,9 +1803,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0}
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Mux Operator
@@ -1922,9 +1832,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0}
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Mux Operator
@@ -2085,9 +1995,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -2104,9 +2011,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -2216,9 +2120,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -2235,9 +2136,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -2286,9 +2184,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 _col0 (type: string)
1 key (type: string)
@@ -2300,9 +2195,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 _col0 (type: string)
1 key (type: string)
@@ -2314,9 +2206,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1 {key}
keys:
0 _col0 (type: string)
1 key (type: string)
@@ -2343,9 +2232,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1 {key}
keys:
0 _col0 (type: string)
1 key (type: string)
@@ -2386,9 +2272,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1
keys:
0 key (type: string)
1 key (type: string)
@@ -2405,9 +2288,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key}
- 1
keys:
0 key (type: string)
1 key (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out Thu Dec 11 20:28:02 2014
@@ -79,9 +79,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {value}
- 1 {key} {value}
keys:
0 key (type: string)
1 key (type: string)
@@ -99,9 +96,6 @@ STAGE PLANS:
Union
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col5} {_col6}
- 1 {_col0}
keys:
0 _col6 (type: string)
1 _col1 (type: string)
@@ -119,9 +113,6 @@ STAGE PLANS:
Union
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1} {_col5} {_col6}
- 1 {_col0}
keys:
0 _col6 (type: string)
1 _col1 (type: string)
@@ -138,9 +129,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {key} {value}
- 1 {key} {value}
keys:
0 key (type: string)
1 key (type: string)
@@ -149,9 +137,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1} {_col5} {_col6}
- 1 {_col0} {_col1}
keys:
0 _col6 (type: string)
1 _col1 (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Thu Dec 11 20:28:02 2014
@@ -35,9 +35,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ keys:
+ 0
+ 1
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out Thu Dec 11 20:28:02 2014
@@ -125,9 +125,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0}
+ keys:
+ 0
+ 1
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -272,9 +272,6 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0 {_col0} {_col1}
- 1 {_col0}
keys:
0
1
@@ -286,9 +283,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1}
- 1 {_col0}
keys:
0
1
Modified: hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out Thu Dec 11 20:28:02 2014
@@ -1094,9 +1094,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
Binary files hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out Thu Dec 11 20:28:02 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out Thu Dec 11 20:28:02 2014
@@ -32,9 +32,9 @@ STAGE PLANS:
Join Operator
condition map:
Left Outer Join0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -89,9 +89,9 @@ STAGE PLANS:
Join Operator
condition map:
Left Outer Join0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -146,9 +146,9 @@ STAGE PLANS:
Join Operator
condition map:
Right Outer Join0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -203,9 +203,9 @@ STAGE PLANS:
Join Operator
condition map:
Right Outer Join0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -260,9 +260,9 @@ STAGE PLANS:
Join Operator
condition map:
Outer Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -317,9 +317,9 @@ STAGE PLANS:
Join Operator
condition map:
Outer Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
Binary files hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Thu Dec 11 20:28:02 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out Thu Dec 11 20:28:02 2014
@@ -103,9 +103,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1 {VALUE._col1}
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
outputColumnNames: _col7
Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -175,9 +175,6 @@ STAGE PLANS:
predicate: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
- condition expressions:
- 0
- 1 {myvalue}
keys:
0 key (type: int)
1 key (type: int)
@@ -194,9 +191,6 @@ STAGE PLANS:
Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1 {myvalue}
keys:
0 key (type: int)
1 key (type: int)
@@ -296,9 +290,6 @@ STAGE PLANS:
Sorted Merge Bucket Map Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {value}
- 1 {value2}
keys:
0 key (type: int)
1 key (type: int)
Modified: hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Thu Dec 11 20:28:02 2014
@@ -2781,9 +2781,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
outputColumnNames: _col0, _col1, _col6, _col7
Statistics: Num rows: 11 Data size: 88 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -3124,9 +3124,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
outputColumnNames: _col0, _col1, _col6, _col7
Statistics: Num rows: 11 Data size: 88 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out Thu Dec 11 20:28:02 2014
@@ -369,9 +369,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0}
- 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col1
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Thu Dec 11 20:28:02 2014
@@ -98,9 +98,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0}
- 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col1
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -247,9 +247,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0}
- 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
outputColumnNames: _col1
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Thu Dec 11 20:28:02 2014
@@ -68,9 +68,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 6 Data size: 69 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -192,9 +192,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 19 Data size: 210 Basic stats: COMPLETE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out Thu Dec 11 20:28:02 2014
@@ -70,9 +70,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 6 Data size: 69 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -596,9 +596,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 19 Data size: 210 Basic stats: COMPLETE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Thu Dec 11 20:28:02 2014
@@ -77,9 +77,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -125,9 +125,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2}
- 1 {VALUE._col0}
+ keys:
+ 0 _col1 (type: string)
+ 1 _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -1764,9 +1764,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -1806,9 +1806,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2}
- 1 {VALUE._col0}
+ keys:
+ 0 _col1 (type: string)
+ 1 _col1 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out Thu Dec 11 20:28:02 2014
@@ -95,10 +95,10 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
+ 2 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 52 Data size: 558 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -1807,10 +1807,10 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
- condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0}
- 1 {KEY.reducesinkkey0} {VALUE._col0}
- 2 {KEY.reducesinkkey0}
+ keys:
+ 0 _col0 (type: string)
+ 1 _col0 (type: string)
+ 2 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 160 Data size: 1705 Basic stats: COMPLETE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out Thu Dec 11 20:28:02 2014
@@ -96,9 +96,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0
- 1
+ keys:
+ 0 _col0 (type: string)
+ 1 id (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: 'a' (type: string), 'c' (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join5.q.out?rev=1644752&r1=1644751&r2=1644752&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join5.q.out Thu Dec 11 20:28:02 2014
@@ -79,9 +79,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
- 1 {VALUE._col0}
+ keys:
+ 0 id1 (type: string), id2 (type: string)
+ 1 id (type: string), id (type: string)
outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -113,9 +113,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col6}
- 1 {VALUE._col1}
+ keys:
+ 0
+ 1
outputColumnNames: _col0, _col1, _col6, _col11
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -187,9 +187,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
- 1 {VALUE._col0}
+ keys:
+ 0 id1 (type: string), id2 (type: string)
+ 1 id (type: string), id (type: string)
outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -221,9 +221,9 @@ STAGE PLANS:
Join Operator
condition map:
Inner Join 0 to 1
- condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col6}
- 1 {VALUE._col1}
+ keys:
+ 0
+ 1
outputColumnNames: _col0, _col1, _col6, _col11
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Filter Operator