http://git-wip-us.apache.org/repos/asf/hive/blob/4ad4ceb6/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 eab635e..42bad8d 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[899][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' 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[891][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product +Warning: Shuffle Join MERGEJOIN[890][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product +Warning: Shuffle Join MERGEJOIN[892][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 @@ -290,727 +290,715 @@ Stage-0 limit:100 Stage-1 Reducer 8 - File Output Operator [FS_583] - Limit [LIM_582] (rows=100 width=405) + File Output Operator [FS_574] + Limit [LIM_573] (rows=100 width=405) Number of rows:100 - Select Operator [SEL_581] (rows=1016388080 width=405) + Select Operator [SEL_572] (rows=1016388080 width=405) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] <-Reducer 7 [SIMPLE_EDGE] - SHUFFLE [RS_580] - Select Operator [SEL_579] (rows=1016388080 width=405) + SHUFFLE [RS_571] + Select Operator [SEL_570] (rows=1016388080 width=405) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Group By Operator [GBY_578] (rows=1016388080 width=405) + Group By Operator [GBY_569] (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_577] + Reduce Output Operator [RS_568] PartitionCols:_col0, _col1, _col2, _col3, _col4 - Group By Operator [GBY_576] (rows=2032776160 width=405) + Group By Operator [GBY_567] (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_381] (rows=116155905 width=432) + Select Operator [SEL_375] (rows=116155905 width=432) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_380] (rows=116155905 width=432) + Filter Operator [FIL_374] (rows=116155905 width=432) predicate:(_col5 > _col1) - Merge Join Operator [MERGEJOIN_900] (rows=348467716 width=432) + Merge Join Operator [MERGEJOIN_891] (rows=348467716 width=432) Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"] <-Reducer 11 [CUSTOM_SIMPLE_EDGE] - PARTITION_ONLY_SHUFFLE [RS_376] - Select Operator [SEL_234] (rows=1 width=8) - Filter Operator [FIL_233] (rows=1 width=8) + PARTITION_ONLY_SHUFFLE [RS_370] + Select Operator [SEL_231] (rows=1 width=8) + Filter Operator [FIL_230] (rows=1 width=8) predicate:(sq_count_check(_col0) <= 1) - Group By Operator [GBY_231] (rows=1 width=8) + Group By Operator [GBY_228] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_226] (rows=1 width=8) - Group By Operator [GBY_225] (rows=1 width=8) + Select Operator [SEL_223] (rows=1 width=8) + Group By Operator [GBY_222] (rows=1 width=8) Output:["_col0"],aggregations:["count(VALUE._col0)"] <-Union 10 [CUSTOM_SIMPLE_EDGE] <-Reducer 74 [CONTAINS] - Reduce Output Operator [RS_224] - Group By Operator [GBY_223] (rows=1 width=8) + Reduce Output Operator [RS_221] + Group By Operator [GBY_220] (rows=1 width=8) Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_222] (rows=1108786976 width=108) + Select Operator [SEL_219] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_210] (rows=316788826 width=135) + Select Operator [SEL_207] (rows=316788826 width=135) Output:["_col0"] - Merge Join Operator [MERGEJOIN_870] (rows=316788826 width=135) - Conds:RS_207._col0=RS_208._col0(Inner),Output:["_col1"] + Merge Join Operator [MERGEJOIN_861] (rows=316788826 width=135) + Conds:RS_204._col0=RS_205._col0(Inner),Output:["_col1"] <-Map 76 [SIMPLE_EDGE] - SHUFFLE [RS_208] + SHUFFLE [RS_205] PartitionCols:_col0 Select Operator [SEL_15] (rows=8116 width=1119) Output:["_col0"] - Filter Operator [FIL_782] (rows=8116 width=1119) + Filter Operator [FIL_773] (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_207] + SHUFFLE [RS_204] PartitionCols:_col0 Select Operator [SEL_12] (rows=287989836 width=135) Output:["_col0","_col1"] - Filter Operator [FIL_781] (rows=287989836 width=135) + Filter Operator [FIL_772] (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_224] - Group By Operator [GBY_223] (rows=1 width=8) + Reduce Output Operator [RS_221] + Group By Operator [GBY_220] (rows=1 width=8) Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_222] (rows=1108786976 width=108) + Select Operator [SEL_219] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_221] (rows=158402938 width=135) + Select Operator [SEL_218] (rows=158402938 width=135) Output:["_col0"] - Merge Join Operator [MERGEJOIN_871] (rows=158402938 width=135) - Conds:RS_218._col0=RS_219._col0(Inner),Output:["_col1"] + Merge Join Operator [MERGEJOIN_862] (rows=158402938 width=135) + Conds:RS_215._col0=RS_216._col0(Inner),Output:["_col1"] <-Map 84 [SIMPLE_EDGE] - SHUFFLE [RS_219] + SHUFFLE [RS_216] PartitionCols:_col0 Select Operator [SEL_26] (rows=8116 width=1119) Output:["_col0"] - Filter Operator [FIL_784] (rows=8116 width=1119) + Filter Operator [FIL_775] (rows=8116 width=1119) predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null) 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_218] + SHUFFLE [RS_215] PartitionCols:_col0 Select Operator [SEL_23] (rows=144002668 width=135) Output:["_col0","_col1"] - Filter Operator [FIL_783] (rows=144002668 width=135) + Filter Operator [FIL_774] (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_224] - Group By Operator [GBY_223] (rows=1 width=8) + Reduce Output Operator [RS_221] + Group By Operator [GBY_220] (rows=1 width=8) Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_222] (rows=1108786976 width=108) + Select Operator [SEL_219] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_200] (rows=633595212 width=88) + Select Operator [SEL_197] (rows=633595212 width=88) Output:["_col0"] - Merge Join Operator [MERGEJOIN_869] (rows=633595212 width=88) - Conds:RS_197._col0=RS_198._col0(Inner),Output:["_col1"] + Merge Join Operator [MERGEJOIN_860] (rows=633595212 width=88) + Conds:RS_194._col0=RS_195._col0(Inner),Output:["_col1"] <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_198] + SHUFFLE [RS_195] PartitionCols:_col0 Select Operator [SEL_5] (rows=8116 width=1119) Output:["_col0"] - Filter Operator [FIL_780] (rows=8116 width=1119) + Filter Operator [FIL_771] (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_197] + SHUFFLE [RS_194] PartitionCols:_col0 Select Operator [SEL_2] (rows=575995635 width=88) Output:["_col0","_col1"] - Filter Operator [FIL_779] (rows=575995635 width=88) + Filter Operator [FIL_770] (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_377] - Group By Operator [GBY_270] (rows=1 width=288) + PARTITION_ONLY_SHUFFLE [RS_371] + Group By Operator [GBY_267] (rows=1 width=288) Output:["_col0"],aggregations:["avg(VALUE._col0)"] <-Union 37 [CUSTOM_SIMPLE_EDGE] <-Reducer 36 [CONTAINS] - Reduce Output Operator [RS_269] - Group By Operator [GBY_268] (rows=1 width=288) + Reduce Output Operator [RS_266] + Group By Operator [GBY_265] (rows=1 width=288) Output:["_col0"],aggregations:["avg(_col0)"] - Select Operator [SEL_266] (rows=1108786976 width=108) + Select Operator [SEL_263] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_244] (rows=633595212 width=88) + Select Operator [SEL_241] (rows=633595212 width=88) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_872] (rows=633595212 width=88) - Conds:RS_241._col0=RS_242._col0(Inner),Output:["_col1","_col2"] + Merge Join Operator [MERGEJOIN_863] (rows=633595212 width=88) + Conds:RS_238._col0=RS_239._col0(Inner),Output:["_col1","_col2"] <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_242] + SHUFFLE [RS_239] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_5] <-Map 88 [SIMPLE_EDGE] - SHUFFLE [RS_241] + SHUFFLE [RS_238] PartitionCols:_col0 Select Operator [SEL_46] (rows=575995635 width=88) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_785] (rows=575995635 width=88) + Filter Operator [FIL_776] (rows=575995635 width=88) predicate:ss_sold_date_sk is not null 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_269] - Group By Operator [GBY_268] (rows=1 width=288) + Reduce Output Operator [RS_266] + Group By Operator [GBY_265] (rows=1 width=288) Output:["_col0"],aggregations:["avg(_col0)"] - Select Operator [SEL_266] (rows=1108786976 width=108) + Select Operator [SEL_263] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_254] (rows=316788826 width=135) + Select Operator [SEL_251] (rows=316788826 width=135) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_873] (rows=316788826 width=135) - Conds:RS_251._col0=RS_252._col0(Inner),Output:["_col1","_col2"] + Merge Join Operator [MERGEJOIN_864] (rows=316788826 width=135) + Conds:RS_248._col0=RS_249._col0(Inner),Output:["_col1","_col2"] <-Map 76 [SIMPLE_EDGE] - SHUFFLE [RS_252] + SHUFFLE [RS_249] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_15] <-Map 89 [SIMPLE_EDGE] - SHUFFLE [RS_251] + SHUFFLE [RS_248] PartitionCols:_col0 Select Operator [SEL_56] (rows=287989836 width=135) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_787] (rows=287989836 width=135) + Filter Operator [FIL_778] (rows=287989836 width=135) predicate:cs_sold_date_sk is not null 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_269] - Group By Operator [GBY_268] (rows=1 width=288) + Reduce Output Operator [RS_266] + Group By Operator [GBY_265] (rows=1 width=288) Output:["_col0"],aggregations:["avg(_col0)"] - Select Operator [SEL_266] (rows=1108786976 width=108) + Select Operator [SEL_263] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_265] (rows=158402938 width=135) + Select Operator [SEL_262] (rows=158402938 width=135) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_874] (rows=158402938 width=135) - Conds:RS_262._col0=RS_263._col0(Inner),Output:["_col1","_col2"] + Merge Join Operator [MERGEJOIN_865] (rows=158402938 width=135) + Conds:RS_259._col0=RS_260._col0(Inner),Output:["_col1","_col2"] <-Map 84 [SIMPLE_EDGE] - SHUFFLE [RS_263] + SHUFFLE [RS_260] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_26] <-Map 90 [SIMPLE_EDGE] - SHUFFLE [RS_262] + SHUFFLE [RS_259] PartitionCols:_col0 Select Operator [SEL_67] (rows=144002668 width=135) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_789] (rows=144002668 width=135) + Filter Operator [FIL_780] (rows=144002668 width=135) predicate:ws_sold_date_sk is not null 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_378] - Group By Operator [GBY_374] (rows=348467716 width=135) + PARTITION_ONLY_SHUFFLE [RS_372] + Group By Operator [GBY_368] (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_373] + SHUFFLE [RS_367] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_372] (rows=696935432 width=135) + Group By Operator [GBY_366] (rows=696935432 width=135) Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2 - Select Operator [SEL_370] (rows=696935432 width=135) + Select Operator [SEL_364] (rows=696935432 width=135) Output:["_col0","_col1","_col2","_col3"] - 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"] + 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"] <-Map 96 [SIMPLE_EDGE] - SHUFFLE [RS_367] + SHUFFLE [RS_361] PartitionCols:_col0 - Select Operator [SEL_280] (rows=462000 width=1436) + Select Operator [SEL_277] (rows=462000 width=1436) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_818] (rows=462000 width=1436) + Filter Operator [FIL_809] (rows=462000 width=1436) predicate:i_item_sk is not null 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_368] + SHUFFLE [RS_362] PartitionCols:_col0 - Group By Operator [GBY_361] (rows=254100 width=1436) + Group By Operator [GBY_355] (rows=254100 width=1436) Output:["_col0"],keys:KEY._col0 <-Reducer 44 [SIMPLE_EDGE] - SHUFFLE [RS_360] + SHUFFLE [RS_354] PartitionCols:_col0 - Group By Operator [GBY_359] (rows=508200 width=1436) + Group By Operator [GBY_353] (rows=508200 width=1436) Output:["_col0"],keys:_col0 - Merge Join Operator [MERGEJOIN_882] (rows=508200 width=1436) - Conds:RS_355._col1, _col2, _col3=RS_356._col0, _col1, _col2(Inner),Output:["_col0"] + Merge Join Operator [MERGEJOIN_873] (rows=508200 width=1436) + Conds:RS_349._col1, _col2, _col3=RS_350._col0, _col1, _col2(Inner),Output:["_col0"] <-Map 96 [SIMPLE_EDGE] - SHUFFLE [RS_355] + SHUFFLE [RS_349] PartitionCols:_col1, _col2, _col3 - Select Operator [SEL_283] (rows=462000 width=1436) + Select Operator [SEL_280] (rows=462000 width=1436) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_819] (rows=462000 width=1436) + Filter Operator [FIL_810] (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_87] <-Reducer 43 [SIMPLE_EDGE] - SHUFFLE [RS_356] + SHUFFLE [RS_350] PartitionCols:_col0, _col1, _col2 - Select Operator [SEL_354] (rows=1 width=108) + Select Operator [SEL_348] (rows=1 width=108) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_353] (rows=1 width=108) + Filter Operator [FIL_347] (rows=1 width=108) predicate:(_col3 = 3) - Group By Operator [GBY_352] (rows=304916424 width=108) + Group By Operator [GBY_346] (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_351] + Reduce Output Operator [RS_345] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_350] (rows=609832849 width=108) + Group By Operator [GBY_344] (rows=609832849 width=108) Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 - Group By Operator [GBY_303] (rows=348477374 width=88) + Group By Operator [GBY_299] (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_302] + SHUFFLE [RS_298] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_301] (rows=696954748 width=88) - Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2 - Select Operator [SEL_299] (rows=696954748 width=88) - Output:["_col0","_col1","_col2"] - 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_297] - PartitionCols:_col0 - Select Operator [SEL_292] (rows=462000 width=1436) - Output:["_col0","_col1","_col2","_col3"] - 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_87] - <-Reducer 39 [SIMPLE_EDGE] - SHUFFLE [RS_296] - PartitionCols:_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_294] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_5] - <-Map 97 [SIMPLE_EDGE] - SHUFFLE [RS_293] - PartitionCols:_col0 - Select Operator [SEL_95] (rows=575995635 width=88) - Output:["_col0","_col1"] - Filter Operator [FIL_795] (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) - default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"] + Group By Operator [GBY_297] (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"] + <-Map 96 [SIMPLE_EDGE] + SHUFFLE [RS_294] + PartitionCols:_col0 + Select Operator [SEL_289] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_813] (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_87] + <-Reducer 39 [SIMPLE_EDGE] + SHUFFLE [RS_293] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_867] (rows=633595212 width=88) + Conds:RS_290._col0=RS_291._col0(Inner),Output:["_col1"] + <-Map 17 [SIMPLE_EDGE] + SHUFFLE [RS_291] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_5] + <-Map 97 [SIMPLE_EDGE] + SHUFFLE [RS_290] + PartitionCols:_col0 + Select Operator [SEL_95] (rows=575995635 width=88) + Output:["_col0","_col1"] + Filter Operator [FIL_786] (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) + default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"] <-Reducer 50 [CONTAINS] - Reduce Output Operator [RS_351] + Reduce Output Operator [RS_345] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_350] (rows=609832849 width=108) + Group By Operator [GBY_344] (rows=609832849 width=108) Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 - Group By Operator [GBY_324] (rows=174233858 width=135) + Group By Operator [GBY_319] (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_323] + SHUFFLE [RS_318] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_322] (rows=348467716 width=135) - Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2 - Select Operator [SEL_320] (rows=348467716 width=135) - Output:["_col0","_col1","_col2"] - 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_318] - PartitionCols:_col0 - Select Operator [SEL_313] (rows=462000 width=1436) - Output:["_col0","_col1","_col2","_col3"] - 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_87] - <-Reducer 48 [SIMPLE_EDGE] - SHUFFLE [RS_317] - PartitionCols:_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_315] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_5] - <-Map 98 [SIMPLE_EDGE] - SHUFFLE [RS_314] - PartitionCols:_col0 - Select Operator [SEL_116] (rows=287989836 width=135) - Output:["_col0","_col1"] - Filter Operator [FIL_798] (rows=287989836 width=135) - predicate:(cs_item_sk is not null and cs_sold_date_sk is not null) - TableScan [TS_114] (rows=287989836 width=135) - default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk"] + Group By Operator [GBY_317] (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"] + <-Map 96 [SIMPLE_EDGE] + SHUFFLE [RS_314] + PartitionCols:_col0 + Select Operator [SEL_309] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_816] (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_87] + <-Reducer 48 [SIMPLE_EDGE] + SHUFFLE [RS_313] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_869] (rows=316788826 width=135) + Conds:RS_310._col0=RS_311._col0(Inner),Output:["_col1"] + <-Map 17 [SIMPLE_EDGE] + SHUFFLE [RS_311] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_5] + <-Map 98 [SIMPLE_EDGE] + SHUFFLE [RS_310] + PartitionCols:_col0 + Select Operator [SEL_115] (rows=287989836 width=135) + Output:["_col0","_col1"] + Filter Operator [FIL_789] (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) + default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk"] <-Reducer 53 [CONTAINS] - Reduce Output Operator [RS_351] + Reduce Output Operator [RS_345] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_350] (rows=609832849 width=108) + Group By Operator [GBY_344] (rows=609832849 width=108) Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 - Group By Operator [GBY_346] (rows=87121617 width=135) + Group By Operator [GBY_340] (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_345] + SHUFFLE [RS_339] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_344] (rows=174243235 width=135) - Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2 - Select Operator [SEL_342] (rows=174243235 width=135) - Output:["_col0","_col1","_col2"] - 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_340] - PartitionCols:_col0 - Select Operator [SEL_335] (rows=462000 width=1436) - Output:["_col0","_col1","_col2","_col3"] - 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_87] - <-Reducer 51 [SIMPLE_EDGE] - SHUFFLE [RS_339] - PartitionCols:_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_337] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_5] - <-Map 99 [SIMPLE_EDGE] - SHUFFLE [RS_336] - PartitionCols:_col0 - Select Operator [SEL_138] (rows=144002668 width=135) - Output:["_col0","_col1"] - Filter Operator [FIL_801] (rows=144002668 width=135) - predicate:(ws_item_sk is not null and ws_sold_date_sk is not null) - TableScan [TS_136] (rows=144002668 width=135) - default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"] + Group By Operator [GBY_338] (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"] + <-Map 96 [SIMPLE_EDGE] + SHUFFLE [RS_335] + PartitionCols:_col0 + Select Operator [SEL_330] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_819] (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_87] + <-Reducer 51 [SIMPLE_EDGE] + SHUFFLE [RS_334] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_871] (rows=158402938 width=135) + Conds:RS_331._col0=RS_332._col0(Inner),Output:["_col1"] + <-Map 17 [SIMPLE_EDGE] + SHUFFLE [RS_332] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_5] + <-Map 99 [SIMPLE_EDGE] + SHUFFLE [RS_331] + PartitionCols:_col0 + Select Operator [SEL_136] (rows=144002668 width=135) + Output:["_col0","_col1"] + Filter Operator [FIL_792] (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) + default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"] <-Reducer 94 [SIMPLE_EDGE] - SHUFFLE [RS_366] + SHUFFLE [RS_360] PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_875] (rows=316788826 width=135) - Conds:RS_363._col0=RS_364._col0(Inner),Output:["_col1","_col2","_col3"] + Merge Join Operator [MERGEJOIN_866] (rows=316788826 width=135) + Conds:RS_357._col0=RS_358._col0(Inner),Output:["_col1","_col2","_col3"] <-Map 93 [SIMPLE_EDGE] - SHUFFLE [RS_364] + SHUFFLE [RS_358] PartitionCols:_col0 Select Operator [SEL_86] (rows=18262 width=1119) Output:["_col0"] - Filter Operator [FIL_792] (rows=18262 width=1119) + Filter Operator [FIL_783] (rows=18262 width=1119) predicate:((d_year = 2000) and (d_moy = 11) and d_date_sk is not null) 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_363] + SHUFFLE [RS_357] PartitionCols:_col0 - Select Operator [SEL_274] (rows=287989836 width=135) + Select Operator [SEL_271] (rows=287989836 width=135) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_816] (rows=287989836 width=135) + Filter Operator [FIL_807] (rows=287989836 width=135) predicate:(cs_item_sk is not null and cs_sold_date_sk is not null) - TableScan [TS_272] (rows=287989836 width=135) + TableScan [TS_269] (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_577] + Reduce Output Operator [RS_568] PartitionCols:_col0, _col1, _col2, _col3, _col4 - Group By Operator [GBY_576] (rows=2032776160 width=405) + Group By Operator [GBY_567] (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_573] (rows=58081078 width=432) + Select Operator [SEL_564] (rows=58081078 width=432) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_572] (rows=58081078 width=432) + Filter Operator [FIL_563] (rows=58081078 width=432) predicate:(_col5 > _col1) - Merge Join Operator [MERGEJOIN_901] (rows=174243235 width=432) + Merge Join Operator [MERGEJOIN_892] (rows=174243235 width=432) Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"] <-Reducer 15 [CUSTOM_SIMPLE_EDGE] - PARTITION_ONLY_SHUFFLE [RS_568] - Select Operator [SEL_426] (rows=1 width=8) - Filter Operator [FIL_425] (rows=1 width=8) + PARTITION_ONLY_SHUFFLE [RS_559] + Select Operator [SEL_420] (rows=1 width=8) + Filter Operator [FIL_419] (rows=1 width=8) predicate:(sq_count_check(_col0) <= 1) - Group By Operator [GBY_423] (rows=1 width=8) + Group By Operator [GBY_417] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_418] (rows=1 width=8) - Group By Operator [GBY_417] (rows=1 width=8) + Select Operator [SEL_412] (rows=1 width=8) + Group By Operator [GBY_411] (rows=1 width=8) Output:["_col0"],aggregations:["count(VALUE._col0)"] <-Union 14 [CUSTOM_SIMPLE_EDGE] <-Reducer 13 [CONTAINS] - Reduce Output Operator [RS_416] - Group By Operator [GBY_415] (rows=1 width=8) + Reduce Output Operator [RS_410] + Group By Operator [GBY_409] (rows=1 width=8) Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_414] (rows=1108786976 width=108) + Select Operator [SEL_408] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_392] (rows=633595212 width=88) + Select Operator [SEL_386] (rows=633595212 width=88) Output:["_col0"] - Merge Join Operator [MERGEJOIN_884] (rows=633595212 width=88) - Conds:RS_389._col0=RS_390._col0(Inner),Output:["_col1"] + Merge Join Operator [MERGEJOIN_875] (rows=633595212 width=88) + Conds:RS_383._col0=RS_384._col0(Inner),Output:["_col1"] <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_390] + SHUFFLE [RS_384] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_5] <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_389] + SHUFFLE [RS_383] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_2] <-Reducer 75 [CONTAINS] - Reduce Output Operator [RS_416] - Group By Operator [GBY_415] (rows=1 width=8) + Reduce Output Operator [RS_410] + Group By Operator [GBY_409] (rows=1 width=8) Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_414] (rows=1108786976 width=108) + Select Operator [SEL_408] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_402] (rows=316788826 width=135) + Select Operator [SEL_396] (rows=316788826 width=135) Output:["_col0"] - Merge Join Operator [MERGEJOIN_885] (rows=316788826 width=135) - Conds:RS_399._col0=RS_400._col0(Inner),Output:["_col1"] + Merge Join Operator [MERGEJOIN_876] (rows=316788826 width=135) + Conds:RS_393._col0=RS_394._col0(Inner),Output:["_col1"] <-Map 76 [SIMPLE_EDGE] - SHUFFLE [RS_400] + SHUFFLE [RS_394] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_15] <-Map 72 [SIMPLE_EDGE] - SHUFFLE [RS_399] + SHUFFLE [RS_393] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_12] <-Reducer 83 [CONTAINS] - Reduce Output Operator [RS_416] - Group By Operator [GBY_415] (rows=1 width=8) + Reduce Output Operator [RS_410] + Group By Operator [GBY_409] (rows=1 width=8) Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_414] (rows=1108786976 width=108) + Select Operator [SEL_408] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_413] (rows=158402938 width=135) + Select Operator [SEL_407] (rows=158402938 width=135) Output:["_col0"] - Merge Join Operator [MERGEJOIN_886] (rows=158402938 width=135) - Conds:RS_410._col0=RS_411._col0(Inner),Output:["_col1"] + Merge Join Operator [MERGEJOIN_877] (rows=158402938 width=135) + Conds:RS_404._col0=RS_405._col0(Inner),Output:["_col1"] <-Map 84 [SIMPLE_EDGE] - SHUFFLE [RS_411] + SHUFFLE [RS_405] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_26] <-Map 80 [SIMPLE_EDGE] - SHUFFLE [RS_410] + SHUFFLE [RS_404] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_23] <-Reducer 56 [CUSTOM_SIMPLE_EDGE] - PARTITION_ONLY_SHUFFLE [RS_569] - Group By Operator [GBY_462] (rows=1 width=288) + PARTITION_ONLY_SHUFFLE [RS_560] + Group By Operator [GBY_456] (rows=1 width=288) Output:["_col0"],aggregations:["avg(VALUE._col0)"] <-Union 55 [CUSTOM_SIMPLE_EDGE] <-Reducer 54 [CONTAINS] - Reduce Output Operator [RS_461] - Group By Operator [GBY_460] (rows=1 width=288) + Reduce Output Operator [RS_455] + Group By Operator [GBY_454] (rows=1 width=288) Output:["_col0"],aggregations:["avg(_col0)"] - Select Operator [SEL_458] (rows=1108786976 width=108) + Select Operator [SEL_452] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_436] (rows=633595212 width=88) + Select Operator [SEL_430] (rows=633595212 width=88) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_887] (rows=633595212 width=88) - Conds:RS_433._col0=RS_434._col0(Inner),Output:["_col1","_col2"] + Merge Join Operator [MERGEJOIN_878] (rows=633595212 width=88) + Conds:RS_427._col0=RS_428._col0(Inner),Output:["_col1","_col2"] <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_434] + SHUFFLE [RS_428] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_5] <-Map 88 [SIMPLE_EDGE] - SHUFFLE [RS_433] + SHUFFLE [RS_427] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_46] <-Reducer 79 [CONTAINS] - Reduce Output Operator [RS_461] - Group By Operator [GBY_460] (rows=1 width=288) + Reduce Output Operator [RS_455] + Group By Operator [GBY_454] (rows=1 width=288) Output:["_col0"],aggregations:["avg(_col0)"] - Select Operator [SEL_458] (rows=1108786976 width=108) + Select Operator [SEL_452] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_446] (rows=316788826 width=135) + Select Operator [SEL_440] (rows=316788826 width=135) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_888] (rows=316788826 width=135) - Conds:RS_443._col0=RS_444._col0(Inner),Output:["_col1","_col2"] + Merge Join Operator [MERGEJOIN_879] (rows=316788826 width=135) + Conds:RS_437._col0=RS_438._col0(Inner),Output:["_col1","_col2"] <-Map 76 [SIMPLE_EDGE] - SHUFFLE [RS_444] + SHUFFLE [RS_438] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_15] <-Map 89 [SIMPLE_EDGE] - SHUFFLE [RS_443] + SHUFFLE [RS_437] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_56] <-Reducer 87 [CONTAINS] - Reduce Output Operator [RS_461] - Group By Operator [GBY_460] (rows=1 width=288) + Reduce Output Operator [RS_455] + Group By Operator [GBY_454] (rows=1 width=288) Output:["_col0"],aggregations:["avg(_col0)"] - Select Operator [SEL_458] (rows=1108786976 width=108) + Select Operator [SEL_452] (rows=1108786976 width=108) Output:["_col0"] - Select Operator [SEL_457] (rows=158402938 width=135) + Select Operator [SEL_451] (rows=158402938 width=135) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_889] (rows=158402938 width=135) - Conds:RS_454._col0=RS_455._col0(Inner),Output:["_col1","_col2"] + Merge Join Operator [MERGEJOIN_880] (rows=158402938 width=135) + Conds:RS_448._col0=RS_449._col0(Inner),Output:["_col1","_col2"] <-Map 84 [SIMPLE_EDGE] - SHUFFLE [RS_455] + SHUFFLE [RS_449] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_26] <-Map 90 [SIMPLE_EDGE] - SHUFFLE [RS_454] + SHUFFLE [RS_448] PartitionCols:_col0 Please refer to the previous Select Operator [SEL_67] <-Reducer 65 [CUSTOM_SIMPLE_EDGE] - PARTITION_ONLY_SHUFFLE [RS_570] - Group By Operator [GBY_566] (rows=174243235 width=135) + PARTITION_ONLY_SHUFFLE [RS_561] + Group By Operator [GBY_557] (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_565] + SHUFFLE [RS_556] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_564] (rows=348486471 width=135) + Group By Operator [GBY_555] (rows=348486471 width=135) Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2 - Select Operator [SEL_562] (rows=348486471 width=135) + Select Operator [SEL_553] (rows=348486471 width=135) Output:["_col0","_col1","_col2","_col3"] - Merge Join Operator [MERGEJOIN_898] (rows=348486471 width=135) - Conds:RS_558._col1=RS_559._col0(Inner),RS_558._col1=RS_560._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"] + 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"] <-Map 96 [SIMPLE_EDGE] - SHUFFLE [RS_559] + SHUFFLE [RS_550] PartitionCols:_col0 - Select Operator [SEL_472] (rows=462000 width=1436) + Select Operator [SEL_466] (rows=462000 width=1436) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_843] (rows=462000 width=1436) + Filter Operator [FIL_834] (rows=462000 width=1436) predicate:i_item_sk is not null Please refer to the previous TableScan [TS_87] <-Reducer 63 [SIMPLE_EDGE] - SHUFFLE [RS_560] + SHUFFLE [RS_551] PartitionCols:_col0 - Group By Operator [GBY_553] (rows=254100 width=1436) + Group By Operator [GBY_544] (rows=254100 width=1436) Output:["_col0"],keys:KEY._col0 <-Reducer 62 [SIMPLE_EDGE] - SHUFFLE [RS_552] + SHUFFLE [RS_543] PartitionCols:_col0 - Group By Operator [GBY_551] (rows=508200 width=1436) + Group By Operator [GBY_542] (rows=508200 width=1436) Output:["_col0"],keys:_col0 - Merge Join Operator [MERGEJOIN_897] (rows=508200 width=1436) - Conds:RS_547._col1, _col2, _col3=RS_548._col0, _col1, _col2(Inner),Output:["_col0"] + Merge Join Operator [MERGEJOIN_888] (rows=508200 width=1436) + Conds:RS_538._col1, _col2, _col3=RS_539._col0, _col1, _col2(Inner),Output:["_col0"] <-Map 96 [SIMPLE_EDGE] - SHUFFLE [RS_547] + SHUFFLE [RS_538] PartitionCols:_col1, _col2, _col3 - Select Operator [SEL_475] (rows=462000 width=1436) + Select Operator [SEL_469] (rows=462000 width=1436) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_844] (rows=462000 width=1436) + Filter Operator [FIL_835] (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_87] <-Reducer 61 [SIMPLE_EDGE] - SHUFFLE [RS_548] + SHUFFLE [RS_539] PartitionCols:_col0, _col1, _col2 - Select Operator [SEL_546] (rows=1 width=108) + Select Operator [SEL_537] (rows=1 width=108) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_545] (rows=1 width=108) + Filter Operator [FIL_536] (rows=1 width=108) predicate:(_col3 = 3) - Group By Operator [GBY_544] (rows=304916424 width=108) + Group By Operator [GBY_535] (rows=304916424 width=108) Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2 <-Union 60 [SIMPLE_EDGE] <-Reducer 59 [CONTAINS] - Reduce Output Operator [RS_543] + Reduce Output Operator [RS_534] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_542] (rows=609832849 width=108) + Group By Operator [GBY_533] (rows=609832849 width=108) Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 - Group By Operator [GBY_495] (rows=348477374 width=88) + Group By Operator [GBY_488] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2 <-Reducer 58 [SIMPLE_EDGE] - SHUFFLE [RS_494] + SHUFFLE [RS_487] PartitionCols:_col0, _col1, _col2 - Group By Operator [GBY_493] (rows=696954748 width=88) - Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2 - Select Operator [SEL_491] (rows=696954748 width=88) - Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_892] (rows=696954748 width=88) - Conds:RS_488._col1=RS_489._col0(Inner),Output:["_col5","_col6","_col7"] - <-Map 96 [SIMPLE_EDGE] - SHUFFLE [RS_489] - PartitionCols:_col0 - Select Operator [SEL_484] (rows=462000 width=1436) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_847] (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_87] - <-Reducer 57 [SIMPLE_EDGE] -
<TRUNCATED>
