http://git-wip-us.apache.org/repos/asf/hive/blob/696affa2/ql/src/test/results/clientpositive/perf/tez/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query14.q.out b/ql/src/test/results/clientpositive/perf/tez/query14.q.out
index 4461f02..8e21934 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query14.q.out
@@ -1,6 +1,6 @@
-Warning: Shuffle Join MERGEJOIN[890][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
-Warning: Shuffle Join MERGEJOIN[891][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
-Warning: Shuffle Join MERGEJOIN[892][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product
+Warning: Shuffle Join MERGEJOIN[893][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
+Warning: Shuffle Join MERGEJOIN[894][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
+Warning: Shuffle Join MERGEJOIN[895][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product
PREHOOK: query: explain
with cross_items as
(select i_item_sk ss_item_sk
@@ -281,726 +281,726 @@ Stage-0
limit:100
Stage-1
Reducer 8
- File Output Operator [FS_574]
- Limit [LIM_573] (rows=100 width=237)
+ File Output Operator [FS_577]
+ Limit [LIM_576] (rows=100 width=237)
Number of rows:100
- Select Operator [SEL_572] (rows=1016388080 width=237)
+ Select Operator [SEL_575] (rows=1016388080 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Reducer 7 [SIMPLE_EDGE]
- SHUFFLE [RS_571]
- Select Operator [SEL_570] (rows=1016388080 width=237)
+ SHUFFLE [RS_574]
+ Select Operator [SEL_573] (rows=1016388080 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Group By Operator [GBY_569] (rows=1016388080 width=237)
+ Group By Operator [GBY_572] (rows=1016388080 width=237)
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_568]
+ Reduce Output Operator [RS_571]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_567] (rows=2032776160 width=237)
+ Group By Operator [GBY_570] (rows=2032776160 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0L
- Select Operator [SEL_375] (rows=116155905 width=264)
+ Select Operator [SEL_377] (rows=116155905 width=264)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_374] (rows=116155905 width=264)
+ Filter Operator [FIL_376] (rows=116155905 width=264)
predicate:(_col5 > _col1)
- Merge Join Operator [MERGEJOIN_891] (rows=348467716 width=264)
+ Merge Join Operator [MERGEJOIN_894] (rows=348467716 width=264)
Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
<-Reducer 11 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_370]
- Select Operator [SEL_231] (rows=1 width=8)
- Filter Operator [FIL_230] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_372]
+ Select Operator [SEL_233] (rows=1 width=8)
+ Filter Operator [FIL_232] (rows=1 width=8)
predicate:(sq_count_check(_col0) <= 1)
- Group By Operator [GBY_228] (rows=1 width=8)
+ Group By Operator [GBY_230] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_223] (rows=1 width=8)
- Group By Operator [GBY_222] (rows=1 width=8)
+ Select Operator [SEL_225] (rows=1 width=8)
+ Group By Operator [GBY_224] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Union 10 [CUSTOM_SIMPLE_EDGE]
<-Reducer 19 [CONTAINS]
- Reduce Output Operator [RS_221]
- Group By Operator [GBY_220] (rows=1 width=8)
+ Reduce Output Operator [RS_223]
+ Group By Operator [GBY_222] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_219] (rows=1108786976 width=108)
+ Select Operator [SEL_220] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_207] (rows=316788826 width=135)
+ Select Operator [SEL_208] (rows=316788826 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_861] (rows=316788826 width=135)
- Conds:RS_204._col0=RS_205._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_864] (rows=316788826 width=135)
+ Conds:RS_205._col0=RS_206._col0(Inner),Output:["_col1"]
<-Map 21 [SIMPLE_EDGE]
- SHUFFLE [RS_205]
+ SHUFFLE [RS_206]
PartitionCols:_col0
Select Operator [SEL_15] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_773] (rows=8116 width=1119)
+ Filter Operator [FIL_776] (rows=8116 width=1119)
predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000)
TableScan [TS_13] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 17 [SIMPLE_EDGE]
- SHUFFLE [RS_204]
+ SHUFFLE [RS_205]
PartitionCols:_col0
Select Operator [SEL_12] (rows=287989836 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_772] (rows=287989836 width=135)
+ Filter Operator [FIL_775] (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 33 [CONTAINS]
- Reduce Output Operator [RS_221]
- Group By Operator [GBY_220] (rows=1 width=8)
+ Reduce Output Operator [RS_223]
+ Group By Operator [GBY_222] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_219] (rows=1108786976 width=108)
+ Select Operator [SEL_220] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_218] (rows=158402938 width=135)
+ Select Operator [SEL_219] (rows=158402938 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_862] (rows=158402938 width=135)
- Conds:RS_215._col0=RS_216._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_865] (rows=158402938 width=135)
+ Conds:RS_216._col0=RS_217._col0(Inner),Output:["_col1"]
<-Map 35 [SIMPLE_EDGE]
- SHUFFLE [RS_216]
+ SHUFFLE [RS_217]
PartitionCols:_col0
Select Operator [SEL_26] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_775] (rows=8116 width=1119)
+ Filter Operator [FIL_778] (rows=8116 width=1119)
predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000)
TableScan [TS_24] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 31 [SIMPLE_EDGE]
- SHUFFLE [RS_215]
+ SHUFFLE [RS_216]
PartitionCols:_col0
Select Operator [SEL_23] (rows=144002668 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_774] (rows=144002668 width=135)
+ Filter Operator [FIL_777] (rows=144002668 width=135)
predicate:ws_sold_date_sk is not null
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_221]
- Group By Operator [GBY_220] (rows=1 width=8)
+ Reduce Output Operator [RS_223]
+ Group By Operator [GBY_222] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_219] (rows=1108786976 width=108)
+ Select Operator [SEL_220] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_197] (rows=633595212 width=88)
+ Select Operator [SEL_198] (rows=633595212 width=88)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_860] (rows=633595212 width=88)
- Conds:RS_194._col0=RS_195._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_863] (rows=633595212 width=88)
+ Conds:RS_195._col0=RS_196._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_195]
+ SHUFFLE [RS_196]
PartitionCols:_col0
- Select Operator [SEL_98] (rows=8116 width=1119)
+ Select Operator [SEL_99] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_787] (rows=8116 width=1119)
+ Filter Operator [FIL_790] (rows=8116 width=1119)
predicate:(d_date_sk is not null and d_year BETWEEN 1999 AND 2001)
- TableScan [TS_96] (rows=73049 width=1119)
+ TableScan [TS_97] (rows=73049 width=1119)
default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 1 [SIMPLE_EDGE]
- SHUFFLE [RS_194]
+ SHUFFLE [RS_195]
PartitionCols:_col0
Select Operator [SEL_2] (rows=575995635 width=88)
Output:["_col0","_col1"]
- Filter Operator [FIL_770] (rows=575995635 width=88)
+ Filter Operator [FIL_773] (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 27 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_371]
- Select Operator [SEL_268] (rows=1 width=120)
+ PARTITION_ONLY_SHUFFLE [RS_373]
+ Select Operator [SEL_270] (rows=1 width=120)
Output:["_col0"]
- Group By Operator [GBY_267] (rows=1 width=120)
+ Group By Operator [GBY_269] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"]
<-Union 26 [CUSTOM_SIMPLE_EDGE]
<-Reducer 25 [CONTAINS]
- Reduce Output Operator [RS_266]
- Group By Operator [GBY_265] (rows=1 width=120)
+ Reduce Output Operator [RS_268]
+ Group By Operator [GBY_267] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_263] (rows=1108786976 width=108)
+ Select Operator [SEL_265] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_251] (rows=316788826 width=135)
+ Select Operator [SEL_253] (rows=316788826 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_864] (rows=316788826 width=135)
- Conds:RS_248._col0=RS_249._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_867] (rows=316788826 width=135)
+ Conds:RS_250._col0=RS_251._col0(Inner),Output:["_col1","_col2"]
<-Map 21 [SIMPLE_EDGE]
- SHUFFLE [RS_249]
+ SHUFFLE [RS_251]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_15]
<-Map 43 [SIMPLE_EDGE]
- SHUFFLE [RS_248]
+ SHUFFLE [RS_250]
PartitionCols:_col0
- Select Operator [SEL_56] (rows=287989836 width=135)
+ Select Operator [SEL_57] (rows=287989836 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_778] (rows=287989836 width=135)
+ Filter Operator [FIL_781] (rows=287989836 width=135)
predicate:cs_sold_date_sk is not null
- TableScan [TS_54] (rows=287989836 width=135)
+ TableScan [TS_55] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity","cs_list_price"]
<-Reducer 37 [CONTAINS]
- Reduce Output Operator [RS_266]
- Group By Operator [GBY_265] (rows=1 width=120)
+ Reduce Output Operator [RS_268]
+ Group By Operator [GBY_267] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_263] (rows=1108786976 width=108)
+ Select Operator [SEL_265] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_262] (rows=158402938 width=135)
+ Select Operator [SEL_264] (rows=158402938 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_865] (rows=158402938 width=135)
- Conds:RS_259._col0=RS_260._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_868] (rows=158402938 width=135)
+ Conds:RS_261._col0=RS_262._col0(Inner),Output:["_col1","_col2"]
<-Map 35 [SIMPLE_EDGE]
- SHUFFLE [RS_260]
+ SHUFFLE [RS_262]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_26]
<-Map 44 [SIMPLE_EDGE]
- SHUFFLE [RS_259]
+ SHUFFLE [RS_261]
PartitionCols:_col0
- Select Operator [SEL_67] (rows=144002668 width=135)
+ Select Operator [SEL_68] (rows=144002668 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_780] (rows=144002668 width=135)
+ Filter Operator [FIL_783] (rows=144002668 width=135)
predicate:ws_sold_date_sk is not null
- TableScan [TS_65] (rows=144002668 width=135)
+ TableScan [TS_66] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"]
<-Reducer 41 [CONTAINS]
- Reduce Output Operator [RS_266]
- Group By Operator [GBY_265] (rows=1 width=120)
+ Reduce Output Operator [RS_268]
+ Group By Operator [GBY_267] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_263] (rows=1108786976 width=108)
+ Select Operator [SEL_265] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_241] (rows=633595212 width=88)
+ Select Operator [SEL_243] (rows=633595212 width=88)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_863] (rows=633595212 width=88)
- Conds:RS_238._col0=RS_239._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_866] (rows=633595212 width=88)
+ Conds:RS_240._col0=RS_241._col0(Inner),Output:["_col1","_col2"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_239]
+ SHUFFLE [RS_241]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_98]
+ Please refer to the previous Select Operator [SEL_99]
<-Map 39 [SIMPLE_EDGE]
- SHUFFLE [RS_238]
+ SHUFFLE [RS_240]
PartitionCols:_col0
- Select Operator [SEL_46] (rows=575995635 width=88)
+ Select Operator [SEL_47] (rows=575995635 width=88)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_776] (rows=575995635 width=88)
+ Filter Operator [FIL_779] (rows=575995635 width=88)
predicate:ss_sold_date_sk is not null
- TableScan [TS_44] (rows=575995635 width=88)
+ TableScan [TS_45] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity","ss_list_price"]
<-Reducer 52 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_372]
- Group By Operator [GBY_368] (rows=348467716 width=135)
+ PARTITION_ONLY_SHUFFLE [RS_374]
+ Group By Operator [GBY_370] (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 51 [SIMPLE_EDGE]
- SHUFFLE [RS_367]
+ SHUFFLE [RS_369]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_366] (rows=696935432 width=135)
+ Group By Operator [GBY_368] (rows=696935432 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2
- Select Operator [SEL_364] (rows=696935432 width=135)
+ Select Operator [SEL_366] (rows=696935432 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Merge Join Operator [MERGEJOIN_874] (rows=696935432 width=135)
- Conds:RS_360._col1=RS_361._col0(Inner),RS_360._col1=RS_362._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ Merge Join Operator [MERGEJOIN_877] (rows=696935432 width=135)
+ Conds:RS_362._col1=RS_363._col0(Inner),RS_362._col1=RS_364._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_361]
+ SHUFFLE [RS_363]
PartitionCols:_col0
- Select Operator [SEL_277] (rows=462000 width=1436)
+ Select Operator [SEL_279] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_809] (rows=462000 width=1436)
+ Filter Operator [FIL_812] (rows=462000 width=1436)
predicate:i_item_sk is not null
- TableScan [TS_90] (rows=462000 width=1436)
+ TableScan [TS_91] (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 50 [SIMPLE_EDGE]
- SHUFFLE [RS_360]
+ SHUFFLE [RS_362]
PartitionCols:_col1
- Merge Join Operator [MERGEJOIN_866] (rows=316788826 width=135)
- Conds:RS_357._col0=RS_358._col0(Inner),Output:["_col1","_col2","_col3"]
+ Merge Join Operator [MERGEJOIN_869] (rows=316788826 width=135)
+ Conds:RS_359._col0=RS_360._col0(Inner),Output:["_col1","_col2","_col3"]
<-Map 49 [SIMPLE_EDGE]
- SHUFFLE [RS_358]
+ SHUFFLE [RS_360]
PartitionCols:_col0
- Select Operator [SEL_86] (rows=18262 width=1119)
+ Select Operator [SEL_87] (rows=18262 width=1119)
Output:["_col0"]
- Filter Operator [FIL_783] (rows=18262 width=1119)
+ Filter Operator [FIL_786] (rows=18262 width=1119)
predicate:((d_moy = 11) and (d_year = 2000) and d_date_sk is not null)
- TableScan [TS_84] (rows=73049 width=1119)
+ TableScan [TS_85] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 91 [SIMPLE_EDGE]
- SHUFFLE [RS_357]
+ SHUFFLE [RS_359]
PartitionCols:_col0
- Select Operator [SEL_271] (rows=287989836 width=135)
+ Select Operator [SEL_273] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_807] (rows=287989836 width=135)
+ Filter Operator [FIL_810] (rows=287989836 width=135)
predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
- TableScan [TS_269] (rows=287989836 width=135)
+ TableScan [TS_271] (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 68 [ONE_TO_ONE_EDGE]
- FORWARD [RS_362]
+ FORWARD [RS_364]
PartitionCols:_col0
- Group By Operator [GBY_355] (rows=254100 width=1436)
+ Group By Operator [GBY_357] (rows=254100 width=1436)
Output:["_col0"],keys:KEY._col0
<-Reducer 67 [SIMPLE_EDGE]
- SHUFFLE [RS_354]
+ SHUFFLE [RS_356]
PartitionCols:_col0
- Group By Operator [GBY_353] (rows=508200 width=1436)
+ Group By Operator [GBY_355] (rows=508200 width=1436)
Output:["_col0"],keys:_col0
- Merge Join Operator [MERGEJOIN_873] (rows=508200 width=1436)
- Conds:RS_349._col1, _col2, _col3=RS_350._col0, _col1, _col2(Inner),Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_876] (rows=508200 width=1436)
+ Conds:RS_351._col1, _col2, _col3=RS_352._col0, _col1, _col2(Inner),Output:["_col0"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_349]
+ SHUFFLE [RS_351]
PartitionCols:_col1, _col2, _col3
- Select Operator [SEL_280] (rows=462000 width=1436)
+ Select Operator [SEL_282] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_810] (rows=462000 width=1436)
+ Filter Operator [FIL_813] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
- Please refer to the previous TableScan [TS_90]
+ Please refer to the previous TableScan [TS_91]
<-Reducer 72 [ONE_TO_ONE_EDGE]
- FORWARD [RS_350]
+ FORWARD [RS_352]
PartitionCols:_col0, _col1, _col2
- Select Operator [SEL_348] (rows=1 width=108)
+ Select Operator [SEL_350] (rows=1 width=108)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_347] (rows=1 width=108)
+ Filter Operator [FIL_349] (rows=1 width=108)
predicate:(_col3 = 3L)
- Group By Operator [GBY_346] (rows=304916424 width=108)
+ Group By Operator [GBY_348] (rows=304916424 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Union 71 [SIMPLE_EDGE]
<-Reducer 70 [CONTAINS]
- Reduce Output Operator [RS_345]
+ Reduce Output Operator [RS_347]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_344] (rows=609832849 width=108)
+ Group By Operator [GBY_346] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_299] (rows=348477374 width=88)
+ Group By Operator [GBY_301] (rows=348477374 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 69 [SIMPLE_EDGE]
- SHUFFLE [RS_298]
+ SHUFFLE [RS_300]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_297] (rows=696954748 width=88)
+ Group By Operator [GBY_299] (rows=696954748 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7
- Merge Join Operator [MERGEJOIN_868] (rows=696954748 width=88)
- Conds:RS_293._col1=RS_294._col0(Inner),Output:["_col5","_col6","_col7"]
+ Merge Join Operator [MERGEJOIN_871] (rows=696954748 width=88)
+ Conds:RS_295._col1=RS_296._col0(Inner),Output:["_col5","_col6","_col7"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_294]
+ SHUFFLE [RS_296]
PartitionCols:_col0
- Select Operator [SEL_289] (rows=462000 width=1436)
+ Select Operator [SEL_291] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_813] (rows=462000 width=1436)
+ Filter Operator [FIL_816] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
- Please refer to the previous TableScan [TS_90]
+ Please refer to the previous TableScan [TS_91]
<-Reducer 85 [SIMPLE_EDGE]
- SHUFFLE [RS_293]
+ SHUFFLE [RS_295]
PartitionCols:_col1
- Merge Join Operator [MERGEJOIN_852] (rows=633595212 width=88)
- Conds:RS_102._col0=RS_103._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_855] (rows=633595212 width=88)
+ Conds:RS_103._col0=RS_104._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_103]
+ SHUFFLE [RS_104]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_98]
+ Please refer to the previous Select Operator [SEL_99]
<-Map 84 [SIMPLE_EDGE]
- SHUFFLE [RS_102]
+ SHUFFLE [RS_103]
PartitionCols:_col0
- Select Operator [SEL_95] (rows=575995635 width=88)
+ Select Operator [SEL_96] (rows=575995635 width=88)
Output:["_col0","_col1"]
- Filter Operator [FIL_786] (rows=575995635 width=88)
+ Filter Operator [FIL_789] (rows=575995635 width=88)
predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
- TableScan [TS_93] (rows=575995635 width=88)
+ TableScan [TS_94] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"]
<-Reducer 79 [CONTAINS]
- Reduce Output Operator [RS_345]
+ Reduce Output Operator [RS_347]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_344] (rows=609832849 width=108)
+ Group By Operator [GBY_346] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_319] (rows=174233858 width=135)
+ Group By Operator [GBY_321] (rows=174233858 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 78 [SIMPLE_EDGE]
- SHUFFLE [RS_318]
+ SHUFFLE [RS_320]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_317] (rows=348467716 width=135)
+ Group By Operator [GBY_319] (rows=348467716 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7
- Merge Join Operator [MERGEJOIN_870] (rows=348467716 width=135)
- Conds:RS_313._col1=RS_314._col0(Inner),Output:["_col5","_col6","_col7"]
+ Merge Join Operator [MERGEJOIN_873] (rows=348467716 width=135)
+ Conds:RS_315._col1=RS_316._col0(Inner),Output:["_col5","_col6","_col7"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_314]
+ SHUFFLE [RS_316]
PartitionCols:_col0
- Select Operator [SEL_309] (rows=462000 width=1436)
+ Select Operator [SEL_311] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_816] (rows=462000 width=1436)
+ Filter Operator [FIL_819] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
- Please refer to the previous TableScan [TS_90]
+ Please refer to the previous TableScan [TS_91]
<-Reducer 87 [SIMPLE_EDGE]
- SHUFFLE [RS_313]
+ SHUFFLE [RS_315]
PartitionCols:_col1
- Merge Join Operator [MERGEJOIN_854] (rows=316788826 width=135)
- Conds:RS_122._col0=RS_123._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_857] (rows=316788826 width=135)
+ Conds:RS_123._col0=RS_124._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_123]
+ SHUFFLE [RS_124]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_98]
+ Please refer to the previous Select Operator [SEL_99]
<-Map 89 [SIMPLE_EDGE]
- SHUFFLE [RS_122]
+ SHUFFLE [RS_123]
PartitionCols:_col0
- Select Operator [SEL_115] (rows=287989836 width=135)
+ Select Operator [SEL_116] (rows=287989836 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_789] (rows=287989836 width=135)
+ Filter Operator [FIL_792] (rows=287989836 width=135)
predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
- TableScan [TS_113] (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 82 [CONTAINS]
- Reduce Output Operator [RS_345]
+ Reduce Output Operator [RS_347]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_344] (rows=609832849 width=108)
+ Group By Operator [GBY_346] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_340] (rows=87121617 width=135)
+ Group By Operator [GBY_342] (rows=87121617 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 81 [SIMPLE_EDGE]
- SHUFFLE [RS_339]
+ SHUFFLE [RS_341]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_338] (rows=174243235 width=135)
+ Group By Operator [GBY_340] (rows=174243235 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7
- Merge Join Operator [MERGEJOIN_872] (rows=174243235 width=135)
- Conds:RS_334._col1=RS_335._col0(Inner),Output:["_col5","_col6","_col7"]
+ Merge Join Operator [MERGEJOIN_875] (rows=174243235 width=135)
+ Conds:RS_336._col1=RS_337._col0(Inner),Output:["_col5","_col6","_col7"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_335]
+ SHUFFLE [RS_337]
PartitionCols:_col0
- Select Operator [SEL_330] (rows=462000 width=1436)
+ Select Operator [SEL_332] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_819] (rows=462000 width=1436)
+ Filter Operator [FIL_822] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
- Please refer to the previous TableScan [TS_90]
+ Please refer to the previous TableScan [TS_91]
<-Reducer 88 [SIMPLE_EDGE]
- SHUFFLE [RS_334]
+ SHUFFLE [RS_336]
PartitionCols:_col1
- Merge Join Operator [MERGEJOIN_856] (rows=158402938 width=135)
- Conds:RS_143._col0=RS_144._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_859] (rows=158402938 width=135)
+ Conds:RS_144._col0=RS_145._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_144]
+ SHUFFLE [RS_145]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_98]
+ Please refer to the previous Select Operator [SEL_99]
<-Map 90 [SIMPLE_EDGE]
- SHUFFLE [RS_143]
+ SHUFFLE [RS_144]
PartitionCols:_col0
- Select Operator [SEL_136] (rows=144002668 width=135)
+ Select Operator [SEL_137] (rows=144002668 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_792] (rows=144002668 width=135)
+ Filter Operator [FIL_795] (rows=144002668 width=135)
predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
- TableScan [TS_134] (rows=144002668 width=135)
+ TableScan [TS_135] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"]
<-Reducer 16 [CONTAINS]
- Reduce Output Operator [RS_568]
+ Reduce Output Operator [RS_571]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_567] (rows=2032776160 width=237)
+ Group By Operator [GBY_570] (rows=2032776160 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0L
- Select Operator [SEL_564] (rows=58081078 width=264)
+ Select Operator [SEL_567] (rows=58081078 width=264)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_563] (rows=58081078 width=264)
+ Filter Operator [FIL_566] (rows=58081078 width=264)
predicate:(_col5 > _col1)
- Merge Join Operator [MERGEJOIN_892] (rows=174243235 width=264)
+ Merge Join Operator [MERGEJOIN_895] (rows=174243235 width=264)
Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
<-Reducer 15 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_559]
- Select Operator [SEL_420] (rows=1 width=8)
- Filter Operator [FIL_419] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_562]
+ Select Operator [SEL_423] (rows=1 width=8)
+ Filter Operator [FIL_422] (rows=1 width=8)
predicate:(sq_count_check(_col0) <= 1)
- Group By Operator [GBY_417] (rows=1 width=8)
+ Group By Operator [GBY_420] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_412] (rows=1 width=8)
- Group By Operator [GBY_411] (rows=1 width=8)
+ Select Operator [SEL_415] (rows=1 width=8)
+ Group By Operator [GBY_414] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Union 14 [CUSTOM_SIMPLE_EDGE]
<-Reducer 13 [CONTAINS]
- Reduce Output Operator [RS_410]
- Group By Operator [GBY_409] (rows=1 width=8)
+ Reduce Output Operator [RS_413]
+ Group By Operator [GBY_412] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_408] (rows=1108786976 width=108)
+ Select Operator [SEL_410] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_386] (rows=633595212 width=88)
+ Select Operator [SEL_388] (rows=633595212 width=88)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_875] (rows=633595212 width=88)
- Conds:RS_383._col0=RS_384._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_878] (rows=633595212 width=88)
+ Conds:RS_385._col0=RS_386._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_384]
+ SHUFFLE [RS_386]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_98]
+ Please refer to the previous Select Operator [SEL_99]
<-Map 1 [SIMPLE_EDGE]
- SHUFFLE [RS_383]
+ SHUFFLE [RS_385]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_2]
<-Reducer 20 [CONTAINS]
- Reduce Output Operator [RS_410]
- Group By Operator [GBY_409] (rows=1 width=8)
+ Reduce Output Operator [RS_413]
+ Group By Operator [GBY_412] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_408] (rows=1108786976 width=108)
+ Select Operator [SEL_410] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_396] (rows=316788826 width=135)
+ Select Operator [SEL_398] (rows=316788826 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_876] (rows=316788826 width=135)
- Conds:RS_393._col0=RS_394._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_879] (rows=316788826 width=135)
+ Conds:RS_395._col0=RS_396._col0(Inner),Output:["_col1"]
<-Map 21 [SIMPLE_EDGE]
- SHUFFLE [RS_394]
+ SHUFFLE [RS_396]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_15]
<-Map 17 [SIMPLE_EDGE]
- SHUFFLE [RS_393]
+ SHUFFLE [RS_395]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_12]
<-Reducer 34 [CONTAINS]
- Reduce Output Operator [RS_410]
- Group By Operator [GBY_409] (rows=1 width=8)
+ Reduce Output Operator [RS_413]
+ Group By Operator [GBY_412] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_408] (rows=1108786976 width=108)
+ Select Operator [SEL_410] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_407] (rows=158402938 width=135)
+ Select Operator [SEL_409] (rows=158402938 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_877] (rows=158402938 width=135)
- Conds:RS_404._col0=RS_405._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_880] (rows=158402938 width=135)
+ Conds:RS_406._col0=RS_407._col0(Inner),Output:["_col1"]
<-Map 35 [SIMPLE_EDGE]
- SHUFFLE [RS_405]
+ SHUFFLE [RS_407]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_26]
<-Map 31 [SIMPLE_EDGE]
- SHUFFLE [RS_404]
+ SHUFFLE [RS_406]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_23]
<-Reducer 30 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_560]
- Select Operator [SEL_457] (rows=1 width=120)
+ PARTITION_ONLY_SHUFFLE [RS_563]
+ Select Operator [SEL_460] (rows=1 width=120)
Output:["_col0"]
- Group By Operator [GBY_456] (rows=1 width=120)
+ Group By Operator [GBY_459] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"]
<-Union 29 [CUSTOM_SIMPLE_EDGE]
<-Reducer 28 [CONTAINS]
- Reduce Output Operator [RS_455]
- Group By Operator [GBY_454] (rows=1 width=120)
+ Reduce Output Operator [RS_458]
+ Group By Operator [GBY_457] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_452] (rows=1108786976 width=108)
+ Select Operator [SEL_455] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_440] (rows=316788826 width=135)
+ Select Operator [SEL_443] (rows=316788826 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_879] (rows=316788826 width=135)
- Conds:RS_437._col0=RS_438._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_882] (rows=316788826 width=135)
+ Conds:RS_440._col0=RS_441._col0(Inner),Output:["_col1","_col2"]
<-Map 21 [SIMPLE_EDGE]
- SHUFFLE [RS_438]
+ SHUFFLE [RS_441]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_15]
<-Map 43 [SIMPLE_EDGE]
- SHUFFLE [RS_437]
+ SHUFFLE [RS_440]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_56]
+ Please refer to the previous Select Operator [SEL_57]
<-Reducer 38 [CONTAINS]
- Reduce Output Operator [RS_455]
- Group By Operator [GBY_454] (rows=1 width=120)
+ Reduce Output Operator [RS_458]
+ Group By Operator [GBY_457] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_452] (rows=1108786976 width=108)
+ Select Operator [SEL_455] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_451] (rows=158402938 width=135)
+ Select Operator [SEL_454] (rows=158402938 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_880] (rows=158402938 width=135)
- Conds:RS_448._col0=RS_449._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_883] (rows=158402938 width=135)
+ Conds:RS_451._col0=RS_452._col0(Inner),Output:["_col1","_col2"]
<-Map 35 [SIMPLE_EDGE]
- SHUFFLE [RS_449]
+ SHUFFLE [RS_452]
PartitionCols:_col0
Please refer to the previous Select Operator [SEL_26]
<-Map 44 [SIMPLE_EDGE]
- SHUFFLE [RS_448]
+ SHUFFLE [RS_451]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_67]
+ Please refer to the previous Select Operator [SEL_68]
<-Reducer 42 [CONTAINS]
- Reduce Output Operator [RS_455]
- Group By Operator [GBY_454] (rows=1 width=120)
+ Reduce Output Operator [RS_458]
+ Group By Operator [GBY_457] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_452] (rows=1108786976 width=108)
+ Select Operator [SEL_455] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_430] (rows=633595212 width=88)
+ Select Operator [SEL_433] (rows=633595212 width=88)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_878] (rows=633595212 width=88)
- Conds:RS_427._col0=RS_428._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_881] (rows=633595212 width=88)
+ Conds:RS_430._col0=RS_431._col0(Inner),Output:["_col1","_col2"]
<-Map 86 [SIMPLE_EDGE]
- SHUFFLE [RS_428]
+ SHUFFLE [RS_431]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_98]
+ Please refer to the previous Select Operator [SEL_99]
<-Map 39 [SIMPLE_EDGE]
- SHUFFLE [RS_427]
+ SHUFFLE [RS_430]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_46]
+ Please refer to the previous Select Operator [SEL_47]
<-Reducer 55 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_561]
- Group By Operator [GBY_557] (rows=174243235 width=135)
+ PARTITION_ONLY_SHUFFLE [RS_564]
+ Group By Operator [GBY_560] (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 54 [SIMPLE_EDGE]
- SHUFFLE [RS_556]
+ SHUFFLE [RS_559]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_555] (rows=348486471 width=135)
+ Group By Operator [GBY_558] (rows=348486471 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2
- Select Operator [SEL_553] (rows=348486471 width=135)
+ Select Operator [SEL_556] (rows=348486471 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Merge Join Operator [MERGEJOIN_889] (rows=348486471 width=135)
- Conds:RS_549._col1=RS_550._col0(Inner),RS_549._col1=RS_551._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ Merge Join Operator [MERGEJOIN_892] (rows=348486471 width=135)
+ Conds:RS_552._col1=RS_553._col0(Inner),RS_552._col1=RS_554._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_550]
+ SHUFFLE [RS_553]
PartitionCols:_col0
- Select Operator [SEL_466] (rows=462000 width=1436)
+ Select Operator [SEL_469] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_834] (rows=462000 width=1436)
+ Filter Operator [FIL_837] (rows=462000 width=1436)
predicate:i_item_sk is not null
- Please refer to the previous TableScan [TS_90]
+ Please refer to the previous TableScan [TS_91]
<-Reducer 53 [SIMPLE_EDGE]
- SHUFFLE [RS_549]
+ SHUFFLE [RS_552]
PartitionCols:_col1
- Merge Join Operator [MERGEJOIN_881] (rows=158402938 width=135)
- Conds:RS_546._col0=RS_547._col0(Inner),Output:["_col1","_col2","_col3"]
+ Merge Join Operator [MERGEJOIN_884] (rows=158402938 width=135)
+ Conds:RS_549._col0=RS_550._col0(Inner),Output:["_col1","_col2","_col3"]
<-Map 49 [SIMPLE_EDGE]
- SHUFFLE [RS_547]
+ SHUFFLE [RS_550]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_86]
+ Please refer to the previous Select Operator [SEL_87]
<-Map 92 [SIMPLE_EDGE]
- SHUFFLE [RS_546]
+ SHUFFLE [RS_549]
PartitionCols:_col0
- Select Operator [SEL_460] (rows=144002668 width=135)
+ Select Operator [SEL_463] (rows=144002668 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_832] (rows=144002668 width=135)
+ Filter Operator [FIL_835] (rows=144002668 width=135)
predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
- TableScan [TS_458] (rows=144002668 width=135)
+ TableScan [TS_461] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_quantity","ws_list_price"]
<-Reducer 77 [ONE_TO_ONE_EDGE]
- FORWARD [RS_551]
+ FORWARD [RS_554]
PartitionCols:_col0
- Group By Operator [GBY_544] (rows=254100 width=1436)
+ Group By Operator [GBY_547] (rows=254100 width=1436)
Output:["_col0"],keys:KEY._col0
<-Reducer 76 [SIMPLE_EDGE]
- SHUFFLE [RS_543]
+ SHUFFLE [RS_546]
PartitionCols:_col0
- Group By Operator [GBY_542] (rows=508200 width=1436)
+ Group By Operator [GBY_545] (rows=508200 width=1436)
Output:["_col0"],keys:_col0
- Merge Join Operator [MERGEJOIN_888] (rows=508200 width=1436)
- Conds:RS_538._col1, _col2, _col3=RS_539._col0, _col1, _col2(Inner),Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_891] (rows=508200 width=1436)
+ Conds:RS_541._col1, _col2, _col3=RS_542._col0, _col1, _col2(Inner),Output:["_col0"]
<-Map 56 [SIMPLE_EDGE]
- SHUFFLE [RS_538]
+ SHUFFLE [RS_541]
PartitionCols:_col1, _col2, _col3
- Select Operator [SEL_469] (rows=462000 width=1436)
+ Select Operator [SEL_472] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_835] (rows=462000 width=1436)
+ Filter Operator [FIL_838] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
- Please refer to the previous TableScan [TS_90]
+ Please refer to the previous TableScan [TS_91]
<-Reducer 75 [ONE_TO_ONE_EDGE]
- FORWARD [RS_539]
+ FORWARD [RS_542]
PartitionCols:_col0, _col1, _col2
- Select Operator [SEL_537] (rows=1 width=108)
+ Select Operator [SEL_540] (rows=1 width=108)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_536] (rows=1 width=108)
+ Filter Operator [FIL_539] (rows=1 width=108)
predicate:(_col3 = 3L)
- Group By Operator [GBY_535] (rows=304916424 width=108)
+ Group By Operator [GBY_538] (rows=304916424 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Union 74 [SIMPLE_EDGE]
<-Reducer 73 [CONTAINS]
- Reduce Output Operator [RS_534]
+ Reduce Output Operator [RS_537]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_533] (rows=609832849 width=108)
+ Group By Operator [GBY_536] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_488] (rows=348477374 width=88)
+ Group By Operator [GBY_491] (rows=348477374 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 69 [SIMPLE_EDGE]
- SHUFFLE [RS_487]
+ SHUFFLE [RS_490]
PartitionCols:_col0, _col1, _col2
- Please refer to the previous Group By Operator [GBY_297]
+ Please refer to the previous Group By Operator [GBY_299]
<-Reducer 80 [CONTAINS]
- Reduce Output Operator [RS_534]
+ Reduce Output Operator [RS_537]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_533] (rows=609832849 width=108)
+ Group By Operator [GBY_536] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_508] (rows=174233858 width=135)
+ Group By Operator [GBY_511] (rows=174233858 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 78 [SIMPLE_EDGE]
- SHUFFLE [RS_507]
+ SHUFFLE [RS_510]
PartitionCols:_col0, _col1, _col2
- Please refer to the previous Group By Operator [GBY_317]
+ Please refer to the previous Group By Operator [GBY_319]
<-Reducer 83 [CONTAINS]
- Reduce Output Operator [RS_534]
+ Reduce Output Operator [RS_537]
PartitionCols:_col0, _col1,
<TRUNCATED>