You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/06/05 20:28:15 UTC
svn commit: r1600719 [11/40] - in /hive/trunk:
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/
ql/src/java/org/apache/...
Modified: hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_reorder3.q.out Thu Jun 5 18:28:07 2014
@@ -86,7 +86,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
@@ -95,7 +95,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
@@ -104,7 +104,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
@@ -113,7 +113,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -121,10 +121,10 @@ STAGE PLANS:
Inner Join 1 to 2
Inner Join 2 to 3
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
- 3 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
+ 3 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 99 Basic stats: PARTIAL Column stats: NONE
Select Operator
@@ -196,7 +196,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
@@ -205,14 +205,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: val (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 33 Basic stats: PARTIAL Column stats: NONE
File Output Operator
@@ -231,7 +231,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 0 Data size: 33 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col4 (type: string), _col5 (type: string), _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
@@ -240,14 +240,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: val (type: string)
Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), val (type: string)
+ value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col3} {VALUE._col4}
+ 1 {VALUE._col0} {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 0 Data size: 36 Basic stats: PARTIAL Column stats: NONE
File Output Operator
@@ -271,11 +271,11 @@ STAGE PLANS:
value expressions: key (type: string), val (type: string)
TableScan
Reduce Output Operator
- key expressions: (_col4 + 1) (type: double)
+ key expressions: (_col0 + 1) (type: double)
sort order: +
- Map-reduce partition columns: (_col4 + 1) (type: double)
+ Map-reduce partition columns: (_col0 + 1) (type: double)
Statistics: Num rows: 0 Data size: 36 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col8 (type: string), _col9 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -286,7 +286,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 39 Basic stats: PARTIAL Column stats: NONE
Select Operator
- expressions: _col8 (type: string), _col9 (type: string), _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 0 Data size: 39 Basic stats: PARTIAL Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join_star.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_star.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_star.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_star.q.out Thu Jun 5 18:28:07 2014
@@ -241,7 +241,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col7} {_col0} {_col1}
+ 0 {_col0} {_col1} {_col7}
1 {f4}
keys:
0 _col3 (type: int)
@@ -268,15 +268,15 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col7} {_col0} {_col1}
+ 0 {_col0} {_col1} {_col7}
1 {f4}
keys:
0 _col3 (type: int)
1 f3 (type: int)
- outputColumnNames: _col1, _col4, _col5, _col11
+ outputColumnNames: _col0, _col1, _col7, _col11
Statistics: Num rows: 6 Data size: 117 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: int), _col5 (type: int), _col1 (type: int), _col11 (type: int)
+ expressions: _col0 (type: int), _col1 (type: int), _col7 (type: int), _col11 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 6 Data size: 117 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -354,7 +354,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col7} {_col0} {_col1}
+ 0 {_col0} {_col1} {_col7}
1 {f4}
keys:
0 _col7 (type: int)
@@ -381,15 +381,15 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col7} {_col0} {_col1}
+ 0 {_col0} {_col1} {_col7}
1 {f4}
keys:
0 _col7 (type: int)
1 f3 (type: int)
- outputColumnNames: _col1, _col4, _col5, _col11
+ outputColumnNames: _col0, _col1, _col7, _col11
Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: int), _col5 (type: int), _col1 (type: int), _col11 (type: int)
+ expressions: _col0 (type: int), _col1 (type: int), _col7 (type: int), _col11 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -467,7 +467,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col7} {_col0} {_col1}
+ 0 {_col0} {_col1} {_col7}
1 {f4}
keys:
0 _col7 (type: int)
@@ -494,15 +494,15 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {_col7} {_col0} {_col1}
+ 0 {_col0} {_col1} {_col7}
1 {f4}
keys:
0 _col7 (type: int)
1 f3 (type: int)
- outputColumnNames: _col1, _col4, _col5, _col11
+ outputColumnNames: _col0, _col1, _col7, _col11
Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: int), _col5 (type: int), _col1 (type: int), _col11 (type: int)
+ expressions: _col0 (type: int), _col1 (type: int), _col7 (type: int), _col11 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 8 Data size: 117 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -611,7 +611,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col7} {_col0} {_col1} {_col3}
+ 0 {_col0} {_col1} {_col3} {_col7}
1 {f4}
keys:
0 _col7 (type: int)
@@ -622,10 +622,10 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col11} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col7} {_col11}
1 {f6}
keys:
- 0 _col7 (type: int)
+ 0 _col3 (type: int)
1 f5 (type: int)
dim4
TableScan
@@ -633,7 +633,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col15} {_col1} {_col5} {_col8} {_col9}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15}
1 {f8}
2 {f12}
keys:
@@ -646,7 +646,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col1} {_col5} {_col9} {_col12} {_col13} {_col23} {_col19}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15} {_col19} {_col23}
1 {f10}
keys:
0 _col19 (type: int)
@@ -657,7 +657,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col15} {_col1} {_col5} {_col8} {_col9}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15}
1 {f8}
2 {f12}
keys:
@@ -670,10 +670,10 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col1} {_col5} {_col9} {_col12} {_col13} {_col19} {_col27} {_col23}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15} {_col19} {_col23} {_col27}
1 {f14}
keys:
- 0 _col19 (type: int)
+ 0 _col23 (type: int)
1 f13 (type: int)
Stage: Stage-12
@@ -697,62 +697,62 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {_col7} {_col0} {_col1} {_col3}
+ 0 {_col0} {_col1} {_col3} {_col7}
1 {f4}
keys:
0 _col7 (type: int)
1 f3 (type: int)
- outputColumnNames: _col1, _col4, _col5, _col7, _col11
+ outputColumnNames: _col0, _col1, _col3, _col7, _col11
Statistics: Num rows: 6 Data size: 117 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {_col11} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col7} {_col11}
1 {f6}
keys:
- 0 _col7 (type: int)
+ 0 _col3 (type: int)
1 f5 (type: int)
- outputColumnNames: _col1, _col5, _col8, _col9, _col15
+ outputColumnNames: _col0, _col1, _col7, _col11, _col15
Statistics: Num rows: 6 Data size: 128 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join0 to 1
Left Outer Join0 to 2
condition expressions:
- 0 {_col15} {_col1} {_col5} {_col8} {_col9}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15}
1 {f8}
2 {f12}
keys:
0 _col15 (type: int)
1 f7 (type: int)
2 f11 (type: int)
- outputColumnNames: _col1, _col5, _col9, _col12, _col13, _col19, _col23
+ outputColumnNames: _col0, _col1, _col7, _col11, _col15, _col19, _col23
Statistics: Num rows: 13 Data size: 281 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {_col1} {_col5} {_col9} {_col12} {_col13} {_col23} {_col19}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15} {_col19} {_col23}
1 {f10}
keys:
0 _col19 (type: int)
1 f9 (type: int)
- outputColumnNames: _col1, _col5, _col9, _col12, _col13, _col19, _col23, _col27
+ outputColumnNames: _col0, _col1, _col7, _col11, _col15, _col19, _col23, _col27
Statistics: Num rows: 14 Data size: 309 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {_col1} {_col5} {_col9} {_col12} {_col13} {_col19} {_col27} {_col23}
+ 0 {_col0} {_col1} {_col7} {_col11} {_col15} {_col19} {_col23} {_col27}
1 {f14}
keys:
- 0 _col19 (type: int)
+ 0 _col23 (type: int)
1 f13 (type: int)
- outputColumnNames: _col1, _col5, _col9, _col12, _col13, _col19, _col23, _col27, _col31
+ outputColumnNames: _col0, _col1, _col7, _col11, _col15, _col19, _col23, _col27, _col31
Statistics: Num rows: 15 Data size: 339 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col12 (type: int), _col13 (type: int), _col9 (type: int), _col5 (type: int), _col1 (type: int), _col27 (type: int), _col23 (type: int), _col19 (type: int), _col31 (type: int)
+ expressions: _col0 (type: int), _col1 (type: int), _col7 (type: int), _col11 (type: int), _col15 (type: int), _col19 (type: int), _col27 (type: int), _col23 (type: int), _col31 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 15 Data size: 339 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out Thu Jun 5 18:28:07 2014
@@ -47,14 +47,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: aint (type: int)
Statistics: Num rows: 401 Data size: 1606 Basic stats: COMPLETE Column stats: NONE
- value expressions: aint (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col4}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col3}
outputColumnNames: _col0, _col12
Statistics: Num rows: 441 Data size: 1766 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out Thu Jun 5 18:28:07 2014
@@ -39,7 +39,7 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0
- 1 {VALUE._col1}
+ 1 {VALUE._col0}
outputColumnNames: _col5
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -60,7 +60,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: value (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string), BLOCK__OFFSET__INSIDE__FILE (type: bigint)
+ value expressions: key (type: string), BLOCK__OFFSET__INSIDE__FILE (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col5 (type: string)
@@ -73,7 +73,7 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+ 1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1}
outputColumnNames: _col8, _col9, _col10
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -95,9 +95,10 @@ STAGE PLANS:
key expressions: _col0 (type: bigint), _col1 (type: string), _col2 (type: string)
sort order: +++
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint), _col1 (type: string), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 3
Modified: hive/trunk/ql/src/test/results/clientpositive/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_view.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_view.q.out Thu Jun 5 18:28:07 2014
@@ -50,7 +50,7 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col2}
+ 1 {VALUE._col0} {KEY.reducesinkkey0}
outputColumnNames: _col1, _col5, _col7
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view.q.out Thu Jun 5 18:28:07 2014
@@ -47,7 +47,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col2 (type: int)
sort order: ++
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
+ value expressions: _col1 (type: string)
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
@@ -66,9 +66,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col2 (type: int)
sort order: ++
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), KEY.reducesinkkey1 (type: int)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1
@@ -88,9 +90,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col2 (type: int)
sort order: ++
Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), KEY.reducesinkkey1 (type: int)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 1
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_cp.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_cp.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_cp.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_cp.q.out Thu Jun 5 18:28:07 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0
- 1 {VALUE._col1}
+ 1 {VALUE._col0}
outputColumnNames: _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out Thu Jun 5 18:28:07 2014
@@ -192,7 +192,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 11624 Basic stats: PARTIAL Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: int)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 11624 Basic stats: PARTIAL Column stats: COMPLETE
Limit
Number of rows: 2
@@ -213,21 +215,21 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 11624 Basic stats: PARTIAL Column stats: COMPLETE
- value expressions: _col0 (type: string), _col1 (type: int)
+ value expressions: _col1 (type: int)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 11624 Basic stats: PARTIAL Column stats: COMPLETE
- value expressions: _col0 (type: string), _col1 (type: int)
+ value expressions: _col1 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 0 Data size: 12786 Basic stats: PARTIAL Column stats: NONE
Select Operator
@@ -288,7 +290,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 11624 Basic stats: PARTIAL Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: int)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 11624 Basic stats: PARTIAL Column stats: COMPLETE
Limit
Number of rows: 2
Modified: hive/trunk/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/limit_pushdown.q.out Thu Jun 5 18:28:07 2014
@@ -28,9 +28,11 @@ STAGE PLANS:
sort order: +
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
@@ -103,9 +105,11 @@ STAGE PLANS:
sort order: -
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
@@ -630,9 +634,11 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 0
@@ -722,9 +728,11 @@ STAGE PLANS:
sort order: +
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
- value expressions: _col0 (type: string), _col1 (type: double)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: double)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
@@ -848,21 +856,21 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 2 Data size: 200 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 3 Data size: 330 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -934,7 +942,9 @@ STAGE PLANS:
TopN Hash Memory Usage: 0.3
value expressions: _col0 (type: string), _col1 (type: bigint)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: bigint)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 3
@@ -1058,17 +1068,19 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), value (type: string), value (type: string), value (type: string), value (type: string), value (type: string), value (type: string), value (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 2.0E-5
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
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=1600719&r1=1600718&r2=1600719&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 Thu Jun 5 18:28:07 2014
@@ -20,7 +20,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -29,14 +29,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -149,9 +149,11 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -320,7 +322,9 @@ STAGE PLANS:
TopN Hash Memory Usage: 0.3
value expressions: _col0 (type: string), _col1 (type: double)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: double)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
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=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out Thu Jun 5 18:28:07 2014
@@ -55,7 +55,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
TableScan
alias: p1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -70,8 +69,8 @@ STAGE PLANS:
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col5
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -191,14 +190,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col5
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/load_dyn_part14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/load_dyn_part14.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/load_dyn_part14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/load_dyn_part14.q.out Thu Jun 5 18:28:07 2014
@@ -79,7 +79,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Limit
Number of rows: 2
@@ -178,7 +180,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Limit
Number of rows: 2
@@ -208,7 +212,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Limit
Number of rows: 2
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=1600719&r1=1600718&r2=1600719&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 Thu Jun 5 18:28:07 2014 differ
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=1600719&r1=1600718&r2=1600719&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 Thu Jun 5 18:28:07 2014
@@ -144,11 +144,13 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col2 (type: string), _col4 (type: string)
sort order: +++
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col1 (type: string), _col3 (type: string), _col5 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string), VALUE._col1 (type: string), KEY.reducesinkkey2 (type: string), VALUE._col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -306,11 +308,13 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col2 (type: string), _col4 (type: string)
sort order: +++
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col1 (type: string), _col3 (type: string), _col5 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string), VALUE._col1 (type: string), KEY.reducesinkkey2 (type: string), VALUE._col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
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=1600719&r1=1600718&r2=1600719&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 Thu Jun 5 18:28:07 2014
@@ -312,11 +312,12 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1144,11 +1145,12 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
sort order: ++++++
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Local Work:
Map Reduce Local Work
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out Thu Jun 5 18:28:07 2014
@@ -51,20 +51,18 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: UDFToInteger(VALUE._col0) (type: int), UDFToInteger(VALUE._col1) (type: int), UDFToInteger(VALUE._col2) (type: int), VALUE._col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out Thu Jun 5 18:28:07 2014
@@ -48,20 +48,18 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: UDFToInteger(VALUE._col0) (type: int), UDFToInteger(VALUE._col1) (type: int), UDFToInteger(VALUE._col2) (type: int), VALUE._col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out Thu Jun 5 18:28:07 2014
@@ -48,20 +48,18 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: UDFToInteger(VALUE._col0) (type: int), UDFToInteger(VALUE._col1) (type: int), UDFToInteger(VALUE._col2) (type: int), VALUE._col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out Thu Jun 5 18:28:07 2014
@@ -51,20 +51,18 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: UDFToInteger(VALUE._col0) (type: int), UDFToInteger(VALUE._col1) (type: int), UDFToInteger(VALUE._col2) (type: int), VALUE._col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), UDFToInteger(_col1) (type: int), UDFToInteger(_col2) (type: int), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out Thu Jun 5 18:28:07 2014
@@ -40,22 +40,20 @@ STAGE PLANS:
sort order: -+
Map-reduce partition columns: _col3 (type: string), _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: int), _col2 (type: int), _col3 (type: string)
+ value expressions: _col0 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: UDFToInteger(VALUE._col0) (type: int), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out Thu Jun 5 18:28:07 2014
@@ -40,22 +40,20 @@ STAGE PLANS:
sort order: -+
Map-reduce partition columns: _col3 (type: string), _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: int), _col2 (type: int), _col3 (type: string)
+ value expressions: _col0 (type: string), _col3 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: UDFToInteger(VALUE._col0) (type: int), KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out Thu Jun 5 18:28:07 2014
@@ -48,20 +48,18 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), UDFToInteger(VALUE._col2) (type: int), UDFToInteger(VALUE._col3) (type: int), UDFToInteger(VALUE._col4) (type: int), VALUE._col5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string), UDFToInteger(_col2) (type: int), UDFToInteger(_col3) (type: int), UDFToInteger(_col4) (type: int), _col5 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out Thu Jun 5 18:28:07 2014
@@ -51,20 +51,18 @@ STAGE PLANS:
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), UDFToInteger(VALUE._col2) (type: int), UDFToInteger(VALUE._col3) (type: int), UDFToInteger(VALUE._col4) (type: int), VALUE._col5 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string), UDFToInteger(_col2) (type: int), UDFToInteger(_col3) (type: int), UDFToInteger(_col4) (type: int), _col5 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ File Output Operator
+ compressed: false
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge3.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/merge3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/merge3.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/merge4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge4.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/merge4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/merge4.q.out Thu Jun 5 18:28:07 2014
@@ -2799,7 +2799,9 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Limit
Number of rows: 1
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=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out Thu Jun 5 18:28:07 2014
@@ -54,7 +54,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: val1 (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: val1 (type: int), val2 (type: int)
+ value expressions: val2 (type: int)
TableScan
alias: b
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -63,7 +63,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: val1 (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: val1 (type: int), val2 (type: int)
+ value expressions: val2 (type: int)
TableScan
alias: c
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -72,7 +72,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: val1 (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: val1 (type: int), val2 (type: int)
+ value expressions: val2 (type: int)
TableScan
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -81,7 +81,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: val1 (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: val1 (type: int), val2 (type: int)
+ value expressions: val2 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
@@ -89,10 +89,10 @@ STAGE PLANS:
Inner Join 0 to 2
Inner Join 0 to 3
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
- 3 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
+ 3 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -111,7 +111,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: _col12 (type: int), _col13 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col0 (type: int), _col1 (type: int)
+ value expressions: _col0 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col12 (type: int), _col13 (type: int)
TableScan
alias: e
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -120,18 +120,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: val2 (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: val1 (type: int), val2 (type: int)
+ value expressions: val1 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9} {VALUE._col12} {VALUE._col13}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12}
+ 1 {VALUE._col0} {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13, _col16, _col17
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col12 (type: int), _col13 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col0 (type: int), _col1 (type: int), _col16 (type: int), _col17 (type: int)
+ 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)
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
@@ -170,7 +170,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: c
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -179,7 +179,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
TableScan
alias: a
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -188,19 +188,19 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
Left Outer Join1 to 2
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
- 2 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0} {VALUE._col0}
filter predicates:
0
- 1 {(VALUE._col0 < 10)}
+ 1 {(KEY.reducesinkkey0 < 10)}
2
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE