hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [15/51] [partial] hive git commit: HIVE-20850: Push case conditional from projections to dimension tables if possible (Zoltan Haindrich via Jesus Camacho Rodriguez)
Date Mon, 12 Nov 2018 18:04:35 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query17.q.out b/ql/src/test/results/clientpositive/perf/tez/query17.q.out
index bb18527..642a67f 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query17.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query17.q.out
@@ -147,7 +147,7 @@ Stage-0
                         Select Operator [SEL_47] (rows=8581091759 width=381)
                           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
                           Merge Join Operator [MERGEJOIN_213] (rows=8581091759 width=381)
-                            Conds:RS_44._col3=RS_257._col0(Inner),Output:["_col5","_col9","_col10","_col14","_col21","_col25"]
+                            Conds:RS_44._col3=RS_257._col0(Inner),Output:["_col5","_col8","_col9","_col13","_col19","_col22"]
                           <-Map 21 [SIMPLE_EDGE] vectorized
                             SHUFFLE [RS_257]
                               PartitionCols:_col0
@@ -161,12 +161,12 @@ Stage-0
                             SHUFFLE [RS_44]
                               PartitionCols:_col3
                               Merge Join Operator [MERGEJOIN_212] (rows=8581091759 width=299)
-                                Conds:RS_41._col1, _col2, _col4=RS_42._col7, _col8, _col9(Inner),Output:["_col3","_col5","_col9","_col10","_col14","_col21"]
+                                Conds:RS_41._col1, _col2, _col4=RS_42._col6, _col7, _col8(Inner),Output:["_col3","_col5","_col8","_col9","_col13","_col19"]
                               <-Reducer 11 [SIMPLE_EDGE]
                                 SHUFFLE [RS_42]
-                                  PartitionCols:_col7, _col8, _col9
+                                  PartitionCols:_col6, _col7, _col8
                                   Merge Join Operator [MERGEJOIN_211] (rows=1640229377 width=19)
-                                    Conds:RS_28._col2, _col1=RS_29._col1, _col2(Inner),Output:["_col3","_col7","_col8","_col9","_col10"]
+                                    Conds:RS_28._col2, _col1=RS_29._col1, _col2(Inner),Output:["_col3","_col6","_col7","_col8","_col9"]
                                   <-Reducer 10 [SIMPLE_EDGE]
                                     PARTITION_ONLY_SHUFFLE [RS_28]
                                       PartitionCols:_col2, _col1
@@ -175,7 +175,7 @@ Stage-0
                                       <-Map 8 [SIMPLE_EDGE] vectorized
                                         PARTITION_ONLY_SHUFFLE [RS_222]
                                           PartitionCols:_col0
-                                          Select Operator [SEL_218] (rows=304 width=94)
+                                          Select Operator [SEL_218] (rows=304 width=4)
                                             Output:["_col0"]
                                             Filter Operator [FIL_215] (rows=304 width=94)
                                               predicate:((d_quarter_name) IN ('2000Q1', '2000Q2', '2000Q3') and d_date_sk is not null)
@@ -205,7 +205,7 @@ Stage-0
                                                           <-Map 8 [SIMPLE_EDGE] vectorized
                                                             PARTITION_ONLY_SHUFFLE [RS_224]
                                                               PartitionCols:_col0
-                                                              Select Operator [SEL_219] (rows=304 width=94)
+                                                              Select Operator [SEL_219] (rows=304 width=4)
                                                                 Output:["_col0"]
                                                                 Filter Operator [FIL_216] (rows=304 width=94)
                                                                   predicate:((d_quarter_name) IN ('2000Q1', '2000Q2', '2000Q3') and d_date_sk is not null)
@@ -249,7 +249,7 @@ Stage-0
                                 SHUFFLE [RS_41]
                                   PartitionCols:_col1, _col2, _col4
                                   Merge Join Operator [MERGEJOIN_208] (rows=27749405 width=294)
-                                    Conds:RS_38._col1=RS_254._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col9","_col10"]
+                                    Conds:RS_38._col1=RS_254._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col8","_col9"]
                                   <-Map 18 [SIMPLE_EDGE] vectorized
                                     SHUFFLE [RS_254]
                                       PartitionCols:_col0
@@ -267,7 +267,7 @@ Stage-0
                                       <-Map 8 [SIMPLE_EDGE] vectorized
                                         PARTITION_ONLY_SHUFFLE [RS_220]
                                           PartitionCols:_col0
-                                          Select Operator [SEL_217] (rows=101 width=94)
+                                          Select Operator [SEL_217] (rows=101 width=4)
                                             Output:["_col0"]
                                             Filter Operator [FIL_214] (rows=101 width=94)
                                               predicate:((d_quarter_name = '2000Q1') and d_date_sk is not null)

http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query18.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query18.q.out b/ql/src/test/results/clientpositive/perf/tez/query18.q.out
index 58fb7a7..f51e75b 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query18.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query18.q.out
@@ -99,147 +99,145 @@ Stage-0
     limit:100
     Stage-1
       Reducer 6 vectorized
-      File Output Operator [FS_182]
-        Limit [LIM_181] (rows=100 width=1165)
+      File Output Operator [FS_181]
+        Limit [LIM_180] (rows=100 width=1165)
           Number of rows:100
-          Select Operator [SEL_180] (rows=10969055 width=1165)
+          Select Operator [SEL_179] (rows=10969055 width=1165)
             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10"]
           <-Reducer 5 [SIMPLE_EDGE] vectorized
-            SHUFFLE [RS_179]
-              Select Operator [SEL_178] (rows=10969055 width=1165)
+            SHUFFLE [RS_178]
+              Select Operator [SEL_177] (rows=10969055 width=1165)
                 Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10"]
-                Group By Operator [GBY_177] (rows=10969055 width=1229)
+                Group By Operator [GBY_176] (rows=10969055 width=1229)
                   Output:["_col0","_col1","_col2","_col3","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)","sum(VALUE._col2)","count(VALUE._col3)","sum(VALUE._col4)","count(VALUE._col5)","sum(VALUE._col6)","count(VALUE._col7)","sum(VALUE._col8)","count(VALUE._col9)","sum(VALUE._col10)","count(VALUE._col11)","sum(VALUE._col12)","count(VALUE._col13)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
                 <-Reducer 4 [SIMPLE_EDGE]
-                  SHUFFLE [RS_43]
+                  SHUFFLE [RS_42]
                     PartitionCols:_col0, _col1, _col2, _col3, _col4
-                    Group By Operator [GBY_42] (rows=10969055 width=1229)
-                      Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18"],aggregations:["sum(_col4)","count(_col4)","sum(_col5)","count(_col5)","sum(_col6)","count(_col6)","sum(_col7)","count(_col7)","sum(_col8)","count(_col8)","sum(_col9)","count(_col9)","sum(_col10)","count(_col10)"],keys:_col0, _col1, _col2, _col3, 0L
-                      Select Operator [SEL_40] (rows=2193811 width=618)
-                        Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10"]
-                        Merge Join Operator [MERGEJOIN_143] (rows=2193811 width=618)
-                          Conds:RS_37._col0=RS_38._col3(Inner),Output:["_col4","_col6","_col7","_col8","_col11","_col16","_col17","_col18","_col19","_col20","_col26"]
-                        <-Reducer 3 [SIMPLE_EDGE]
-                          PARTITION_ONLY_SHUFFLE [RS_37]
-                            PartitionCols:_col0
-                            Merge Join Operator [MERGEJOIN_139] (rows=4959744 width=287)
-                              Conds:RS_34._col1=RS_152._col0(Inner),Output:["_col0","_col4","_col6","_col7","_col8"]
-                            <-Map 9 [SIMPLE_EDGE] vectorized
-                              SHUFFLE [RS_152]
+                    Group By Operator [GBY_41] (rows=10969055 width=1229)
+                      Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18"],aggregations:["sum(_col15)","count(_col15)","sum(_col16)","count(_col16)","sum(_col17)","count(_col17)","sum(_col18)","count(_col18)","sum(_col19)","count(_col19)","sum(_col3)","count(_col3)","sum(_col22)","count(_col22)"],keys:_col5, _col6, _col7, _col10, 0L
+                      Merge Join Operator [MERGEJOIN_142] (rows=2193811 width=811)
+                        Conds:RS_37._col0=RS_38._col3(Inner),Output:["_col3","_col5","_col6","_col7","_col10","_col15","_col16","_col17","_col18","_col19","_col22"]
+                      <-Reducer 3 [SIMPLE_EDGE]
+                        PARTITION_ONLY_SHUFFLE [RS_37]
+                          PartitionCols:_col0
+                          Merge Join Operator [MERGEJOIN_138] (rows=4959744 width=368)
+                            Conds:RS_34._col1=RS_151._col0(Inner),Output:["_col0","_col3","_col5","_col6","_col7"]
+                          <-Map 9 [SIMPLE_EDGE] vectorized
+                            SHUFFLE [RS_151]
+                              PartitionCols:_col0
+                              Select Operator [SEL_150] (rows=1861800 width=4)
+                                Output:["_col0"]
+                                Filter Operator [FIL_149] (rows=1861800 width=4)
+                                  predicate:cd_demo_sk is not null
+                                  TableScan [TS_6] (rows=1861800 width=4)
+                                    default@customer_demographics,cd2,Tbl:COMPLETE,Col:COMPLETE,Output:["cd_demo_sk"]
+                          <-Reducer 2 [SIMPLE_EDGE]
+                            SHUFFLE [RS_34]
+                              PartitionCols:_col1
+                              Merge Join Operator [MERGEJOIN_137] (rows=4890586 width=371)
+                                Conds:RS_145._col2=RS_148._col0(Inner),Output:["_col0","_col1","_col3","_col5","_col6","_col7"]
+                              <-Map 1 [SIMPLE_EDGE] vectorized
+                                SHUFFLE [RS_145]
+                                  PartitionCols:_col2
+                                  Select Operator [SEL_144] (rows=35631408 width=119)
+                                    Output:["_col0","_col1","_col2","_col3"]
+                                    Filter Operator [FIL_143] (rows=35631408 width=19)
+                                      predicate:((c_birth_month) IN (9, 5, 12, 4, 1, 10) and c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_customer_sk is not null)
+                                      TableScan [TS_0] (rows=80000000 width=19)
+                                        default@customer,customer,Tbl:COMPLETE,Col:COMPLETE,Output:["c_customer_sk","c_current_cdemo_sk","c_current_addr_sk","c_birth_month","c_birth_year"]
+                              <-Map 8 [SIMPLE_EDGE] vectorized
+                                SHUFFLE [RS_148]
+                                  PartitionCols:_col0
+                                  Select Operator [SEL_147] (rows=5490196 width=285)
+                                    Output:["_col0","_col1","_col2","_col3"]
+                                    Filter Operator [FIL_146] (rows=5490196 width=285)
+                                      predicate:((ca_state) IN ('ND', 'WI', 'AL', 'NC', 'OK', 'MS', 'TN') and ca_address_sk is not null)
+                                      TableScan [TS_3] (rows=40000000 width=285)
+                                        default@customer_address,customer_address,Tbl:COMPLETE,Col:COMPLETE,Output:["ca_address_sk","ca_county","ca_state","ca_country"]
+                      <-Reducer 13 [SIMPLE_EDGE]
+                        SHUFFLE [RS_38]
+                          PartitionCols:_col3
+                          Select Operator [SEL_30] (rows=15983481 width=735)
+                            Output:["_col1","_col3","_col6","_col7","_col8","_col9","_col10","_col13"]
+                            Merge Join Operator [MERGEJOIN_141] (rows=15983481 width=735)
+                              Conds:RS_27._col3=RS_175._col0(Inner),Output:["_col1","_col4","_col5","_col6","_col7","_col8","_col11","_col13"]
+                            <-Map 18 [SIMPLE_EDGE] vectorized
+                              SHUFFLE [RS_175]
                                 PartitionCols:_col0
-                                Select Operator [SEL_151] (rows=1861800 width=4)
-                                  Output:["_col0"]
-                                  Filter Operator [FIL_150] (rows=1861800 width=4)
-                                    predicate:cd_demo_sk is not null
-                                    TableScan [TS_6] (rows=1861800 width=4)
-                                      default@customer_demographics,cd2,Tbl:COMPLETE,Col:COMPLETE,Output:["cd_demo_sk"]
-                            <-Reducer 2 [SIMPLE_EDGE]
-                              SHUFFLE [RS_34]
-                                PartitionCols:_col1
-                                Merge Join Operator [MERGEJOIN_138] (rows=4890586 width=290)
-                                  Conds:RS_146._col2=RS_149._col0(Inner),Output:["_col0","_col1","_col4","_col6","_col7","_col8"]
-                                <-Map 1 [SIMPLE_EDGE] vectorized
-                                  SHUFFLE [RS_146]
-                                    PartitionCols:_col2
-                                    Select Operator [SEL_145] (rows=35631408 width=19)
-                                      Output:["_col0","_col1","_col2","_col4"]
-                                      Filter Operator [FIL_144] (rows=35631408 width=19)
-                                        predicate:((c_birth_month) IN (9, 5, 12, 4, 1, 10) and c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_customer_sk is not null)
-                                        TableScan [TS_0] (rows=80000000 width=19)
-                                          default@customer,customer,Tbl:COMPLETE,Col:COMPLETE,Output:["c_customer_sk","c_current_cdemo_sk","c_current_addr_sk","c_birth_month","c_birth_year"]
-                                <-Map 8 [SIMPLE_EDGE] vectorized
-                                  SHUFFLE [RS_149]
+                                Select Operator [SEL_174] (rows=462000 width=104)
+                                  Output:["_col0","_col1"]
+                                  Filter Operator [FIL_173] (rows=462000 width=104)
+                                    predicate:i_item_sk is not null
+                                    TableScan [TS_18] (rows=462000 width=104)
+                                      default@item,item,Tbl:COMPLETE,Col:COMPLETE,Output:["i_item_sk","i_item_id"]
+                            <-Reducer 12 [SIMPLE_EDGE]
+                              SHUFFLE [RS_27]
+                                PartitionCols:_col3
+                                Merge Join Operator [MERGEJOIN_140] (rows=15983481 width=639)
+                                  Conds:RS_24._col2=RS_162._col0(Inner),Output:["_col1","_col3","_col4","_col5","_col6","_col7","_col8","_col11"]
+                                <-Map 16 [SIMPLE_EDGE] vectorized
+                                  PARTITION_ONLY_SHUFFLE [RS_162]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_148] (rows=5490196 width=285)
-                                      Output:["_col0","_col1","_col2","_col3"]
-                                      Filter Operator [FIL_147] (rows=5490196 width=285)
-                                        predicate:((ca_state) IN ('ND', 'WI', 'AL', 'NC', 'OK', 'MS', 'TN') and ca_address_sk is not null)
-                                        TableScan [TS_3] (rows=40000000 width=285)
-                                          default@customer_address,customer_address,Tbl:COMPLETE,Col:COMPLETE,Output:["ca_address_sk","ca_county","ca_state","ca_country"]
-                        <-Reducer 13 [SIMPLE_EDGE]
-                          SHUFFLE [RS_38]
-                            PartitionCols:_col3
-                            Select Operator [SEL_30] (rows=15983481 width=529)
-                              Output:["_col1","_col3","_col6","_col7","_col8","_col9","_col10","_col16"]
-                              Merge Join Operator [MERGEJOIN_142] (rows=15983481 width=529)
-                                Conds:RS_27._col3=RS_176._col0(Inner),Output:["_col1","_col4","_col5","_col6","_col7","_col8","_col14","_col16"]
-                              <-Map 18 [SIMPLE_EDGE] vectorized
-                                SHUFFLE [RS_176]
-                                  PartitionCols:_col0
-                                  Select Operator [SEL_175] (rows=462000 width=104)
-                                    Output:["_col0","_col1"]
-                                    Filter Operator [FIL_174] (rows=462000 width=104)
-                                      predicate:i_item_sk is not null
-                                      TableScan [TS_18] (rows=462000 width=104)
-                                        default@item,item,Tbl:COMPLETE,Col:COMPLETE,Output:["i_item_sk","i_item_id"]
-                              <-Reducer 12 [SIMPLE_EDGE]
-                                SHUFFLE [RS_27]
-                                  PartitionCols:_col3
-                                  Merge Join Operator [MERGEJOIN_141] (rows=15983481 width=433)
-                                    Conds:RS_24._col2=RS_163._col0(Inner),Output:["_col1","_col3","_col4","_col5","_col6","_col7","_col8","_col14"]
-                                  <-Map 16 [SIMPLE_EDGE] vectorized
-                                    PARTITION_ONLY_SHUFFLE [RS_163]
-                                      PartitionCols:_col0
-                                      Select Operator [SEL_162] (rows=103433 width=184)
-                                        Output:["_col0","_col3"]
-                                        Filter Operator [FIL_161] (rows=103433 width=187)
-                                          predicate:((cd_education_status = 'College') and (cd_gender = 'M') and cd_demo_sk is not null)
-                                          TableScan [TS_15] (rows=1861800 width=187)
-                                            default@customer_demographics,cd1,Tbl:COMPLETE,Col:COMPLETE,Output:["cd_demo_sk","cd_gender","cd_education_status","cd_dep_count"]
-                                  <-Reducer 11 [SIMPLE_EDGE]
-                                    SHUFFLE [RS_24]
-                                      PartitionCols:_col2
-                                      Merge Join Operator [MERGEJOIN_140] (rows=100578970 width=459)
-                                        Conds:RS_173._col0=RS_155._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
-                                      <-Map 14 [SIMPLE_EDGE] vectorized
-                                        PARTITION_ONLY_SHUFFLE [RS_155]
-                                          PartitionCols:_col0
-                                          Select Operator [SEL_154] (rows=652 width=8)
-                                            Output:["_col0"]
-                                            Filter Operator [FIL_153] (rows=652 width=8)
-                                              predicate:((d_year = 2001) and d_date_sk is not null)
-                                              TableScan [TS_12] (rows=73049 width=8)
-                                                default@date_dim,date_dim,Tbl:COMPLETE,Col:COMPLETE,Output:["d_date_sk","d_year"]
-                                      <-Map 10 [SIMPLE_EDGE] vectorized
-                                        SHUFFLE [RS_173]
-                                          PartitionCols:_col0
-                                          Select Operator [SEL_172] (rows=283692098 width=466)
-                                            Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
-                                            Filter Operator [FIL_171] (rows=283692098 width=466)
-                                              predicate:((cs_bill_cdemo_sk BETWEEN DynamicValue(RS_25_cd1_cd_demo_sk_min) AND DynamicValue(RS_25_cd1_cd_demo_sk_max) and in_bloom_filter(cs_bill_cdemo_sk, DynamicValue(RS_25_cd1_cd_demo_sk_bloom_filter))) and (cs_bill_customer_sk BETWEEN DynamicValue(RS_37_customer_c_customer_sk_min) AND DynamicValue(RS_37_customer_c_customer_sk_max) and in_bloom_filter(cs_bill_customer_sk, DynamicValue(RS_37_customer_c_customer_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_22_date_dim_d_date_sk_min) AND DynamicValue(RS_22_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_22_date_dim_d_date_sk_bloom_filter))) and cs_bill_cdemo_sk is not null and cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
-                                              TableScan [TS_9] (rows=287989836 width=466)
-                                                default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_bill_cdemo_sk","cs_item_sk","cs_quantity","cs_list_price","cs_sales_price","cs_coupon_amt","cs_net_profit"]
-                                              <-Reducer 15 [BROADCAST_EDGE] vectorized
-                                                BROADCAST [RS_160]
-                                                  Group By Operator [GBY_159] (rows=1 width=12)
-                                                    Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"]
-                                                  <-Map 14 [CUSTOM_SIMPLE_EDGE] vectorized
-                                                    PARTITION_ONLY_SHUFFLE [RS_158]
-                                                      Group By Operator [GBY_157] (rows=1 width=12)
-                                                        Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"]
-                                                        Select Operator [SEL_156] (rows=652 width=4)
-                                                          Output:["_col0"]
-                                                           Please refer to the previous Select Operator [SEL_154]
-                                              <-Reducer 17 [BROADCAST_EDGE] vectorized
-                                                BROADCAST [RS_168]
-                                                  Group By Operator [GBY_167] (rows=1 width=12)
-                                                    Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"]
-                                                  <-Map 16 [CUSTOM_SIMPLE_EDGE] vectorized
-                                                    PARTITION_ONLY_SHUFFLE [RS_166]
-                                                      Group By Operator [GBY_165] (rows=1 width=12)
-                                                        Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"]
-                                                        Select Operator [SEL_164] (rows=103433 width=4)
-                                                          Output:["_col0"]
-                                                           Please refer to the previous Select Operator [SEL_162]
-                                              <-Reducer 7 [BROADCAST_EDGE] vectorized
-                                                BROADCAST [RS_170]
-                                                  Group By Operator [GBY_169] (rows=1 width=12)
-                                                    Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=4890586)"]
-                                                  <-Reducer 3 [CUSTOM_SIMPLE_EDGE]
-                                                    PARTITION_ONLY_SHUFFLE [RS_120]
-                                                      Group By Operator [GBY_119] (rows=1 width=12)
-                                                        Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=4890586)"]
-                                                        Select Operator [SEL_118] (rows=4959744 width=4)
-                                                          Output:["_col0"]
-                                                           Please refer to the previous Merge Join Operator [MERGEJOIN_139]
+                                    Select Operator [SEL_161] (rows=103433 width=116)
+                                      Output:["_col0","_col1"]
+                                      Filter Operator [FIL_160] (rows=103433 width=187)
+                                        predicate:((cd_education_status = 'College') and (cd_gender = 'M') and cd_demo_sk is not null)
+                                        TableScan [TS_15] (rows=1861800 width=187)
+                                          default@customer_demographics,cd1,Tbl:COMPLETE,Col:COMPLETE,Output:["cd_demo_sk","cd_gender","cd_education_status","cd_dep_count"]
+                                <-Reducer 11 [SIMPLE_EDGE]
+                                  SHUFFLE [RS_24]
+                                    PartitionCols:_col2
+                                    Merge Join Operator [MERGEJOIN_139] (rows=100578970 width=565)
+                                      Conds:RS_172._col0=RS_154._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
+                                    <-Map 14 [SIMPLE_EDGE] vectorized
+                                      PARTITION_ONLY_SHUFFLE [RS_154]
+                                        PartitionCols:_col0
+                                        Select Operator [SEL_153] (rows=652 width=4)
+                                          Output:["_col0"]
+                                          Filter Operator [FIL_152] (rows=652 width=8)
+                                            predicate:((d_year = 2001) and d_date_sk is not null)
+                                            TableScan [TS_12] (rows=73049 width=8)
+                                              default@date_dim,date_dim,Tbl:COMPLETE,Col:COMPLETE,Output:["d_date_sk","d_year"]
+                                    <-Map 10 [SIMPLE_EDGE] vectorized
+                                      SHUFFLE [RS_172]
+                                        PartitionCols:_col0
+                                        Select Operator [SEL_171] (rows=283692098 width=573)
+                                          Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
+                                          Filter Operator [FIL_170] (rows=283692098 width=466)
+                                            predicate:((cs_bill_cdemo_sk BETWEEN DynamicValue(RS_25_cd1_cd_demo_sk_min) AND DynamicValue(RS_25_cd1_cd_demo_sk_max) and in_bloom_filter(cs_bill_cdemo_sk, DynamicValue(RS_25_cd1_cd_demo_sk_bloom_filter))) and (cs_bill_customer_sk BETWEEN DynamicValue(RS_37_customer_c_customer_sk_min) AND DynamicValue(RS_37_customer_c_customer_sk_max) and in_bloom_filter(cs_bill_customer_sk, DynamicValue(RS_37_customer_c_customer_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_22_date_dim_d_date_sk_min) AND DynamicValue(RS_22_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_22_date_dim_d_date_sk_bloom_filter))) and cs_bill_cdemo_sk is not null and cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
+                                            TableScan [TS_9] (rows=287989836 width=466)
+                                              default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_bill_cdemo_sk","cs_item_sk","cs_quantity","cs_list_price","cs_sales_price","cs_coupon_amt","cs_net_profit"]
+                                            <-Reducer 15 [BROADCAST_EDGE] vectorized
+                                              BROADCAST [RS_159]
+                                                Group By Operator [GBY_158] (rows=1 width=12)
+                                                  Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"]
+                                                <-Map 14 [CUSTOM_SIMPLE_EDGE] vectorized
+                                                  PARTITION_ONLY_SHUFFLE [RS_157]
+                                                    Group By Operator [GBY_156] (rows=1 width=12)
+                                                      Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"]
+                                                      Select Operator [SEL_155] (rows=652 width=4)
+                                                        Output:["_col0"]
+                                                         Please refer to the previous Select Operator [SEL_153]
+                                            <-Reducer 17 [BROADCAST_EDGE] vectorized
+                                              BROADCAST [RS_167]
+                                                Group By Operator [GBY_166] (rows=1 width=12)
+                                                  Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"]
+                                                <-Map 16 [CUSTOM_SIMPLE_EDGE] vectorized
+                                                  PARTITION_ONLY_SHUFFLE [RS_165]
+                                                    Group By Operator [GBY_164] (rows=1 width=12)
+                                                      Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"]
+                                                      Select Operator [SEL_163] (rows=103433 width=4)
+                                                        Output:["_col0"]
+                                                         Please refer to the previous Select Operator [SEL_161]
+                                            <-Reducer 7 [BROADCAST_EDGE] vectorized
+                                              BROADCAST [RS_169]
+                                                Group By Operator [GBY_168] (rows=1 width=12)
+                                                  Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=4890586)"]
+                                                <-Reducer 3 [CUSTOM_SIMPLE_EDGE]
+                                                  PARTITION_ONLY_SHUFFLE [RS_119]
+                                                    Group By Operator [GBY_118] (rows=1 width=12)
+                                                      Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=4890586)"]
+                                                      Select Operator [SEL_117] (rows=4959744 width=4)
+                                                        Output:["_col0"]
+                                                         Please refer to the previous Merge Join Operator [MERGEJOIN_138]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query19.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query19.q.out b/ql/src/test/results/clientpositive/perf/tez/query19.q.out
index fd8578f..ebb4d17 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query19.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query19.q.out
@@ -94,17 +94,17 @@ Stage-0
                   SHUFFLE [RS_37]
                     PartitionCols:_col0, _col1, _col2, _col3
                     Group By Operator [GBY_36] (rows=2098703 width=314)
-                      Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col8)"],keys:_col14, _col13, _col15, _col16
-                      Select Operator [SEL_35] (rows=2098703 width=380)
-                        Output:["_col8","_col13","_col14","_col15","_col16"]
-                        Filter Operator [FIL_34] (rows=2098703 width=380)
-                          predicate:(substr(_col3, 1, 5) <> substr(_col19, 1, 5))
-                          Merge Join Operator [MERGEJOIN_123] (rows=2098703 width=380)
-                            Conds:RS_31._col7=RS_151._col0(Inner),Output:["_col3","_col8","_col13","_col14","_col15","_col16","_col19"]
+                      Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col8)"],keys:_col12, _col11, _col13, _col14
+                      Select Operator [SEL_35] (rows=2098703 width=570)
+                        Output:["_col8","_col11","_col12","_col13","_col14"]
+                        Filter Operator [FIL_34] (rows=2098703 width=570)
+                          predicate:(_col3 <> _col16)
+                          Merge Join Operator [MERGEJOIN_123] (rows=2098703 width=570)
+                            Conds:RS_31._col7=RS_151._col0(Inner),Output:["_col3","_col8","_col11","_col12","_col13","_col14","_col16"]
                           <-Map 15 [SIMPLE_EDGE] vectorized
                             SHUFFLE [RS_151]
                               PartitionCols:_col0
-                              Select Operator [SEL_150] (rows=1704 width=93)
+                              Select Operator [SEL_150] (rows=1704 width=188)
                                 Output:["_col0","_col1"]
                                 Filter Operator [FIL_149] (rows=1704 width=93)
                                   predicate:s_store_sk is not null
@@ -113,17 +113,17 @@ Stage-0
                           <-Reducer 3 [SIMPLE_EDGE]
                             SHUFFLE [RS_31]
                               PartitionCols:_col7
-                              Merge Join Operator [MERGEJOIN_122] (rows=2098703 width=291)
-                                Conds:RS_28._col0=RS_29._col2(Inner),Output:["_col3","_col7","_col8","_col13","_col14","_col15","_col16"]
+                              Merge Join Operator [MERGEJOIN_122] (rows=2098703 width=386)
+                                Conds:RS_28._col0=RS_29._col2(Inner),Output:["_col3","_col7","_col8","_col11","_col12","_col13","_col14"]
                               <-Reducer 10 [SIMPLE_EDGE]
                                 SHUFFLE [RS_29]
                                   PartitionCols:_col2
                                   Merge Join Operator [MERGEJOIN_121] (rows=2098703 width=202)
-                                    Conds:RS_18._col1=RS_140._col0(Inner),Output:["_col2","_col3","_col4","_col9","_col10","_col11","_col12"]
+                                    Conds:RS_18._col1=RS_140._col0(Inner),Output:["_col2","_col3","_col4","_col7","_col8","_col9","_col10"]
                                   <-Map 13 [SIMPLE_EDGE] vectorized
                                     PARTITION_ONLY_SHUFFLE [RS_140]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_139] (rows=7333 width=210)
+                                      Select Operator [SEL_139] (rows=7333 width=206)
                                         Output:["_col0","_col1","_col2","_col3","_col4"]
                                         Filter Operator [FIL_138] (rows=7333 width=210)
                                           predicate:((i_manager_id = 7) and i_item_sk is not null)
@@ -137,7 +137,7 @@ Stage-0
                                       <-Map 11 [SIMPLE_EDGE] vectorized
                                         SHUFFLE [RS_132]
                                           PartitionCols:_col0
-                                          Select Operator [SEL_131] (rows=50 width=12)
+                                          Select Operator [SEL_131] (rows=50 width=4)
                                             Output:["_col0"]
                                             Filter Operator [FIL_130] (rows=50 width=12)
                                               predicate:((d_moy = 11) and (d_year = 1999) and d_date_sk is not null)
@@ -177,7 +177,7 @@ Stage-0
                               <-Reducer 2 [SIMPLE_EDGE]
                                 SHUFFLE [RS_28]
                                   PartitionCols:_col0
-                                  Merge Join Operator [MERGEJOIN_119] (rows=80000000 width=93)
+                                  Merge Join Operator [MERGEJOIN_119] (rows=80000000 width=188)
                                     Conds:RS_126._col1=RS_129._col0(Inner),Output:["_col0","_col3"]
                                   <-Map 1 [SIMPLE_EDGE] vectorized
                                     SHUFFLE [RS_126]
@@ -191,7 +191,7 @@ Stage-0
                                   <-Map 7 [SIMPLE_EDGE] vectorized
                                     SHUFFLE [RS_129]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_128] (rows=40000000 width=93)
+                                      Select Operator [SEL_128] (rows=40000000 width=188)
                                         Output:["_col0","_col1"]
                                         Filter Operator [FIL_127] (rows=40000000 width=93)
                                           predicate:ca_address_sk is not null

http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query2.q.out b/ql/src/test/results/clientpositive/perf/tez/query2.q.out
index f46b336..2bea1c7 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query2.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query2.q.out
@@ -149,7 +149,7 @@ Stage-0
             Select Operator [SEL_56] (rows=12881 width=788)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
               Merge Join Operator [MERGEJOIN_146] (rows=12881 width=1572)
-                Conds:RS_53._col0=RS_54.(_col0 - 53)(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col11","_col12","_col13","_col14","_col15","_col16","_col17"]
+                Conds:RS_53._col0=RS_54.(_col0 - 53)(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col10","_col11","_col12","_col13","_col14","_col15","_col16"]
               <-Reducer 5 [ONE_TO_ONE_EDGE]
                 FORWARD [RS_53]
                   PartitionCols:_col0
@@ -158,7 +158,7 @@ Stage-0
                   <-Map 11 [SIMPLE_EDGE] vectorized
                     SHUFFLE [RS_170]
                       PartitionCols:_col0
-                      Select Operator [SEL_168] (rows=652 width=8)
+                      Select Operator [SEL_168] (rows=652 width=4)
                         Output:["_col0"]
                         Filter Operator [FIL_166] (rows=652 width=8)
                           predicate:((d_year = 2001) and d_week_seq is not null)
@@ -172,17 +172,17 @@ Stage-0
                       <-Reducer 3 [SIMPLE_EDGE]
                         SHUFFLE [RS_17]
                           PartitionCols:_col0
-                          Group By Operator [GBY_16] (rows=4576896 width=788)
+                          Group By Operator [GBY_16] (rows=3182784 width=788)
                             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"],aggregations:["sum(_col1)","sum(_col2)","sum(_col3)","sum(_col4)","sum(_col5)","sum(_col6)","sum(_col7)"],keys:_col0
-                            Select Operator [SEL_14] (rows=430516591 width=206)
+                            Select Operator [SEL_14] (rows=430516591 width=143)
                               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
-                              Merge Join Operator [MERGEJOIN_142] (rows=430516591 width=206)
-                                Conds:Union 2._col0=RS_162._col0(Inner),Output:["_col1","_col3","_col4"]
+                              Merge Join Operator [MERGEJOIN_142] (rows=430516591 width=143)
+                                Conds:Union 2._col0=RS_162._col0(Inner),Output:["_col1","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10"]
                               <-Map 10 [SIMPLE_EDGE] vectorized
                                 SHUFFLE [RS_162]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_161] (rows=73049 width=99)
-                                    Output:["_col0","_col1","_col2"]
+                                  Select Operator [SEL_161] (rows=73049 width=36)
+                                    Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
                                     Filter Operator [FIL_160] (rows=73049 width=99)
                                       predicate:(d_date_sk is not null and d_week_seq is not null)
                                       TableScan [TS_8] (rows=73049 width=99)
@@ -214,7 +214,7 @@ Stage-0
                   <-Map 11 [SIMPLE_EDGE] vectorized
                     SHUFFLE [RS_171]
                       PartitionCols:_col0
-                      Select Operator [SEL_169] (rows=652 width=8)
+                      Select Operator [SEL_169] (rows=652 width=4)
                         Output:["_col0"]
                         Filter Operator [FIL_167] (rows=652 width=8)
                           predicate:((d_year = 2002) and d_week_seq is not null)

http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query20.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query20.q.out b/ql/src/test/results/clientpositive/perf/tez/query20.q.out
index 892beb3..0fa6f79 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query20.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query20.q.out
@@ -101,9 +101,9 @@ Stage-0
                         SHUFFLE [RS_17]
                           PartitionCols:_col0, _col1, _col2, _col3, _col4
                           Group By Operator [GBY_16] (rows=138600 width=689)
-                            Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)"],keys:_col10, _col9, _col6, _col7, _col8
+                            Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)"],keys:_col9, _col8, _col5, _col6, _col7
                             Merge Join Operator [MERGEJOIN_58] (rows=9551005 width=673)
-                              Conds:RS_12._col1=RS_69._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10"]
+                              Conds:RS_12._col1=RS_69._col0(Inner),Output:["_col2","_col5","_col6","_col7","_col8","_col9"]
                             <-Map 9 [SIMPLE_EDGE] vectorized
                               SHUFFLE [RS_69]
                                 PartitionCols:_col0
@@ -121,7 +121,7 @@ Stage-0
                                 <-Map 7 [SIMPLE_EDGE] vectorized
                                   PARTITION_ONLY_SHUFFLE [RS_61]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_60] (rows=8116 width=98)
+                                    Select Operator [SEL_60] (rows=8116 width=4)
                                       Output:["_col0"]
                                       Filter Operator [FIL_59] (rows=8116 width=98)
                                         predicate:(CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'2001-01-12 00:00:00' AND TIMESTAMP'2001-02-11 00:00:00' and d_date_sk is not null)

http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query21.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query21.q.out b/ql/src/test/results/clientpositive/perf/tez/query21.q.out
index be040df..382775a 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query21.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query21.q.out
@@ -96,10 +96,10 @@ Stage-0
                     PartitionCols:_col0, _col1
                     Group By Operator [GBY_23] (rows=463966 width=216)
                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(_col2)","sum(_col3)"],keys:_col0, _col1
-                      Select Operator [SEL_21] (rows=463966 width=294)
+                      Select Operator [SEL_21] (rows=463966 width=208)
                         Output:["_col0","_col1","_col2","_col3"]
-                        Merge Join Operator [MERGEJOIN_77] (rows=463966 width=294)
-                          Conds:RS_18._col2=RS_89._col0(Inner),Output:["_col3","_col5","_col7","_col10"]
+                        Merge Join Operator [MERGEJOIN_77] (rows=463966 width=208)
+                          Conds:RS_18._col2=RS_89._col0(Inner),Output:["_col3","_col5","_col6","_col8","_col10"]
                         <-Map 9 [SIMPLE_EDGE] vectorized
                           SHUFFLE [RS_89]
                             PartitionCols:_col0
@@ -112,12 +112,12 @@ Stage-0
                         <-Reducer 3 [SIMPLE_EDGE]
                           SHUFFLE [RS_18]
                             PartitionCols:_col2
-                            Merge Join Operator [MERGEJOIN_76] (rows=463966 width=198)
-                              Conds:RS_15._col1=RS_86._col0(Inner),Output:["_col2","_col3","_col5","_col7"]
+                            Merge Join Operator [MERGEJOIN_76] (rows=463966 width=112)
+                              Conds:RS_15._col1=RS_86._col0(Inner),Output:["_col2","_col3","_col5","_col6","_col8"]
                             <-Map 8 [SIMPLE_EDGE] vectorized
                               SHUFFLE [RS_86]
                                 PartitionCols:_col0
-                                Select Operator [SEL_85] (rows=51333 width=215)
+                                Select Operator [SEL_85] (rows=51333 width=104)
                                   Output:["_col0","_col1"]
                                   Filter Operator [FIL_84] (rows=51333 width=215)
                                     predicate:(i_current_price BETWEEN 0.99 AND 1.49 and i_item_sk is not null)
@@ -126,8 +126,8 @@ Stage-0
                             <-Reducer 2 [SIMPLE_EDGE]
                               SHUFFLE [RS_15]
                                 PartitionCols:_col1
-                                Merge Join Operator [MERGEJOIN_75] (rows=4175715 width=104)
-                                  Conds:RS_80._col0=RS_83._col0(Inner),Output:["_col1","_col2","_col3","_col5"]
+                                Merge Join Operator [MERGEJOIN_75] (rows=4175715 width=18)
+                                  Conds:RS_80._col0=RS_83._col0(Inner),Output:["_col1","_col2","_col3","_col5","_col6"]
                                 <-Map 1 [SIMPLE_EDGE] vectorized
                                   SHUFFLE [RS_80]
                                     PartitionCols:_col0
@@ -140,8 +140,8 @@ Stage-0
                                 <-Map 7 [SIMPLE_EDGE] vectorized
                                   SHUFFLE [RS_83]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_82] (rows=8116 width=98)
-                                      Output:["_col0","_col1"]
+                                    Select Operator [SEL_82] (rows=8116 width=12)
+                                      Output:["_col0","_col1","_col2"]
                                       Filter Operator [FIL_81] (rows=8116 width=98)
                                         predicate:(CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-09 00:00:00' AND TIMESTAMP'1998-05-08 00:00:00' and d_date_sk is not null)
                                         TableScan [TS_3] (rows=73049 width=98)

http://git-wip-us.apache.org/repos/asf/hive/blob/55887646/ql/src/test/results/clientpositive/perf/tez/query22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query22.q.out b/ql/src/test/results/clientpositive/perf/tez/query22.q.out
index df6889b..2d88d8f 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query22.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query22.q.out
@@ -79,9 +79,9 @@ Stage-0
                   SHUFFLE [RS_23]
                     PartitionCols:_col0, _col1, _col2, _col3, _col4
                     Group By Operator [GBY_22] (rows=32730675 width=413)
-                      Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col3)","count(_col3)"],keys:_col8, _col9, _col10, _col11, 0L
+                      Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col3)","count(_col3)"],keys:_col7, _col8, _col9, _col10, 0L
                       Merge Join Operator [MERGEJOIN_75] (rows=6546135 width=391)
-                        Conds:RS_18._col1=RS_87._col0(Inner),Output:["_col3","_col8","_col9","_col10","_col11"]
+                        Conds:RS_18._col1=RS_87._col0(Inner),Output:["_col3","_col7","_col8","_col9","_col10"]
                       <-Map 9 [SIMPLE_EDGE] vectorized
                         SHUFFLE [RS_87]
                           PartitionCols:_col0
@@ -122,7 +122,7 @@ Stage-0
                               <-Map 7 [SIMPLE_EDGE] vectorized
                                 SHUFFLE [RS_81]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_80] (rows=317 width=8)
+                                  Select Operator [SEL_80] (rows=317 width=4)
                                     Output:["_col0"]
                                     Filter Operator [FIL_79] (rows=317 width=8)
                                       predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223)


Mime
View raw message