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 [17/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/subquery_notin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out Thu Jun 5 18:28:07 2014
@@ -202,7 +202,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col1 (type: string)
TableScan
alias: s1
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -218,14 +218,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1, _col4
Statistics: Num rows: 34 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -453,21 +452,20 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col1 (type: string), _col2 (type: string)
Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int)
+ value expressions: _col5 (type: int)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 5 Data size: 1057 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col2} {VALUE._col5}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1} {VALUE._col3}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col1, _col2, _col5, _col11
Statistics: Num rows: 17 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -728,7 +726,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: double)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: double)
TableScan
Reduce Output Operator
key expressions: UDFToDouble(_col5) (type: double)
@@ -742,7 +739,7 @@ STAGE PLANS:
Left Outer Join0 to 1
condition expressions:
0 {VALUE._col1} {VALUE._col5}
- 1 {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col1, _col5, _col11
Statistics: Num rows: 36 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -1026,21 +1023,20 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col5 (type: int), _col2 (type: string)
Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int)
+ value expressions: _col1 (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col2} {VALUE._col5}
- 1 {VALUE._col0}
+ 0 {VALUE._col1} {KEY.reducesinkkey1} {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col1, _col2, _col5, _col11
Statistics: Num rows: 17 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -1546,7 +1542,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 20 Data size: 2093 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
TableScan
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1562,14 +1557,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col0, _col1
Statistics: Num rows: 22 Data size: 2302 Basic stats: COMPLETE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_notin_having.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_notin_having.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_notin_having.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_notin_having.q.out Thu Jun 5 18:28:07 2014
@@ -150,7 +150,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
TableScan
alias: s1
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -166,18 +166,17 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((1 = 1) and _col4 is null) (type: boolean)
+ predicate: ((1 = 1) and _col2 is null) (type: boolean)
Statistics: Num rows: 17 Data size: 1732 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
@@ -309,7 +308,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 29 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double), _col1 (type: double)
+ value expressions: _col0 (type: string), _col1 (type: double)
TableScan
Reduce Output Operator
sort order:
@@ -319,9 +318,9 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5}
+ 0 {VALUE._col0} {VALUE._col1}
1
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -335,29 +334,27 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col0 (type: string), _col5 (type: double)
+ key expressions: _col0 (type: string), _col1 (type: double)
sort order: ++
- Map-reduce partition columns: _col0 (type: string), _col5 (type: double)
+ Map-reduce partition columns: _col0 (type: string), _col1 (type: double)
Statistics: Num rows: 31 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: double)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: double)
Statistics: Num rows: 4 Data size: 437 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col7
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
+ 1 {KEY.reducesinkkey0}
+ outputColumnNames: _col0, _col1, _col4
Statistics: Num rows: 34 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((1 = 1) and _col7 is null) (type: boolean)
+ predicate: ((1 = 1) and _col4 is null) (type: boolean)
Statistics: Num rows: 8 Data size: 903 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
@@ -632,25 +629,24 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 31 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double)
+ value expressions: _col1 (type: double)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 4 Data size: 437 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col5
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0}
+ outputColumnNames: _col0, _col1, _col3
Statistics: Num rows: 34 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((1 = 1) and _col5 is null) (type: boolean)
+ predicate: ((1 = 1) and _col3 is null) (type: boolean)
Statistics: Num rows: 8 Data size: 903 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out Thu Jun 5 18:28:07 2014
@@ -107,13 +107,12 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key1 (type: string), value1 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: key1 (type: string), value1 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
@@ -158,7 +157,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
TableScan
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -184,7 +182,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -321,13 +319,13 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: p_size (type: int), p_mfgr (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: p_name (type: string), p_mfgr (type: string), p_size (type: int)
+ value expressions: p_name (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col2} {VALUE._col5}
+ 0 {VALUE._col1} {KEY.reducesinkkey1} {KEY.reducesinkkey0}
1
outputColumnNames: _col1, _col2, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -456,7 +454,7 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: p_size (type: int), p_mfgr (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: p_name (type: string), p_mfgr (type: string), p_size (type: int)
+ value expressions: p_name (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
@@ -468,7 +466,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col2} {VALUE._col5}
+ 0 {VALUE._col1} {KEY.reducesinkkey1} {KEY.reducesinkkey0}
1
outputColumnNames: _col1, _col2, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -575,7 +573,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: key (type: string), value (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string), value (type: string)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
@@ -587,7 +584,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -678,7 +675,7 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col2 (type: bigint), _col1 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+ value expressions: _col0 (type: string), _col2 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col0 (type: bigint), _col1 (type: string)
@@ -690,7 +687,7 @@ STAGE PLANS:
condition map:
Left Semi Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+ 0 {VALUE._col0} {KEY.reducesinkkey1} {VALUE._col1}
1
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -833,21 +830,20 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col1 (type: string), _col2 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col1 (type: string), _col2 (type: string), _col5 (type: int)
+ value expressions: _col5 (type: int)
TableScan
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
- 0 {VALUE._col1} {VALUE._col2} {VALUE._col5}
- 1 {VALUE._col0}
+ 0 {KEY.reducesinkkey0} {KEY.reducesinkkey1} {VALUE._col3}
+ 1 {KEY.reducesinkkey0}
outputColumnNames: _col1, _col2, _col5, _col11
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out Thu Jun 5 18:28:07 2014
@@ -50,9 +50,10 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE
File Output Operator
compressed: false
@@ -115,9 +116,10 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col0 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/auto_join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/auto_join0.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/auto_join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/auto_join0.q.out Thu Jun 5 18:28:07 2014
@@ -65,7 +65,6 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
sort order: ++++
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Map 4
Map Operator Tree:
TableScan
@@ -84,21 +83,19 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: sum(hash(_col0,_col1,_col2,_col3))
- mode: hash
- outputColumnNames: _col0
+ Group By Operator
+ aggregations: sum(hash(_col0,_col1,_col2,_col3))
+ mode: hash
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint)
+ value expressions: _col0 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out Thu Jun 5 18:28:07 2014
@@ -160,7 +160,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: int)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: int), value (type: string)
+ value expressions: value (type: string)
Stage: Stage-0
Fetch Operator
@@ -259,7 +259,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: int)
Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: double), _col1 (type: int)
+ value expressions: _col0 (type: double)
Stage: Stage-0
Fetch Operator
@@ -342,7 +342,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: int)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: int), value (type: string)
+ value expressions: value (type: string)
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -493,7 +493,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col1 (type: int)
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: double), _col1 (type: int)
+ value expressions: _col0 (type: double)
Stage: Stage-0
Fetch Operator
@@ -758,7 +758,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: double)
+ value expressions: _col1 (type: double)
Stage: Stage-0
Fetch Operator
@@ -847,7 +847,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 13 Data size: 1352 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: double)
+ value expressions: _col1 (type: double)
Stage: Stage-0
Fetch Operator
@@ -913,7 +913,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: value (type: string)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: int), value (type: string)
+ value expressions: key (type: int)
Stage: Stage-0
Fetch Operator
@@ -998,7 +998,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: int)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: int), value (type: string)
+ value expressions: value (type: string)
Stage: Stage-0
Fetch Operator
@@ -1067,10 +1067,10 @@ STAGE PLANS:
keys:
0 _col1 (type: string)
1 value (type: string)
- outputColumnNames: _col5, _col10
+ outputColumnNames: _col0, _col10
Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col5 (type: int), _col10 (type: int)
+ expressions: _col0 (type: int), _col10 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out Thu Jun 5 18:28:07 2014
@@ -165,10 +165,10 @@ STAGE PLANS:
keys:
0 _col1 (type: string)
1 value (type: string)
- outputColumnNames: _col5, _col10
+ outputColumnNames: _col0, _col10
Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col5 (type: int), _col10 (type: int)
+ expressions: _col0 (type: int), _col10 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -338,7 +338,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int)
Stage: Stage-0
Fetch Operator
@@ -414,7 +413,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int)
Stage: Stage-0
Fetch Operator
@@ -456,7 +454,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int)
Map 2
Map Operator Tree:
TableScan
@@ -576,7 +573,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 121 Data size: 1283 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int)
Stage: Stage-0
Fetch Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/count.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/count.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/count.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/count.q.out Thu Jun 5 18:28:07 2014
@@ -136,7 +136,7 @@ STAGE PLANS:
key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int)
sort order: ++++
Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col4 (type: bigint), _col5 (type: bigint), _col6 (type: bigint), _col7 (type: bigint), _col8 (type: bigint), _col9 (type: bigint), _col10 (type: bigint), _col11 (type: bigint), _col12 (type: bigint), _col13 (type: bigint), _col14 (type: bigint), _col15 (type: bigint), _col16 (type: bigint), _col17 (type: bigint), _col18 (type: bigint), _col19 (type: bigint), _col20 (type: bigint), _col21 (type: bigint), _col22 (type: bigint), _col23 (type: bigint), _col24 (type: bigint)
+ value expressions: _col4 (type: bigint), _col5 (type: bigint), _col6 (type: bigint), _col7 (type: bigint), _col8 (type: bigint), _col9 (type: bigint)
Reducer 2
Reduce Operator Tree:
Group By Operator
@@ -267,7 +267,6 @@ STAGE PLANS:
key expressions: a (type: int), b (type: int), c (type: int), d (type: int)
sort order: ++++
Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reducer 2
Reduce Operator Tree:
Group By Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out Thu Jun 5 18:28:07 2014
@@ -161,14 +161,13 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reducer 2
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out Thu Jun 5 18:28:07 2014
@@ -107,7 +107,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Map 4
Map Operator Tree:
TableScan
@@ -118,7 +118,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Map 5
Map Operator Tree:
TableScan
@@ -134,8 +134,8 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1}
- 1 {VALUE._col0} {VALUE._col1}
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col4, _col5
Statistics: Num rows: 0 Data size: 125 Basic stats: PARTIAL Column stats: NONE
Reduce Output Operator
@@ -204,7 +204,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Map 5
Map Operator Tree:
TableScan
@@ -230,7 +229,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
@@ -442,7 +441,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Map 5
Map Operator Tree:
TableScan
@@ -478,7 +476,7 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
+ 0 {KEY.reducesinkkey0}
1
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out Thu Jun 5 18:28:07 2014
@@ -124,7 +124,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
- value expressions: key (type: string), value (type: string)
+ value expressions: value (type: string)
Map 3
Map Operator Tree:
TableScan
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out Thu Jun 5 18:28:07 2014
@@ -49,10 +49,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (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)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -61,10 +62,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
Reducer 3
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -191,10 +193,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (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)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -203,10 +206,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
Reducer 3
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -333,10 +337,11 @@ STAGE PLANS:
key expressions: _col0 (type: double), _col1 (type: string)
sort order: ++
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: double), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: double), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -345,10 +350,11 @@ STAGE PLANS:
key expressions: _col0 (type: double), _col1 (type: string)
sort order: ++
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: double), _col1 (type: string)
Reducer 3
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: double), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -541,10 +547,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (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)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -553,10 +560,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
Reducer 3
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -727,7 +735,6 @@ STAGE PLANS:
sort order: ++
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
tag: -1
- value expressions: _col0 (type: string), _col1 (type: string)
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -780,7 +787,9 @@ STAGE PLANS:
Reducer 2
Needs Tagging: false
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -790,11 +799,12 @@ STAGE PLANS:
sort order: ++
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
tag: -1
- value expressions: _col0 (type: string), _col1 (type: string)
Reducer 3
Needs Tagging: false
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out Thu Jun 5 18:28:07 2014
@@ -181,11 +181,13 @@ STAGE PLANS:
key expressions: _col0 (type: smallint)
sort order: +
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: smallint), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col0 (type: smallint)
@@ -265,7 +267,9 @@ STAGE PLANS:
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 10 Data size: 2960 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -546,11 +550,13 @@ STAGE PLANS:
key expressions: _col0 (type: smallint)
sort order: +
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: smallint), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col0 (type: smallint)
@@ -630,7 +636,9 @@ STAGE PLANS:
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 10 Data size: 2960 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -1327,11 +1335,13 @@ STAGE PLANS:
key expressions: _col1 (type: int)
sort order: +
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ value expressions: _col0 (type: smallint), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), KEY.reducesinkkey0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1395,11 +1405,13 @@ STAGE PLANS:
key expressions: _col1 (type: int)
sort order: +
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ value expressions: _col0 (type: smallint), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), KEY.reducesinkkey0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 1048 Data size: 310873 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col1 (type: int)
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out Thu Jun 5 18:28:07 2014
@@ -211,7 +211,9 @@ STAGE PLANS:
value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 10 Data size: 240 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -562,7 +564,9 @@ STAGE PLANS:
value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 10 Data size: 240 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
@@ -1257,10 +1261,12 @@ STAGE PLANS:
key expressions: _col1 (type: int)
sort order: +
Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ value expressions: _col0 (type: smallint), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), KEY.reducesinkkey0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1324,10 +1330,12 @@ STAGE PLANS:
key expressions: _col1 (type: int)
sort order: +
Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ value expressions: _col0 (type: smallint), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: smallint), KEY.reducesinkkey0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col1 (type: int)
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out Thu Jun 5 18:28:07 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_into1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_into1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_into1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_into1.q.out Thu Jun 5 18:28:07 2014
@@ -44,7 +44,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
@@ -136,7 +138,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
@@ -237,7 +241,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_into2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_into2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_into2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_into2.q.out Thu Jun 5 18:28:07 2014
@@ -48,7 +48,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
@@ -167,7 +169,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 100
@@ -269,7 +273,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 50
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out Thu Jun 5 18:28:07 2014
@@ -77,10 +77,11 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
sort order: ++++
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reducer 3
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out Thu Jun 5 18:28:07 2014
@@ -47,15 +47,14 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: key (type: string)
Reducer 2
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0}
- 1 {VALUE._col1}
+ 0 {KEY.reducesinkkey0}
+ 1 {VALUE._col0}
outputColumnNames: _col0, _col5
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out Thu Jun 5 18:28:07 2014
@@ -33,10 +33,12 @@ 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)
Reducer 2
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
@@ -114,10 +116,12 @@ 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)
Reducer 2
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
@@ -677,10 +681,12 @@ 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)
Reducer 2
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
@@ -765,10 +771,12 @@ 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)
Reducer 3
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
@@ -909,15 +917,15 @@ 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)
Reducer 3
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
@@ -956,7 +964,9 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: bigint)
Reducer 6
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
@@ -966,7 +976,7 @@ STAGE PLANS:
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)
Stage: Stage-0
Fetch Operator
@@ -1091,18 +1101,20 @@ 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)
Reducer 2
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/tez/mapjoin_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out Thu Jun 5 18:28:07 2014
@@ -96,7 +96,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: dec (type: decimal(4,0))
Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: NONE
- value expressions: dec (type: decimal(4,0))
Map 2
Map Operator Tree:
TableScan
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce1.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce1.q.out Thu Jun 5 18:28:07 2014
@@ -58,20 +58,18 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reducer 2
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-2
Dependency Collection
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/mapreduce2.q.out Thu Jun 5 18:28:07 2014
@@ -55,20 +55,18 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Reducer 2
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-2
Dependency Collection
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out Thu Jun 5 18:28:07 2014
@@ -48,7 +48,7 @@ PREHOOK: query: create table stats_tbl(
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary)
PREHOOK: type: CREATETABLE
@@ -62,7 +62,7 @@ POSTHOOK: query: create table stats_tbl(
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary)
POSTHOOK: type: CREATETABLE
@@ -77,7 +77,7 @@ PREHOOK: query: create table stats_tbl_p
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary) partitioned by (dt string)
PREHOOK: type: CREATETABLE
@@ -91,7 +91,7 @@ POSTHOOK: query: create table stats_tbl_
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
@@ -332,10 +332,10 @@ POSTHOOK: Input: default@stats_tbl_part
POSTHOOK: Input: default@stats_tbl_part@dt=2012
#### A masked pattern was here ####
PREHOOK: query: explain
-select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -347,18 +347,64 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl
PREHOOK: type: QUERY
#### A masked pattern was here ####
-POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl
POSTHOOK: type: QUERY
#### A masked pattern was here ####
-9999 9999 1999.8 9999 9999 9999 9999 9999 65791 0 99.9800033569336 0.0
+9999 9999 1999.8 9999 9999 9999 9999 9999
+PREHOOK: query: explain
+select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: 1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl
+PREHOOK: type: QUERY
+#### A masked pattern was here ####
+POSTHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl
+POSTHOOK: type: QUERY
+#### A masked pattern was here ####
+65536 65791 4294967296 4294967551 0.009999999776482582 99.9800033569336 0.01 50.0
PREHOOK: query: explain
-select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: 1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part
+PREHOOK: type: QUERY
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part
+POSTHOOK: type: QUERY
+#### A masked pattern was here ####
+9489 9489 1897.8 9489 9489 9489 9489 9489
+PREHOOK: query: explain
+select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -370,13 +416,13 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+PREHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part
PREHOOK: type: QUERY
#### A masked pattern was here ####
-POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+POSTHOOK: query: select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part
POSTHOOK: type: QUERY
#### A masked pattern was here ####
-9489 9489 1897.8 9489 9489 9489 9489 9489 65791 0 99.9800033569336 0.0
+65536 65791 4294967296 4294967551 0.009999999776482582 99.9800033569336 0.01 50.0
PREHOOK: query: explain select count(ts) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(ts) from stats_tbl_part