hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [6/9] hive git commit: HIVE-9695: Redundant filter operator in reducer Vertex when CBO is disabled (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Thu, 08 Oct 2015 19:36:01 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/48c420e5/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
index 7d9d99e..141a80b 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
@@ -548,10 +548,10 @@ Stage-0
                               Select Operator [SEL_37]
                                  outputColumnNames:["_col2","_col6"]
                                  Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE
Column stats: COMPLETE
-                                 Filter Operator [FIL_36]
+                                 Filter Operator [FIL_51]
                                     predicate:((_col1 > 0) or (_col6 >= 0)) (type:
boolean)
                                     Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE
Column stats: COMPLETE
-                                    Merge Join Operator [MERGEJOIN_55]
+                                    Merge Join Operator [MERGEJOIN_57]
                                     |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |  keys:{"0":"_col0 (type: string)","1":"_col0 (type:
string)"}
                                     |  outputColumnNames:["_col1","_col2","_col6"]
@@ -566,7 +566,7 @@ Stage-0
                                     |     Select Operator [SEL_30]
                                     |        outputColumnNames:["_col0","_col1"]
                                     |        Statistics:Num rows: 18 Data size: 1424 Basic
stats: COMPLETE Column stats: COMPLETE
-                                    |        Filter Operator [FIL_53]
+                                    |        Filter Operator [FIL_55]
                                     |           predicate:key is not null (type: boolean)
                                     |           Statistics:Num rows: 18 Data size: 1424 Basic
stats: COMPLETE Column stats: COMPLETE
                                     |           TableScan [TS_29]
@@ -582,10 +582,10 @@ Stage-0
                                           Select Operator [SEL_28]
                                              outputColumnNames:["_col0","_col1","_col2"]
                                              Statistics:Num rows: 1 Data size: 101 Basic
stats: COMPLETE Column stats: COMPLETE
-                                             Filter Operator [FIL_27]
+                                             Filter Operator [FIL_52]
                                                 predicate:((_col1 + _col4) >= 0) (type:
boolean)
                                                 Statistics:Num rows: 1 Data size: 101 Basic
stats: COMPLETE Column stats: COMPLETE
-                                                Merge Join Operator [MERGEJOIN_54]
+                                                Merge Join Operator [MERGEJOIN_56]
                                                 |  condition map:[{"":"Inner Join 0 to 1"}]
                                                 |  keys:{"0":"_col0 (type: string)","1":"_col0
(type: string)"}
                                                 |  outputColumnNames:["_col0","_col1","_col2","_col4"]
@@ -626,7 +626,7 @@ Stage-0
                                                 |                       keys:key (type: string),
c_int (type: int), c_float (type: float)
                                                 |                       outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                 |                       Statistics:Num rows:
1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
-                                                |                       Filter Operator [FIL_52]
+                                                |                       Filter Operator [FIL_54]
                                                 |                          predicate:((((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and key is not null) (type: boolean)
                                                 |                          Statistics:Num
rows: 3 Data size: 279 Basic stats: COMPLETE Column stats: COMPLETE
                                                 |                          TableScan [TS_11]
@@ -668,7 +668,7 @@ Stage-0
                                                                         keys:key (type: string),
c_int (type: int), c_float (type: float)
                                                                         outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                                         Statistics:Num rows:
1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
-                                                                        Filter Operator [FIL_51]
+                                                                        Filter Operator [FIL_53]
                                                                            predicate:((((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and key is not null) (type: boolean)
                                                                            Statistics:Num
rows: 3 Data size: 279 Basic stats: COMPLETE Column stats: COMPLETE
                                                                            TableScan [TS_0]
@@ -731,10 +731,10 @@ Stage-0
                               Select Operator [SEL_34]
                                  outputColumnNames:["_col2","_col6"]
                                  Statistics:Num rows: 1 Data size: 16 Basic stats: COMPLETE
Column stats: COMPLETE
-                                 Filter Operator [FIL_48]
+                                 Filter Operator [FIL_49]
                                     predicate:((((_col6 > 0) and ((_col6 >= 1) or (_col2
>= 1))) and ((UDFToLong(_col6) + _col2) >= 0)) and ((_col1 > 0) or (_col6 >= 0)))
(type: boolean)
                                     Statistics:Num rows: 1 Data size: 16 Basic stats: COMPLETE
Column stats: COMPLETE
-                                    Merge Join Operator [MERGEJOIN_53]
+                                    Merge Join Operator [MERGEJOIN_55]
                                     |  condition map:[{"":"Left Outer Join0 to 1"}]
                                     |  keys:{"0":"_col0 (type: string)","1":"_col0 (type:
string)"}
                                     |  outputColumnNames:["_col1","_col2","_col6"]
@@ -762,10 +762,10 @@ Stage-0
                                           Select Operator [SEL_27]
                                              outputColumnNames:["_col0","_col1","_col2"]
                                              Statistics:Num rows: 1 Data size: 101 Basic
stats: COMPLETE Column stats: COMPLETE
-                                             Filter Operator [FIL_26]
+                                             Filter Operator [FIL_50]
                                                 predicate:((_col1 + _col4) >= 0) (type:
boolean)
                                                 Statistics:Num rows: 1 Data size: 101 Basic
stats: COMPLETE Column stats: COMPLETE
-                                                Merge Join Operator [MERGEJOIN_52]
+                                                Merge Join Operator [MERGEJOIN_54]
                                                 |  condition map:[{"":"Left Outer Join0 to
1"}]
                                                 |  keys:{"0":"_col0 (type: string)","1":"_col0
(type: string)"}
                                                 |  outputColumnNames:["_col0","_col1","_col2","_col4"]
@@ -809,7 +809,7 @@ Stage-0
                                                 |                       Select Operator [SEL_2]
                                                 |                          outputColumnNames:["_col0","_col2","_col3"]
                                                 |                          Statistics:Num
rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
-                                                |                          Filter Operator
[FIL_49]
+                                                |                          Filter Operator
[FIL_51]
                                                 |                             predicate:((((((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int
>= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
                                                 |                             Statistics:Num
rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                 |                             TableScan [TS_0]
@@ -842,7 +842,7 @@ Stage-0
                                                                   Select Operator [SEL_15]
                                                                      outputColumnNames:["_col0","_col2","_col3"]
                                                                      Statistics:Num rows:
1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
-                                                                     Filter Operator [FIL_50]
+                                                                     Filter Operator [FIL_52]
                                                                         predicate:((((((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int
>= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
                                                                         Statistics:Num rows:
1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                         TableScan [TS_13]
@@ -894,10 +894,10 @@ Stage-0
                         Select Operator [SEL_30]
                            outputColumnNames:["_col2","_col6"]
                            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column
stats: COMPLETE
-                           Filter Operator [FIL_29]
+                           Filter Operator [FIL_38]
                               predicate:(((_col1 + _col4) >= 2) and ((_col1 > 0) or
(_col6 >= 0))) (type: boolean)
                               Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE
Column stats: COMPLETE
-                              Merge Join Operator [MERGEJOIN_40]
+                              Merge Join Operator [MERGEJOIN_41]
                               |  condition map:[{"":"Right Outer Join0 to 1"},{"":"Right
Outer Join0 to 2"}]
                               |  keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)","2":"_col0
(type: string)"}
                               |  outputColumnNames:["_col1","_col2","_col4","_col6"]
@@ -954,7 +954,7 @@ Stage-0
                               |                       Select Operator [SEL_2]
                               |                          outputColumnNames:["_col0","_col2","_col3"]
                               |                          Statistics:Num rows: 1 Data size:
93 Basic stats: COMPLETE Column stats: COMPLETE
-                              |                          Filter Operator [FIL_38]
+                              |                          Filter Operator [FIL_39]
                               |                             predicate:((((((c_int + 1) >=
0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >=
1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
                               |                             Statistics:Num rows: 1 Data size:
93 Basic stats: COMPLETE Column stats: COMPLETE
                               |                             TableScan [TS_0]
@@ -987,7 +987,7 @@ Stage-0
                                                 Select Operator [SEL_15]
                                                    outputColumnNames:["_col0","_col2","_col3"]
                                                    Statistics:Num rows: 1 Data size: 93 Basic
stats: COMPLETE Column stats: COMPLETE
-                                                   Filter Operator [FIL_39]
+                                                   Filter Operator [FIL_40]
                                                       predicate:((((((c_int + 1) >= 0)
and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1)
or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
                                                       Statistics:Num rows: 1 Data size: 93
Basic stats: COMPLETE Column stats: COMPLETE
                                                       TableScan [TS_13]
@@ -1050,10 +1050,10 @@ Stage-0
                               Select Operator [SEL_33]
                                  outputColumnNames:["_col2","_col6"]
                                  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE
Column stats: COMPLETE
-                                 Filter Operator [FIL_44]
+                                 Filter Operator [FIL_45]
                                     predicate:(((((_col6 > 0) and ((_col6 >= 1) or
(_col2 >= 1))) and ((UDFToLong(_col6) + _col2) >= 0)) and ((_col1 + _col4) >= 0))
and ((_col1 > 0) or (_col6 >= 0))) (type: boolean)
                                     Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE
Column stats: COMPLETE
-                                    Merge Join Operator [MERGEJOIN_47]
+                                    Merge Join Operator [MERGEJOIN_48]
                                     |  condition map:[{"":"Outer Join 0 to 1"},{"":"Outer
Join 0 to 2"}]
                                     |  keys:{"0":"_col0 (type: string)","1":"_col0 (type:
string)","2":"_col0 (type: string)"}
                                     |  outputColumnNames:["_col1","_col2","_col4","_col6"]
@@ -1110,7 +1110,7 @@ Stage-0
                                     |                       Select Operator [SEL_2]
                                     |                          outputColumnNames:["_col0","_col2","_col3"]
                                     |                          Statistics:Num rows: 1 Data
size: 93 Basic stats: COMPLETE Column stats: COMPLETE
-                                    |                          Filter Operator [FIL_45]
+                                    |                          Filter Operator [FIL_46]
                                     |                             predicate:((((((c_int +
1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int
>= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
                                     |                             Statistics:Num rows: 1
Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                     |                             TableScan [TS_0]
@@ -1155,7 +1155,7 @@ Stage-0
                                                             Select Operator [SEL_15]
                                                                outputColumnNames:["_col0","_col2","_col3"]
                                                                Statistics:Num rows: 1 Data
size: 93 Basic stats: COMPLETE Column stats: COMPLETE
-                                                               Filter Operator [FIL_46]
+                                                               Filter Operator [FIL_47]
                                                                   predicate:((((((c_int +
1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int
>= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
                                                                   Statistics:Num rows: 1
Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                   TableScan [TS_13]
@@ -1207,10 +1207,10 @@ Stage-0
                         Select Operator [SEL_35]
                            outputColumnNames:["_col2","_col6"]
                            Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column
stats: COMPLETE
-                           Filter Operator [FIL_34]
+                           Filter Operator [FIL_46]
                               predicate:((_col1 > 0) or (_col6 >= 0)) (type: boolean)
                               Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE
Column stats: COMPLETE
-                              Merge Join Operator [MERGEJOIN_50]
+                              Merge Join Operator [MERGEJOIN_52]
                               |  condition map:[{"":"Inner Join 0 to 1"}]
                               |  keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
                               |  outputColumnNames:["_col1","_col2","_col6"]
@@ -1225,7 +1225,7 @@ Stage-0
                               |     Select Operator [SEL_28]
                               |        outputColumnNames:["_col0","_col1"]
                               |        Statistics:Num rows: 18 Data size: 1424 Basic stats:
COMPLETE Column stats: COMPLETE
-                              |        Filter Operator [FIL_48]
+                              |        Filter Operator [FIL_50]
                               |           predicate:key is not null (type: boolean)
                               |           Statistics:Num rows: 18 Data size: 1424 Basic stats:
COMPLETE Column stats: COMPLETE
                               |           TableScan [TS_27]
@@ -1241,10 +1241,10 @@ Stage-0
                                     Select Operator [SEL_26]
                                        outputColumnNames:["_col0","_col1","_col2"]
                                        Statistics:Num rows: 1 Data size: 101 Basic stats:
COMPLETE Column stats: COMPLETE
-                                       Filter Operator [FIL_25]
+                                       Filter Operator [FIL_47]
                                           predicate:((_col1 + _col4) >= 0) (type: boolean)
                                           Statistics:Num rows: 1 Data size: 101 Basic stats:
COMPLETE Column stats: COMPLETE
-                                          Merge Join Operator [MERGEJOIN_49]
+                                          Merge Join Operator [MERGEJOIN_51]
                                           |  condition map:[{"":"Inner Join 0 to 1"}]
                                           |  keys:{"0":"_col0 (type: string)","1":"_col0
(type: string)"}
                                           |  outputColumnNames:["_col0","_col1","_col2","_col4"]
@@ -1279,7 +1279,7 @@ Stage-0
                                           |                 Select Operator [SEL_2]
                                           |                    outputColumnNames:["_col0","_col2","_col3"]
                                           |                    Statistics:Num rows: 1 Data
size: 93 Basic stats: COMPLETE Column stats: COMPLETE
-                                          |                    Filter Operator [FIL_46]
+                                          |                    Filter Operator [FIL_48]
                                           |                       predicate:(((((((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int
>= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is
not null) (type: boolean)
                                           |                       Statistics:Num rows: 1
Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                           |                       TableScan [TS_0]
@@ -1312,7 +1312,7 @@ Stage-0
                                                             Select Operator [SEL_12]
                                                                outputColumnNames:["_col0","_col2","_col3"]
                                                                Statistics:Num rows: 1 Data
size: 93 Basic stats: COMPLETE Column stats: COMPLETE
-                                                               Filter Operator [FIL_47]
+                                                               Filter Operator [FIL_49]
                                                                   predicate:(((((((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int
>= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is
not null) (type: boolean)
                                                                   Statistics:Num rows: 1
Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                   TableScan [TS_10]
@@ -1954,10 +1954,10 @@ Stage-0
             Select Operator [SEL_19]
                outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                Statistics:Num rows: 4 Data size: 404 Basic stats: COMPLETE Column stats:
COMPLETE
-               Filter Operator [FIL_18]
+               Filter Operator [FIL_26]
                   predicate:(((_col4 + 1) = 2) and ((_col1 > 0) or (_col6 >= 0))) (type:
boolean)
                   Statistics:Num rows: 4 Data size: 404 Basic stats: COMPLETE Column stats:
COMPLETE
-                  Merge Join Operator [MERGEJOIN_32]
+                  Merge Join Operator [MERGEJOIN_34]
                   |  condition map:[{"":"Inner Join 0 to 1"}]
                   |  keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
                   |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6"]
@@ -1972,7 +1972,7 @@ Stage-0
                   |     Select Operator [SEL_12]
                   |        outputColumnNames:["_col0","_col1"]
                   |        Statistics:Num rows: 18 Data size: 1424 Basic stats: COMPLETE
Column stats: COMPLETE
-                  |        Filter Operator [FIL_30]
+                  |        Filter Operator [FIL_32]
                   |           predicate:key is not null (type: boolean)
                   |           Statistics:Num rows: 18 Data size: 1424 Basic stats: COMPLETE
Column stats: COMPLETE
                   |           TableScan [TS_11]
@@ -1985,10 +1985,10 @@ Stage-0
                         sort order:+
                         Statistics:Num rows: 4 Data size: 728 Basic stats: COMPLETE Column
stats: COMPLETE
                         value expressions:_col1 (type: int), _col2 (type: float), _col3 (type:
string), _col4 (type: int)
-                        Filter Operator [FIL_27]
+                        Filter Operator [FIL_29]
                            predicate:((((_col1 + _col4) = 2) and _col0 is not null) and ((_col4
+ 1) = 2)) (type: boolean)
                            Statistics:Num rows: 4 Data size: 728 Basic stats: COMPLETE Column
stats: COMPLETE
-                           Merge Join Operator [MERGEJOIN_31]
+                           Merge Join Operator [MERGEJOIN_33]
                            |  condition map:[{"":"Outer Join 0 to 1"}]
                            |  keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
                            |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
@@ -2003,7 +2003,7 @@ Stage-0
                            |     Select Operator [SEL_2]
                            |        outputColumnNames:["_col0","_col1","_col2"]
                            |        Statistics:Num rows: 6 Data size: 465 Basic stats: COMPLETE
Column stats: COMPLETE
-                           |        Filter Operator [FIL_28]
+                           |        Filter Operator [FIL_30]
                            |           predicate:(((c_int + 1) = 2) and ((c_int > 0) or
(c_float >= 0.0))) (type: boolean)
                            |           Statistics:Num rows: 6 Data size: 465 Basic stats:
COMPLETE Column stats: COMPLETE
                            |           TableScan [TS_0]
@@ -2019,7 +2019,7 @@ Stage-0
                                  Select Operator [SEL_5]
                                     outputColumnNames:["_col0","_col1"]
                                     Statistics:Num rows: 6 Data size: 445 Basic stats: COMPLETE
Column stats: COMPLETE
-                                    Filter Operator [FIL_29]
+                                    Filter Operator [FIL_31]
                                        predicate:(((c_int + 1) = 2) and ((c_int > 0) or
(c_float >= 0.0))) (type: boolean)
                                        Statistics:Num rows: 6 Data size: 465 Basic stats:
COMPLETE Column stats: COMPLETE
                                        TableScan [TS_3]
@@ -2047,10 +2047,10 @@ Stage-0
             Select Operator [SEL_13]
                outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                Statistics:Num rows: 12 Data size: 1212 Basic stats: COMPLETE Column stats:
COMPLETE
-               Filter Operator [FIL_20]
+               Filter Operator [FIL_21]
                   predicate:((((_col4 + 1) = 2) and ((_col1 > 0) or (_col6 >= 0)))
and ((_col1 + _col4) = 2)) (type: boolean)
                   Statistics:Num rows: 12 Data size: 1212 Basic stats: COMPLETE Column stats:
COMPLETE
-                  Merge Join Operator [MERGEJOIN_23]
+                  Merge Join Operator [MERGEJOIN_24]
                   |  condition map:[{"":"Right Outer Join0 to 1"},{"":"Right Outer Join0
to 2"}]
                   |  keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)","2":"_col0
(type: string)"}
                   |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6"]
@@ -2065,7 +2065,7 @@ Stage-0
                   |     Select Operator [SEL_2]
                   |        outputColumnNames:["_col0","_col1","_col2"]
                   |        Statistics:Num rows: 6 Data size: 465 Basic stats: COMPLETE Column
stats: COMPLETE
-                  |        Filter Operator [FIL_21]
+                  |        Filter Operator [FIL_22]
                   |           predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float
>= 0.0))) (type: boolean)
                   |           Statistics:Num rows: 6 Data size: 465 Basic stats: COMPLETE
Column stats: COMPLETE
                   |           TableScan [TS_0]
@@ -2081,7 +2081,7 @@ Stage-0
                   |     Select Operator [SEL_5]
                   |        outputColumnNames:["_col0","_col1"]
                   |        Statistics:Num rows: 6 Data size: 445 Basic stats: COMPLETE Column
stats: COMPLETE
-                  |        Filter Operator [FIL_22]
+                  |        Filter Operator [FIL_23]
                   |           predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float
>= 0.0))) (type: boolean)
                   |           Statistics:Num rows: 6 Data size: 465 Basic stats: COMPLETE
Column stats: COMPLETE
                   |           TableScan [TS_3]
@@ -2418,10 +2418,10 @@ Stage-0
                                  Select Operator [SEL_39]
                                     outputColumnNames:["_col2","_col6"]
                                     Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE
Column stats: COMPLETE
-                                    Filter Operator [FIL_38]
+                                    Filter Operator [FIL_54]
                                        predicate:((_col1 > 0) or (_col6 >= 0)) (type:
boolean)
                                        Statistics:Num rows: 2 Data size: 32 Basic stats:
COMPLETE Column stats: COMPLETE
-                                       Merge Join Operator [MERGEJOIN_60]
+                                       Merge Join Operator [MERGEJOIN_62]
                                        |  condition map:[{"":"Inner Join 0 to 1"}]
                                        |  keys:{"0":"_col0 (type: string)","1":"_col0 (type:
string)"}
                                        |  outputColumnNames:["_col1","_col2","_col6"]
@@ -2436,7 +2436,7 @@ Stage-0
                                        |     Select Operator [SEL_32]
                                        |        outputColumnNames:["_col0","_col1"]
                                        |        Statistics:Num rows: 18 Data size: 1424 Basic
stats: COMPLETE Column stats: COMPLETE
-                                       |        Filter Operator [FIL_58]
+                                       |        Filter Operator [FIL_60]
                                        |           predicate:key is not null (type: boolean)
                                        |           Statistics:Num rows: 18 Data size: 1424
Basic stats: COMPLETE Column stats: COMPLETE
                                        |           TableScan [TS_31]
@@ -2452,10 +2452,10 @@ Stage-0
                                              Select Operator [SEL_30]
                                                 outputColumnNames:["_col0","_col1","_col2"]
                                                 Statistics:Num rows: 1 Data size: 101 Basic
stats: COMPLETE Column stats: COMPLETE
-                                                Filter Operator [FIL_29]
+                                                Filter Operator [FIL_55]
                                                    predicate:((_col1 + _col4) >= 0) (type:
boolean)
                                                    Statistics:Num rows: 1 Data size: 101
Basic stats: COMPLETE Column stats: COMPLETE
-                                                   Merge Join Operator [MERGEJOIN_59]
+                                                   Merge Join Operator [MERGEJOIN_61]
                                                    |  condition map:[{"":"Inner Join 0 to
1"}]
                                                    |  keys:{"0":"_col0 (type: string)","1":"_col0
(type: string)"}
                                                    |  outputColumnNames:["_col0","_col1","_col2","_col4"]
@@ -2467,7 +2467,7 @@ Stage-0
                                                    |     sort order:+
                                                    |     Statistics:Num rows: 1 Data size:
105 Basic stats: COMPLETE Column stats: COMPLETE
                                                    |     value expressions:_col1 (type: int)
-                                                   |     Filter Operator [FIL_56]
+                                                   |     Filter Operator [FIL_58]
                                                    |        predicate:_col0 is not null (type:
boolean)
                                                    |        Statistics:Num rows: 1 Data size:
105 Basic stats: COMPLETE Column stats: COMPLETE
                                                    |        Limit [LIM_22]
@@ -2502,7 +2502,7 @@ Stage-0
                                                    |                             keys:key
(type: string), c_int (type: int), c_float (type: float)
                                                    |                             outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                    |                             Statistics:Num
rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
-                                                   |                             Filter Operator
[FIL_57]
+                                                   |                             Filter Operator
[FIL_59]
                                                    |                                predicate:(((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) (type: boolean)
                                                    |                                Statistics:Num
rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: COMPLETE
                                                    |                                TableScan
[TS_12]
@@ -2515,7 +2515,7 @@ Stage-0
                                                          sort order:+
                                                          Statistics:Num rows: 1 Data size:
97 Basic stats: COMPLETE Column stats: COMPLETE
                                                          value expressions:_col1 (type: int),
_col2 (type: bigint)
-                                                         Filter Operator [FIL_54]
+                                                         Filter Operator [FIL_56]
                                                             predicate:_col0 is not null (type:
boolean)
                                                             Statistics:Num rows: 1 Data size:
97 Basic stats: COMPLETE Column stats: COMPLETE
                                                             Limit [LIM_10]
@@ -2550,7 +2550,7 @@ Stage-0
                                                                                  keys:key
(type: string), c_int (type: int), c_float (type: float)
                                                                                  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                                                  Statistics:Num
rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
-                                                                                 Filter Operator
[FIL_55]
+                                                                                 Filter Operator
[FIL_57]
                                                                                     predicate:(((c_int
+ 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) (type: boolean)
                                                                                     Statistics:Num
rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: COMPLETE
                                                                                     TableScan
[TS_0]

http://git-wip-us.apache.org/repos/asf/hive/blob/48c420e5/ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out b/ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out
index be58a2b..8398f68 100644
--- a/ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out
+++ b/ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out
@@ -323,7 +323,7 @@ STAGE PLANS:
                 outputColumnNames: _col0, _col22, _col26, _col50, _col58
                 Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                 Filter Operator
-                  predicate: ((_col0 = _col58) and (_col22 = _col26) and (_col50) IN ('KS',
'AL', 'MN', 'AL', 'SC', 'VT')) (type: boolean)
+                  predicate: ((_col0 = _col58) and (_col22 = _col26)) (type: boolean)
                   Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
                   Select Operator
                     expressions: _col50 (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/48c420e5/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
b/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
index c779368..38caa49 100644
--- a/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
+++ b/ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
@@ -1924,7 +1924,7 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 #### A masked pattern was here ####
 1000
-Warning: Shuffle Join MERGEJOIN[13][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer
2' is a cross product
+Warning: Shuffle Join MERGEJOIN[14][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer
2' is a cross product
 PREHOOK: query: -- non-equi join
 EXPLAIN select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.`date` =
'2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr
= srcpart_date_hour.hr)
 PREHOOK: type: QUERY
@@ -2011,7 +2011,7 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-Warning: Shuffle Join MERGEJOIN[13][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer
2' is a cross product
+Warning: Shuffle Join MERGEJOIN[14][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer
2' is a cross product
 PREHOOK: query: select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.`date`
= '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or
srcpart.hr = srcpart_date_hour.hr)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@srcpart

http://git-wip-us.apache.org/repos/asf/hive/blob/48c420e5/ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out b/ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out
index 288025d..4535058 100644
--- a/ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out
+++ b/ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out
@@ -320,7 +320,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col22, _col26, _col50, _col58
           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
           Filter Operator
-            predicate: ((_col0 = _col58) and (_col22 = _col26) and (_col50) IN ('KS', 'AL',
'MN', 'AL', 'SC', 'VT')) (type: boolean)
+            predicate: ((_col0 = _col58) and (_col22 = _col26)) (type: boolean)
             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
             Select Operator
               expressions: _col50 (type: string)


Mime
View raw message