You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/08/05 08:44:59 UTC
svn commit: r1615869 - in /hive/branches/cbo/ql/src:
java/org/apache/hadoop/hive/ql/plan/ test/results/clientpositive/tez/
Author: gunther
Date: Tue Aug 5 06:44:59 2014
New Revision: 1615869
URL: http://svn.apache.org/r1615869
Log:
HIVE-7612: Add link to parent vertex to mapjoin in explain (Gunther Hagleitner)
Modified:
hive/branches/cbo/ql/src/java/org/apache/hadoop/hive/ql/plan/MapJoinDesc.java
hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join0.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out
hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out
Modified: hive/branches/cbo/ql/src/java/org/apache/hadoop/hive/ql/plan/MapJoinDesc.java
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/java/org/apache/hadoop/hive/ql/plan/MapJoinDesc.java?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/java/org/apache/hadoop/hive/ql/plan/MapJoinDesc.java (original)
+++ hive/branches/cbo/ql/src/java/org/apache/hadoop/hive/ql/plan/MapJoinDesc.java Tue Aug 5 06:44:59 2014
@@ -119,6 +119,7 @@ public class MapJoinDesc extends JoinDes
}
}
+ @Explain(displayName = "input vertices")
public Map<Integer, String> getParentToInput() {
return parentToInput;
}
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join0.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join0.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join0.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join0.q.out Tue Aug 5 06:44:59 2014
@@ -56,6 +56,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col2, _col3
+ input vertices:
+ 1 Map 4
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)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out Tue Aug 5 06:44:59 2014
@@ -44,6 +44,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0, _col5
+ input vertices:
+ 0 Map 2
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: UDFToInteger(_col0) (type: int), _col5 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out Tue Aug 5 06:44:59 2014
@@ -141,6 +141,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col6
+ input vertices:
+ 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
@@ -218,6 +220,8 @@ STAGE PLANS:
0 _col1 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double), _col3 (type: string)
@@ -333,6 +337,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col5, _col6
+ input vertices:
+ 1 Map 4
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col5 (type: int), _col6 (type: string)
@@ -386,6 +392,8 @@ STAGE PLANS:
0 _col1 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
+ input vertices:
+ 1 Map 1
Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double), _col3 (type: string)
@@ -446,6 +454,8 @@ STAGE PLANS:
0 _col1 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double), _col3 (type: string)
@@ -476,6 +486,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 1 Map 4
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string)
@@ -600,6 +612,9 @@ STAGE PLANS:
1 key (type: int)
2 key (type: int)
outputColumnNames: _col0, _col1, _col6
+ input vertices:
+ 1 Map 1
+ 2 Map 2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
@@ -670,6 +685,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string)
@@ -685,6 +702,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
+ input vertices:
+ 1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string)
@@ -759,6 +778,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: double), _col3 (type: string)
@@ -860,6 +881,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: double), _col3 (type: string)
@@ -954,6 +977,8 @@ STAGE PLANS:
0 value (type: string)
1 value (type: string)
outputColumnNames: _col0, _col1, _col6
+ input vertices:
+ 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
@@ -1045,6 +1070,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col5
+ input vertices:
+ 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col5 (type: string)
@@ -1125,6 +1152,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 0 Map 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -1136,6 +1165,8 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
outputColumnNames: _col0, _col10
+ input vertices:
+ 1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col10 (type: int)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out Tue Aug 5 06:44:59 2014
@@ -151,6 +151,8 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 0 Map 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -162,6 +164,8 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
outputColumnNames: _col0, _col10
+ input vertices:
+ 1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col10 (type: int)
@@ -253,6 +257,8 @@ STAGE PLANS:
0 UDFToDouble(key) (type: double)
1 UDFToDouble(key) (type: double)
outputColumnNames: _col0, _col1, _col5
+ input vertices:
+ 0 Map 2
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col5 (type: string)
@@ -325,6 +331,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 1 Map 2
Statistics: Num rows: 91 Data size: 969 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -400,6 +408,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 1 Map 2
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -492,6 +502,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 0 Map 1
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -545,6 +557,8 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -636,6 +650,8 @@ STAGE PLANS:
0 UDFToDouble(_col0) (type: double)
1 UDFToDouble(key) (type: double)
outputColumnNames: _col0, _col2
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out Tue Aug 5 06:44:59 2014
@@ -15776,3 +15776,173 @@ POSTHOOK: Input: default@t1
#### A masked pattern was here ####
0 NULL
1 1.0
+PREHOOK: query: -- 9. Test Windowing Functions
+select count(c_int) over() from t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 9. Test Windowing Functions
+select count(c_int) over() from t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+PREHOOK: query: select * from (select count(c_int) over() from t1) t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select count(c_int) over() from t1) t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+PREHOOK: query: select count(c_int) over(), sum(c_float) over() from t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select count(c_int) over(), sum(c_float) over() from t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+18 18.0
+PREHOOK: query: select x from (select count(c_int) over() as x, sum(c_float) over() from t1) t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select x from (select count(c_int) over() as x, sum(c_float) over() from t1) t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+18
+PREHOOK: query: select * from (select max(c_int) over (partition by key order by value Rows UNBOUNDED PRECEDING), min(c_int) over (partition by key order by value rows current row), count(c_int) over(partition by key order by value ROWS 1 PRECEDING), avg(value) over (partition by key order by value Rows between unbounded preceding and unbounded following), sum(value) over (partition by key order by value rows between unbounded preceding and current row), avg(c_float) over (partition by key order by value Rows between 1 preceding and unbounded following), sum(c_float) over (partition by key order by value rows between 1 preceding and current row), max(c_float) over (partition by key order by value rows between 1 preceding and unbounded following), min(c_float) over (partition by key order by value rows between 1 preceding and 1 following) from t1) t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select max(c_int) over (partition by key order by value Rows UNBOUNDED PRECEDING), min(c_int) over (partition by key order by value rows current row), count(c_int) over(partition by key order by value ROWS 1 PRECEDING), avg(value) over (partition by key order by value Rows between unbounded preceding and unbounded following), sum(value) over (partition by key order by value rows between unbounded preceding and current row), avg(c_float) over (partition by key order by value Rows between 1 preceding and unbounded following), sum(c_float) over (partition by key order by value rows between 1 preceding and current row), max(c_float) over (partition by key order by value rows between 1 preceding and unbounded following), min(c_float) over (partition by key order by value rows between 1 preceding and 1 following) from t1) t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1 1 1 1.0 1.0 1.0 1.0 1.0 1.0
+1 1 2 1.0 2.0 1.0 2.0 1.0 1.0
+1 1 1 1.0 1.0 1.0 1.0 1.0 1.0
+1 1 2 1.0 2.0 1.0 2.0 1.0 1.0
+1 1 1 1.0 1.0 1.0 1.0 1.0 1.0
+1 1 2 1.0 2.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 3.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 4.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 5.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 6.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 7.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 8.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 9.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 10.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 11.0 1.0 2.0 1.0 1.0
+1 1 2 1.0 12.0 1.0 2.0 1.0 1.0
+1 1 1 1.0 1.0 1.0 1.0 1.0 1.0
+1 1 2 1.0 2.0 1.0 2.0 1.0 1.0
+NULL NULL 0 NULL 0.0 NULL NULL NULL NULL
+NULL NULL 0 NULL 0.0 NULL NULL NULL NULL
+PREHOOK: query: select i, a, h, b, c, d, e, f, g, a as x, a +1 as y from (select max(c_int) over (partition by key order by value range UNBOUNDED PRECEDING) a, min(c_int) over (partition by key order by value range current row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c, avg(value) over (partition by key order by value range between unbounded preceding and unbounded following) d, sum(value) over (partition by key order by value range between unbounded preceding and current row) e, avg(c_float) over (partition by key order by value range between 1 preceding and unbounded following) f, sum(c_float) over (partition by key order by value range between 1 preceding and current row) g, max(c_float) over (partition by key order by value range between 1 preceding and unbounded following) h, min(c_float) over (partition by key order by value range between 1 preceding and 1 following) i from t1) t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select i, a, h, b, c, d, e, f, g, a as x, a +1 as y from (select max(c_int) over (partition by key order by value range UNBOUNDED PRECEDING) a, min(c_int) over (partition by key order by value range current row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c, avg(value) over (partition by key order by value range between unbounded preceding and unbounded following) d, sum(value) over (partition by key order by value range between unbounded preceding and current row) e, avg(c_float) over (partition by key order by value range between 1 preceding and unbounded following) f, sum(c_float) over (partition by key order by value range between 1 preceding and current row) g, max(c_float) over (partition by key order by value range between 1 preceding and unbounded following) h, min(c_float) over (partition by key order by value range between 1 preceding and 1 following) i from t1) t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2
+1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2
+1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2
+1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2
+1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2
+1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2
+NULL NULL NULL NULL 0 NULL 0.0 NULL NULL NULL NULL
+NULL NULL NULL NULL 0 NULL 0.0 NULL NULL NULL NULL
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out Tue Aug 5 06:44:59 2014
@@ -58,6 +58,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col4, _col5
+ input vertices:
+ 1 Map 1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
@@ -112,6 +114,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col4, _col5
+ input vertices:
+ 1 Map 2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
sort order:
@@ -146,6 +150,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ input vertices:
+ 0 Map 1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
@@ -207,6 +213,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -250,6 +258,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col4
+ input vertices:
+ 1 Reducer 2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
@@ -318,6 +328,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -356,6 +368,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col4
+ input vertices:
+ 1 Reducer 2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
@@ -430,6 +444,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -513,6 +529,8 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1
+ input vertices:
+ 1 Reducer 2
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out Tue Aug 5 06:44:59 2014
@@ -117,6 +117,8 @@ STAGE PLANS:
0 dec (type: decimal(4,2))
1 dec (type: decimal(4,0))
outputColumnNames: _col0, _col3
+ input vertices:
+ 1 Map 1
Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: decimal(4,2)), _col3 (type: decimal(4,0))
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out Tue Aug 5 06:44:59 2014
@@ -35,6 +35,8 @@ STAGE PLANS:
0 value (type: string)
1 value (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -46,6 +48,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 2
Statistics: Num rows: 34 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -126,6 +130,8 @@ STAGE PLANS:
0 value (type: string)
1 value (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -137,6 +143,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 2
Statistics: Num rows: 9 Data size: 2181 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -218,6 +226,8 @@ STAGE PLANS:
0 value (type: string)
1 value (type: string)
outputColumnNames: _col0, _col2
+ input vertices:
+ 1 Map 4
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -229,6 +239,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col2
+ input vertices:
+ 1 Map 3
Statistics: Num rows: 34 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col2 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out Tue Aug 5 06:44:59 2014
@@ -853,6 +853,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col4, _col5
+ input vertices:
+ 0 Map 4
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col4 (type: string), _col5 (type: string)
@@ -1705,6 +1707,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
+ input vertices:
+ 0 Reducer 3
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out?rev=1615869&r1=1615868&r2=1615869&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_union.q.out Tue Aug 5 06:44:59 2014
@@ -36,6 +36,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1
+ input vertices:
+ 1 Map 3
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
@@ -349,6 +351,8 @@ STAGE PLANS:
0 key (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col4
+ input vertices:
+ 0 Map 1
Select Operator
expressions: _col0 (type: string), _col4 (type: string)
outputColumnNames: _col0, _col1
@@ -377,6 +381,8 @@ STAGE PLANS:
0 key (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col4
+ input vertices:
+ 0 Map 1
Select Operator
expressions: _col0 (type: string), _col4 (type: string)
outputColumnNames: _col0, _col1
@@ -526,6 +532,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 5
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
@@ -542,6 +550,9 @@ STAGE PLANS:
1 _col0 (type: string)
2 key (type: string)
outputColumnNames: _col0, _col4, _col5
+ input vertices:
+ 0 Map 1
+ 2 Map 8
Select Operator
expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
@@ -591,6 +602,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 6
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
@@ -607,6 +620,9 @@ STAGE PLANS:
1 _col0 (type: string)
2 key (type: string)
outputColumnNames: _col0, _col4, _col5
+ input vertices:
+ 0 Map 1
+ 2 Map 8
Select Operator
expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
@@ -653,6 +669,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 10
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
@@ -669,6 +687,9 @@ STAGE PLANS:
1 _col0 (type: string)
2 key (type: string)
outputColumnNames: _col0, _col4, _col5
+ input vertices:
+ 0 Map 1
+ 2 Map 8
Select Operator
expressions: _col0 (type: string), _col4 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
@@ -871,6 +892,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 3
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
@@ -912,6 +935,8 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
+ input vertices:
+ 1 Map 5
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
@@ -1042,6 +1067,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
+ input vertices:
+ 1 Map 3
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
@@ -1085,6 +1112,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
+ input vertices:
+ 1 Map 3
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
@@ -1152,6 +1181,8 @@ STAGE PLANS:
0 _col0 (type: string)
1 key (type: string)
outputColumnNames: _col0, _col2
+ input vertices:
+ 0 Union 2
Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: string)