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>