hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [13/32] hive git commit: HIVE-11865: Disable Hive PPD optimizer when CBO has optimized the plan (Jesus Camacho Rodriguez, reviewed by Laljo John Pullokkaran)
Date Mon, 21 Dec 2015 01:06:54 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/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 953e61f..37cb542 100644
--- a/ql/src/test/results/clientpositive/perf/query80.q.out
+++ b/ql/src/test/results/clientpositive/perf/query80.q.out
@@ -31,435 +31,429 @@ Stage-0
       limit:100
       Stage-1
          Reducer 10
-         File Output Operator [FS_149]
+         File Output Operator [FS_125]
             compressed:false
             Statistics:Num rows: 100 Data size: 143600 Basic stats: COMPLETE Column stats: NONE
             table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
-            Limit [LIM_148]
+            Limit [LIM_124]
                Number of rows:100
                Statistics:Num rows: 100 Data size: 143600 Basic stats: COMPLETE Column stats: NONE
-               Select Operator [SEL_147]
+               Select Operator [SEL_123]
                |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                |  Statistics:Num rows: 419265 Data size: 602181139 Basic stats: COMPLETE Column stats: NONE
                |<-Reducer 9 [SIMPLE_EDGE]
-                  Reduce Output Operator [RS_146]
+                  Reduce Output Operator [RS_122]
                      key expressions:_col0 (type: string), _col1 (type: string)
                      sort order:++
                      Statistics:Num rows: 419265 Data size: 602181139 Basic stats: COMPLETE Column stats: NONE
                      value expressions:_col2 (type: decimal(27,2)), _col3 (type: decimal(32,2)), _col4 (type: decimal(33,2))
-                     Select Operator [SEL_145]
+                     Select Operator [SEL_121]
                         outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                         Statistics:Num rows: 419265 Data size: 602181139 Basic stats: COMPLETE Column stats: NONE
-                        Group By Operator [GBY_144]
+                        Group By Operator [GBY_120]
                         |  aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)"]
                         |  keys:KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)
                         |  outputColumnNames:["_col0","_col1","_col3","_col4","_col5"]
                         |  Statistics:Num rows: 419265 Data size: 602181139 Basic stats: COMPLETE Column stats: NONE
                         |<-Union 8 [SIMPLE_EDGE]
                            |<-Reducer 22 [CONTAINS]
-                           |  Reduce Output Operator [RS_143]
+                           |  Reduce Output Operator [RS_119]
                            |     key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            |     sort order:+++
                            |     Statistics:Num rows: 838530 Data size: 1204362279 Basic stats: COMPLETE Column stats: NONE
                            |     value expressions:_col3 (type: decimal(27,2)), _col4 (type: decimal(32,2)), _col5 (type: decimal(33,2))
-                           |     Group By Operator [GBY_142]
+                           |     Group By Operator [GBY_118]
                            |        aggregations:["sum(_col2)","sum(_col3)","sum(_col4)"]
                            |        keys:_col0 (type: string), _col1 (type: string), '0' (type: string)
                            |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
                            |        Statistics:Num rows: 838530 Data size: 1204362279 Basic stats: COMPLETE Column stats: NONE
-                           |        Select Operator [SEL_91]
+                           |        Select Operator [SEL_75]
                            |           outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                            |           Statistics:Num rows: 93170 Data size: 133818031 Basic stats: COMPLETE Column stats: NONE
-                           |           Group By Operator [GBY_90]
+                           |           Group By Operator [GBY_74]
                            |           |  aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)"]
                            |           |  keys:KEY._col0 (type: string)
                            |           |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |           |  Statistics:Num rows: 93170 Data size: 133818031 Basic stats: COMPLETE Column stats: NONE
                            |           |<-Reducer 21 [SIMPLE_EDGE]
-                           |              Reduce Output Operator [RS_89]
+                           |              Reduce Output Operator [RS_73]
                            |                 key expressions:_col0 (type: string)
                            |                 Map-reduce partition columns:_col0 (type: string)
                            |                 sort order:+
                            |                 Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
                            |                 value expressions:_col1 (type: decimal(17,2)), _col2 (type: decimal(22,2)), _col3 (type: decimal(23,2))
-                           |                 Group By Operator [GBY_88]
+                           |                 Group By Operator [GBY_72]
                            |                    aggregations:["sum(_col1)","sum(_col2)","sum(_col3)"]
                            |                    keys:_col0 (type: string)
                            |                    outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |                    Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
-                           |                    Select Operator [SEL_86]
+                           |                    Select Operator [SEL_70]
                            |                       outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |                       Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
-                           |                       Merge Join Operator [MERGEJOIN_234]
+                           |                       Merge Join Operator [MERGEJOIN_211]
                            |                       |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                       |  keys:{"0":"_col3 (type: int)","1":"_col0 (type: int)"}
                            |                       |  outputColumnNames:["_col5","_col6","_col9","_col10","_col14"]
                            |                       |  Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
                            |                       |<-Map 27 [SIMPLE_EDGE]
-                           |                       |  Reduce Output Operator [RS_84]
+                           |                       |  Reduce Output Operator [RS_68]
                            |                       |     key expressions:_col0 (type: int)
                            |                       |     Map-reduce partition columns:_col0 (type: int)
                            |                       |     sort order:+
                            |                       |     Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                           |                       |     Select Operator [SEL_62]
+                           |                       |     Select Operator [SEL_54]
                            |                       |        outputColumnNames:["_col0"]
                            |                       |        Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                           |                       |        Filter Operator [FIL_218]
+                           |                       |        Filter Operator [FIL_194]
                            |                       |           predicate:((p_channel_tv = 'N') and p_promo_sk is not null) (type: boolean)
                            |                       |           Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                           |                       |           TableScan [TS_60]
+                           |                       |           TableScan [TS_52]
                            |                       |              alias:promotion
                            |                       |              Statistics:Num rows: 2300 Data size: 2713420 Basic stats: COMPLETE Column stats: NONE
                            |                       |<-Reducer 20 [SIMPLE_EDGE]
-                           |                          Reduce Output Operator [RS_82]
+                           |                          Reduce Output Operator [RS_67]
                            |                             key expressions:_col3 (type: int)
                            |                             Map-reduce partition columns:_col3 (type: int)
                            |                             sort order:+
                            |                             Statistics:Num rows: 169400 Data size: 243305506 Basic stats: COMPLETE Column stats: NONE
                            |                             value expressions:_col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2)), _col14 (type: string)
-                           |                             Merge Join Operator [MERGEJOIN_233]
+                           |                             Merge Join Operator [MERGEJOIN_210]
                            |                             |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                             |  keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"}
                            |                             |  outputColumnNames:["_col3","_col5","_col6","_col9","_col10","_col14"]
                            |                             |  Statistics:Num rows: 169400 Data size: 243305506 Basic stats: COMPLETE Column stats: NONE
                            |                             |<-Map 26 [SIMPLE_EDGE]
-                           |                             |  Reduce Output Operator [RS_79]
+                           |                             |  Reduce Output Operator [RS_65]
                            |                             |     key expressions:_col0 (type: int)
                            |                             |     Map-reduce partition columns:_col0 (type: int)
                            |                             |     sort order:+
                            |                             |     Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                           |                             |     Select Operator [SEL_59]
+                           |                             |     Select Operator [SEL_51]
                            |                             |        outputColumnNames:["_col0"]
                            |                             |        Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                           |                             |        Filter Operator [FIL_217]
+                           |                             |        Filter Operator [FIL_193]
                            |                             |           predicate:((i_current_price > 50) and i_item_sk is not null) (type: boolean)
                            |                             |           Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                           |                             |           TableScan [TS_57]
+                           |                             |           TableScan [TS_49]
                            |                             |              alias:item
                            |                             |              Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
                            |                             |<-Reducer 19 [SIMPLE_EDGE]
-                           |                                Reduce Output Operator [RS_77]
+                           |                                Reduce Output Operator [RS_64]
                            |                                   key expressions:_col2 (type: int)
                            |                                   Map-reduce partition columns:_col2 (type: int)
                            |                                   sort order:+
                            |                                   Statistics:Num rows: 50600 Data size: 23318689 Basic stats: COMPLETE Column stats: NONE
                            |                                   value expressions:_col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2)), _col14 (type: string)
-                           |                                   Merge Join Operator [MERGEJOIN_232]
+                           |                                   Merge Join Operator [MERGEJOIN_209]
                            |                                   |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                                   |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                            |                                   |  outputColumnNames:["_col2","_col3","_col5","_col6","_col9","_col10","_col14"]
                            |                                   |  Statistics:Num rows: 50600 Data size: 23318689 Basic stats: COMPLETE Column stats: NONE
                            |                                   |<-Map 25 [SIMPLE_EDGE]
-                           |                                   |  Reduce Output Operator [RS_74]
+                           |                                   |  Reduce Output Operator [RS_62]
                            |                                   |     key expressions:_col0 (type: int)
                            |                                   |     Map-reduce partition columns:_col0 (type: int)
                            |                                   |     sort order:+
                            |                                   |     Statistics:Num rows: 46000 Data size: 21198808 Basic stats: COMPLETE Column stats: NONE
                            |                                   |     value expressions:_col1 (type: string)
-                           |                                   |     Select Operator [SEL_56]
+                           |                                   |     Select Operator [SEL_48]
                            |                                   |        outputColumnNames:["_col0","_col1"]
                            |                                   |        Statistics:Num rows: 46000 Data size: 21198808 Basic stats: COMPLETE Column stats: NONE
-                           |                                   |        Filter Operator [FIL_216]
+                           |                                   |        Filter Operator [FIL_192]
                            |                                   |           predicate:cp_catalog_page_sk is not null (type: boolean)
                            |                                   |           Statistics:Num rows: 46000 Data size: 21198808 Basic stats: COMPLETE Column stats: NONE
-                           |                                   |           TableScan [TS_54]
+                           |                                   |           TableScan [TS_46]
                            |                                   |              alias:catalog_page
                            |                                   |              Statistics:Num rows: 46000 Data size: 21198808 Basic stats: COMPLETE Column stats: NONE
                            |                                   |<-Reducer 18 [SIMPLE_EDGE]
-                           |                                      Reduce Output Operator [RS_72]
+                           |                                      Reduce Output Operator [RS_61]
                            |                                         key expressions:_col1 (type: int)
                            |                                         Map-reduce partition columns:_col1 (type: int)
                            |                                         sort order:+
                            |                                         Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
                            |                                         value expressions:_col2 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2))
-                           |                                         Merge Join Operator [MERGEJOIN_231]
+                           |                                         Merge Join Operator [MERGEJOIN_208]
                            |                                         |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                                         |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                            |                                         |  outputColumnNames:["_col1","_col2","_col3","_col5","_col6","_col9","_col10"]
                            |                                         |  Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
                            |                                         |<-Map 24 [SIMPLE_EDGE]
-                           |                                         |  Reduce Output Operator [RS_69]
+                           |                                         |  Reduce Output Operator [RS_59]
                            |                                         |     key expressions:_col0 (type: int)
                            |                                         |     Map-reduce partition columns:_col0 (type: int)
                            |                                         |     sort order:+
                            |                                         |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                           |                                         |     Select Operator [SEL_53]
+                           |                                         |     Select Operator [SEL_45]
                            |                                         |        outputColumnNames:["_col0"]
                            |                                         |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                           |                                         |        Filter Operator [FIL_215]
+                           |                                         |        Filter Operator [FIL_191]
                            |                                         |           predicate:(d_date BETWEEN 1998-08-04 AND 1998-09-04 and d_date_sk is not null) (type: boolean)
                            |                                         |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                           |                                         |           TableScan [TS_51]
+                           |                                         |           TableScan [TS_43]
                            |                                         |              alias:date_dim
                            |                                         |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                            |                                         |<-Reducer 17 [SIMPLE_EDGE]
-                           |                                            Reduce Output Operator [RS_67]
+                           |                                            Reduce Output Operator [RS_58]
                            |                                               key expressions:_col0 (type: int)
                            |                                               Map-reduce partition columns:_col0 (type: int)
                            |                                               sort order:+
                            |                                               Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2))
-                           |                                               Merge Join Operator [MERGEJOIN_230]
+                           |                                               Merge Join Operator [MERGEJOIN_202]
                            |                                               |  condition map:[{"":"Left Outer Join0 to 1"}]
                            |                                               |  keys:{"0":"_col2 (type: int), _col4 (type: int)","1":"_col0 (type: int), _col1 (type: int)"}
                            |                                               |  outputColumnNames:["_col0","_col1","_col2","_col3","_col5","_col6","_col9","_col10"]
                            |                                               |  Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               |<-Map 16 [SIMPLE_EDGE]
-                           |                                               |  Reduce Output Operator [RS_63]
+                           |                                               |  Reduce Output Operator [RS_55]
                            |                                               |     key expressions:_col2 (type: int), _col4 (type: int)
                            |                                               |     Map-reduce partition columns:_col2 (type: int), _col4 (type: int)
                            |                                               |     sort order:++
                            |                                               |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               |     value expressions:_col0 (type: int), _col1 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2))
-                           |                                               |     Select Operator [SEL_48]
+                           |                                               |     Select Operator [SEL_40]
                            |                                               |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
                            |                                               |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                               |        Filter Operator [FIL_213]
+                           |                                               |        Filter Operator [FIL_189]
                            |                                               |           predicate:(((cs_sold_date_sk is not null and cs_catalog_page_sk is not null) and cs_item_sk is not null) and cs_promo_sk is not null) (type: boolean)
                            |                                               |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                               |           TableScan [TS_46]
+                           |                                               |           TableScan [TS_38]
                            |                                               |              alias:catalog_sales
                            |                                               |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               |<-Map 23 [SIMPLE_EDGE]
-                           |                                                  Reduce Output Operator [RS_64]
+                           |                                                  Reduce Output Operator [RS_56]
                            |                                                     key expressions:_col0 (type: int), _col1 (type: int)
                            |                                                     Map-reduce partition columns:_col0 (type: int), _col1 (type: int)
                            |                                                     sort order:++
                            |                                                     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                                     value expressions:_col2 (type: decimal(7,2)), _col3 (type: decimal(7,2))
-                           |                                                     Select Operator [SEL_50]
+                           |                                                     Select Operator [SEL_42]
                            |                                                        outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |                                                        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                                        Filter Operator [FIL_214]
-                           |                                                           predicate:cr_item_sk is not null (type: boolean)
+                           |                                                        TableScan [TS_41]
+                           |                                                           alias:catalog_returns
                            |                                                           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                                           TableScan [TS_49]
-                           |                                                              alias:catalog_returns
-                           |                                                              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |<-Reducer 34 [CONTAINS]
-                           |  Reduce Output Operator [RS_143]
+                           |  Reduce Output Operator [RS_119]
                            |     key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            |     sort order:+++
                            |     Statistics:Num rows: 838530 Data size: 1204362279 Basic stats: COMPLETE Column stats: NONE
                            |     value expressions:_col3 (type: decimal(27,2)), _col4 (type: decimal(32,2)), _col5 (type: decimal(33,2))
-                           |     Group By Operator [GBY_142]
+                           |     Group By Operator [GBY_118]
                            |        aggregations:["sum(_col2)","sum(_col3)","sum(_col4)"]
                            |        keys:_col0 (type: string), _col1 (type: string), '0' (type: string)
                            |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
                            |        Statistics:Num rows: 838530 Data size: 1204362279 Basic stats: COMPLETE Column stats: NONE
-                           |        Select Operator [SEL_139]
+                           |        Select Operator [SEL_115]
                            |           outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                            |           Statistics:Num rows: 93170 Data size: 133818031 Basic stats: COMPLETE Column stats: NONE
-                           |           Group By Operator [GBY_138]
+                           |           Group By Operator [GBY_114]
                            |           |  aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)"]
                            |           |  keys:KEY._col0 (type: string)
                            |           |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |           |  Statistics:Num rows: 93170 Data size: 133818031 Basic stats: COMPLETE Column stats: NONE
                            |           |<-Reducer 33 [SIMPLE_EDGE]
-                           |              Reduce Output Operator [RS_137]
+                           |              Reduce Output Operator [RS_113]
                            |                 key expressions:_col0 (type: string)
                            |                 Map-reduce partition columns:_col0 (type: string)
                            |                 sort order:+
                            |                 Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
                            |                 value expressions:_col1 (type: decimal(17,2)), _col2 (type: decimal(22,2)), _col3 (type: decimal(23,2))
-                           |                 Group By Operator [GBY_136]
+                           |                 Group By Operator [GBY_112]
                            |                    aggregations:["sum(_col1)","sum(_col2)","sum(_col3)"]
                            |                    keys:_col0 (type: string)
                            |                    outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |                    Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
-                           |                    Select Operator [SEL_134]
+                           |                    Select Operator [SEL_110]
                            |                       outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |                       Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
-                           |                       Merge Join Operator [MERGEJOIN_239]
+                           |                       Merge Join Operator [MERGEJOIN_215]
                            |                       |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                       |  keys:{"0":"_col3 (type: int)","1":"_col0 (type: int)"}
                            |                       |  outputColumnNames:["_col5","_col6","_col9","_col10","_col14"]
                            |                       |  Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
                            |                       |<-Map 39 [SIMPLE_EDGE]
-                           |                       |  Reduce Output Operator [RS_132]
+                           |                       |  Reduce Output Operator [RS_108]
                            |                       |     key expressions:_col0 (type: int)
                            |                       |     Map-reduce partition columns:_col0 (type: int)
                            |                       |     sort order:+
                            |                       |     Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                           |                       |     Select Operator [SEL_110]
+                           |                       |     Select Operator [SEL_94]
                            |                       |        outputColumnNames:["_col0"]
                            |                       |        Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                           |                       |        Filter Operator [FIL_224]
+                           |                       |        Filter Operator [FIL_200]
                            |                       |           predicate:((p_channel_tv = 'N') and p_promo_sk is not null) (type: boolean)
                            |                       |           Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                           |                       |           TableScan [TS_108]
+                           |                       |           TableScan [TS_92]
                            |                       |              alias:promotion
                            |                       |              Statistics:Num rows: 2300 Data size: 2713420 Basic stats: COMPLETE Column stats: NONE
                            |                       |<-Reducer 32 [SIMPLE_EDGE]
-                           |                          Reduce Output Operator [RS_130]
+                           |                          Reduce Output Operator [RS_107]
                            |                             key expressions:_col3 (type: int)
                            |                             Map-reduce partition columns:_col3 (type: int)
                            |                             sort order:+
                            |                             Statistics:Num rows: 169400 Data size: 243305506 Basic stats: COMPLETE Column stats: NONE
                            |                             value expressions:_col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2)), _col14 (type: string)
-                           |                             Merge Join Operator [MERGEJOIN_238]
+                           |                             Merge Join Operator [MERGEJOIN_214]
                            |                             |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                             |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                            |                             |  outputColumnNames:["_col3","_col5","_col6","_col9","_col10","_col14"]
                            |                             |  Statistics:Num rows: 169400 Data size: 243305506 Basic stats: COMPLETE Column stats: NONE
                            |                             |<-Map 38 [SIMPLE_EDGE]
-                           |                             |  Reduce Output Operator [RS_127]
+                           |                             |  Reduce Output Operator [RS_105]
                            |                             |     key expressions:_col0 (type: int)
                            |                             |     Map-reduce partition columns:_col0 (type: int)
                            |                             |     sort order:+
                            |                             |     Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                           |                             |     Select Operator [SEL_107]
+                           |                             |     Select Operator [SEL_91]
                            |                             |        outputColumnNames:["_col0"]
                            |                             |        Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                           |                             |        Filter Operator [FIL_223]
+                           |                             |        Filter Operator [FIL_199]
                            |                             |           predicate:((i_current_price > 50) and i_item_sk is not null) (type: boolean)
                            |                             |           Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                           |                             |           TableScan [TS_105]
+                           |                             |           TableScan [TS_89]
                            |                             |              alias:item
                            |                             |              Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
                            |                             |<-Reducer 31 [SIMPLE_EDGE]
-                           |                                Reduce Output Operator [RS_125]
+                           |                                Reduce Output Operator [RS_104]
                            |                                   key expressions:_col1 (type: int)
                            |                                   Map-reduce partition columns:_col1 (type: int)
                            |                                   sort order:+
                            |                                   Statistics:Num rows: 44193 Data size: 49453132 Basic stats: COMPLETE Column stats: NONE
                            |                                   value expressions:_col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2)), _col14 (type: string)
-                           |                                   Merge Join Operator [MERGEJOIN_237]
+                           |                                   Merge Join Operator [MERGEJOIN_213]
                            |                                   |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                                   |  keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"}
                            |                                   |  outputColumnNames:["_col1","_col3","_col5","_col6","_col9","_col10","_col14"]
                            |                                   |  Statistics:Num rows: 44193 Data size: 49453132 Basic stats: COMPLETE Column stats: NONE
                            |                                   |<-Map 37 [SIMPLE_EDGE]
-                           |                                   |  Reduce Output Operator [RS_122]
+                           |                                   |  Reduce Output Operator [RS_102]
                            |                                   |     key expressions:_col0 (type: int)
                            |                                   |     Map-reduce partition columns:_col0 (type: int)
                            |                                   |     sort order:+
                            |                                   |     Statistics:Num rows: 84 Data size: 155408 Basic stats: COMPLETE Column stats: NONE
                            |                                   |     value expressions:_col1 (type: string)
-                           |                                   |     Select Operator [SEL_104]
+                           |                                   |     Select Operator [SEL_88]
                            |                                   |        outputColumnNames:["_col0","_col1"]
                            |                                   |        Statistics:Num rows: 84 Data size: 155408 Basic stats: COMPLETE Column stats: NONE
-                           |                                   |        Filter Operator [FIL_222]
+                           |                                   |        Filter Operator [FIL_198]
                            |                                   |           predicate:web_site_sk is not null (type: boolean)
                            |                                   |           Statistics:Num rows: 84 Data size: 155408 Basic stats: COMPLETE Column stats: NONE
-                           |                                   |           TableScan [TS_102]
+                           |                                   |           TableScan [TS_86]
                            |                                   |              alias:web_site
                            |                                   |              Statistics:Num rows: 84 Data size: 155408 Basic stats: COMPLETE Column stats: NONE
                            |                                   |<-Reducer 30 [SIMPLE_EDGE]
-                           |                                      Reduce Output Operator [RS_120]
+                           |                                      Reduce Output Operator [RS_101]
                            |                                         key expressions:_col2 (type: int)
                            |                                         Map-reduce partition columns:_col2 (type: int)
                            |                                         sort order:+
                            |                                         Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
                            |                                         value expressions:_col1 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2))
-                           |                                         Merge Join Operator [MERGEJOIN_236]
+                           |                                         Merge Join Operator [MERGEJOIN_212]
                            |                                         |  condition map:[{"":"Inner Join 0 to 1"}]
                            |                                         |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                            |                                         |  outputColumnNames:["_col1","_col2","_col3","_col5","_col6","_col9","_col10"]
                            |                                         |  Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
                            |                                         |<-Map 36 [SIMPLE_EDGE]
-                           |                                         |  Reduce Output Operator [RS_117]
+                           |                                         |  Reduce Output Operator [RS_99]
                            |                                         |     key expressions:_col0 (type: int)
                            |                                         |     Map-reduce partition columns:_col0 (type: int)
                            |                                         |     sort order:+
                            |                                         |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                           |                                         |     Select Operator [SEL_101]
+                           |                                         |     Select Operator [SEL_85]
                            |                                         |        outputColumnNames:["_col0"]
                            |                                         |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                           |                                         |        Filter Operator [FIL_221]
+                           |                                         |        Filter Operator [FIL_197]
                            |                                         |           predicate:(d_date BETWEEN 1998-08-04 AND 1998-09-04 and d_date_sk is not null) (type: boolean)
                            |                                         |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                           |                                         |           TableScan [TS_99]
+                           |                                         |           TableScan [TS_83]
                            |                                         |              alias:date_dim
                            |                                         |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                            |                                         |<-Reducer 29 [SIMPLE_EDGE]
-                           |                                            Reduce Output Operator [RS_115]
+                           |                                            Reduce Output Operator [RS_98]
                            |                                               key expressions:_col0 (type: int)
                            |                                               Map-reduce partition columns:_col0 (type: int)
                            |                                               sort order:+
                            |                                               Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2))
-                           |                                               Merge Join Operator [MERGEJOIN_235]
+                           |                                               Merge Join Operator [MERGEJOIN_203]
                            |                                               |  condition map:[{"":"Left Outer Join0 to 1"}]
                            |                                               |  keys:{"0":"_col1 (type: int), _col4 (type: int)","1":"_col0 (type: int), _col1 (type: int)"}
                            |                                               |  outputColumnNames:["_col0","_col1","_col2","_col3","_col5","_col6","_col9","_col10"]
                            |                                               |  Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               |<-Map 28 [SIMPLE_EDGE]
-                           |                                               |  Reduce Output Operator [RS_111]
+                           |                                               |  Reduce Output Operator [RS_95]
                            |                                               |     key expressions:_col1 (type: int), _col4 (type: int)
                            |                                               |     Map-reduce partition columns:_col1 (type: int), _col4 (type: int)
                            |                                               |     sort order:++
                            |                                               |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               |     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2))
-                           |                                               |     Select Operator [SEL_96]
+                           |                                               |     Select Operator [SEL_80]
                            |                                               |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
                            |                                               |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                               |        Filter Operator [FIL_219]
+                           |                                               |        Filter Operator [FIL_195]
                            |                                               |           predicate:(((ws_sold_date_sk is not null and ws_web_site_sk is not null) and ws_item_sk is not null) and ws_promo_sk is not null) (type: boolean)
                            |                                               |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                               |           TableScan [TS_94]
+                           |                                               |           TableScan [TS_78]
                            |                                               |              alias:web_sales
                            |                                               |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                               |<-Map 35 [SIMPLE_EDGE]
-                           |                                                  Reduce Output Operator [RS_112]
+                           |                                                  Reduce Output Operator [RS_96]
                            |                                                     key expressions:_col0 (type: int), _col1 (type: int)
                            |                                                     Map-reduce partition columns:_col0 (type: int), _col1 (type: int)
                            |                                                     sort order:++
                            |                                                     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |                                                     value expressions:_col2 (type: decimal(7,2)), _col3 (type: decimal(7,2))
-                           |                                                     Select Operator [SEL_98]
+                           |                                                     Select Operator [SEL_82]
                            |                                                        outputColumnNames:["_col0","_col1","_col2","_col3"]
                            |                                                        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                                        Filter Operator [FIL_220]
-                           |                                                           predicate:wr_item_sk is not null (type: boolean)
+                           |                                                        TableScan [TS_81]
+                           |                                                           alias:web_returns
                            |                                                           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                           |                                                           TableScan [TS_97]
-                           |                                                              alias:web_returns
-                           |                                                              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                            |<-Reducer 7 [CONTAINS]
-                              Reduce Output Operator [RS_143]
+                              Reduce Output Operator [RS_119]
                                  key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                                  Map-reduce partition columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                                  sort order:+++
                                  Statistics:Num rows: 838530 Data size: 1204362279 Basic stats: COMPLETE Column stats: NONE
                                  value expressions:_col3 (type: decimal(27,2)), _col4 (type: decimal(32,2)), _col5 (type: decimal(33,2))
-                                 Group By Operator [GBY_142]
+                                 Group By Operator [GBY_118]
                                     aggregations:["sum(_col2)","sum(_col3)","sum(_col4)"]
                                     keys:_col0 (type: string), _col1 (type: string), '0' (type: string)
                                     outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
                                     Statistics:Num rows: 838530 Data size: 1204362279 Basic stats: COMPLETE Column stats: NONE
-                                    Select Operator [SEL_45]
+                                    Select Operator [SEL_37]
                                        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
                                        Statistics:Num rows: 93170 Data size: 133818031 Basic stats: COMPLETE Column stats: NONE
-                                       Group By Operator [GBY_44]
+                                       Group By Operator [GBY_36]
                                        |  aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)"]
                                        |  keys:KEY._col0 (type: string)
                                        |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                        |  Statistics:Num rows: 93170 Data size: 133818031 Basic stats: COMPLETE Column stats: NONE
                                        |<-Reducer 6 [SIMPLE_EDGE]
-                                          Reduce Output Operator [RS_43]
+                                          Reduce Output Operator [RS_35]
                                              key expressions:_col0 (type: string)
                                              Map-reduce partition columns:_col0 (type: string)
                                              sort order:+
                                              Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
                                              value expressions:_col1 (type: decimal(17,2)), _col2 (type: decimal(22,2)), _col3 (type: decimal(23,2))
-                                             Group By Operator [GBY_42]
+                                             Group By Operator [GBY_34]
                                                 aggregations:["sum(_col1)","sum(_col2)","sum(_col3)"]
                                                 keys:_col0 (type: string)
                                                 outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                 Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
-                                                Select Operator [SEL_40]
+                                                Select Operator [SEL_32]
                                                    outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                    Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
-                                                   Merge Join Operator [MERGEJOIN_229]
+                                                   Merge Join Operator [MERGEJOIN_207]
                                                    |  condition map:[{"":"Inner Join 0 to 1"}]
                                                    |  keys:{"0":"_col3 (type: int)","1":"_col0 (type: int)"}
                                                    |  outputColumnNames:["_col5","_col6","_col9","_col10","_col14"]
                                                    |  Statistics:Num rows: 186340 Data size: 267636062 Basic stats: COMPLETE Column stats: NONE
                                                    |<-Map 15 [SIMPLE_EDGE]
-                                                   |  Reduce Output Operator [RS_38]
+                                                   |  Reduce Output Operator [RS_30]
                                                    |     key expressions:_col0 (type: int)
                                                    |     Map-reduce partition columns:_col0 (type: int)
                                                    |     sort order:+
@@ -467,26 +461,26 @@ Stage-0
                                                    |     Select Operator [SEL_16]
                                                    |        outputColumnNames:["_col0"]
                                                    |        Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
-                                                   |        Filter Operator [FIL_212]
+                                                   |        Filter Operator [FIL_188]
                                                    |           predicate:((p_channel_tv = 'N') and p_promo_sk is not null) (type: boolean)
                                                    |           Statistics:Num rows: 1150 Data size: 1356710 Basic stats: COMPLETE Column stats: NONE
                                                    |           TableScan [TS_14]
                                                    |              alias:promotion
                                                    |              Statistics:Num rows: 2300 Data size: 2713420 Basic stats: COMPLETE Column stats: NONE
                                                    |<-Reducer 5 [SIMPLE_EDGE]
-                                                      Reduce Output Operator [RS_36]
+                                                      Reduce Output Operator [RS_29]
                                                          key expressions:_col3 (type: int)
                                                          Map-reduce partition columns:_col3 (type: int)
                                                          sort order:+
                                                          Statistics:Num rows: 169400 Data size: 243305506 Basic stats: COMPLETE Column stats: NONE
                                                          value expressions:_col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2)), _col14 (type: string)
-                                                         Merge Join Operator [MERGEJOIN_228]
+                                                         Merge Join Operator [MERGEJOIN_206]
                                                          |  condition map:[{"":"Inner Join 0 to 1"}]
                                                          |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                                                          |  outputColumnNames:["_col3","_col5","_col6","_col9","_col10","_col14"]
                                                          |  Statistics:Num rows: 169400 Data size: 243305506 Basic stats: COMPLETE Column stats: NONE
                                                          |<-Map 14 [SIMPLE_EDGE]
-                                                         |  Reduce Output Operator [RS_33]
+                                                         |  Reduce Output Operator [RS_27]
                                                          |     key expressions:_col0 (type: int)
                                                          |     Map-reduce partition columns:_col0 (type: int)
                                                          |     sort order:+
@@ -494,26 +488,26 @@ Stage-0
                                                          |     Select Operator [SEL_13]
                                                          |        outputColumnNames:["_col0"]
                                                          |        Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
-                                                         |        Filter Operator [FIL_211]
+                                                         |        Filter Operator [FIL_187]
                                                          |           predicate:((i_current_price > 50) and i_item_sk is not null) (type: boolean)
                                                          |           Statistics:Num rows: 154000 Data size: 221186819 Basic stats: COMPLETE Column stats: NONE
                                                          |           TableScan [TS_11]
                                                          |              alias:item
                                                          |              Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
                                                          |<-Reducer 4 [SIMPLE_EDGE]
-                                                            Reduce Output Operator [RS_31]
+                                                            Reduce Output Operator [RS_26]
                                                                key expressions:_col1 (type: int)
                                                                Map-reduce partition columns:_col1 (type: int)
                                                                sort order:+
                                                                Statistics:Num rows: 44193 Data size: 49453132 Basic stats: COMPLETE Column stats: NONE
                                                                value expressions:_col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2)), _col14 (type: string)
-                                                               Merge Join Operator [MERGEJOIN_227]
+                                                               Merge Join Operator [MERGEJOIN_205]
                                                                |  condition map:[{"":"Inner Join 0 to 1"}]
                                                                |  keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"}
                                                                |  outputColumnNames:["_col1","_col3","_col5","_col6","_col9","_col10","_col14"]
                                                                |  Statistics:Num rows: 44193 Data size: 49453132 Basic stats: COMPLETE Column stats: NONE
                                                                |<-Map 13 [SIMPLE_EDGE]
-                                                               |  Reduce Output Operator [RS_28]
+                                                               |  Reduce Output Operator [RS_24]
                                                                |     key expressions:_col0 (type: int)
                                                                |     Map-reduce partition columns:_col0 (type: int)
                                                                |     sort order:+
@@ -522,26 +516,26 @@ Stage-0
                                                                |     Select Operator [SEL_10]
                                                                |        outputColumnNames:["_col0","_col1"]
                                                                |        Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE
-                                                               |        Filter Operator [FIL_210]
+                                                               |        Filter Operator [FIL_186]
                                                                |           predicate:s_store_sk is not null (type: boolean)
                                                                |           Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE
                                                                |           TableScan [TS_8]
                                                                |              alias:store
                                                                |              Statistics:Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE
                                                                |<-Reducer 3 [SIMPLE_EDGE]
-                                                                  Reduce Output Operator [RS_26]
+                                                                  Reduce Output Operator [RS_23]
                                                                      key expressions:_col2 (type: int)
                                                                      Map-reduce partition columns:_col2 (type: int)
                                                                      sort order:+
                                                                      Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
                                                                      value expressions:_col1 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2))
-                                                                     Merge Join Operator [MERGEJOIN_226]
+                                                                     Merge Join Operator [MERGEJOIN_204]
                                                                      |  condition map:[{"":"Inner Join 0 to 1"}]
                                                                      |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                                                                      |  outputColumnNames:["_col1","_col2","_col3","_col5","_col6","_col9","_col10"]
                                                                      |  Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
                                                                      |<-Map 12 [SIMPLE_EDGE]
-                                                                     |  Reduce Output Operator [RS_23]
+                                                                     |  Reduce Output Operator [RS_21]
                                                                      |     key expressions:_col0 (type: int)
                                                                      |     Map-reduce partition columns:_col0 (type: int)
                                                                      |     sort order:+
@@ -549,20 +543,20 @@ Stage-0
                                                                      |     Select Operator [SEL_7]
                                                                      |        outputColumnNames:["_col0"]
                                                                      |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                                                     |        Filter Operator [FIL_209]
+                                                                     |        Filter Operator [FIL_185]
                                                                      |           predicate:(d_date BETWEEN 1998-08-04 AND 1998-09-04 and d_date_sk is not null) (type: boolean)
                                                                      |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
                                                                      |           TableScan [TS_5]
                                                                      |              alias:date_dim
                                                                      |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                                                                      |<-Reducer 2 [SIMPLE_EDGE]
-                                                                        Reduce Output Operator [RS_21]
+                                                                        Reduce Output Operator [RS_20]
                                                                            key expressions:_col0 (type: int)
                                                                            Map-reduce partition columns:_col0 (type: int)
                                                                            sort order:+
                                                                            Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                                                            value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: decimal(7,2)), _col10 (type: decimal(7,2))
-                                                                           Merge Join Operator [MERGEJOIN_225]
+                                                                           Merge Join Operator [MERGEJOIN_201]
                                                                            |  condition map:[{"":"Left Outer Join0 to 1"}]
                                                                            |  keys:{"0":"_col1 (type: int), _col4 (type: int)","1":"_col0 (type: int), _col1 (type: int)"}
                                                                            |  outputColumnNames:["_col0","_col1","_col2","_col3","_col5","_col6","_col9","_col10"]
@@ -577,7 +571,7 @@ Stage-0
                                                                            |     Select Operator [SEL_2]
                                                                            |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
                                                                            |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                                           |        Filter Operator [FIL_207]
+                                                                           |        Filter Operator [FIL_183]
                                                                            |           predicate:(((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_item_sk is not null) and ss_promo_sk is not null) (type: boolean)
                                                                            |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                                                            |           TableScan [TS_0]
@@ -593,10 +587,7 @@ Stage-0
                                                                                  Select Operator [SEL_4]
                                                                                     outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                                                     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                                                    Filter Operator [FIL_208]
-                                                                                       predicate:sr_item_sk is not null (type: boolean)
+                                                                                    TableScan [TS_3]
+                                                                                       alias:store_returns
                                                                                        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                                                       TableScan [TS_3]
-                                                                                          alias:store_returns
-                                                                                          Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
 

http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/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 6f142ed..654a772 100644
--- a/ql/src/test/results/clientpositive/perf/query82.q.out
+++ b/ql/src/test/results/clientpositive/perf/query82.q.out
@@ -15,43 +15,43 @@ Stage-0
       limit:100
       Stage-1
          Reducer 5
-         File Output Operator [FS_32]
+         File Output Operator [FS_27]
             compressed:false
             Statistics:Num rows: 100 Data size: 143600 Basic stats: COMPLETE Column stats: NONE
             table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
-            Limit [LIM_31]
+            Limit [LIM_26]
                Number of rows:100
                Statistics:Num rows: 100 Data size: 143600 Basic stats: COMPLETE Column stats: NONE
-               Select Operator [SEL_30]
+               Select Operator [SEL_25]
                |  outputColumnNames:["_col0","_col1","_col2"]
                |  Statistics:Num rows: 139755 Data size: 200727046 Basic stats: COMPLETE Column stats: NONE
                |<-Reducer 4 [SIMPLE_EDGE]
-                  Reduce Output Operator [RS_29]
+                  Reduce Output Operator [RS_24]
                      key expressions:_col0 (type: string)
                      sort order:+
                      Statistics:Num rows: 139755 Data size: 200727046 Basic stats: COMPLETE Column stats: NONE
                      value expressions:_col1 (type: string), _col2 (type: decimal(7,2))
-                     Group By Operator [GBY_27]
+                     Group By Operator [GBY_22]
                      |  keys:KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: decimal(7,2))
                      |  outputColumnNames:["_col0","_col1","_col2"]
                      |  Statistics:Num rows: 139755 Data size: 200727046 Basic stats: COMPLETE Column stats: NONE
                      |<-Reducer 3 [SIMPLE_EDGE]
-                        Reduce Output Operator [RS_26]
+                        Reduce Output Operator [RS_21]
                            key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: decimal(7,2))
                            Map-reduce partition columns:_col0 (type: string), _col1 (type: string), _col2 (type: decimal(7,2))
                            sort order:+++
                            Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                           Group By Operator [GBY_25]
+                           Group By Operator [GBY_20]
                               keys:_col1 (type: string), _col2 (type: string), _col3 (type: decimal(7,2))
                               outputColumnNames:["_col0","_col1","_col2"]
                               Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                              Merge Join Operator [MERGEJOIN_48]
+                              Merge Join Operator [MERGEJOIN_43]
                               |  condition map:[{"":"Inner Join 0 to 1"}]
                               |  keys:{"0":"_col5 (type: int)","1":"_col0 (type: int)"}
                               |  outputColumnNames:["_col1","_col2","_col3"]
                               |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
                               |<-Map 7 [SIMPLE_EDGE]
-                              |  Reduce Output Operator [RS_22]
+                              |  Reduce Output Operator [RS_17]
                               |     key expressions:_col0 (type: int)
                               |     Map-reduce partition columns:_col0 (type: int)
                               |     sort order:+
@@ -59,26 +59,26 @@ Stage-0
                               |     Select Operator [SEL_8]
                               |        outputColumnNames:["_col0"]
                               |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                              |        Filter Operator [FIL_45]
+                              |        Filter Operator [FIL_40]
                               |           predicate:(d_date BETWEEN '2002-05-30' AND '2002-07-30' and d_date_sk is not null) (type: boolean)
                               |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
                               |           TableScan [TS_6]
                               |              alias:date_dim
                               |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                               |<-Reducer 2 [SIMPLE_EDGE]
-                                 Reduce Output Operator [RS_20]
+                                 Reduce Output Operator [RS_16]
                                     key expressions:_col5 (type: int)
                                     Map-reduce partition columns:_col5 (type: int)
                                     sort order:+
                                     Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
                                     value expressions:_col1 (type: string), _col2 (type: string), _col3 (type: decimal(7,2))
-                                    Merge Join Operator [MERGEJOIN_47]
+                                    Merge Join Operator [MERGEJOIN_42]
                                     |  condition map:[{"":"Inner Join 0 to 1"},{"":"Inner Join 0 to 2"}]
                                     |  keys:{"0":"_col0 (type: int)","1":"_col1 (type: int)","2":"_col0 (type: int)"}
                                     |  outputColumnNames:["_col1","_col2","_col3","_col5"]
                                     |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
                                     |<-Map 1 [SIMPLE_EDGE]
-                                    |  Reduce Output Operator [RS_13]
+                                    |  Reduce Output Operator [RS_12]
                                     |     key expressions:_col0 (type: int)
                                     |     Map-reduce partition columns:_col0 (type: int)
                                     |     sort order:+
@@ -87,14 +87,14 @@ Stage-0
                                     |     Select Operator [SEL_2]
                                     |        outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |        Statistics:Num rows: 115500 Data size: 165890114 Basic stats: COMPLETE Column stats: NONE
-                                    |        Filter Operator [FIL_43]
+                                    |        Filter Operator [FIL_38]
                                     |           predicate:(((i_manufact_id) IN (437, 129, 727, 663) and i_current_price BETWEEN 30 AND 60) and i_item_sk is not null) (type: boolean)
                                     |           Statistics:Num rows: 115500 Data size: 165890114 Basic stats: COMPLETE Column stats: NONE
                                     |           TableScan [TS_0]
                                     |              alias:item
                                     |              Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
                                     |<-Map 6 [SIMPLE_EDGE]
-                                    |  Reduce Output Operator [RS_15]
+                                    |  Reduce Output Operator [RS_13]
                                     |     key expressions:_col1 (type: int)
                                     |     Map-reduce partition columns:_col1 (type: int)
                                     |     sort order:+
@@ -103,14 +103,14 @@ Stage-0
                                     |     Select Operator [SEL_5]
                                     |        outputColumnNames:["_col0","_col1"]
                                     |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |        Filter Operator [FIL_44]
+                                    |        Filter Operator [FIL_39]
                                     |           predicate:((inv_quantity_on_hand BETWEEN 100 AND 500 and inv_item_sk is not null) and inv_date_sk is not null) (type: boolean)
                                     |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |           TableScan [TS_3]
                                     |              alias:inventory
                                     |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |<-Map 8 [SIMPLE_EDGE]
-                                       Reduce Output Operator [RS_17]
+                                       Reduce Output Operator [RS_14]
                                           key expressions:_col0 (type: int)
                                           Map-reduce partition columns:_col0 (type: int)
                                           sort order:+
@@ -118,7 +118,7 @@ Stage-0
                                           Select Operator [SEL_11]
                                              outputColumnNames:["_col0"]
                                              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                             Filter Operator [FIL_46]
+                                             Filter Operator [FIL_41]
                                                 predicate:ss_item_sk is not null (type: boolean)
                                                 Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                                 TableScan [TS_9]


Mime
View raw message