http://git-wip-us.apache.org/repos/asf/hive/blob/f4a48fdb/ql/src/test/results/clientpositive/perf/tez/constraints/query75.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/constraints/query75.q.out b/ql/src/test/results/clientpositive/perf/tez/constraints/query75.q.out index fee4e83..f259399 100644 --- a/ql/src/test/results/clientpositive/perf/tez/constraints/query75.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/constraints/query75.q.out @@ -205,458 +205,454 @@ Stage-0 limit:-1 Stage-1 Reducer 10 vectorized - File Output Operator [FS_633] - Select Operator [SEL_632] (rows=100 width=160) + File Output Operator [FS_631] + Select Operator [SEL_630] (rows=100 width=160) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"] - Limit [LIM_631] (rows=100 width=152) + Limit [LIM_629] (rows=100 width=152) Number of rows:100 - Select Operator [SEL_630] (rows=3422897230256 width=151) + Select Operator [SEL_628] (rows=3422897230256 width=151) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] <-Reducer 9 [SIMPLE_EDGE] SHUFFLE [RS_169] Select Operator [SEL_168] (rows=3422897230256 width=151) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - Filter Operator [FIL_167] (rows=3422897230256 width=479) - predicate:((_col13 / _col6) < 0.9) - Merge Join Operator [MERGEJOIN_512] (rows=10268691690770 width=479) - Conds:RS_625._col0, _col1, _col2, _col3=RS_629._col0, _col1, _col2, _col3(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col11","_col12","_col13"] + Filter Operator [FIL_167] (rows=3422897230256 width=255) + predicate:((CAST( _col10 AS decimal(17,2)) / CAST( _col4 AS decimal(17,2))) < 0.9) + Merge Join Operator [MERGEJOIN_512] (rows=10268691690770 width=255) + Conds:RS_624._col0, _col1, _col2, _col3=RS_627._col0, _col1, _col2, _col3(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col10","_col11"] <-Reducer 27 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_629] + SHUFFLE [RS_627] PartitionCols:_col0, _col1, _col2, _col3 - Select Operator [SEL_628] (rows=84235776 width=247) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - Group By Operator [GBY_627] (rows=84235776 width=135) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3 - Group By Operator [GBY_626] (rows=736356923 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 - <-Union 26 [SIMPLE_EDGE] - <-Reducer 25 [CONTAINS] vectorized - Reduce Output Operator [RS_663] - PartitionCols:_col0, _col1, _col2, _col3 - Group By Operator [GBY_662] (rows=736356923 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Group By Operator [GBY_661] (rows=621178955 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 - <-Union 24 [SIMPLE_EDGE] - <-Reducer 23 [CONTAINS] - Reduce Output Operator [RS_536] - PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 - Group By Operator [GBY_535] (rows=621178955 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Select Operator [SEL_533] (rows=170474971 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Merge Join Operator [MERGEJOIN_532] (rows=170474971 width=234) - Conds:RS_99._col1, _col2=RS_618._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] - <-Map 44 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_618] - PartitionCols:_col0, _col1 - Select Operator [SEL_616] (rows=28798881 width=121) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_9] (rows=28798881 width=121) - default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["cr_item_sk","cr_order_number","cr_return_quantity","cr_return_amount"] - <-Reducer 22 [SIMPLE_EDGE] - SHUFFLE [RS_99] - PartitionCols:_col1, _col2 - Merge Join Operator [MERGEJOIN_504] (rows=96821196 width=138) - Conds:RS_96._col1=RS_593._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] - <-Map 37 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_593] - PartitionCols:_col0 - Select Operator [SEL_586] (rows=45745 width=19) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_585] (rows=45745 width=109) - predicate:((i_category = 'Sports') and i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_manufact_id is not null) - TableScan [TS_6] (rows=462000 width=109) - default@item,item,Tbl:COMPLETE,Col:COMPLETE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"] - <-Reducer 21 [SIMPLE_EDGE] - SHUFFLE [RS_96] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_503] (rows=101592102 width=122) - Conds:RS_660._col0=RS_565._col0(Inner),Output:["_col1","_col2","_col3","_col4"] - <-Map 11 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_565] - PartitionCols:_col0 - Select Operator [SEL_556] (rows=652 width=4) - Output:["_col0"] - Filter Operator [FIL_552] (rows=652 width=8) - predicate:(d_year = 2002) - TableScan [TS_3] (rows=73049 width=8) - default@date_dim,date_dim,Tbl:COMPLETE,Col:COMPLETE,Output:["d_date_sk","d_year"] - <-Map 49 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_660] - PartitionCols:_col0 - Select Operator [SEL_659] (rows=286549727 width=127) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_658] (rows=286549727 width=127) - predicate:((cs_item_sk BETWEEN DynamicValue(RS_97_item_i_item_sk_min) AND DynamicValue(RS_97_item_i_item_sk_max) and in_bloom_filter(cs_item_sk, DynamicValue(RS_97_item_i_item_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_94_date_dim_d_date_sk_min) AND DynamicValue(RS_94_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_94_date_dim_d_date_sk_bloom_filter))) and cs_sold_date_sk is not null) - TableScan [TS_82] (rows=287989836 width=127) - default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["cs_sold_date_sk","cs_item_sk","cs_order_number","cs_quantity","cs_ext_sales_price"] - <-Reducer 28 [BROADCAST_EDGE] vectorized - BROADCAST [RS_655] - Group By Operator [GBY_654] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_580] - Group By Operator [GBY_574] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_566] (rows=652 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_556] - <-Reducer 41 [BROADCAST_EDGE] vectorized - BROADCAST [RS_657] - Group By Operator [GBY_656] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_608] - Group By Operator [GBY_602] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_594] (rows=45745 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_586] - <-Reducer 31 [CONTAINS] - Reduce Output Operator [RS_545] - PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 - Group By Operator [GBY_544] (rows=621178955 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Select Operator [SEL_542] (rows=450703984 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Merge Join Operator [MERGEJOIN_541] (rows=450703984 width=204) - Conds:RS_120._col1, _col2=RS_643._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] - <-Map 46 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_643] - PartitionCols:_col0, _col1 - Select Operator [SEL_641] (rows=57591150 width=119) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_30] (rows=57591150 width=119) - default@store_returns,store_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["sr_item_sk","sr_ticket_number","sr_return_quantity","sr_return_amt"] - <-Reducer 30 [SIMPLE_EDGE] - SHUFFLE [RS_120] - PartitionCols:_col1, _col2 - Merge Join Operator [MERGEJOIN_507] (rows=187186493 width=124) - Conds:RS_117._col1=RS_595._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] - <-Map 37 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_595] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_586] - <-Reducer 29 [SIMPLE_EDGE] - SHUFFLE [RS_117] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_506] (rows=196410188 width=109) - Conds:RS_670._col0=RS_567._col0(Inner),Output:["_col1","_col2","_col3","_col4"] - <-Map 11 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_567] - PartitionCols:_col0 - Select Operator [SEL_557] (rows=652 width=4) - Output:["_col0"] - Filter Operator [FIL_553] (rows=652 width=8) - predicate:(d_year = 2002) - Please refer to the previous TableScan [TS_3] - <-Map 50 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_670] - PartitionCols:_col0 - Select Operator [SEL_669] (rows=550076554 width=122) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_668] (rows=550076554 width=122) - predicate:((ss_item_sk BETWEEN DynamicValue(RS_118_item_i_item_sk_min) AND DynamicValue(RS_118_item_i_item_sk_max) and in_bloom_filter(ss_item_sk, DynamicValue(RS_118_item_i_item_sk_bloom_filter))) and (ss_sold_date_sk BETWEEN DynamicValue(RS_115_date_dim_d_date_sk_min) AND DynamicValue(RS_115_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_115_date_dim_d_date_sk_bloom_filter))) and ss_sold_date_sk is not null) - TableScan [TS_103] (rows=575995635 width=122) - default@store_sales,store_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ss_sold_date_sk","ss_item_sk","ss_ticket_number","ss_quantity","ss_ext_sales_price"] - <-Reducer 32 [BROADCAST_EDGE] vectorized - BROADCAST [RS_665] - Group By Operator [GBY_664] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_581] - Group By Operator [GBY_575] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_568] (rows=652 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_557] - <-Reducer 42 [BROADCAST_EDGE] vectorized - BROADCAST [RS_667] - Group By Operator [GBY_666] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_609] - Group By Operator [GBY_603] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_596] (rows=45745 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_586] - <-Reducer 35 [CONTAINS] - Reduce Output Operator [RS_550] - PartitionCols:_col0, _col1, _col2, _col3 - Group By Operator [GBY_549] (rows=736356923 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Select Operator [SEL_547] (rows=115177968 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Merge Join Operator [MERGEJOIN_546] (rows=115177968 width=220) - Conds:RS_148._col1, _col2=RS_653._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] - <-Map 48 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_653] - PartitionCols:_col0, _col1 - Select Operator [SEL_651] (rows=14398467 width=118) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_58] (rows=14398467 width=118) - default@web_returns,web_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["wr_item_sk","wr_order_number","wr_return_quantity","wr_return_amt"] - <-Reducer 34 [SIMPLE_EDGE] - SHUFFLE [RS_148] - PartitionCols:_col1, _col2 - Merge Join Operator [MERGEJOIN_510] (rows=48990732 width=139) - Conds:RS_145._col1=RS_597._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] - <-Map 37 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_597] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_586] - <-Reducer 33 [SIMPLE_EDGE] - SHUFFLE [RS_145] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_509] (rows=51404771 width=123) - Conds:RS_677._col0=RS_569._col0(Inner),Output:["_col1","_col2","_col3","_col4"] - <-Map 11 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_569] - PartitionCols:_col0 - Select Operator [SEL_558] (rows=652 width=4) - Output:["_col0"] - Filter Operator [FIL_554] (rows=652 width=8) - predicate:(d_year = 2002) - Please refer to the previous TableScan [TS_3] - <-Map 51 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_677] - PartitionCols:_col0 - Select Operator [SEL_676] (rows=143966864 width=127) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_675] (rows=143966864 width=127) - predicate:((ws_item_sk BETWEEN DynamicValue(RS_146_item_i_item_sk_min) AND DynamicValue(RS_146_item_i_item_sk_max) and in_bloom_filter(ws_item_sk, DynamicValue(RS_146_item_i_item_sk_bloom_filter))) and (ws_sold_date_sk BETWEEN DynamicValue(RS_143_date_dim_d_date_sk_min) AND DynamicValue(RS_143_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_143_date_dim_d_date_sk_bloom_filter))) and ws_sold_date_sk is not null) - TableScan [TS_131] (rows=144002668 width=127) - default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_date_sk","ws_item_sk","ws_order_number","ws_quantity","ws_ext_sales_price"] - <-Reducer 36 [BROADCAST_EDGE] vectorized - BROADCAST [RS_672] - Group By Operator [GBY_671] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_582] - Group By Operator [GBY_576] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_570] (rows=652 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_558] - <-Reducer 43 [BROADCAST_EDGE] vectorized - BROADCAST [RS_674] - Group By Operator [GBY_673] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_610] - Group By Operator [GBY_604] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_598] (rows=45745 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_586] + Group By Operator [GBY_626] (rows=84235776 width=135) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3 + Group By Operator [GBY_625] (rows=736356923 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 + <-Union 26 [SIMPLE_EDGE] + <-Reducer 25 [CONTAINS] vectorized + Reduce Output Operator [RS_661] + PartitionCols:_col0, _col1, _col2, _col3 + Group By Operator [GBY_660] (rows=736356923 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Group By Operator [GBY_659] (rows=621178955 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 + <-Union 24 [SIMPLE_EDGE] + <-Reducer 23 [CONTAINS] + Reduce Output Operator [RS_536] + PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 + Group By Operator [GBY_535] (rows=621178955 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Select Operator [SEL_533] (rows=170474971 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Merge Join Operator [MERGEJOIN_532] (rows=170474971 width=234) + Conds:RS_99._col1, _col2=RS_618._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] + <-Map 44 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_618] + PartitionCols:_col0, _col1 + Select Operator [SEL_616] (rows=28798881 width=121) + Output:["_col0","_col1","_col2","_col3"] + TableScan [TS_9] (rows=28798881 width=121) + default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["cr_item_sk","cr_order_number","cr_return_quantity","cr_return_amount"] + <-Reducer 22 [SIMPLE_EDGE] + SHUFFLE [RS_99] + PartitionCols:_col1, _col2 + Merge Join Operator [MERGEJOIN_504] (rows=96821196 width=138) + Conds:RS_96._col1=RS_593._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] + <-Map 37 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_593] + PartitionCols:_col0 + Select Operator [SEL_586] (rows=45745 width=19) + Output:["_col0","_col1","_col2","_col3","_col4"] + Filter Operator [FIL_585] (rows=45745 width=109) + predicate:((i_category = 'Sports') and i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_manufact_id is not null) + TableScan [TS_6] (rows=462000 width=109) + default@item,item,Tbl:COMPLETE,Col:COMPLETE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"] + <-Reducer 21 [SIMPLE_EDGE] + SHUFFLE [RS_96] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_503] (rows=101592102 width=122) + Conds:RS_658._col0=RS_565._col0(Inner),Output:["_col1","_col2","_col3","_col4"] + <-Map 11 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_565] + PartitionCols:_col0 + Select Operator [SEL_556] (rows=652 width=4) + Output:["_col0"] + Filter Operator [FIL_552] (rows=652 width=8) + predicate:(d_year = 2002) + TableScan [TS_3] (rows=73049 width=8) + default@date_dim,date_dim,Tbl:COMPLETE,Col:COMPLETE,Output:["d_date_sk","d_year"] + <-Map 49 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_658] + PartitionCols:_col0 + Select Operator [SEL_657] (rows=286549727 width=127) + Output:["_col0","_col1","_col2","_col3","_col4"] + Filter Operator [FIL_656] (rows=286549727 width=127) + predicate:((cs_item_sk BETWEEN DynamicValue(RS_97_item_i_item_sk_min) AND DynamicValue(RS_97_item_i_item_sk_max) and in_bloom_filter(cs_item_sk, DynamicValue(RS_97_item_i_item_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_94_date_dim_d_date_sk_min) AND DynamicValue(RS_94_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_94_date_dim_d_date_sk_bloom_filter))) and cs_sold_date_sk is not null) + TableScan [TS_82] (rows=287989836 width=127) + default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["cs_sold_date_sk","cs_item_sk","cs_order_number","cs_quantity","cs_ext_sales_price"] + <-Reducer 28 [BROADCAST_EDGE] vectorized + BROADCAST [RS_653] + Group By Operator [GBY_652] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_580] + Group By Operator [GBY_574] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_566] (rows=652 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_556] + <-Reducer 41 [BROADCAST_EDGE] vectorized + BROADCAST [RS_655] + Group By Operator [GBY_654] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_608] + Group By Operator [GBY_602] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_594] (rows=45745 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_586] + <-Reducer 31 [CONTAINS] + Reduce Output Operator [RS_545] + PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 + Group By Operator [GBY_544] (rows=621178955 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Select Operator [SEL_542] (rows=450703984 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Merge Join Operator [MERGEJOIN_541] (rows=450703984 width=204) + Conds:RS_120._col1, _col2=RS_641._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] + <-Map 46 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_641] + PartitionCols:_col0, _col1 + Select Operator [SEL_639] (rows=57591150 width=119) + Output:["_col0","_col1","_col2","_col3"] + TableScan [TS_30] (rows=57591150 width=119) + default@store_returns,store_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["sr_item_sk","sr_ticket_number","sr_return_quantity","sr_return_amt"] + <-Reducer 30 [SIMPLE_EDGE] + SHUFFLE [RS_120] + PartitionCols:_col1, _col2 + Merge Join Operator [MERGEJOIN_507] (rows=187186493 width=124) + Conds:RS_117._col1=RS_595._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] + <-Map 37 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_595] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_586] + <-Reducer 29 [SIMPLE_EDGE] + SHUFFLE [RS_117] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_506] (rows=196410188 width=109) + Conds:RS_668._col0=RS_567._col0(Inner),Output:["_col1","_col2","_col3","_col4"] + <-Map 11 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_567] + PartitionCols:_col0 + Select Operator [SEL_557] (rows=652 width=4) + Output:["_col0"] + Filter Operator [FIL_553] (rows=652 width=8) + predicate:(d_year = 2002) + Please refer to the previous TableScan [TS_3] + <-Map 50 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_668] + PartitionCols:_col0 + Select Operator [SEL_667] (rows=550076554 width=122) + Output:["_col0","_col1","_col2","_col3","_col4"] + Filter Operator [FIL_666] (rows=550076554 width=122) + predicate:((ss_item_sk BETWEEN DynamicValue(RS_118_item_i_item_sk_min) AND DynamicValue(RS_118_item_i_item_sk_max) and in_bloom_filter(ss_item_sk, DynamicValue(RS_118_item_i_item_sk_bloom_filter))) and (ss_sold_date_sk BETWEEN DynamicValue(RS_115_date_dim_d_date_sk_min) AND DynamicValue(RS_115_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_115_date_dim_d_date_sk_bloom_filter))) and ss_sold_date_sk is not null) + TableScan [TS_103] (rows=575995635 width=122) + default@store_sales,store_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ss_sold_date_sk","ss_item_sk","ss_ticket_number","ss_quantity","ss_ext_sales_price"] + <-Reducer 32 [BROADCAST_EDGE] vectorized + BROADCAST [RS_663] + Group By Operator [GBY_662] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_581] + Group By Operator [GBY_575] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_568] (rows=652 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_557] + <-Reducer 42 [BROADCAST_EDGE] vectorized + BROADCAST [RS_665] + Group By Operator [GBY_664] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_609] + Group By Operator [GBY_603] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_596] (rows=45745 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_586] + <-Reducer 35 [CONTAINS] + Reduce Output Operator [RS_550] + PartitionCols:_col0, _col1, _col2, _col3 + Group By Operator [GBY_549] (rows=736356923 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Select Operator [SEL_547] (rows=115177968 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Merge Join Operator [MERGEJOIN_546] (rows=115177968 width=220) + Conds:RS_148._col1, _col2=RS_651._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] + <-Map 48 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_651] + PartitionCols:_col0, _col1 + Select Operator [SEL_649] (rows=14398467 width=118) + Output:["_col0","_col1","_col2","_col3"] + TableScan [TS_58] (rows=14398467 width=118) + default@web_returns,web_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["wr_item_sk","wr_order_number","wr_return_quantity","wr_return_amt"] + <-Reducer 34 [SIMPLE_EDGE] + SHUFFLE [RS_148] + PartitionCols:_col1, _col2 + Merge Join Operator [MERGEJOIN_510] (rows=48990732 width=139) + Conds:RS_145._col1=RS_597._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] + <-Map 37 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_597] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_586] + <-Reducer 33 [SIMPLE_EDGE] + SHUFFLE [RS_145] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_509] (rows=51404771 width=123) + Conds:RS_675._col0=RS_569._col0(Inner),Output:["_col1","_col2","_col3","_col4"] + <-Map 11 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_569] + PartitionCols:_col0 + Select Operator [SEL_558] (rows=652 width=4) + Output:["_col0"] + Filter Operator [FIL_554] (rows=652 width=8) + predicate:(d_year = 2002) + Please refer to the previous TableScan [TS_3] + <-Map 51 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_675] + PartitionCols:_col0 + Select Operator [SEL_674] (rows=143966864 width=127) + Output:["_col0","_col1","_col2","_col3","_col4"] + Filter Operator [FIL_673] (rows=143966864 width=127) + predicate:((ws_item_sk BETWEEN DynamicValue(RS_146_item_i_item_sk_min) AND DynamicValue(RS_146_item_i_item_sk_max) and in_bloom_filter(ws_item_sk, DynamicValue(RS_146_item_i_item_sk_bloom_filter))) and (ws_sold_date_sk BETWEEN DynamicValue(RS_143_date_dim_d_date_sk_min) AND DynamicValue(RS_143_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_143_date_dim_d_date_sk_bloom_filter))) and ws_sold_date_sk is not null) + TableScan [TS_131] (rows=144002668 width=127) + default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_date_sk","ws_item_sk","ws_order_number","ws_quantity","ws_ext_sales_price"] + <-Reducer 36 [BROADCAST_EDGE] vectorized + BROADCAST [RS_670] + Group By Operator [GBY_669] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_582] + Group By Operator [GBY_576] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_570] (rows=652 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_558] + <-Reducer 43 [BROADCAST_EDGE] vectorized + BROADCAST [RS_672] + Group By Operator [GBY_671] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_610] + Group By Operator [GBY_604] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_598] (rows=45745 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_586] <-Reducer 8 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_625] + SHUFFLE [RS_624] PartitionCols:_col0, _col1, _col2, _col3 - Select Operator [SEL_624] (rows=84235776 width=247) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - Group By Operator [GBY_623] (rows=84235776 width=135) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3 - Group By Operator [GBY_622] (rows=736356923 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 - <-Union 7 [SIMPLE_EDGE] - <-Reducer 19 [CONTAINS] - Reduce Output Operator [RS_531] - PartitionCols:_col0, _col1, _col2, _col3 - Group By Operator [GBY_530] (rows=736356923 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Select Operator [SEL_528] (rows=115177968 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Merge Join Operator [MERGEJOIN_527] (rows=115177968 width=220) - Conds:RS_66._col1, _col2=RS_652._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] - <-Map 48 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_652] - PartitionCols:_col0, _col1 - Please refer to the previous Select Operator [SEL_651] - <-Reducer 18 [SIMPLE_EDGE] - SHUFFLE [RS_66] - PartitionCols:_col1, _col2 - Merge Join Operator [MERGEJOIN_501] (rows=48990732 width=139) - Conds:RS_63._col1=RS_591._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] - <-Map 37 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_591] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_586] - <-Reducer 17 [SIMPLE_EDGE] - SHUFFLE [RS_63] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_500] (rows=51404771 width=123) - Conds:RS_650._col0=RS_563._col0(Inner),Output:["_col1","_col2","_col3","_col4"] - <-Map 11 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_563] - PartitionCols:_col0 - Select Operator [SEL_555] (rows=652 width=4) - Output:["_col0"] - Filter Operator [FIL_551] (rows=652 width=8) - predicate:(d_year = 2001) - Please refer to the previous TableScan [TS_3] - <-Map 47 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_650] - PartitionCols:_col0 - Select Operator [SEL_649] (rows=143966864 width=127) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_648] (rows=143966864 width=127) - predicate:((ws_item_sk BETWEEN DynamicValue(RS_64_item_i_item_sk_min) AND DynamicValue(RS_64_item_i_item_sk_max) and in_bloom_filter(ws_item_sk, DynamicValue(RS_64_item_i_item_sk_bloom_filter))) and (ws_sold_date_sk BETWEEN DynamicValue(RS_61_date_dim_d_date_sk_min) AND DynamicValue(RS_61_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_61_date_dim_d_date_sk_bloom_filter))) and ws_sold_date_sk is not null) - TableScan [TS_49] (rows=144002668 width=127) - default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_date_sk","ws_item_sk","ws_order_number","ws_quantity","ws_ext_sales_price"] - <-Reducer 20 [BROADCAST_EDGE] vectorized - BROADCAST [RS_645] - Group By Operator [GBY_644] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_579] - Group By Operator [GBY_573] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_564] (rows=652 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_555] - <-Reducer 40 [BROADCAST_EDGE] vectorized - BROADCAST [RS_647] - Group By Operator [GBY_646] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_607] - Group By Operator [GBY_601] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_592] (rows=45745 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_586] - <-Reducer 6 [CONTAINS] vectorized - Reduce Output Operator [RS_621] - PartitionCols:_col0, _col1, _col2, _col3 - Group By Operator [GBY_620] (rows=736356923 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Group By Operator [GBY_619] (rows=621178955 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 - <-Union 5 [SIMPLE_EDGE] - <-Reducer 15 [CONTAINS] - Reduce Output Operator [RS_526] - PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 - Group By Operator [GBY_525] (rows=621178955 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Select Operator [SEL_523] (rows=450703984 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Merge Join Operator [MERGEJOIN_522] (rows=450703984 width=204) - Conds:RS_38._col1, _col2=RS_642._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] - <-Map 46 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_642] - PartitionCols:_col0, _col1 - Please refer to the previous Select Operator [SEL_641] - <-Reducer 14 [SIMPLE_EDGE] - SHUFFLE [RS_38] - PartitionCols:_col1, _col2 - Merge Join Operator [MERGEJOIN_498] (rows=187186493 width=124) - Conds:RS_35._col1=RS_589._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] - <-Map 37 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_589] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_586] - <-Reducer 13 [SIMPLE_EDGE] - SHUFFLE [RS_35] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_497] (rows=196410188 width=109) - Conds:RS_640._col0=RS_561._col0(Inner),Output:["_col1","_col2","_col3","_col4"] - <-Map 11 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_561] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_555] - <-Map 45 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_640] - PartitionCols:_col0 - Select Operator [SEL_639] (rows=550076554 width=122) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_638] (rows=550076554 width=122) - predicate:((ss_item_sk BETWEEN DynamicValue(RS_36_item_i_item_sk_min) AND DynamicValue(RS_36_item_i_item_sk_max) and in_bloom_filter(ss_item_sk, DynamicValue(RS_36_item_i_item_sk_bloom_filter))) and (ss_sold_date_sk BETWEEN DynamicValue(RS_33_date_dim_d_date_sk_min) AND DynamicValue(RS_33_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_33_date_dim_d_date_sk_bloom_filter))) and ss_sold_date_sk is not null) - TableScan [TS_21] (rows=575995635 width=122) - default@store_sales,store_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ss_sold_date_sk","ss_item_sk","ss_ticket_number","ss_quantity","ss_ext_sales_price"] - <-Reducer 16 [BROADCAST_EDGE] vectorized - BROADCAST [RS_635] - Group By Operator [GBY_634] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_578] - Group By Operator [GBY_572] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_562] (rows=652 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_555] - <-Reducer 39 [BROADCAST_EDGE] vectorized - BROADCAST [RS_637] - Group By Operator [GBY_636] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_606] - Group By Operator [GBY_600] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_590] (rows=45745 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_586] - <-Reducer 4 [CONTAINS] - Reduce Output Operator [RS_517] - PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 - Group By Operator [GBY_516] (rows=621178955 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 - Select Operator [SEL_514] (rows=170474971 width=131) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Merge Join Operator [MERGEJOIN_513] (rows=170474971 width=234) - Conds:RS_17._col1, _col2=RS_617._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] - <-Map 44 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_617] - PartitionCols:_col0, _col1 - Please refer to the previous Select Operator [SEL_616] - <-Reducer 3 [SIMPLE_EDGE] - SHUFFLE [RS_17] - PartitionCols:_col1, _col2 - Merge Join Operator [MERGEJOIN_495] (rows=96821196 width=138) - Conds:RS_14._col1=RS_587._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] - <-Map 37 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_587] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_586] - <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_14] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_494] (rows=101592102 width=122) - Conds:RS_615._col0=RS_559._col0(Inner),Output:["_col1","_col2","_col3","_col4"] - <-Map 11 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_559] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_555] - <-Map 1 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_615] - PartitionCols:_col0 - Select Operator [SEL_614] (rows=286549727 width=127) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_613] (rows=286549727 width=127) - predicate:((cs_item_sk BETWEEN DynamicValue(RS_15_item_i_item_sk_min) AND DynamicValue(RS_15_item_i_item_sk_max) and in_bloom_filter(cs_item_sk, DynamicValue(RS_15_item_i_item_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_12_date_dim_d_date_sk_min) AND DynamicValue(RS_12_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_12_date_dim_d_date_sk_bloom_filter))) and cs_sold_date_sk is not null) - TableScan [TS_0] (rows=287989836 width=127) - default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["cs_sold_date_sk","cs_item_sk","cs_order_number","cs_quantity","cs_ext_sales_price"] - <-Reducer 12 [BROADCAST_EDGE] vectorized - BROADCAST [RS_584] - Group By Operator [GBY_583] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_577] - Group By Operator [GBY_571] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_560] (rows=652 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_555] - <-Reducer 38 [BROADCAST_EDGE] vectorized - BROADCAST [RS_612] - Group By Operator [GBY_611] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_605] - Group By Operator [GBY_599] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_588] (rows=45745 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_586] + Group By Operator [GBY_623] (rows=84235776 width=135) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3 + Group By Operator [GBY_622] (rows=736356923 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 + <-Union 7 [SIMPLE_EDGE] + <-Reducer 19 [CONTAINS] + Reduce Output Operator [RS_531] + PartitionCols:_col0, _col1, _col2, _col3 + Group By Operator [GBY_530] (rows=736356923 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Select Operator [SEL_528] (rows=115177968 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Merge Join Operator [MERGEJOIN_527] (rows=115177968 width=220) + Conds:RS_66._col1, _col2=RS_650._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] + <-Map 48 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_650] + PartitionCols:_col0, _col1 + Please refer to the previous Select Operator [SEL_649] + <-Reducer 18 [SIMPLE_EDGE] + SHUFFLE [RS_66] + PartitionCols:_col1, _col2 + Merge Join Operator [MERGEJOIN_501] (rows=48990732 width=139) + Conds:RS_63._col1=RS_591._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] + <-Map 37 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_591] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_586] + <-Reducer 17 [SIMPLE_EDGE] + SHUFFLE [RS_63] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_500] (rows=51404771 width=123) + Conds:RS_648._col0=RS_563._col0(Inner),Output:["_col1","_col2","_col3","_col4"] + <-Map 11 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_563] + PartitionCols:_col0 + Select Operator [SEL_555] (rows=652 width=4) + Output:["_col0"] + Filter Operator [FIL_551] (rows=652 width=8) + predicate:(d_year = 2001) + Please refer to the previous TableScan [TS_3] + <-Map 47 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_648] + PartitionCols:_col0 + Select Operator [SEL_647] (rows=143966864 width=127) + Output:["_col0","_col1","_col2","_col3","_col4"] + Filter Operator [FIL_646] (rows=143966864 width=127) + predicate:((ws_item_sk BETWEEN DynamicValue(RS_64_item_i_item_sk_min) AND DynamicValue(RS_64_item_i_item_sk_max) and in_bloom_filter(ws_item_sk, DynamicValue(RS_64_item_i_item_sk_bloom_filter))) and (ws_sold_date_sk BETWEEN DynamicValue(RS_61_date_dim_d_date_sk_min) AND DynamicValue(RS_61_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_61_date_dim_d_date_sk_bloom_filter))) and ws_sold_date_sk is not null) + TableScan [TS_49] (rows=144002668 width=127) + default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_date_sk","ws_item_sk","ws_order_number","ws_quantity","ws_ext_sales_price"] + <-Reducer 20 [BROADCAST_EDGE] vectorized + BROADCAST [RS_643] + Group By Operator [GBY_642] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_579] + Group By Operator [GBY_573] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_564] (rows=652 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_555] + <-Reducer 40 [BROADCAST_EDGE] vectorized + BROADCAST [RS_645] + Group By Operator [GBY_644] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 37 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_607] + Group By Operator [GBY_601] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_592] (rows=45745 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_586] + <-Reducer 6 [CONTAINS] vectorized + Reduce Output Operator [RS_621] + PartitionCols:_col0, _col1, _col2, _col3 + Group By Operator [GBY_620] (rows=736356923 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Group By Operator [GBY_619] (rows=621178955 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5 + <-Union 5 [SIMPLE_EDGE] + <-Reducer 15 [CONTAINS] + Reduce Output Operator [RS_526] + PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 + Group By Operator [GBY_525] (rows=621178955 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],keys:_col0, _col1, _col2, _col3, _col4, _col5 + Select Operator [SEL_523] (rows=450703984 width=131) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Merge Join Operator [MERGEJOIN_522] (rows=450703984 width=204) + Conds:RS_38._col1, _col2=RS_640._col0, _col1(Left Outer),Output:["_col3","_col4","_col7","_col8","_col9","_col10","_col13","_col14"] + <-Map 46 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_640] + PartitionCols:_col0, _col1 + Please refer to the previous Select Operator [SEL_639] + <-Reducer 14 [SIMPLE_EDGE] + SHUFFLE [RS_38] + PartitionCols:_col1, _col2 + Merge Join Operator [MERGEJOIN_498] (rows=187186493 width=124) + Conds:RS_35._col1=RS_589._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col7","_col8","_col9","_col10"] + <-Map 37 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_589] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_586] + <-Reducer 13 [SIMPLE_EDGE] + SHUFFLE [RS_35] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_497] (rows=196410188 width=109) + Conds:RS_638._col0=RS_561._col0(Inner),Output:["_col1","_col2","_col3","_col4"] + <-Map 11 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_561] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_555] + <-Map 45 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_638] + PartitionCols:_col0 + Select Operator [SEL_637] (rows=550076554 width=122) + Output:["_col0","_col1","_col2","_col3","_col4"] + Filter Operator [FIL_636] (rows=550076554 width=122) + predicate:((ss_item_sk BETWEEN DynamicValue(RS_36_item_i_item_sk_min) AND DynamicValue(RS_36_item_i_item_sk_max) and in_bloom_filter(ss_item_sk, DynamicValue(RS_36_item_i_item_sk_bloom_filter))) and (ss_sold_date_sk BETWEEN DynamicValue(RS_33_date_dim_d_date_sk_min) AND DynamicValue(RS_33_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_33_date_dim_d_date_sk_bloom_filter))) and ss_sold_date_sk is not null) + TableScan [TS_21] (rows=575995635 width=122) + default@store_sales,store_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ss_sold_date_sk","ss_item_sk","ss_ticket_number","ss_quantity","ss_ext_sales_price"] + <-Reducer 16 [BROADCAST_EDGE] vectorized + BROADCAST [RS_633] + Group By Operator [GBY_632] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 11 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_578] + Group By Operator [GBY_572] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_562] (rows=652 width=4) +
<TRUNCATED>
