hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pxi...@apache.org
Subject [6/9] hive git commit: HIVE-16797: Enhance HiveFilterSetOpTransposeRule to remove union branches (Pengcheng Xiong, reviewed by Ashutosh Chauhan)
Date Tue, 20 Jun 2017 17:05:56 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/8c5f55ee/ql/src/test/results/clientpositive/perf/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query14.q.out b/ql/src/test/results/clientpositive/perf/query14.q.out
index 048a17f..64c5921 100644
--- a/ql/src/test/results/clientpositive/perf/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/query14.q.out
@@ -1,6 +1,6 @@
-Warning: Shuffle Join MERGEJOIN[906][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
-Warning: Shuffle Join MERGEJOIN[908][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 16' is a cross product
-Warning: Shuffle Join MERGEJOIN[907][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
+Warning: Shuffle Join MERGEJOIN[900][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
+Warning: Shuffle Join MERGEJOIN[901][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product
+Warning: Shuffle Join MERGEJOIN[899][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
 PREHOOK: query: explain
 with  cross_items as
  (select i_item_sk ss_item_sk
@@ -290,1143 +290,1143 @@ Stage-0
     limit:100
     Stage-1
       Reducer 8
-      File Output Operator [FS_590]
-        Limit [LIM_589] (rows=100 width=405)
+      File Output Operator [FS_583]
+        Limit [LIM_582] (rows=100 width=405)
           Number of rows:100
-          Select Operator [SEL_588] (rows=1016388080 width=405)
+          Select Operator [SEL_581] (rows=1016388080 width=405)
             Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
           <-Reducer 7 [SIMPLE_EDGE]
-            SHUFFLE [RS_587]
-              Select Operator [SEL_586] (rows=1016388080 width=405)
+            SHUFFLE [RS_580]
+              Select Operator [SEL_579] (rows=1016388080 width=405)
                 Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                Group By Operator [GBY_585] (rows=1016388080 width=405)
+                Group By Operator [GBY_578] (rows=1016388080 width=405)
                   Output:["_col0","_col1","_col2","_col3","_col5","_col6"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
                 <-Union 6 [SIMPLE_EDGE]
                   <-Reducer 12 [CONTAINS]
-                    Reduce Output Operator [RS_584]
+                    Reduce Output Operator [RS_577]
                       PartitionCols:_col0, _col1, _col2, _col3, _col4
-                      Group By Operator [GBY_583] (rows=2032776160 width=405)
+                      Group By Operator [GBY_576] (rows=2032776160 width=405)
                         Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0
-                        Select Operator [SEL_385] (rows=116155905 width=432)
+                        Select Operator [SEL_381] (rows=116155905 width=432)
                           Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                          Filter Operator [FIL_384] (rows=116155905 width=432)
+                          Filter Operator [FIL_380] (rows=116155905 width=432)
                             predicate:(_col5 > _col1)
-                            Merge Join Operator [MERGEJOIN_907] (rows=348467716 width=432)
+                            Merge Join Operator [MERGEJOIN_900] (rows=348467716 width=432)
                               Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
                             <-Reducer 11 [CUSTOM_SIMPLE_EDGE]
-                              PARTITION_ONLY_SHUFFLE [RS_380]
-                                Select Operator [SEL_237] (rows=1 width=8)
-                                  Filter Operator [FIL_236] (rows=1 width=8)
+                              PARTITION_ONLY_SHUFFLE [RS_376]
+                                Select Operator [SEL_234] (rows=1 width=8)
+                                  Filter Operator [FIL_233] (rows=1 width=8)
                                     predicate:(sq_count_check(_col0) <= 1)
-                                    Group By Operator [GBY_234] (rows=1 width=8)
+                                    Group By Operator [GBY_231] (rows=1 width=8)
                                       Output:["_col0"],aggregations:["count()"]
-                                      Select Operator [SEL_229] (rows=1 width=8)
-                                        Group By Operator [GBY_228] (rows=1 width=8)
+                                      Select Operator [SEL_226] (rows=1 width=8)
+                                        Group By Operator [GBY_225] (rows=1 width=8)
                                           Output:["_col0"],aggregations:["count(VALUE._col0)"]
                                         <-Union 10 [CUSTOM_SIMPLE_EDGE]
                                           <-Reducer 74 [CONTAINS]
-                                            Reduce Output Operator [RS_227]
-                                              Group By Operator [GBY_226] (rows=1 width=8)
+                                            Reduce Output Operator [RS_224]
+                                              Group By Operator [GBY_223] (rows=1 width=8)
                                                 Output:["_col0"],aggregations:["count(_col0)"]
-                                                Select Operator [SEL_225] (rows=1108786976 width=108)
+                                                Select Operator [SEL_222] (rows=1108786976 width=108)
                                                   Output:["_col0"]
-                                                  Select Operator [SEL_212] (rows=316788826 width=135)
+                                                  Select Operator [SEL_210] (rows=316788826 width=135)
                                                     Output:["_col0"]
-                                                    Merge Join Operator [MERGEJOIN_877] (rows=316788826 width=135)
-                                                      Conds:RS_209._col0=RS_210._col0(Inner),Output:["_col1"]
+                                                    Merge Join Operator [MERGEJOIN_870] (rows=316788826 width=135)
+                                                      Conds:RS_207._col0=RS_208._col0(Inner),Output:["_col1"]
                                                     <-Map 76 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_210]
+                                                      SHUFFLE [RS_208]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_208] (rows=8116 width=1119)
+                                                        Select Operator [SEL_206] (rows=8116 width=1119)
                                                           Output:["_col0"]
-                                                          Filter Operator [FIL_814] (rows=8116 width=1119)
+                                                          Filter Operator [FIL_807] (rows=8116 width=1119)
                                                             predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
                                                             TableScan [TS_13] (rows=73049 width=1119)
                                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
                                                     <-Map 72 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_209]
+                                                      SHUFFLE [RS_207]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_205] (rows=287989836 width=135)
+                                                        Select Operator [SEL_203] (rows=287989836 width=135)
                                                           Output:["_col0","_col1"]
-                                                          Filter Operator [FIL_813] (rows=287989836 width=135)
+                                                          Filter Operator [FIL_806] (rows=287989836 width=135)
                                                             predicate:cs_sold_date_sk is not null
                                                             TableScan [TS_10] (rows=287989836 width=135)
                                                               default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity"]
                                           <-Reducer 82 [CONTAINS]
-                                            Reduce Output Operator [RS_227]
-                                              Group By Operator [GBY_226] (rows=1 width=8)
+                                            Reduce Output Operator [RS_224]
+                                              Group By Operator [GBY_223] (rows=1 width=8)
                                                 Output:["_col0"],aggregations:["count(_col0)"]
-                                                Select Operator [SEL_225] (rows=1108786976 width=108)
+                                                Select Operator [SEL_222] (rows=1108786976 width=108)
                                                   Output:["_col0"]
-                                                  Select Operator [SEL_224] (rows=158402938 width=135)
+                                                  Select Operator [SEL_221] (rows=158402938 width=135)
                                                     Output:["_col0"]
-                                                    Merge Join Operator [MERGEJOIN_878] (rows=158402938 width=135)
-                                                      Conds:RS_221._col0=RS_222._col0(Inner),Output:["_col1"]
+                                                    Merge Join Operator [MERGEJOIN_871] (rows=158402938 width=135)
+                                                      Conds:RS_218._col0=RS_219._col0(Inner),Output:["_col1"]
                                                     <-Map 84 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_222]
+                                                      SHUFFLE [RS_219]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_220] (rows=8116 width=1119)
+                                                        Select Operator [SEL_217] (rows=8116 width=1119)
                                                           Output:["_col0"]
-                                                          Filter Operator [FIL_816] (rows=8116 width=1119)
+                                                          Filter Operator [FIL_809] (rows=8116 width=1119)
                                                             predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
-                                                            TableScan [TS_25] (rows=73049 width=1119)
+                                                            TableScan [TS_24] (rows=73049 width=1119)
                                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
                                                     <-Map 80 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_221]
+                                                      SHUFFLE [RS_218]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_217] (rows=144002668 width=135)
+                                                        Select Operator [SEL_214] (rows=144002668 width=135)
                                                           Output:["_col0","_col1"]
-                                                          Filter Operator [FIL_815] (rows=144002668 width=135)
+                                                          Filter Operator [FIL_808] (rows=144002668 width=135)
                                                             predicate:ws_sold_date_sk is not null
-                                                            TableScan [TS_22] (rows=144002668 width=135)
+                                                            TableScan [TS_21] (rows=144002668 width=135)
                                                               default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity"]
                                           <-Reducer 9 [CONTAINS]
-                                            Reduce Output Operator [RS_227]
-                                              Group By Operator [GBY_226] (rows=1 width=8)
+                                            Reduce Output Operator [RS_224]
+                                              Group By Operator [GBY_223] (rows=1 width=8)
                                                 Output:["_col0"],aggregations:["count(_col0)"]
-                                                Select Operator [SEL_225] (rows=1108786976 width=108)
+                                                Select Operator [SEL_222] (rows=1108786976 width=108)
                                                   Output:["_col0"]
-                                                  Select Operator [SEL_202] (rows=633595212 width=88)
+                                                  Select Operator [SEL_200] (rows=633595212 width=88)
                                                     Output:["_col0"]
-                                                    Merge Join Operator [MERGEJOIN_876] (rows=633595212 width=88)
-                                                      Conds:RS_199._col0=RS_200._col0(Inner),Output:["_col1"]
+                                                    Merge Join Operator [MERGEJOIN_869] (rows=633595212 width=88)
+                                                      Conds:RS_197._col0=RS_198._col0(Inner),Output:["_col1"]
                                                     <-Map 17 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_200]
+                                                      SHUFFLE [RS_198]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_198] (rows=8116 width=1119)
+                                                        Select Operator [SEL_196] (rows=8116 width=1119)
                                                           Output:["_col0"]
-                                                          Filter Operator [FIL_812] (rows=8116 width=1119)
+                                                          Filter Operator [FIL_805] (rows=8116 width=1119)
                                                             predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                             TableScan [TS_3] (rows=73049 width=1119)
                                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
                                                     <-Map 1 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_199]
+                                                      SHUFFLE [RS_197]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_195] (rows=575995635 width=88)
+                                                        Select Operator [SEL_193] (rows=575995635 width=88)
                                                           Output:["_col0","_col1"]
-                                                          Filter Operator [FIL_811] (rows=575995635 width=88)
+                                                          Filter Operator [FIL_804] (rows=575995635 width=88)
                                                             predicate:ss_sold_date_sk is not null
                                                             TableScan [TS_0] (rows=575995635 width=88)
                                                               default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
                             <-Reducer 38 [CUSTOM_SIMPLE_EDGE]
-                              PARTITION_ONLY_SHUFFLE [RS_381]
-                                Group By Operator [GBY_274] (rows=1 width=288)
+                              PARTITION_ONLY_SHUFFLE [RS_377]
+                                Group By Operator [GBY_270] (rows=1 width=288)
                                   Output:["_col0"],aggregations:["avg(VALUE._col0)"]
                                 <-Union 37 [CUSTOM_SIMPLE_EDGE]
                                   <-Reducer 36 [CONTAINS]
-                                    Reduce Output Operator [RS_273]
-                                      Group By Operator [GBY_272] (rows=1 width=288)
+                                    Reduce Output Operator [RS_269]
+                                      Group By Operator [GBY_268] (rows=1 width=288)
                                         Output:["_col0"],aggregations:["avg(_col0)"]
-                                        Select Operator [SEL_270] (rows=1108786976 width=108)
+                                        Select Operator [SEL_266] (rows=1108786976 width=108)
                                           Output:["_col0"]
-                                          Select Operator [SEL_247] (rows=633595212 width=88)
+                                          Select Operator [SEL_244] (rows=633595212 width=88)
                                             Output:["_col0","_col1"]
-                                            Merge Join Operator [MERGEJOIN_879] (rows=633595212 width=88)
-                                              Conds:RS_244._col0=RS_245._col0(Inner),Output:["_col1","_col2"]
+                                            Merge Join Operator [MERGEJOIN_872] (rows=633595212 width=88)
+                                              Conds:RS_241._col0=RS_242._col0(Inner),Output:["_col1","_col2"]
                                             <-Map 17 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_245]
+                                              SHUFFLE [RS_242]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_243] (rows=8116 width=1119)
+                                                Select Operator [SEL_240] (rows=8116 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_818] (rows=8116 width=1119)
+                                                  Filter Operator [FIL_811] (rows=8116 width=1119)
                                                     predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                      Please refer to the previous TableScan [TS_3]
                                             <-Map 88 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_244]
+                                              SHUFFLE [RS_241]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_240] (rows=575995635 width=88)
+                                                Select Operator [SEL_237] (rows=575995635 width=88)
                                                   Output:["_col0","_col1","_col2"]
-                                                  Filter Operator [FIL_817] (rows=575995635 width=88)
+                                                  Filter Operator [FIL_810] (rows=575995635 width=88)
                                                     predicate:ss_sold_date_sk is not null
-                                                    TableScan [TS_45] (rows=575995635 width=88)
+                                                    TableScan [TS_44] (rows=575995635 width=88)
                                                       default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity","ss_list_price"]
                                   <-Reducer 78 [CONTAINS]
-                                    Reduce Output Operator [RS_273]
-                                      Group By Operator [GBY_272] (rows=1 width=288)
+                                    Reduce Output Operator [RS_269]
+                                      Group By Operator [GBY_268] (rows=1 width=288)
                                         Output:["_col0"],aggregations:["avg(_col0)"]
-                                        Select Operator [SEL_270] (rows=1108786976 width=108)
+                                        Select Operator [SEL_266] (rows=1108786976 width=108)
                                           Output:["_col0"]
-                                          Select Operator [SEL_257] (rows=316788826 width=135)
+                                          Select Operator [SEL_254] (rows=316788826 width=135)
                                             Output:["_col0","_col1"]
-                                            Merge Join Operator [MERGEJOIN_880] (rows=316788826 width=135)
-                                              Conds:RS_254._col0=RS_255._col0(Inner),Output:["_col1","_col2"]
+                                            Merge Join Operator [MERGEJOIN_873] (rows=316788826 width=135)
+                                              Conds:RS_251._col0=RS_252._col0(Inner),Output:["_col1","_col2"]
                                             <-Map 76 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_255]
+                                              SHUFFLE [RS_252]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_253] (rows=8116 width=1119)
+                                                Select Operator [SEL_250] (rows=8116 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_820] (rows=8116 width=1119)
+                                                  Filter Operator [FIL_813] (rows=8116 width=1119)
                                                     predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
                                                      Please refer to the previous TableScan [TS_13]
                                             <-Map 89 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_254]
+                                              SHUFFLE [RS_251]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_250] (rows=287989836 width=135)
+                                                Select Operator [SEL_247] (rows=287989836 width=135)
                                                   Output:["_col0","_col1","_col2"]
-                                                  Filter Operator [FIL_819] (rows=287989836 width=135)
+                                                  Filter Operator [FIL_812] (rows=287989836 width=135)
                                                     predicate:cs_sold_date_sk is not null
-                                                    TableScan [TS_55] (rows=287989836 width=135)
+                                                    TableScan [TS_54] (rows=287989836 width=135)
                                                       default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity","cs_list_price"]
                                   <-Reducer 86 [CONTAINS]
-                                    Reduce Output Operator [RS_273]
-                                      Group By Operator [GBY_272] (rows=1 width=288)
+                                    Reduce Output Operator [RS_269]
+                                      Group By Operator [GBY_268] (rows=1 width=288)
                                         Output:["_col0"],aggregations:["avg(_col0)"]
-                                        Select Operator [SEL_270] (rows=1108786976 width=108)
+                                        Select Operator [SEL_266] (rows=1108786976 width=108)
                                           Output:["_col0"]
-                                          Select Operator [SEL_269] (rows=158402938 width=135)
+                                          Select Operator [SEL_265] (rows=158402938 width=135)
                                             Output:["_col0","_col1"]
-                                            Merge Join Operator [MERGEJOIN_881] (rows=158402938 width=135)
-                                              Conds:RS_266._col0=RS_267._col0(Inner),Output:["_col1","_col2"]
+                                            Merge Join Operator [MERGEJOIN_874] (rows=158402938 width=135)
+                                              Conds:RS_262._col0=RS_263._col0(Inner),Output:["_col1","_col2"]
                                             <-Map 84 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_267]
+                                              SHUFFLE [RS_263]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_265] (rows=8116 width=1119)
+                                                Select Operator [SEL_261] (rows=8116 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_822] (rows=8116 width=1119)
+                                                  Filter Operator [FIL_815] (rows=8116 width=1119)
                                                     predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
-                                                     Please refer to the previous TableScan [TS_25]
+                                                     Please refer to the previous TableScan [TS_24]
                                             <-Map 90 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_266]
+                                              SHUFFLE [RS_262]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_262] (rows=144002668 width=135)
+                                                Select Operator [SEL_258] (rows=144002668 width=135)
                                                   Output:["_col0","_col1","_col2"]
-                                                  Filter Operator [FIL_821] (rows=144002668 width=135)
+                                                  Filter Operator [FIL_814] (rows=144002668 width=135)
                                                     predicate:ws_sold_date_sk is not null
-                                                    TableScan [TS_67] (rows=144002668 width=135)
+                                                    TableScan [TS_65] (rows=144002668 width=135)
                                                       default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"]
                             <-Reducer 47 [CUSTOM_SIMPLE_EDGE]
-                              PARTITION_ONLY_SHUFFLE [RS_382]
-                                Group By Operator [GBY_378] (rows=348467716 width=135)
+                              PARTITION_ONLY_SHUFFLE [RS_378]
+                                Group By Operator [GBY_374] (rows=348467716 width=135)
                                   Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2
                                 <-Reducer 46 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_377]
+                                  SHUFFLE [RS_373]
                                     PartitionCols:_col0, _col1, _col2
-                                    Group By Operator [GBY_376] (rows=696935432 width=135)
+                                    Group By Operator [GBY_372] (rows=696935432 width=135)
                                       Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2
-                                      Select Operator [SEL_374] (rows=696935432 width=135)
+                                      Select Operator [SEL_370] (rows=696935432 width=135)
                                         Output:["_col0","_col1","_col2","_col3"]
-                                        Merge Join Operator [MERGEJOIN_890] (rows=696935432 width=135)
-                                          Conds:RS_370._col1=RS_371._col0(Inner),RS_370._col1=RS_372._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+                                        Merge Join Operator [MERGEJOIN_883] (rows=696935432 width=135)
+                                          Conds:RS_366._col1=RS_367._col0(Inner),RS_366._col1=RS_368._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
                                         <-Map 96 [SIMPLE_EDGE]
-                                          SHUFFLE [RS_371]
+                                          SHUFFLE [RS_367]
                                             PartitionCols:_col0
-                                            Select Operator [SEL_284] (rows=462000 width=1436)
+                                            Select Operator [SEL_280] (rows=462000 width=1436)
                                               Output:["_col0","_col1","_col2","_col3"]
-                                              Filter Operator [FIL_825] (rows=462000 width=1436)
+                                              Filter Operator [FIL_818] (rows=462000 width=1436)
                                                 predicate:i_item_sk is not null
-                                                TableScan [TS_89] (rows=462000 width=1436)
+                                                TableScan [TS_87] (rows=462000 width=1436)
                                                   default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
                                         <-Reducer 45 [SIMPLE_EDGE]
-                                          SHUFFLE [RS_372]
+                                          SHUFFLE [RS_368]
                                             PartitionCols:_col0
-                                            Group By Operator [GBY_365] (rows=254100 width=1436)
+                                            Group By Operator [GBY_361] (rows=254100 width=1436)
                                               Output:["_col0"],keys:KEY._col0
                                             <-Reducer 44 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_364]
+                                              SHUFFLE [RS_360]
                                                 PartitionCols:_col0
-                                                Group By Operator [GBY_363] (rows=508200 width=1436)
+                                                Group By Operator [GBY_359] (rows=508200 width=1436)
                                                   Output:["_col0"],keys:_col0
-                                                  Merge Join Operator [MERGEJOIN_889] (rows=508200 width=1436)
-                                                    Conds:RS_359._col1, _col2, _col3=RS_360._col0, _col1, _col2(Inner),Output:["_col0"]
+                                                  Merge Join Operator [MERGEJOIN_882] (rows=508200 width=1436)
+                                                    Conds:RS_355._col1, _col2, _col3=RS_356._col0, _col1, _col2(Inner),Output:["_col0"]
                                                   <-Map 96 [SIMPLE_EDGE]
-                                                    SHUFFLE [RS_359]
+                                                    SHUFFLE [RS_355]
                                                       PartitionCols:_col1, _col2, _col3
-                                                      Select Operator [SEL_287] (rows=462000 width=1436)
+                                                      Select Operator [SEL_283] (rows=462000 width=1436)
                                                         Output:["_col0","_col1","_col2","_col3"]
-                                                        Filter Operator [FIL_826] (rows=462000 width=1436)
+                                                        Filter Operator [FIL_819] (rows=462000 width=1436)
                                                           predicate:(i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_item_sk is not null)
-                                                           Please refer to the previous TableScan [TS_89]
+                                                           Please refer to the previous TableScan [TS_87]
                                                   <-Reducer 43 [SIMPLE_EDGE]
-                                                    SHUFFLE [RS_360]
+                                                    SHUFFLE [RS_356]
                                                       PartitionCols:_col0, _col1, _col2
-                                                      Select Operator [SEL_358] (rows=1 width=108)
+                                                      Select Operator [SEL_354] (rows=1 width=108)
                                                         Output:["_col0","_col1","_col2"]
-                                                        Filter Operator [FIL_357] (rows=1 width=108)
+                                                        Filter Operator [FIL_353] (rows=1 width=108)
                                                           predicate:(_col3 = 3)
-                                                          Group By Operator [GBY_356] (rows=304916424 width=108)
+                                                          Group By Operator [GBY_352] (rows=304916424 width=108)
                                                             Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                                           <-Union 42 [SIMPLE_EDGE]
                                                             <-Reducer 41 [CONTAINS]
-                                                              Reduce Output Operator [RS_355]
+                                                              Reduce Output Operator [RS_351]
                                                                 PartitionCols:_col0, _col1, _col2
-                                                                Group By Operator [GBY_354] (rows=609832849 width=108)
+                                                                Group By Operator [GBY_350] (rows=609832849 width=108)
                                                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
-                                                                  Group By Operator [GBY_307] (rows=348477374 width=88)
+                                                                  Group By Operator [GBY_303] (rows=348477374 width=88)
                                                                     Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                                                   <-Reducer 40 [SIMPLE_EDGE]
-                                                                    SHUFFLE [RS_306]
+                                                                    SHUFFLE [RS_302]
                                                                       PartitionCols:_col0, _col1, _col2
-                                                                      Group By Operator [GBY_305] (rows=696954748 width=88)
+                                                                      Group By Operator [GBY_301] (rows=696954748 width=88)
                                                                         Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
-                                                                        Select Operator [SEL_303] (rows=696954748 width=88)
+                                                                        Select Operator [SEL_299] (rows=696954748 width=88)
                                                                           Output:["_col0","_col1","_col2"]
-                                                                          Merge Join Operator [MERGEJOIN_884] (rows=696954748 width=88)
-                                                                            Conds:RS_300._col1=RS_301._col0(Inner),Output:["_col5","_col6","_col7"]
+                                                                          Merge Join Operator [MERGEJOIN_877] (rows=696954748 width=88)
+                                                                            Conds:RS_296._col1=RS_297._col0(Inner),Output:["_col5","_col6","_col7"]
                                                                           <-Map 96 [SIMPLE_EDGE]
-                                                                            SHUFFLE [RS_301]
+                                                                            SHUFFLE [RS_297]
                                                                               PartitionCols:_col0
-                                                                              Select Operator [SEL_296] (rows=462000 width=1436)
+                                                                              Select Operator [SEL_292] (rows=462000 width=1436)
                                                                                 Output:["_col0","_col1","_col2","_col3"]
-                                                                                Filter Operator [FIL_829] (rows=462000 width=1436)
+                                                                                Filter Operator [FIL_822] (rows=462000 width=1436)
                                                                                   predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
-                                                                                   Please refer to the previous TableScan [TS_89]
+                                                                                   Please refer to the previous TableScan [TS_87]
                                                                           <-Reducer 39 [SIMPLE_EDGE]
-                                                                            SHUFFLE [RS_300]
+                                                                            SHUFFLE [RS_296]
                                                                               PartitionCols:_col1
-                                                                              Merge Join Operator [MERGEJOIN_883] (rows=633595212 width=88)
-                                                                                Conds:RS_297._col0=RS_298._col0(Inner),Output:["_col1"]
+                                                                              Merge Join Operator [MERGEJOIN_876] (rows=633595212 width=88)
+                                                                                Conds:RS_293._col0=RS_294._col0(Inner),Output:["_col1"]
                                                                               <-Map 17 [SIMPLE_EDGE]
-                                                                                SHUFFLE [RS_298]
+                                                                                SHUFFLE [RS_294]
                                                                                   PartitionCols:_col0
-                                                                                  Select Operator [SEL_293] (rows=8116 width=1119)
+                                                                                  Select Operator [SEL_289] (rows=8116 width=1119)
                                                                                     Output:["_col0"]
-                                                                                    Filter Operator [FIL_828] (rows=8116 width=1119)
+                                                                                    Filter Operator [FIL_821] (rows=8116 width=1119)
                                                                                       predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                                                        Please refer to the previous TableScan [TS_3]
                                                                               <-Map 97 [SIMPLE_EDGE]
-                                                                                SHUFFLE [RS_297]
+                                                                                SHUFFLE [RS_293]
                                                                                   PartitionCols:_col0
-                                                                                  Select Operator [SEL_290] (rows=575995635 width=88)
+                                                                                  Select Operator [SEL_286] (rows=575995635 width=88)
                                                                                     Output:["_col0","_col1"]
-                                                                                    Filter Operator [FIL_827] (rows=575995635 width=88)
+                                                                                    Filter Operator [FIL_820] (rows=575995635 width=88)
                                                                                       predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
-                                                                                      TableScan [TS_95] (rows=575995635 width=88)
+                                                                                      TableScan [TS_93] (rows=575995635 width=88)
                                                                                         default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"]
                                                             <-Reducer 50 [CONTAINS]
-                                                              Reduce Output Operator [RS_355]
+                                                              Reduce Output Operator [RS_351]
                                                                 PartitionCols:_col0, _col1, _col2
-                                                                Group By Operator [GBY_354] (rows=609832849 width=108)
+                                                                Group By Operator [GBY_350] (rows=609832849 width=108)
                                                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
-                                                                  Group By Operator [GBY_328] (rows=174233858 width=135)
+                                                                  Group By Operator [GBY_324] (rows=174233858 width=135)
                                                                     Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                                                   <-Reducer 49 [SIMPLE_EDGE]
-                                                                    SHUFFLE [RS_327]
+                                                                    SHUFFLE [RS_323]
                                                                       PartitionCols:_col0, _col1, _col2
-                                                                      Group By Operator [GBY_326] (rows=348467716 width=135)
+                                                                      Group By Operator [GBY_322] (rows=348467716 width=135)
                                                                         Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
-                                                                        Select Operator [SEL_324] (rows=348467716 width=135)
+                                                                        Select Operator [SEL_320] (rows=348467716 width=135)
                                                                           Output:["_col0","_col1","_col2"]
-                                                                          Merge Join Operator [MERGEJOIN_886] (rows=348467716 width=135)
-                                                                            Conds:RS_321._col1=RS_322._col0(Inner),Output:["_col5","_col6","_col7"]
+                                                                          Merge Join Operator [MERGEJOIN_879] (rows=348467716 width=135)
+                                                                            Conds:RS_317._col1=RS_318._col0(Inner),Output:["_col5","_col6","_col7"]
                                                                           <-Map 96 [SIMPLE_EDGE]
-                                                                            SHUFFLE [RS_322]
+                                                                            SHUFFLE [RS_318]
                                                                               PartitionCols:_col0
-                                                                              Select Operator [SEL_317] (rows=462000 width=1436)
+                                                                              Select Operator [SEL_313] (rows=462000 width=1436)
                                                                                 Output:["_col0","_col1","_col2","_col3"]
-                                                                                Filter Operator [FIL_832] (rows=462000 width=1436)
+                                                                                Filter Operator [FIL_825] (rows=462000 width=1436)
                                                                                   predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
-                                                                                   Please refer to the previous TableScan [TS_89]
+                                                                                   Please refer to the previous TableScan [TS_87]
                                                                           <-Reducer 48 [SIMPLE_EDGE]
-                                                                            SHUFFLE [RS_321]
+                                                                            SHUFFLE [RS_317]
                                                                               PartitionCols:_col1
-                                                                              Merge Join Operator [MERGEJOIN_885] (rows=316788826 width=135)
-                                                                                Conds:RS_318._col0=RS_319._col0(Inner),Output:["_col1"]
+                                                                              Merge Join Operator [MERGEJOIN_878] (rows=316788826 width=135)
+                                                                                Conds:RS_314._col0=RS_315._col0(Inner),Output:["_col1"]
                                                                               <-Map 17 [SIMPLE_EDGE]
-                                                                                SHUFFLE [RS_319]
+                                                                                SHUFFLE [RS_315]
                                                                                   PartitionCols:_col0
-                                                                                  Select Operator [SEL_314] (rows=8116 width=1119)
+                                                                                  Select Operator [SEL_310] (rows=8116 width=1119)
                                                                                     Output:["_col0"]
-                                                                                    Filter Operator [FIL_831] (rows=8116 width=1119)
+                                                                                    Filter Operator [FIL_824] (rows=8116 width=1119)
                                                                                       predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                                                        Please refer to the previous TableScan [TS_3]
                                                                               <-Map 98 [SIMPLE_EDGE]
-                                                                                SHUFFLE [RS_318]
+                                                                                SHUFFLE [RS_314]
                                                                                   PartitionCols:_col0
-                                                                                  Select Operator [SEL_311] (rows=287989836 width=135)
+                                                                                  Select Operator [SEL_307] (rows=287989836 width=135)
                                                                                     Output:["_col0","_col1"]
-                                                                                    Filter Operator [FIL_830] (rows=287989836 width=135)
+                                                                                    Filter Operator [FIL_823] (rows=287989836 width=135)
                                                                                       predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
-                                                                                      TableScan [TS_116] (rows=287989836 width=135)
+                                                                                      TableScan [TS_114] (rows=287989836 width=135)
                                                                                         default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk"]
                                                             <-Reducer 53 [CONTAINS]
-                                                              Reduce Output Operator [RS_355]
+                                                              Reduce Output Operator [RS_351]
                                                                 PartitionCols:_col0, _col1, _col2
-                                                                Group By Operator [GBY_354] (rows=609832849 width=108)
+                                                                Group By Operator [GBY_350] (rows=609832849 width=108)
                                                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
-                                                                  Group By Operator [GBY_350] (rows=87121617 width=135)
+                                                                  Group By Operator [GBY_346] (rows=87121617 width=135)
                                                                     Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                                                   <-Reducer 52 [SIMPLE_EDGE]
-                                                                    SHUFFLE [RS_349]
+                                                                    SHUFFLE [RS_345]
                                                                       PartitionCols:_col0, _col1, _col2
-                                                                      Group By Operator [GBY_348] (rows=174243235 width=135)
+                                                                      Group By Operator [GBY_344] (rows=174243235 width=135)
                                                                         Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
-                                                                        Select Operator [SEL_346] (rows=174243235 width=135)
+                                                                        Select Operator [SEL_342] (rows=174243235 width=135)
                                                                           Output:["_col0","_col1","_col2"]
-                                                                          Merge Join Operator [MERGEJOIN_888] (rows=174243235 width=135)
-                                                                            Conds:RS_343._col1=RS_344._col0(Inner),Output:["_col5","_col6","_col7"]
+                                                                          Merge Join Operator [MERGEJOIN_881] (rows=174243235 width=135)
+                                                                            Conds:RS_339._col1=RS_340._col0(Inner),Output:["_col5","_col6","_col7"]
                                                                           <-Map 96 [SIMPLE_EDGE]
-                                                                            SHUFFLE [RS_344]
+                                                                            SHUFFLE [RS_340]
                                                                               PartitionCols:_col0
-                                                                              Select Operator [SEL_339] (rows=462000 width=1436)
+                                                                              Select Operator [SEL_335] (rows=462000 width=1436)
                                                                                 Output:["_col0","_col1","_col2","_col3"]
-                                                                                Filter Operator [FIL_835] (rows=462000 width=1436)
+                                                                                Filter Operator [FIL_828] (rows=462000 width=1436)
                                                                                   predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
-                                                                                   Please refer to the previous TableScan [TS_89]
+                                                                                   Please refer to the previous TableScan [TS_87]
                                                                           <-Reducer 51 [SIMPLE_EDGE]
-                                                                            SHUFFLE [RS_343]
+                                                                            SHUFFLE [RS_339]
                                                                               PartitionCols:_col1
-                                                                              Merge Join Operator [MERGEJOIN_887] (rows=158402938 width=135)
-                                                                                Conds:RS_340._col0=RS_341._col0(Inner),Output:["_col1"]
+                                                                              Merge Join Operator [MERGEJOIN_880] (rows=158402938 width=135)
+                                                                                Conds:RS_336._col0=RS_337._col0(Inner),Output:["_col1"]
                                                                               <-Map 17 [SIMPLE_EDGE]
-                                                                                SHUFFLE [RS_341]
+                                                                                SHUFFLE [RS_337]
                                                                                   PartitionCols:_col0
-                                                                                  Select Operator [SEL_336] (rows=8116 width=1119)
+                                                                                  Select Operator [SEL_332] (rows=8116 width=1119)
                                                                                     Output:["_col0"]
-                                                                                    Filter Operator [FIL_834] (rows=8116 width=1119)
+                                                                                    Filter Operator [FIL_827] (rows=8116 width=1119)
                                                                                       predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                                                        Please refer to the previous TableScan [TS_3]
                                                                               <-Map 99 [SIMPLE_EDGE]
-                                                                                SHUFFLE [RS_340]
+                                                                                SHUFFLE [RS_336]
                                                                                   PartitionCols:_col0
-                                                                                  Select Operator [SEL_333] (rows=144002668 width=135)
+                                                                                  Select Operator [SEL_329] (rows=144002668 width=135)
                                                                                     Output:["_col0","_col1"]
-                                                                                    Filter Operator [FIL_833] (rows=144002668 width=135)
+                                                                                    Filter Operator [FIL_826] (rows=144002668 width=135)
                                                                                       predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
-                                                                                      TableScan [TS_138] (rows=144002668 width=135)
+                                                                                      TableScan [TS_136] (rows=144002668 width=135)
                                                                                         default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"]
                                         <-Reducer 94 [SIMPLE_EDGE]
-                                          SHUFFLE [RS_370]
+                                          SHUFFLE [RS_366]
                                             PartitionCols:_col1
-                                            Merge Join Operator [MERGEJOIN_882] (rows=316788826 width=135)
-                                              Conds:RS_367._col0=RS_368._col0(Inner),Output:["_col1","_col2","_col3"]
+                                            Merge Join Operator [MERGEJOIN_875] (rows=316788826 width=135)
+                                              Conds:RS_363._col0=RS_364._col0(Inner),Output:["_col1","_col2","_col3"]
                                             <-Map 93 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_368]
+                                              SHUFFLE [RS_364]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_281] (rows=18262 width=1119)
+                                                Select Operator [SEL_277] (rows=18262 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_824] (rows=18262 width=1119)
+                                                  Filter Operator [FIL_817] (rows=18262 width=1119)
                                                     predicate:((d_year = 2000) and (d_moy = 11) and d_date_sk is not null)
-                                                    TableScan [TS_86] (rows=73049 width=1119)
+                                                    TableScan [TS_84] (rows=73049 width=1119)
                                                       default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                                             <-Map 100 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_367]
+                                              SHUFFLE [RS_363]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_278] (rows=287989836 width=135)
+                                                Select Operator [SEL_274] (rows=287989836 width=135)
                                                   Output:["_col0","_col1","_col2","_col3"]
-                                                  Filter Operator [FIL_823] (rows=287989836 width=135)
+                                                  Filter Operator [FIL_816] (rows=287989836 width=135)
                                                     predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
-                                                    TableScan [TS_276] (rows=287989836 width=135)
+                                                    TableScan [TS_272] (rows=287989836 width=135)
                                                       default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk","cs_quantity","cs_list_price"]
                   <-Reducer 16 [CONTAINS]
-                    Reduce Output Operator [RS_584]
+                    Reduce Output Operator [RS_577]
                       PartitionCols:_col0, _col1, _col2, _col3, _col4
-                      Group By Operator [GBY_583] (rows=2032776160 width=405)
+                      Group By Operator [GBY_576] (rows=2032776160 width=405)
                         Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0
-                        Select Operator [SEL_580] (rows=58081078 width=432)
+                        Select Operator [SEL_573] (rows=58081078 width=432)
                           Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                          Filter Operator [FIL_579] (rows=58081078 width=432)
+                          Filter Operator [FIL_572] (rows=58081078 width=432)
                             predicate:(_col5 > _col1)
-                            Merge Join Operator [MERGEJOIN_908] (rows=174243235 width=432)
+                            Merge Join Operator [MERGEJOIN_901] (rows=174243235 width=432)
                               Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
                             <-Reducer 15 [CUSTOM_SIMPLE_EDGE]
-                              PARTITION_ONLY_SHUFFLE [RS_575]
-                                Select Operator [SEL_432] (rows=1 width=8)
-                                  Filter Operator [FIL_431] (rows=1 width=8)
+                              PARTITION_ONLY_SHUFFLE [RS_568]
+                                Select Operator [SEL_426] (rows=1 width=8)
+                                  Filter Operator [FIL_425] (rows=1 width=8)
                                     predicate:(sq_count_check(_col0) <= 1)
-                                    Group By Operator [GBY_429] (rows=1 width=8)
+                                    Group By Operator [GBY_423] (rows=1 width=8)
                                       Output:["_col0"],aggregations:["count()"]
-                                      Select Operator [SEL_424] (rows=1 width=8)
-                                        Group By Operator [GBY_423] (rows=1 width=8)
+                                      Select Operator [SEL_418] (rows=1 width=8)
+                                        Group By Operator [GBY_417] (rows=1 width=8)
                                           Output:["_col0"],aggregations:["count(VALUE._col0)"]
                                         <-Union 14 [CUSTOM_SIMPLE_EDGE]
                                           <-Reducer 13 [CONTAINS]
-                                            Reduce Output Operator [RS_422]
-                                              Group By Operator [GBY_421] (rows=1 width=8)
+                                            Reduce Output Operator [RS_416]
+                                              Group By Operator [GBY_415] (rows=1 width=8)
                                                 Output:["_col0"],aggregations:["count(_col0)"]
-                                                Select Operator [SEL_420] (rows=1108786976 width=108)
+                                                Select Operator [SEL_414] (rows=1108786976 width=108)
                                                   Output:["_col0"]
-                                                  Select Operator [SEL_397] (rows=633595212 width=88)
+                                                  Select Operator [SEL_392] (rows=633595212 width=88)
                                                     Output:["_col0"]
-                                                    Merge Join Operator [MERGEJOIN_891] (rows=633595212 width=88)
-                                                      Conds:RS_394._col0=RS_395._col0(Inner),Output:["_col1"]
+                                                    Merge Join Operator [MERGEJOIN_884] (rows=633595212 width=88)
+                                                      Conds:RS_389._col0=RS_390._col0(Inner),Output:["_col1"]
                                                     <-Map 17 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_395]
+                                                      SHUFFLE [RS_390]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_393] (rows=8116 width=1119)
+                                                        Select Operator [SEL_388] (rows=8116 width=1119)
                                                           Output:["_col0"]
-                                                          Filter Operator [FIL_837] (rows=8116 width=1119)
+                                                          Filter Operator [FIL_830] (rows=8116 width=1119)
                                                             predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                              Please refer to the previous TableScan [TS_3]
                                                     <-Map 1 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_394]
+                                                      SHUFFLE [RS_389]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_390] (rows=575995635 width=88)
+                                                        Select Operator [SEL_385] (rows=575995635 width=88)
                                                           Output:["_col0","_col1"]
-                                                          Filter Operator [FIL_836] (rows=575995635 width=88)
+                                                          Filter Operator [FIL_829] (rows=575995635 width=88)
                                                             predicate:ss_sold_date_sk is not null
                                                              Please refer to the previous TableScan [TS_0]
                                           <-Reducer 75 [CONTAINS]
-                                            Reduce Output Operator [RS_422]
-                                              Group By Operator [GBY_421] (rows=1 width=8)
+                                            Reduce Output Operator [RS_416]
+                                              Group By Operator [GBY_415] (rows=1 width=8)
                                                 Output:["_col0"],aggregations:["count(_col0)"]
-                                                Select Operator [SEL_420] (rows=1108786976 width=108)
+                                                Select Operator [SEL_414] (rows=1108786976 width=108)
                                                   Output:["_col0"]
-                                                  Select Operator [SEL_407] (rows=316788826 width=135)
+                                                  Select Operator [SEL_402] (rows=316788826 width=135)
                                                     Output:["_col0"]
-                                                    Merge Join Operator [MERGEJOIN_892] (rows=316788826 width=135)
-                                                      Conds:RS_404._col0=RS_405._col0(Inner),Output:["_col1"]
+                                                    Merge Join Operator [MERGEJOIN_885] (rows=316788826 width=135)
+                                                      Conds:RS_399._col0=RS_400._col0(Inner),Output:["_col1"]
                                                     <-Map 76 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_405]
+                                                      SHUFFLE [RS_400]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_403] (rows=8116 width=1119)
+                                                        Select Operator [SEL_398] (rows=8116 width=1119)
                                                           Output:["_col0"]
-                                                          Filter Operator [FIL_839] (rows=8116 width=1119)
+                                                          Filter Operator [FIL_832] (rows=8116 width=1119)
                                                             predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
                                                              Please refer to the previous TableScan [TS_13]
                                                     <-Map 72 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_404]
+                                                      SHUFFLE [RS_399]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_400] (rows=287989836 width=135)
+                                                        Select Operator [SEL_395] (rows=287989836 width=135)
                                                           Output:["_col0","_col1"]
-                                                          Filter Operator [FIL_838] (rows=287989836 width=135)
+                                                          Filter Operator [FIL_831] (rows=287989836 width=135)
                                                             predicate:cs_sold_date_sk is not null
                                                              Please refer to the previous TableScan [TS_10]
                                           <-Reducer 83 [CONTAINS]
-                                            Reduce Output Operator [RS_422]
-                                              Group By Operator [GBY_421] (rows=1 width=8)
+                                            Reduce Output Operator [RS_416]
+                                              Group By Operator [GBY_415] (rows=1 width=8)
                                                 Output:["_col0"],aggregations:["count(_col0)"]
-                                                Select Operator [SEL_420] (rows=1108786976 width=108)
+                                                Select Operator [SEL_414] (rows=1108786976 width=108)
                                                   Output:["_col0"]
-                                                  Select Operator [SEL_419] (rows=158402938 width=135)
+                                                  Select Operator [SEL_413] (rows=158402938 width=135)
                                                     Output:["_col0"]
-                                                    Merge Join Operator [MERGEJOIN_893] (rows=158402938 width=135)
-                                                      Conds:RS_416._col0=RS_417._col0(Inner),Output:["_col1"]
+                                                    Merge Join Operator [MERGEJOIN_886] (rows=158402938 width=135)
+                                                      Conds:RS_410._col0=RS_411._col0(Inner),Output:["_col1"]
                                                     <-Map 84 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_417]
+                                                      SHUFFLE [RS_411]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_415] (rows=8116 width=1119)
+                                                        Select Operator [SEL_409] (rows=8116 width=1119)
                                                           Output:["_col0"]
-                                                          Filter Operator [FIL_841] (rows=8116 width=1119)
+                                                          Filter Operator [FIL_834] (rows=8116 width=1119)
                                                             predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
-                                                             Please refer to the previous TableScan [TS_25]
+                                                             Please refer to the previous TableScan [TS_24]
                                                     <-Map 80 [SIMPLE_EDGE]
-                                                      SHUFFLE [RS_416]
+                                                      SHUFFLE [RS_410]
                                                         PartitionCols:_col0
-                                                        Select Operator [SEL_412] (rows=144002668 width=135)
+                                                        Select Operator [SEL_406] (rows=144002668 width=135)
                                                           Output:["_col0","_col1"]
-                                                          Filter Operator [FIL_840] (rows=144002668 width=135)
+                                                          Filter Operator [FIL_833] (rows=144002668 width=135)
                                                             predicate:ws_sold_date_sk is not null
-                                                             Please refer to the previous TableScan [TS_22]
+                                                             Please refer to the previous TableScan [TS_21]
                             <-Reducer 56 [CUSTOM_SIMPLE_EDGE]
-                              PARTITION_ONLY_SHUFFLE [RS_576]
-                                Group By Operator [GBY_469] (rows=1 width=288)
+                              PARTITION_ONLY_SHUFFLE [RS_569]
+                                Group By Operator [GBY_462] (rows=1 width=288)
                                   Output:["_col0"],aggregations:["avg(VALUE._col0)"]
                                 <-Union 55 [CUSTOM_SIMPLE_EDGE]
                                   <-Reducer 54 [CONTAINS]
-                                    Reduce Output Operator [RS_468]
-                                      Group By Operator [GBY_467] (rows=1 width=288)
+                                    Reduce Output Operator [RS_461]
+                                      Group By Operator [GBY_460] (rows=1 width=288)
                                         Output:["_col0"],aggregations:["avg(_col0)"]
-                                        Select Operator [SEL_465] (rows=1108786976 width=108)
+                                        Select Operator [SEL_458] (rows=1108786976 width=108)
                                           Output:["_col0"]
-                                          Select Operator [SEL_442] (rows=633595212 width=88)
+                                          Select Operator [SEL_436] (rows=633595212 width=88)
                                             Output:["_col0","_col1"]
-                                            Merge Join Operator [MERGEJOIN_894] (rows=633595212 width=88)
-                                              Conds:RS_439._col0=RS_440._col0(Inner),Output:["_col1","_col2"]
+                                            Merge Join Operator [MERGEJOIN_887] (rows=633595212 width=88)
+                                              Conds:RS_433._col0=RS_434._col0(Inner),Output:["_col1","_col2"]
                                             <-Map 17 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_440]
+                                              SHUFFLE [RS_434]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_438] (rows=8116 width=1119)
+                                                Select Operator [SEL_432] (rows=8116 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_843] (rows=8116 width=1119)
+                                                  Filter Operator [FIL_836] (rows=8116 width=1119)
                                                     predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
                                                      Please refer to the previous TableScan [TS_3]
                                             <-Map 88 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_439]
+                                              SHUFFLE [RS_433]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_435] (rows=575995635 width=88)
+                                                Select Operator [SEL_429] (rows=575995635 width=88)
                                                   Output:["_col0","_col1","_col2"]
-                                                  Filter Operator [FIL_842] (rows=575995635 width=88)
+                                                  Filter Operator [FIL_835] (rows=575995635 width=88)
                                                     predicate:ss_sold_date_sk is not null
-                                                     Please refer to the previous TableScan [TS_45]
+                                                     Please refer to the previous TableScan [TS_44]
                                   <-Reducer 79 [CONTAINS]
-                                    Reduce Output Operator [RS_468]
-                                      Group By Operator [GBY_467] (rows=1 width=288)
+                                    Reduce Output Operator [RS_461]
+                                      Group By Operator [GBY_460] (rows=1 width=288)
                                         Output:["_col0"],aggregations:["avg(_col0)"]
-                                        Select Operator [SEL_465] (rows=1108786976 width=108)
+                                        Select Operator [SEL_458] (rows=1108786976 width=108)
                                           Output:["_col0"]
-                                          Select Operator [SEL_452] (rows=316788826 width=135)
+                                          Select Operator [SEL_446] (rows=316788826 width=135)
                                             Output:["_col0","_col1"]
-                                            Merge Join Operator [MERGEJOIN_895] (rows=316788826 width=135)
-                                              Conds:RS_449._col0=RS_450._col0(Inner),Output:["_col1","_col2"]
+                                            Merge Join Operator [MERGEJOIN_888] (rows=316788826 width=135)
+                                              Conds:RS_443._col0=RS_444._col0(Inner),Output:["_col1","_col2"]
                                             <-Map 76 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_450]
+                                              SHUFFLE [RS_444]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_448] (rows=8116 width=1119)
+                                                Select Operator [SEL_442] (rows=8116 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_845] (rows=8116 width=1119)
+                                                  Filter Operator [FIL_838] (rows=8116 width=1119)
                                                     predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
                                                      Please refer to the previous TableScan [TS_13]
                                             <-Map 89 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_449]
+                                              SHUFFLE [RS_443]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_445] (rows=287989836 width=135)
+                                                Select Operator [SEL_439] (rows=287989836 width=135)
                                                   Output:["_col0","_col1","_col2"]
-                                                  Filter Operator [FIL_844] (rows=287989836 width=135)
+                                                  Filter Operator [FIL_837] (rows=287989836 width=135)
                                                     predicate:cs_sold_date_sk is not null
-                                                     Please refer to the previous TableScan [TS_55]
+                                                     Please refer to the previous TableScan [TS_54]
                                   <-Reducer 87 [CONTAINS]
-                                    Reduce Output Operator [RS_468]
-                                      Group By Operator [GBY_467] (rows=1 width=288)
+                                    Reduce Output Operator [RS_461]
+                                      Group By Operator [GBY_460] (rows=1 width=288)
                                         Output:["_col0"],aggregations:["avg(_col0)"]
-                                        Select Operator [SEL_465] (rows=1108786976 width=108)
+                                        Select Operator [SEL_458] (rows=1108786976 width=108)
                                           Output:["_col0"]
-                                          Select Operator [SEL_464] (rows=158402938 width=135)
+                                          Select Operator [SEL_457] (rows=158402938 width=135)
                                             Output:["_col0","_col1"]
-                                            Merge Join Operator [MERGEJOIN_896] (rows=158402938 width=135)
-                                              Conds:RS_461._col0=RS_462._col0(Inner),Output:["_col1","_col2"]
+                                            Merge Join Operator [MERGEJOIN_889] (rows=158402938 width=135)
+                                              Conds:RS_454._col0=RS_455._col0(Inner),Output:["_col1","_col2"]
                                             <-Map 84 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_462]
+                                              SHUFFLE [RS_455]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_460] (rows=8116 width=1119)
+                                                Select Operator [SEL_453] (rows=8116 width=1119)
                                                   Output:["_col0"]
-                                                  Filter Operator [FIL_847] (rows=8116 width=1119)
+                                                  Filter Operator [FIL_840] (rows=8116 width=1119)
                                                     predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
-                                                     Please refer to the previous TableScan [TS_25]
+                                                     Please refer to the previous TableScan [TS_24]
                                             <-Map 90 [SIMPLE_EDGE]
-                                              SHUFFLE [RS_461]
+                                              SHUFFLE [RS_454]
                                                 PartitionCols:_col0
-                                                Select Operator [SEL_457] (rows=144002668 width=135)
+                                                Select Operator [SEL_450] (rows=144002668 width=135)
                                                   Output:["_col0","_col1","_col2"]
-                                                  Filter Operator [FIL_846] (rows=144002668 width=135)
+                                                  Filter Operator [FIL_839] (rows=144002668 width=135)
                                                     predicate:ws_sold_date_sk is not null
-                                                     Please refer to the previous TableScan [TS_67]
+                                                     Please refer to the previous TableScan [TS_65]
                             <-Reducer 65 [CUSTOM_SIMPLE_EDGE]
-                              PARTITION_ONLY_SHUFFLE [RS_577]
-                                Group By Operator [GBY_573] (rows=174243235 width=135)
+                              PARTITION_ONLY_SHUFFLE [RS_570]
+                                Group By Operator [GBY_566] (rows=174243235 width=135)
                                   Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2
                                 <-Reducer 64 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_572]
+                                  SHUFFLE [RS_565]
                                     PartitionCols:_col0, _col1, _col2
-                                    Group By Operator [GBY_571] (rows=348486471 width=135)
+                                    Group By Operator [GBY_564] (rows=348486471 width=135)
                                       Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2
-                                      Select Operator [SEL_569] (rows=348486471 width=135)
+                                      Select Operator [SEL_562] (rows=348486471 width=135)
                                         Output:["_col0","_col1","_col2","_col3"]
-                                        Merge Join Operator [MERGEJOIN_905] (rows=348486471 width=135)
-                                          Conds:RS_565._col1=RS_566._col0(Inner),RS_

<TRUNCATED>

Mime
View raw message