hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [21/28] hive git commit: HIVE-15029: Add logic to estimate stats for BETWEEN operator (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Tue, 25 Oct 2016 21:43:40 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query64.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query64.q.out b/ql/src/test/results/clientpositive/perf/query64.q.out
index bb74565..468c1bc 100644
--- a/ql/src/test/results/clientpositive/perf/query64.q.out
+++ b/ql/src/test/results/clientpositive/perf/query64.q.out
@@ -144,9 +144,9 @@ Stage-0
                                                           <-Map 34 [SIMPLE_EDGE]
                                                             SHUFFLE [RS_74]
                                                               PartitionCols:_col0
-                                                              Select Operator [SEL_69] (rows=57750 width=1436)
+                                                              Select Operator [SEL_69] (rows=2851 width=1436)
                                                                 Output:["_col0","_col3"]
-                                                                Filter Operator [FIL_597] (rows=57750 width=1436)
+                                                                Filter Operator [FIL_597] (rows=2851 width=1436)
                                                                   predicate:((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND 45 and i_current_price BETWEEN 36 AND 50 and i_item_sk is not null)
                                                                   TableScan [TS_67] (rows=462000 width=1436)
                                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_current_price","i_color","i_product_name"]
@@ -487,9 +487,9 @@ Stage-0
                                                           <-Map 73 [SIMPLE_EDGE]
                                                             SHUFFLE [RS_204]
                                                               PartitionCols:_col0
-                                                              Select Operator [SEL_199] (rows=57750 width=1436)
+                                                              Select Operator [SEL_199] (rows=2851 width=1436)
                                                                 Output:["_col0","_col3"]
-                                                                Filter Operator [FIL_616] (rows=57750 width=1436)
+                                                                Filter Operator [FIL_616] (rows=2851 width=1436)
                                                                   predicate:((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND 45 and i_current_price BETWEEN 36 AND 50 and i_item_sk is not null)
                                                                   TableScan [TS_197] (rows=462000 width=1436)
                                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_current_price","i_color","i_product_name"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query65.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query65.q.out b/ql/src/test/results/clientpositive/perf/query65.q.out
index 50564a5..060cddf 100644
--- a/ql/src/test/results/clientpositive/perf/query65.q.out
+++ b/ql/src/test/results/clientpositive/perf/query65.q.out
@@ -151,9 +151,9 @@ Stage-0
                                           <-Map 11 [SIMPLE_EDGE]
                                             SHUFFLE [RS_21]
                                               PartitionCols:_col0
-                                              Select Operator [SEL_19] (rows=36524 width=1119)
+                                              Select Operator [SEL_19] (rows=8116 width=1119)
                                                 Output:["_col0"]
-                                                Filter Operator [FIL_76] (rows=36524 width=1119)
+                                                Filter Operator [FIL_76] (rows=8116 width=1119)
                                                   predicate:(d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null)
                                                   TableScan [TS_17] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]
@@ -192,9 +192,9 @@ Stage-0
                                     <-Map 7 [SIMPLE_EDGE]
                                       SHUFFLE [RS_7]
                                         PartitionCols:_col0
-                                        Select Operator [SEL_5] (rows=36524 width=1119)
+                                        Select Operator [SEL_5] (rows=8116 width=1119)
                                           Output:["_col0"]
-                                          Filter Operator [FIL_74] (rows=36524 width=1119)
+                                          Filter Operator [FIL_74] (rows=8116 width=1119)
                                             predicate:(d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null)
                                             TableScan [TS_3] (rows=73049 width=1119)
                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query66.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query66.q.out b/ql/src/test/results/clientpositive/perf/query66.q.out
index 8f62292..5cf60f6 100644
--- a/ql/src/test/results/clientpositive/perf/query66.q.out
+++ b/ql/src/test/results/clientpositive/perf/query66.q.out
@@ -541,9 +541,9 @@ Stage-0
                                               <-Map 20 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_49]
                                                   PartitionCols:_col0
-                                                  Select Operator [SEL_38] (rows=43200 width=471)
+                                                  Select Operator [SEL_38] (rows=9600 width=471)
                                                     Output:["_col0"]
-                                                    Filter Operator [FIL_111] (rows=43200 width=471)
+                                                    Filter Operator [FIL_111] (rows=9600 width=471)
                                                       predicate:(t_time BETWEEN 49530 AND 78330 and t_time_sk is not null)
                                                       TableScan [TS_36] (rows=86400 width=471)
                                                         default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_time"]
@@ -619,9 +619,9 @@ Stage-0
                                               <-Map 10 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_16]
                                                   PartitionCols:_col0
-                                                  Select Operator [SEL_5] (rows=43200 width=471)
+                                                  Select Operator [SEL_5] (rows=9600 width=471)
                                                     Output:["_col0"]
-                                                    Filter Operator [FIL_106] (rows=43200 width=471)
+                                                    Filter Operator [FIL_106] (rows=9600 width=471)
                                                       predicate:(t_time BETWEEN 49530 AND 78330 and t_time_sk is not null)
                                                       TableScan [TS_3] (rows=86400 width=471)
                                                         default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_time"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query67.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query67.q.out b/ql/src/test/results/clientpositive/perf/query67.q.out
index da84d4a..41cd274 100644
--- a/ql/src/test/results/clientpositive/perf/query67.q.out
+++ b/ql/src/test/results/clientpositive/perf/query67.q.out
@@ -170,9 +170,9 @@ Stage-0
                                           <-Map 8 [SIMPLE_EDGE]
                                             SHUFFLE [RS_13]
                                               PartitionCols:_col0
-                                              Select Operator [SEL_5] (rows=36524 width=1119)
+                                              Select Operator [SEL_5] (rows=8116 width=1119)
                                                 Output:["_col0","_col2","_col3","_col4"]
-                                                Filter Operator [FIL_49] (rows=36524 width=1119)
+                                                Filter Operator [FIL_49] (rows=8116 width=1119)
                                                   predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                                   TableScan [TS_3] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq","d_year","d_moy","d_qoy"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query68.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query68.q.out b/ql/src/test/results/clientpositive/perf/query68.q.out
index d0bddaf..b84bdf6 100644
--- a/ql/src/test/results/clientpositive/perf/query68.q.out
+++ b/ql/src/test/results/clientpositive/perf/query68.q.out
@@ -93,9 +93,9 @@ Stage-0
                                             <-Map 12 [SIMPLE_EDGE]
                                               SHUFFLE [RS_22]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_11] (rows=18262 width=1119)
+                                                Select Operator [SEL_11] (rows=4058 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_77] (rows=18262 width=1119)
+                                                  Filter Operator [FIL_77] (rows=4058 width=1119)
                                                     predicate:((d_year) IN (1998, 1999, 2000) and d_dom BETWEEN 1 AND 2 and d_date_sk is not null)
                                                     TableScan [TS_9] (rows=73049 width=1119)
                                                       default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query70.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query70.q.out b/ql/src/test/results/clientpositive/perf/query70.q.out
index 4cfd4df..5a82cd1 100644
--- a/ql/src/test/results/clientpositive/perf/query70.q.out
+++ b/ql/src/test/results/clientpositive/perf/query70.q.out
@@ -67,9 +67,9 @@ Stage-0
                                     <-Map 7 [SIMPLE_EDGE]
                                       SHUFFLE [RS_44]
                                         PartitionCols:_col0
-                                        Select Operator [SEL_5] (rows=36524 width=1119)
+                                        Select Operator [SEL_5] (rows=8116 width=1119)
                                           Output:["_col0"]
-                                          Filter Operator [FIL_81] (rows=36524 width=1119)
+                                          Filter Operator [FIL_81] (rows=8116 width=1119)
                                             predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                             TableScan [TS_3] (rows=73049 width=1119)
                                               default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]
@@ -140,9 +140,9 @@ Stage-0
                                                                 <-Map 15 [SIMPLE_EDGE]
                                                                   SHUFFLE [RS_19]
                                                                     PartitionCols:_col0
-                                                                    Select Operator [SEL_14] (rows=36524 width=1119)
+                                                                    Select Operator [SEL_14] (rows=8116 width=1119)
                                                                       Output:["_col0"]
-                                                                      Filter Operator [FIL_85] (rows=36524 width=1119)
+                                                                      Filter Operator [FIL_85] (rows=8116 width=1119)
                                                                         predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                                                         TableScan [TS_12] (rows=73049 width=1119)
                                                                           default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query73.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query73.q.out b/ql/src/test/results/clientpositive/perf/query73.q.out
index 00223c0..9e1a39a 100644
--- a/ql/src/test/results/clientpositive/perf/query73.q.out
+++ b/ql/src/test/results/clientpositive/perf/query73.q.out
@@ -18,13 +18,13 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_37]
-        Select Operator [SEL_36] (rows=210828819 width=88)
+        Select Operator [SEL_36] (rows=88000001 width=860)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
         <-Reducer 2 [SIMPLE_EDGE]
           SHUFFLE [RS_35]
-            Select Operator [SEL_34] (rows=210828819 width=88)
+            Select Operator [SEL_34] (rows=88000001 width=860)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
-              Merge Join Operator [MERGEJOIN_60] (rows=210828819 width=88)
+              Merge Join Operator [MERGEJOIN_60] (rows=88000001 width=860)
                 Conds:RS_31._col0=RS_32._col1(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col7"]
               <-Map 1 [SIMPLE_EDGE]
                 SHUFFLE [RS_31]
@@ -38,7 +38,7 @@ Stage-0
               <-Reducer 8 [SIMPLE_EDGE]
                 SHUFFLE [RS_32]
                   PartitionCols:_col1
-                  Filter Operator [FIL_29] (rows=191662559 width=88)
+                  Filter Operator [FIL_29] (rows=42591679 width=88)
                     predicate:_col2 BETWEEN 1 AND 5
                     Select Operator [SEL_28] (rows=383325119 width=88)
                       Output:["_col0","_col1","_col2"]
@@ -91,9 +91,9 @@ Stage-0
                                     <-Map 9 [SIMPLE_EDGE]
                                       SHUFFLE [RS_16]
                                         PartitionCols:_col0
-                                        Select Operator [SEL_8] (rows=18262 width=1119)
+                                        Select Operator [SEL_8] (rows=4058 width=1119)
                                           Output:["_col0"]
-                                          Filter Operator [FIL_54] (rows=18262 width=1119)
+                                          Filter Operator [FIL_54] (rows=4058 width=1119)
                                             predicate:((d_year) IN (1998, 1999, 2000) and d_dom BETWEEN 1 AND 2 and d_date_sk is not null)
                                             TableScan [TS_6] (rows=73049 width=1119)
                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query79.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query79.q.out b/ql/src/test/results/clientpositive/perf/query79.q.out
index f5a68fc..6ce9592 100644
--- a/ql/src/test/results/clientpositive/perf/query79.q.out
+++ b/ql/src/test/results/clientpositive/perf/query79.q.out
@@ -70,9 +70,9 @@ Stage-0
                                   <-Map 10 [SIMPLE_EDGE]
                                     SHUFFLE [RS_19]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_11] (rows=852 width=1910)
+                                      Select Operator [SEL_11] (rows=189 width=1910)
                                         Output:["_col0","_col2"]
-                                        Filter Operator [FIL_55] (rows=852 width=1910)
+                                        Filter Operator [FIL_55] (rows=189 width=1910)
                                           predicate:(s_number_employees BETWEEN 200 AND 295 and s_store_sk is not null)
                                           TableScan [TS_9] (rows=1704 width=1910)
                                             default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_number_employees","s_city"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query80.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query80.q.out b/ql/src/test/results/clientpositive/perf/query80.q.out
index b1b98cb..6595e89 100644
--- a/ql/src/test/results/clientpositive/perf/query80.q.out
+++ b/ql/src/test/results/clientpositive/perf/query80.q.out
@@ -106,9 +106,9 @@ Stage-0
                                               <-Map 24 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_61]
                                                   PartitionCols:_col0
-                                                  Select Operator [SEL_47] (rows=36524 width=1119)
+                                                  Select Operator [SEL_47] (rows=8116 width=1119)
                                                     Output:["_col0"]
-                                                    Filter Operator [FIL_194] (rows=36524 width=1119)
+                                                    Filter Operator [FIL_194] (rows=8116 width=1119)
                                                       predicate:(d_date BETWEEN 1998-08-04 AND 1998-09-04 and d_date_sk is not null)
                                                       TableScan [TS_45] (rows=73049 width=1119)
                                                         default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
@@ -198,9 +198,9 @@ Stage-0
                                               <-Map 36 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_102]
                                                   PartitionCols:_col0
-                                                  Select Operator [SEL_88] (rows=36524 width=1119)
+                                                  Select Operator [SEL_88] (rows=8116 width=1119)
                                                     Output:["_col0"]
-                                                    Filter Operator [FIL_200] (rows=36524 width=1119)
+                                                    Filter Operator [FIL_200] (rows=8116 width=1119)
                                                       predicate:(d_date BETWEEN 1998-08-04 AND 1998-09-04 and d_date_sk is not null)
                                                       TableScan [TS_86] (rows=73049 width=1119)
                                                         default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
@@ -290,9 +290,9 @@ Stage-0
                                               <-Map 12 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_22]
                                                   PartitionCols:_col0
-                                                  Select Operator [SEL_8] (rows=36524 width=1119)
+                                                  Select Operator [SEL_8] (rows=8116 width=1119)
                                                     Output:["_col0"]
-                                                    Filter Operator [FIL_188] (rows=36524 width=1119)
+                                                    Filter Operator [FIL_188] (rows=8116 width=1119)
                                                       predicate:(d_date BETWEEN 1998-08-04 AND 1998-09-04 and d_date_sk is not null)
                                                       TableScan [TS_6] (rows=73049 width=1119)
                                                         default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query82.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query82.q.out b/ql/src/test/results/clientpositive/perf/query82.q.out
index a049855..6f784c4 100644
--- a/ql/src/test/results/clientpositive/perf/query82.q.out
+++ b/ql/src/test/results/clientpositive/perf/query82.q.out
@@ -43,32 +43,32 @@ Stage-0
                     <-Map 5 [SIMPLE_EDGE]
                       SHUFFLE [RS_17]
                         PartitionCols:_col0
-                        Select Operator [SEL_5] (rows=115500 width=1436)
+                        Select Operator [SEL_5] (rows=25666 width=1436)
                           Output:["_col0","_col1","_col2","_col3"]
-                          Filter Operator [FIL_40] (rows=115500 width=1436)
+                          Filter Operator [FIL_40] (rows=25666 width=1436)
                             predicate:((i_manufact_id) IN (437, 129, 727, 663) and i_current_price BETWEEN 30 AND 60 and i_item_sk is not null)
                             TableScan [TS_3] (rows=462000 width=1436)
                               default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_item_id","i_item_desc","i_current_price","i_manufact_id"]
                     <-Reducer 7 [SIMPLE_EDGE]
                       SHUFFLE [RS_18]
                         PartitionCols:_col1
-                        Merge Join Operator [MERGEJOIN_43] (rows=20671200 width=15)
+                        Merge Join Operator [MERGEJOIN_43] (rows=4593600 width=15)
                           Conds:RS_12._col0=RS_13._col0(Inner),Output:["_col1"]
                         <-Map 6 [SIMPLE_EDGE]
                           SHUFFLE [RS_12]
                             PartitionCols:_col0
-                            Select Operator [SEL_8] (rows=18792000 width=15)
+                            Select Operator [SEL_8] (rows=4176000 width=15)
                               Output:["_col0","_col1"]
-                              Filter Operator [FIL_41] (rows=18792000 width=15)
+                              Filter Operator [FIL_41] (rows=4176000 width=15)
                                 predicate:(inv_quantity_on_hand BETWEEN 100 AND 500 and inv_item_sk is not null and inv_date_sk is not null)
                                 TableScan [TS_6] (rows=37584000 width=15)
                                   default@inventory,inventory,Tbl:COMPLETE,Col:NONE,Output:["inv_date_sk","inv_item_sk","inv_quantity_on_hand"]
                         <-Map 8 [SIMPLE_EDGE]
                           SHUFFLE [RS_13]
                             PartitionCols:_col0
-                            Select Operator [SEL_11] (rows=36524 width=1119)
+                            Select Operator [SEL_11] (rows=8116 width=1119)
                               Output:["_col0"]
-                              Filter Operator [FIL_42] (rows=36524 width=1119)
+                              Filter Operator [FIL_42] (rows=8116 width=1119)
                                 predicate:(d_date BETWEEN '2002-05-30' AND '2002-07-30' and d_date_sk is not null)
                                 TableScan [TS_9] (rows=73049 width=1119)
                                   default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query85.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query85.q.out b/ql/src/test/results/clientpositive/perf/query85.q.out
index 2c1e8b1..e7f7348 100644
--- a/ql/src/test/results/clientpositive/perf/query85.q.out
+++ b/ql/src/test/results/clientpositive/perf/query85.q.out
@@ -21,24 +21,24 @@ Stage-0
     Stage-1
       Reducer 5
       File Output Operator [FS_59]
-        Limit [LIM_58] (rows=100 width=135)
+        Limit [LIM_58] (rows=100 width=1014)
           Number of rows:100
-          Select Operator [SEL_57] (rows=39462256 width=135)
+          Select Operator [SEL_57] (rows=1220082 width=1014)
             Output:["_col0","_col1","_col2","_col3"]
           <-Reducer 4 [SIMPLE_EDGE]
             SHUFFLE [RS_56]
-              Select Operator [SEL_55] (rows=39462256 width=135)
+              Select Operator [SEL_55] (rows=1220082 width=1014)
                 Output:["_col0","_col1","_col2","_col3"]
-                Group By Operator [GBY_54] (rows=39462256 width=135)
+                Group By Operator [GBY_54] (rows=1220082 width=1014)
                   Output:["_col0","_col1","_col2","_col3"],aggregations:["avg(VALUE._col0)","avg(VALUE._col1)","avg(VALUE._col2)"],keys:KEY._col0
                 <-Reducer 3 [SIMPLE_EDGE]
                   SHUFFLE [RS_53]
                     PartitionCols:_col0
-                    Group By Operator [GBY_52] (rows=78924512 width=135)
+                    Group By Operator [GBY_52] (rows=2440165 width=1014)
                       Output:["_col0","_col1","_col2","_col3"],aggregations:["avg(_col6)","avg(_col16)","avg(_col15)"],keys:_col28
-                      Select Operator [SEL_51] (rows=78924512 width=135)
+                      Select Operator [SEL_51] (rows=2440165 width=1014)
                         Output:["_col28","_col6","_col16","_col15"]
-                        Merge Join Operator [MERGEJOIN_109] (rows=78924512 width=135)
+                        Merge Join Operator [MERGEJOIN_109] (rows=2440165 width=1014)
                           Conds:RS_48._col13=RS_49._col0(Inner),Output:["_col6","_col15","_col16","_col28"]
                         <-Map 17 [SIMPLE_EDGE]
                           SHUFFLE [RS_49]
@@ -52,7 +52,7 @@ Stage-0
                         <-Reducer 2 [SIMPLE_EDGE]
                           SHUFFLE [RS_48]
                             PartitionCols:_col13
-                            Merge Join Operator [MERGEJOIN_108] (rows=71749555 width=135)
+                            Merge Join Operator [MERGEJOIN_108] (rows=2218332 width=1014)
                               Conds:RS_45._col0=RS_46._col0(Inner),Output:["_col6","_col13","_col15","_col16"]
                             <-Map 1 [SIMPLE_EDGE]
                               SHUFFLE [RS_45]
@@ -66,13 +66,13 @@ Stage-0
                             <-Reducer 8 [SIMPLE_EDGE]
                               SHUFFLE [RS_46]
                                 PartitionCols:_col0
-                                Select Operator [SEL_41] (rows=65226867 width=135)
+                                Select Operator [SEL_41] (rows=2016666 width=1014)
                                   Output:["_col0","_col11","_col13","_col14","_col4"]
-                                  Filter Operator [FIL_40] (rows=65226867 width=135)
+                                  Filter Operator [FIL_40] (rows=2016666 width=1014)
                                     predicate:(((_col23) IN ('KY', 'GA', 'NM') and _col6 BETWEEN 100 AND 200) or ((_col23) IN ('MT', 'OR', 'IN') and _col6 BETWEEN 150 AND 300) or ((_col23) IN ('WI', 'MO', 'WV') and _col6 BETWEEN 50 AND 250))
-                                    Select Operator [SEL_39] (rows=86969158 width=135)
+                                    Select Operator [SEL_39] (rows=12100000 width=1014)
                                       Output:["_col0","_col4","_col6","_col11","_col13","_col14","_col23"]
-                                      Merge Join Operator [MERGEJOIN_107] (rows=86969158 width=135)
+                                      Merge Join Operator [MERGEJOIN_107] (rows=12100000 width=1014)
                                         Conds:RS_36._col13, _col20, _col21=RS_37._col0, _col1, _col2(Inner),Output:["_col1","_col3","_col7","_col9","_col14","_col16","_col17"]
                                       <-Map 16 [SIMPLE_EDGE]
                                         SHUFFLE [RS_37]
@@ -86,7 +86,7 @@ Stage-0
                                       <-Reducer 7 [SIMPLE_EDGE]
                                         SHUFFLE [RS_36]
                                           PartitionCols:_col13, _col20, _col21
-                                          Merge Join Operator [MERGEJOIN_106] (rows=79062870 width=135)
+                                          Merge Join Operator [MERGEJOIN_106] (rows=11000000 width=1014)
                                             Conds:RS_33._col0=RS_34._col9(Inner),Output:["_col1","_col3","_col7","_col9","_col13","_col14","_col16","_col17","_col20","_col21"]
                                           <-Map 6 [SIMPLE_EDGE]
                                             SHUFFLE [RS_33]
@@ -100,13 +100,13 @@ Stage-0
                                           <-Reducer 12 [SIMPLE_EDGE]
                                             SHUFFLE [RS_34]
                                               PartitionCols:_col9
-                                              Select Operator [SEL_29] (rows=71875335 width=135)
+                                              Select Operator [SEL_29] (rows=1774698 width=135)
                                                 Output:["_col0","_col10","_col11","_col13","_col14","_col17","_col18","_col4","_col6","_col9"]
-                                                Filter Operator [FIL_28] (rows=71875335 width=135)
+                                                Filter Operator [FIL_28] (rows=1774698 width=135)
                                                   predicate:(((_col17 = 'M') and (_col18 = '4 yr Degree') and _col5 BETWEEN 100 AND 150) or ((_col17 = 'D') and (_col18 = 'Primary') and _col5 BETWEEN 50 AND 100) or ((_col17 = 'U') and (_col18 = 'Advanced Degree') and _col5 BETWEEN 150 AND 200))
-                                                  Select Operator [SEL_27] (rows=191667562 width=135)
+                                                  Select Operator [SEL_27] (rows=21296393 width=135)
                                                     Output:["_col0","_col4","_col5","_col6","_col9","_col10","_col11","_col13","_col14","_col17","_col18"]
-                                                    Merge Join Operator [MERGEJOIN_105] (rows=191667562 width=135)
+                                                    Merge Join Operator [MERGEJOIN_105] (rows=21296393 width=135)
                                                       Conds:RS_24._col9=RS_25._col0(Inner),Output:["_col1","_col5","_col6","_col7","_col10","_col11","_col12","_col14","_col15","_col17","_col18"]
                                                     <-Map 15 [SIMPLE_EDGE]
                                                       SHUFFLE [RS_25]
@@ -120,7 +120,7 @@ Stage-0
                                                     <-Reducer 11 [SIMPLE_EDGE]
                                                       SHUFFLE [RS_24]
                                                         PartitionCols:_col9
-                                                        Merge Join Operator [MERGEJOIN_104] (rows=174243235 width=135)
+                                                        Merge Join Operator [MERGEJOIN_104] (rows=19360357 width=135)
                                                           Conds:RS_21._col2, _col4=RS_22._col0, _col5(Inner),Output:["_col1","_col5","_col6","_col7","_col9","_col10","_col11","_col12","_col14","_col15"]
                                                         <-Map 14 [SIMPLE_EDGE]
                                                           SHUFFLE [RS_22]
@@ -134,14 +134,14 @@ Stage-0
                                                         <-Reducer 10 [SIMPLE_EDGE]
                                                           SHUFFLE [RS_21]
                                                             PartitionCols:_col2, _col4
-                                                            Merge Join Operator [MERGEJOIN_103] (rows=158402938 width=135)
+                                                            Merge Join Operator [MERGEJOIN_103] (rows=17600325 width=135)
                                                               Conds:RS_18._col0=RS_19._col2(Inner),Output:["_col1","_col2","_col4","_col5","_col6","_col7"]
                                                             <-Map 13 [SIMPLE_EDGE]
                                                               SHUFFLE [RS_19]
                                                                 PartitionCols:_col2
-                                                                Select Operator [SEL_11] (rows=144002668 width=135)
+                                                                Select Operator [SEL_11] (rows=16000296 width=135)
                                                                   Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                                                  Filter Operator [FIL_98] (rows=144002668 width=135)
+                                                                  Filter Operator [FIL_98] (rows=16000296 width=135)
                                                                     predicate:((ws_sales_price BETWEEN 100 AND 150 or ws_sales_price BETWEEN 50 AND 100 or ws_sales_price BETWEEN 150 AND 200) and (ws_net_profit BETWEEN 100 AND 200 or ws_net_profit BETWEEN 150 AND 300 or ws_net_profit BETWEEN 50 AND 250) and ws_order_number is not null and ws_item_sk is not null and ws_web_page_sk is not null and ws_sold_date_sk is not null)
                                                                     TableScan [TS_9] (rows=144002668 width=135)
                                                                       default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_web_page_sk","ws_order_number","ws_quantity","ws_sales_price","ws_net_profit"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query87.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query87.q.out b/ql/src/test/results/clientpositive/perf/query87.q.out
index 7c475ff..75634d5 100644
--- a/ql/src/test/results/clientpositive/perf/query87.q.out
+++ b/ql/src/test/results/clientpositive/perf/query87.q.out
@@ -75,9 +75,9 @@ Stage-0
                                   <-Map 20 [SIMPLE_EDGE]
                                     SHUFFLE [RS_55]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_50] (rows=36524 width=1119)
+                                      Select Operator [SEL_50] (rows=8116 width=1119)
                                         Output:["_col0","_col1"]
-                                        Filter Operator [FIL_103] (rows=36524 width=1119)
+                                        Filter Operator [FIL_103] (rows=8116 width=1119)
                                           predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                           TableScan [TS_48] (rows=73049 width=1119)
                                             default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"]
@@ -130,9 +130,9 @@ Stage-0
                                           <-Map 14 [SIMPLE_EDGE]
                                             SHUFFLE [RS_30]
                                               PartitionCols:_col0
-                                              Select Operator [SEL_25] (rows=36524 width=1119)
+                                              Select Operator [SEL_25] (rows=8116 width=1119)
                                                 Output:["_col0","_col1"]
-                                                Filter Operator [FIL_100] (rows=36524 width=1119)
+                                                Filter Operator [FIL_100] (rows=8116 width=1119)
                                                   predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                                   TableScan [TS_23] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"]
@@ -176,9 +176,9 @@ Stage-0
                                           <-Map 8 [SIMPLE_EDGE]
                                             SHUFFLE [RS_10]
                                               PartitionCols:_col0
-                                              Select Operator [SEL_5] (rows=36524 width=1119)
+                                              Select Operator [SEL_5] (rows=8116 width=1119)
                                                 Output:["_col0","_col1"]
-                                                Filter Operator [FIL_97] (rows=36524 width=1119)
+                                                Filter Operator [FIL_97] (rows=8116 width=1119)
                                                   predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                                   TableScan [TS_3] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query90.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query90.q.out b/ql/src/test/results/clientpositive/perf/query90.q.out
index 09a934d..92eeba1 100644
--- a/ql/src/test/results/clientpositive/perf/query90.q.out
+++ b/ql/src/test/results/clientpositive/perf/query90.q.out
@@ -60,9 +60,9 @@ Stage-0
                               <-Map 17 [SIMPLE_EDGE]
                                 SHUFFLE [RS_42]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_34] (rows=43200 width=471)
+                                  Select Operator [SEL_34] (rows=9600 width=471)
                                     Output:["_col0"]
-                                    Filter Operator [FIL_84] (rows=43200 width=471)
+                                    Filter Operator [FIL_84] (rows=9600 width=471)
                                       predicate:(t_hour BETWEEN 14 AND 15 and t_time_sk is not null)
                                       TableScan [TS_32] (rows=86400 width=471)
                                         default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_hour"]
@@ -83,9 +83,9 @@ Stage-0
                                   <-Map 16 [SIMPLE_EDGE]
                                     SHUFFLE [RS_39]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_31] (rows=2301 width=585)
+                                      Select Operator [SEL_31] (rows=511 width=585)
                                         Output:["_col0"]
-                                        Filter Operator [FIL_83] (rows=2301 width=585)
+                                        Filter Operator [FIL_83] (rows=511 width=585)
                                           predicate:(wp_char_count BETWEEN 5000 AND 5200 and wp_web_page_sk is not null)
                                           TableScan [TS_29] (rows=4602 width=585)
                                             default@web_page,web_page,Tbl:COMPLETE,Col:NONE,Output:["wp_web_page_sk","wp_char_count"]
@@ -116,9 +116,9 @@ Stage-0
                               <-Map 9 [SIMPLE_EDGE]
                                 SHUFFLE [RS_16]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_8] (rows=43200 width=471)
+                                  Select Operator [SEL_8] (rows=9600 width=471)
                                     Output:["_col0"]
-                                    Filter Operator [FIL_80] (rows=43200 width=471)
+                                    Filter Operator [FIL_80] (rows=9600 width=471)
                                       predicate:(t_hour BETWEEN 6 AND 7 and t_time_sk is not null)
                                       TableScan [TS_6] (rows=86400 width=471)
                                         default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_hour"]
@@ -139,9 +139,9 @@ Stage-0
                                   <-Map 8 [SIMPLE_EDGE]
                                     SHUFFLE [RS_13]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_5] (rows=2301 width=585)
+                                      Select Operator [SEL_5] (rows=511 width=585)
                                         Output:["_col0"]
-                                        Filter Operator [FIL_79] (rows=2301 width=585)
+                                        Filter Operator [FIL_79] (rows=511 width=585)
                                           predicate:(wp_char_count BETWEEN 5000 AND 5200 and wp_web_page_sk is not null)
                                           TableScan [TS_3] (rows=4602 width=585)
                                             default@web_page,web_page,Tbl:COMPLETE,Col:NONE,Output:["wp_web_page_sk","wp_char_count"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query94.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query94.q.out b/ql/src/test/results/clientpositive/perf/query94.q.out
index 59b1a3e..836b16b 100644
--- a/ql/src/test/results/clientpositive/perf/query94.q.out
+++ b/ql/src/test/results/clientpositive/perf/query94.q.out
@@ -78,9 +78,9 @@ Stage-0
                                 <-Map 11 [SIMPLE_EDGE]
                                   SHUFFLE [RS_32]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_16] (rows=36524 width=1119)
+                                    Select Operator [SEL_16] (rows=8116 width=1119)
                                       Output:["_col0"]
-                                      Filter Operator [FIL_76] (rows=36524 width=1119)
+                                      Filter Operator [FIL_76] (rows=8116 width=1119)
                                         predicate:(d_date BETWEEN '1999-05-01' AND '1999-07-01' and d_date_sk is not null)
                                         TableScan [TS_14] (rows=73049 width=1119)
                                           default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query95.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query95.q.out b/ql/src/test/results/clientpositive/perf/query95.q.out
index f934704..9b0d1b2 100644
--- a/ql/src/test/results/clientpositive/perf/query95.q.out
+++ b/ql/src/test/results/clientpositive/perf/query95.q.out
@@ -59,9 +59,9 @@ Stage-0
                       <-Map 15 [SIMPLE_EDGE]
                         SHUFFLE [RS_50]
                           PartitionCols:_col0
-                          Select Operator [SEL_34] (rows=36524 width=1119)
+                          Select Operator [SEL_34] (rows=8116 width=1119)
                             Output:["_col0"]
-                            Filter Operator [FIL_113] (rows=36524 width=1119)
+                            Filter Operator [FIL_113] (rows=8116 width=1119)
                               predicate:(d_date BETWEEN '2002-05-01' AND '2002-06-30' and d_date_sk is not null)
                               TableScan [TS_32] (rows=73049 width=1119)
                                 default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query97.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query97.q.out b/ql/src/test/results/clientpositive/perf/query97.q.out
index 9fa10da..c885e99 100644
--- a/ql/src/test/results/clientpositive/perf/query97.q.out
+++ b/ql/src/test/results/clientpositive/perf/query97.q.out
@@ -56,9 +56,9 @@ Stage-0
                               <-Map 6 [SIMPLE_EDGE]
                                 SHUFFLE [RS_7]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_5] (rows=36524 width=1119)
+                                  Select Operator [SEL_5] (rows=8116 width=1119)
                                     Output:["_col0"]
-                                    Filter Operator [FIL_44] (rows=36524 width=1119)
+                                    Filter Operator [FIL_44] (rows=8116 width=1119)
                                       predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                       TableScan [TS_3] (rows=73049 width=1119)
                                         default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]
@@ -77,9 +77,9 @@ Stage-0
                             <-Map 10 [SIMPLE_EDGE]
                               SHUFFLE [RS_21]
                                 PartitionCols:_col0
-                                Select Operator [SEL_19] (rows=36524 width=1119)
+                                Select Operator [SEL_19] (rows=8116 width=1119)
                                   Output:["_col0"]
-                                  Filter Operator [FIL_46] (rows=36524 width=1119)
+                                  Filter Operator [FIL_46] (rows=8116 width=1119)
                                     predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null)
                                     TableScan [TS_17] (rows=73049 width=1119)
                                       default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/perf/query98.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query98.q.out b/ql/src/test/results/clientpositive/perf/query98.q.out
index 1cc860a..35cc897 100644
--- a/ql/src/test/results/clientpositive/perf/query98.q.out
+++ b/ql/src/test/results/clientpositive/perf/query98.q.out
@@ -69,9 +69,9 @@ Stage-0
                                   <-Map 7 [SIMPLE_EDGE]
                                     SHUFFLE [RS_10]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_5] (rows=36524 width=1119)
+                                      Select Operator [SEL_5] (rows=8116 width=1119)
                                         Output:["_col0"]
-                                        Filter Operator [FIL_34] (rows=36524 width=1119)
+                                        Filter Operator [FIL_34] (rows=8116 width=1119)
                                           predicate:(d_date BETWEEN 2001-01-12 AND 2001-02-11 and d_date_sk is not null)
                                           TableScan [TS_3] (rows=73049 width=1119)
                                             default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_between_in.q.out b/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
index fbb43c4..500f69c 100644
--- a/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
@@ -254,15 +254,15 @@ STAGE PLANS:
                   Statistics: Num rows: 12288 Data size: 2467616 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: cdate BETWEEN 1969-12-30 AND 1970-01-02 (type: boolean)
-                    Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: cdate (type: date)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: date)
                         sort order: +
-                        Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
             Execution mode: vectorized
         Reducer 2 
             Execution mode: vectorized
@@ -270,10 +270,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: date)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -307,15 +307,15 @@ STAGE PLANS:
                   Statistics: Num rows: 12288 Data size: 2467616 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: cdate NOT BETWEEN 1968-05-01 AND 1971-09-01 (type: boolean)
-                    Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: cdate (type: date)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: date)
                         sort order: +
-                        Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
             Execution mode: vectorized
         Reducer 2 
             Execution mode: vectorized
@@ -323,10 +323,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: date)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -360,15 +360,15 @@ STAGE PLANS:
                   Statistics: Num rows: 12288 Data size: 2467616 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: cdecimal1 BETWEEN -20 AND 45.9918918919 (type: boolean)
-                    Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: cdecimal1 (type: decimal(20,10))
                       outputColumnNames: _col0
-                      Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: decimal(20,10))
                         sort order: +
-                        Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
             Execution mode: vectorized
         Reducer 2 
             Execution mode: vectorized
@@ -376,10 +376,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: decimal(20,10))
                 outputColumnNames: _col0
-                Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1365 Data size: 274112 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -413,9 +413,9 @@ STAGE PLANS:
                   Statistics: Num rows: 12288 Data size: 2467616 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 (type: boolean)
-                    Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
-                      Statistics: Num rows: 6144 Data size: 1233808 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10923 Data size: 2193503 Basic stats: COMPLETE Column stats: NONE
                       Group By Operator
                         aggregations: count()
                         mode: hash

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
index 9a3d59f..3249525 100644
--- a/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
@@ -46,27 +46,27 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_12]
-        Select Operator [SEL_11] (rows=9759/10 width=620)
+        Select Operator [SEL_11] (rows=2166/10 width=620)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
         <-Reducer 2 [SIMPLE_EDGE]
           SHUFFLE [RS_10]
-            Merge Join Operator [MERGEJOIN_17] (rows=9759/10 width=620)
+            Merge Join Operator [MERGEJOIN_17] (rows=2166/10 width=620)
               Conds:RS_6._col2=RS_7._col2(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
             <-Map 1 [SIMPLE_EDGE]
               SHUFFLE [RS_6]
                 PartitionCols:_col2
-                Select Operator [SEL_2] (rows=6144/10 width=251)
+                Select Operator [SEL_2] (rows=1365/10 width=251)
                   Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-                  Filter Operator [FIL_15] (rows=6144/10 width=251)
+                  Filter Operator [FIL_15] (rows=1365/10 width=251)
                     predicate:cint BETWEEN 1000000 AND 3000000
                     TableScan [TS_0] (rows=12288/12288 width=251)
                       default@alltypesorc,a,Tbl:COMPLETE,Col:COMPLETE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
             <-Map 4 [SIMPLE_EDGE]
               SHUFFLE [RS_7]
                 PartitionCols:_col2
-                Select Operator [SEL_5] (rows=4586/10 width=251)
+                Select Operator [SEL_5] (rows=1019/10 width=251)
                   Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-                  Filter Operator [FIL_16] (rows=4586/10 width=251)
+                  Filter Operator [FIL_16] (rows=1019/10 width=251)
                     predicate:(cint BETWEEN 1000000 AND 3000000 and cbigint is not null)
                     TableScan [TS_3] (rows=12288/12288 width=251)
                       default@alltypesorc,b,Tbl:COMPLETE,Col:COMPLETE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
@@ -147,23 +147,23 @@ Stage-0
           SHUFFLE [RS_11]
             Group By Operator [GBY_10] (rows=1/1 width=8)
               Output:["_col0"],aggregations:["count()"]
-              Merge Join Operator [MERGEJOIN_19] (rows=9759/10 width=8)
+              Merge Join Operator [MERGEJOIN_19] (rows=2166/10 width=8)
                 Conds:RS_6._col0=RS_7._col0(Inner)
               <-Map 1 [SIMPLE_EDGE]
                 SHUFFLE [RS_6]
                   PartitionCols:_col0
-                  Select Operator [SEL_2] (rows=6144/10 width=2)
+                  Select Operator [SEL_2] (rows=1365/10 width=2)
                     Output:["_col0"]
-                    Filter Operator [FIL_17] (rows=6144/10 width=2)
+                    Filter Operator [FIL_17] (rows=1365/10 width=2)
                       predicate:cint BETWEEN 1000000 AND 3000000
                       TableScan [TS_0] (rows=12288/12288 width=2)
                         default@alltypesorc,a,Tbl:COMPLETE,Col:COMPLETE,Output:["cint"]
               <-Map 4 [SIMPLE_EDGE]
                 SHUFFLE [RS_7]
                   PartitionCols:_col0
-                  Select Operator [SEL_5] (rows=4586/10 width=8)
+                  Select Operator [SEL_5] (rows=1019/10 width=8)
                     Output:["_col0"]
-                    Filter Operator [FIL_18] (rows=4586/10 width=8)
+                    Filter Operator [FIL_18] (rows=1019/10 width=8)
                       predicate:(cint BETWEEN 1000000 AND 3000000 and cbigint is not null)
                       TableScan [TS_3] (rows=12288/12288 width=8)
                         default@alltypesorc,b,Tbl:COMPLETE,Col:COMPLETE,Output:["cint","cbigint"]
@@ -236,34 +236,34 @@ Stage-0
     Stage-1
       Reducer 4
       File Output Operator [FS_16]
-        Select Operator [SEL_15] (rows=2765/5 width=12)
+        Select Operator [SEL_15] (rows=615/5 width=12)
           Output:["_col0","_col1"]
         <-Reducer 3 [SIMPLE_EDGE]
           SHUFFLE [RS_14]
-            Group By Operator [GBY_12] (rows=2765/5 width=12)
+            Group By Operator [GBY_12] (rows=615/5 width=12)
               Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
             <-Reducer 2 [SIMPLE_EDGE]
               SHUFFLE [RS_11]
                 PartitionCols:_col0
-                Group By Operator [GBY_10] (rows=2765/5 width=12)
+                Group By Operator [GBY_10] (rows=615/5 width=12)
                   Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
-                  Merge Join Operator [MERGEJOIN_21] (rows=9759/10 width=4)
+                  Merge Join Operator [MERGEJOIN_21] (rows=2166/10 width=4)
                     Conds:RS_6._col1=RS_7._col0(Inner),Output:["_col0"]
                   <-Map 1 [SIMPLE_EDGE]
                     SHUFFLE [RS_6]
                       PartitionCols:_col1
-                      Select Operator [SEL_2] (rows=6144/10 width=5)
+                      Select Operator [SEL_2] (rows=1365/10 width=5)
                         Output:["_col0","_col1"]
-                        Filter Operator [FIL_19] (rows=6144/10 width=5)
+                        Filter Operator [FIL_19] (rows=1365/10 width=5)
                           predicate:cint BETWEEN 1000000 AND 3000000
                           TableScan [TS_0] (rows=12288/12288 width=5)
                             default@alltypesorc,a,Tbl:COMPLETE,Col:COMPLETE,Output:["csmallint","cint"]
                   <-Map 5 [SIMPLE_EDGE]
                     SHUFFLE [RS_7]
                       PartitionCols:_col0
-                      Select Operator [SEL_5] (rows=4586/10 width=8)
+                      Select Operator [SEL_5] (rows=1019/10 width=8)
                         Output:["_col0"]
-                        Filter Operator [FIL_20] (rows=4586/10 width=8)
+                        Filter Operator [FIL_20] (rows=1019/10 width=8)
                           predicate:(cint BETWEEN 1000000 AND 3000000 and cbigint is not null)
                           TableScan [TS_3] (rows=12288/12288 width=8)
                             default@alltypesorc,b,Tbl:COMPLETE,Col:COMPLETE,Output:["cint","cbigint"]
@@ -341,27 +341,27 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_12]
-        Select Operator [SEL_11] (rows=6758/10 width=215)
+        Select Operator [SEL_11] (rows=1501/10 width=215)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
         <-Reducer 2 [SIMPLE_EDGE]
           SHUFFLE [RS_10]
-            Map Join Operator [MAPJOIN_17] (rows=6758/10 width=215)
+            Map Join Operator [MAPJOIN_17] (rows=1501/10 width=215)
               Conds:RS_6.KEY.reducesinkkey0=RS_7.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true,Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
             <-Map 4 [CUSTOM_SIMPLE_EDGE]
               PARTITION_ONLY_SHUFFLE [RS_7]
                 PartitionCols:_col2
-                Select Operator [SEL_5] (rows=6144/10 width=215)
+                Select Operator [SEL_5] (rows=1365/10 width=215)
                   Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-                  Filter Operator [FIL_16] (rows=6144/10 width=215)
+                  Filter Operator [FIL_16] (rows=1365/10 width=215)
                     predicate:(cint BETWEEN 1000000 AND 3000000 and cbigint is not null)
                     TableScan [TS_3] (rows=12288/12288 width=215)
                       default@alltypesorc,b,Tbl:COMPLETE,Col:NONE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
             <-Map 1 [CUSTOM_SIMPLE_EDGE]
               PARTITION_ONLY_SHUFFLE [RS_6]
                 PartitionCols:_col2
-                Select Operator [SEL_2] (rows=6144/10 width=215)
+                Select Operator [SEL_2] (rows=1365/10 width=215)
                   Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-                  Filter Operator [FIL_15] (rows=6144/10 width=215)
+                  Filter Operator [FIL_15] (rows=1365/10 width=215)
                     predicate:cint BETWEEN 1000000 AND 3000000
                     TableScan [TS_0] (rows=12288/12288 width=215)
                       default@alltypesorc,a,Tbl:COMPLETE,Col:NONE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
@@ -440,25 +440,25 @@ Stage-0
           Output:["_col0"],aggregations:["count(VALUE._col0)"]
         <-Reducer 2 [SIMPLE_EDGE]
           SHUFFLE [RS_11]
-            Group By Operator [GBY_10] (rows=1/14 width=8)
+            Group By Operator [GBY_10] (rows=1/3 width=8)
               Output:["_col0"],aggregations:["count()"]
-              Map Join Operator [MAPJOIN_19] (rows=6758/10 width=215)
+              Map Join Operator [MAPJOIN_19] (rows=1501/10 width=215)
                 Conds:RS_6.KEY.reducesinkkey0=RS_7.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true
               <-Map 4 [CUSTOM_SIMPLE_EDGE]
                 PARTITION_ONLY_SHUFFLE [RS_7]
                   PartitionCols:_col0
-                  Select Operator [SEL_5] (rows=6144/10 width=215)
+                  Select Operator [SEL_5] (rows=1365/10 width=215)
                     Output:["_col0"]
-                    Filter Operator [FIL_18] (rows=6144/10 width=215)
+                    Filter Operator [FIL_18] (rows=1365/10 width=215)
                       predicate:(cint BETWEEN 1000000 AND 3000000 and cbigint is not null)
                       TableScan [TS_3] (rows=12288/12288 width=215)
                         default@alltypesorc,b,Tbl:COMPLETE,Col:NONE,Output:["cint","cbigint"]
               <-Map 1 [CUSTOM_SIMPLE_EDGE]
                 PARTITION_ONLY_SHUFFLE [RS_6]
                   PartitionCols:_col0
-                  Select Operator [SEL_2] (rows=6144/10 width=215)
+                  Select Operator [SEL_2] (rows=1365/10 width=215)
                     Output:["_col0"]
-                    Filter Operator [FIL_17] (rows=6144/10 width=215)
+                    Filter Operator [FIL_17] (rows=1365/10 width=215)
                       predicate:cint BETWEEN 1000000 AND 3000000
                       TableScan [TS_0] (rows=12288/12288 width=215)
                         default@alltypesorc,a,Tbl:COMPLETE,Col:NONE,Output:["cint"]
@@ -531,34 +531,34 @@ Stage-0
     Stage-1
       Reducer 4
       File Output Operator [FS_16]
-        Select Operator [SEL_15] (rows=3379/5 width=215)
+        Select Operator [SEL_15] (rows=750/5 width=215)
           Output:["_col0","_col1"]
         <-Reducer 3 [SIMPLE_EDGE]
           SHUFFLE [RS_14]
-            Group By Operator [GBY_12] (rows=3379/5 width=215)
+            Group By Operator [GBY_12] (rows=750/5 width=215)
               Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
             <-Reducer 2 [SIMPLE_EDGE]
               SHUFFLE [RS_11]
                 PartitionCols:_col0
-                Group By Operator [GBY_10] (rows=6758/9 width=215)
+                Group By Operator [GBY_10] (rows=1501/7 width=215)
                   Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
-                  Map Join Operator [MAPJOIN_21] (rows=6758/10 width=215)
+                  Map Join Operator [MAPJOIN_21] (rows=1501/10 width=215)
                     Conds:RS_6.KEY.reducesinkkey0=RS_7.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true,Output:["_col0"]
                   <-Map 5 [CUSTOM_SIMPLE_EDGE]
                     PARTITION_ONLY_SHUFFLE [RS_7]
                       PartitionCols:_col0
-                      Select Operator [SEL_5] (rows=6144/10 width=215)
+                      Select Operator [SEL_5] (rows=1365/10 width=215)
                         Output:["_col0"]
-                        Filter Operator [FIL_20] (rows=6144/10 width=215)
+                        Filter Operator [FIL_20] (rows=1365/10 width=215)
                           predicate:(cint BETWEEN 1000000 AND 3000000 and cbigint is not null)
                           TableScan [TS_3] (rows=12288/12288 width=215)
                             default@alltypesorc,b,Tbl:COMPLETE,Col:NONE,Output:["cint","cbigint"]
                   <-Map 1 [CUSTOM_SIMPLE_EDGE]
                     PARTITION_ONLY_SHUFFLE [RS_6]
                       PartitionCols:_col1
-                      Select Operator [SEL_2] (rows=6144/10 width=215)
+                      Select Operator [SEL_2] (rows=1365/10 width=215)
                         Output:["_col0","_col1"]
-                        Filter Operator [FIL_19] (rows=6144/10 width=215)
+                        Filter Operator [FIL_19] (rows=1365/10 width=215)
                           predicate:cint BETWEEN 1000000 AND 3000000
                           TableScan [TS_0] (rows=12288/12288 width=215)
                             default@alltypesorc,a,Tbl:COMPLETE,Col:NONE,Output:["csmallint","cint"]
@@ -583,8 +583,8 @@ order by c1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
+-13036	1
 -8915	1
 -3799	1
 10782	1
--13036	1
 NULL	6

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/udf_between.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_between.q.out b/ql/src/test/results/clientpositive/udf_between.q.out
index efe6615..bd9b4bb 100644
--- a/ql/src/test/results/clientpositive/udf_between.q.out
+++ b/ql/src/test/results/clientpositive/udf_between.q.out
@@ -25,11 +25,11 @@ STAGE PLANS:
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
           Filter Operator
             predicate: (UDFToDouble(key) + 100.0) BETWEEN 100 AND 200 (type: boolean)
-            Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: key (type: string), value (type: string)
               outputColumnNames: _col0, _col1
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
               Limit
                 Number of rows: 20
                 Statistics: Num rows: 20 Data size: 200 Basic stats: COMPLETE Column stats: NONE
@@ -80,11 +80,11 @@ STAGE PLANS:
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
           Filter Operator
             predicate: (UDFToDouble(key) + 100.0) NOT BETWEEN 100 AND 200 (type: boolean)
-            Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 445 Data size: 4727 Basic stats: COMPLETE Column stats: NONE
             Select Operator
               expressions: key (type: string), value (type: string)
               outputColumnNames: _col0, _col1
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 445 Data size: 4727 Basic stats: COMPLETE Column stats: NONE
               Limit
                 Number of rows: 20
                 Statistics: Num rows: 20 Data size: 200 Basic stats: COMPLETE Column stats: NONE

http://git-wip-us.apache.org/repos/asf/hive/blob/e2653db3/ql/src/test/results/clientpositive/vector_between_columns.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_between_columns.q.out b/ql/src/test/results/clientpositive/vector_between_columns.q.out
index 0b9401d..1366e31 100644
--- a/ql/src/test/results/clientpositive/vector_between_columns.q.out
+++ b/ql/src/test/results/clientpositive/vector_between_columns.q.out
@@ -232,14 +232,14 @@ STAGE PLANS:
                 Statistics: Num rows: 25 Data size: 385 Basic stats: COMPLETE Column stats: NONE
                 Filter Operator
                   predicate: _col1 BETWEEN _col3 AND _col3 (type: boolean)
-                  Statistics: Num rows: 12 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: _col0 (type: int), _col2 (type: int), _col1 (type: int), _col3 (type: smallint)
                     outputColumnNames: _col0, _col1, _col2, _col3
-                    Statistics: Num rows: 12 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 12 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat


Mime
View raw message