hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1615869 - in /hive/branches/cbo/ql/src: java/org/apache/hadoop/hive/ql/plan/ test/results/clientpositive/tez/
Date Tue, 05 Aug 2014 06:44:59 GMT
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)



Mime
View raw message