Repository: hive Updated Branches: refs/heads/master 353c55e22 -> f4a48fdbb
http://git-wip-us.apache.org/repos/asf/hive/blob/f4a48fdb/ql/src/test/results/clientpositive/perf/tez/constraints/query83.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/constraints/query83.q.out b/ql/src/test/results/clientpositive/perf/tez/constraints/query83.q.out index 4c9fc68..0dea786 100644 --- a/ql/src/test/results/clientpositive/perf/tez/constraints/query83.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/constraints/query83.q.out @@ -166,23 +166,23 @@ Stage-0 limit:100 Stage-1 Reducer 7 vectorized - File Output Operator [FS_397] - Limit [LIM_396] (rows=100 width=260) + File Output Operator [FS_395] + Limit [LIM_394] (rows=100 width=260) Number of rows:100 - Select Operator [SEL_395] (rows=130021 width=260) + Select Operator [SEL_393] (rows=130021 width=260) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] <-Reducer 6 [SIMPLE_EDGE] SHUFFLE [RS_124] Select Operator [SEL_123] (rows=130021 width=260) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - Merge Join Operator [MERGEJOIN_360] (rows=130021 width=148) - Conds:RS_120._col0=RS_394._col0(Inner),Output:["_col0","_col1","_col2","_col4","_col5","_col7","_col8"] + Merge Join Operator [MERGEJOIN_360] (rows=130021 width=132) + Conds:RS_120._col0=RS_392._col0(Inner),Output:["_col0","_col1","_col3","_col5","_col6"] <-Reducer 14 [ONE_TO_ONE_EDGE] vectorized - FORWARD [RS_394] + FORWARD [RS_392] PartitionCols:_col0 - Select Operator [SEL_393] (rows=130021 width=116) + Select Operator [SEL_391] (rows=130021 width=116) Output:["_col0","_col1","_col2"] - Group By Operator [GBY_392] (rows=130021 width=108) + Group By Operator [GBY_390] (rows=130021 width=108) Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0 <-Reducer 13 [SIMPLE_EDGE] SHUFFLE [RS_114] @@ -241,7 +241,7 @@ Stage-0 SHUFFLE [RS_109] PartitionCols:_col0 Merge Join Operator [MERGEJOIN_353] (rows=13749816 width=107) - Conds:RS_391._col1=RS_367._col0(Inner),Output:["_col0","_col2","_col4"] + Conds:RS_389._col1=RS_367._col0(Inner),Output:["_col0","_col2","_col4"] <-Map 8 [SIMPLE_EDGE] vectorized SHUFFLE [RS_367] PartitionCols:_col0 @@ -250,89 +250,85 @@ Stage-0 TableScan [TS_3] (rows=462000 width=104) default@item,item,Tbl:COMPLETE,Col:COMPLETE,Output:["i_item_sk","i_item_id"] <-Map 22 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_391] + SHUFFLE [RS_389] PartitionCols:_col1 - Select Operator [SEL_390] (rows=13749816 width=11) + Select Operator [SEL_388] (rows=13749816 width=11) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_389] (rows=13749816 width=11) + Filter Operator [FIL_387] (rows=13749816 width=11) predicate:wr_returned_date_sk is not null TableScan [TS_78] (rows=14398467 width=11) default@web_returns,web_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["wr_returned_date_sk","wr_item_sk","wr_return_quantity"] <-Reducer 5 [ONE_TO_ONE_EDGE] FORWARD [RS_120] PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_359] (rows=134905 width=132) - Conds:RS_382._col0=RS_388._col0(Inner),Output:["_col0","_col1","_col2","_col4","_col5"] + Merge Join Operator [MERGEJOIN_359] (rows=134905 width=116) + Conds:RS_381._col0=RS_386._col0(Inner),Output:["_col0","_col1","_col3"] <-Reducer 11 [ONE_TO_ONE_EDGE] vectorized - FORWARD [RS_388] + FORWARD [RS_386] PartitionCols:_col0 - Select Operator [SEL_387] (rows=141711 width=116) - Output:["_col0","_col1","_col2"] - Group By Operator [GBY_386] (rows=141711 width=108) - Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0 - <-Reducer 10 [SIMPLE_EDGE] - SHUFFLE [RS_75] - PartitionCols:_col0 - Group By Operator [GBY_74] (rows=462000 width=108) - Output:["_col0","_col1"],aggregations:["sum(_col2)"],keys:_col4 - Merge Join Operator [MERGEJOIN_357] (rows=25343167 width=103) - Conds:RS_70._col0=RS_71._col0(Inner),Output:["_col2","_col4"] - <-Reducer 16 [SIMPLE_EDGE] - SHUFFLE [RS_71] - PartitionCols:_col0 - Please refer to the previous Merge Join Operator [MERGEJOIN_349] - <-Reducer 9 [SIMPLE_EDGE] - SHUFFLE [RS_70] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_350] (rows=55578005 width=107) - Conds:RS_385._col1=RS_366._col0(Inner),Output:["_col0","_col2","_col4"] - <-Map 8 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_366] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_364] - <-Map 21 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_385] - PartitionCols:_col1 - Select Operator [SEL_384] (rows=55578005 width=11) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_383] (rows=55578005 width=11) - predicate:sr_returned_date_sk is not null - TableScan [TS_39] (rows=57591150 width=11) - default@store_returns,store_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["sr_returned_date_sk","sr_item_sk","sr_return_quantity"] + Group By Operator [GBY_385] (rows=141711 width=108) + Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0 + <-Reducer 10 [SIMPLE_EDGE] + SHUFFLE [RS_75] + PartitionCols:_col0 + Group By Operator [GBY_74] (rows=462000 width=108) + Output:["_col0","_col1"],aggregations:["sum(_col2)"],keys:_col4 + Merge Join Operator [MERGEJOIN_357] (rows=25343167 width=103) + Conds:RS_70._col0=RS_71._col0(Inner),Output:["_col2","_col4"] + <-Reducer 16 [SIMPLE_EDGE] + SHUFFLE [RS_71] + PartitionCols:_col0 + Please refer to the previous Merge Join Operator [MERGEJOIN_349] + <-Reducer 9 [SIMPLE_EDGE] + SHUFFLE [RS_70] + PartitionCols:_col0 + Merge Join Operator [MERGEJOIN_350] (rows=55578005 width=107) + Conds:RS_384._col1=RS_366._col0(Inner),Output:["_col0","_col2","_col4"] + <-Map 8 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_366] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_364] + <-Map 21 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_384] + PartitionCols:_col1 + Select Operator [SEL_383] (rows=55578005 width=11) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_382] (rows=55578005 width=11) + predicate:sr_returned_date_sk is not null + TableScan [TS_39] (rows=57591150 width=11) + default@store_returns,store_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["sr_returned_date_sk","sr_item_sk","sr_return_quantity"] <-Reducer 4 [ONE_TO_ONE_EDGE] vectorized - FORWARD [RS_382] + FORWARD [RS_381] PartitionCols:_col0 - Select Operator [SEL_381] (rows=134905 width=116) - Output:["_col0","_col1","_col2"] - Group By Operator [GBY_380] (rows=134905 width=108) - Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0 - <-Reducer 3 [SIMPLE_EDGE] - SHUFFLE [RS_36] - PartitionCols:_col0 - Group By Operator [GBY_35] (rows=462000 width=108) - Output:["_col0","_col1"],aggregations:["sum(_col2)"],keys:_col4 - Merge Join Operator [MERGEJOIN_356] (rows=12501392 width=103) - Conds:RS_31._col0=RS_32._col0(Inner),Output:["_col2","_col4"] - <-Reducer 16 [SIMPLE_EDGE] - SHUFFLE [RS_32] - PartitionCols:_col0 - Please refer to the previous Merge Join Operator [MERGEJOIN_349] - <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_31] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_347] (rows=28798881 width=107) - Conds:RS_363._col1=RS_365._col0(Inner),Output:["_col0","_col2","_col4"] - <-Map 8 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_365] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_364] - <-Map 1 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_363] - PartitionCols:_col1 - Select Operator [SEL_362] (rows=28798881 width=11) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_361] (rows=28798881 width=11) - predicate:cr_returned_date_sk is not null - TableScan [TS_0] (rows=28798881 width=11) - default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["cr_returned_date_sk","cr_item_sk","cr_return_quantity"] + Group By Operator [GBY_380] (rows=134905 width=108) + Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0 + <-Reducer 3 [SIMPLE_EDGE] + SHUFFLE [RS_36] + PartitionCols:_col0 + Group By Operator [GBY_35] (rows=462000 width=108) + Output:["_col0","_col1"],aggregations:["sum(_col2)"],keys:_col4 + Merge Join Operator [MERGEJOIN_356] (rows=12501392 width=103) + Conds:RS_31._col0=RS_32._col0(Inner),Output:["_col2","_col4"] + <-Reducer 16 [SIMPLE_EDGE] + SHUFFLE [RS_32] + PartitionCols:_col0 + Please refer to the previous Merge Join Operator [MERGEJOIN_349] + <-Reducer 2 [SIMPLE_EDGE] + SHUFFLE [RS_31] + PartitionCols:_col0 + Merge Join Operator [MERGEJOIN_347] (rows=28798881 width=107) + Conds:RS_363._col1=RS_365._col0(Inner),Output:["_col0","_col2","_col4"] + <-Map 8 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_365] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_364] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_363] + PartitionCols:_col1 + Select Operator [SEL_362] (rows=28798881 width=11) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_361] (rows=28798881 width=11) + predicate:cr_returned_date_sk is not null + TableScan [TS_0] (rows=28798881 width=11) + default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["cr_returned_date_sk","cr_item_sk","cr_return_quantity"] http://git-wip-us.apache.org/repos/asf/hive/blob/f4a48fdb/ql/src/test/results/clientpositive/perf/tez/constraints/query90.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/constraints/query90.q.out b/ql/src/test/results/clientpositive/perf/tez/constraints/query90.q.out index 3b171da..f902607 100644 --- a/ql/src/test/results/clientpositive/perf/tez/constraints/query90.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/constraints/query90.q.out @@ -78,186 +78,182 @@ Stage-0 limit:100 Stage-1 Reducer 7 vectorized - File Output Operator [FS_211] - Limit [LIM_210] (rows=1 width=112) + File Output Operator [FS_209] + Limit [LIM_208] (rows=1 width=112) Number of rows:100 - Select Operator [SEL_209] (rows=1 width=112) + Select Operator [SEL_207] (rows=1 width=112) Output:["_col0"] <-Reducer 6 [SIMPLE_EDGE] SHUFFLE [RS_56] Select Operator [SEL_55] (rows=1 width=112) Output:["_col0"] - Merge Join Operator [MERGEJOIN_152] (rows=1 width=224) + Merge Join Operator [MERGEJOIN_152] (rows=1 width=16) Conds:(Inner),Output:["_col0","_col1"] <-Reducer 13 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_208] - Select Operator [SEL_207] (rows=1 width=112) - Output:["_col0"] - Group By Operator [GBY_206] (rows=1 width=8) - Output:["_col0"],aggregations:["count(VALUE._col0)"] - <-Reducer 12 [CUSTOM_SIMPLE_EDGE] - PARTITION_ONLY_SHUFFLE [RS_49] - Group By Operator [GBY_48] (rows=1 width=8) - Output:["_col0"],aggregations:["count()"] - Merge Join Operator [MERGEJOIN_151] (rows=153010 width=8) - Conds:RS_44._col1=RS_183._col0(Inner) - <-Map 18 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_183] - PartitionCols:_col0 - Select Operator [SEL_180] (rows=655 width=4) - Output:["_col0"] - Filter Operator [FIL_179] (rows=655 width=8) - predicate:(hd_dep_count = 8) - TableScan [TS_9] (rows=7200 width=8) - default@household_demographics,household_demographics,Tbl:COMPLETE,Col:COMPLETE,Output:["hd_demo_sk","hd_dep_count"] - <-Reducer 11 [SIMPLE_EDGE] - SHUFFLE [RS_44] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_150] (rows=1681936 width=3) - Conds:RS_41._col0=RS_171._col0(Inner),Output:["_col1"] - <-Map 15 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_171] - PartitionCols:_col0 - Select Operator [SEL_168] (rows=9095 width=4) - Output:["_col0"] - Filter Operator [FIL_166] (rows=9095 width=8) - predicate:t_hour BETWEEN 14 AND 15 - TableScan [TS_6] (rows=86400 width=8) - default@time_dim,time_dim,Tbl:COMPLETE,Col:COMPLETE,Output:["t_time_sk","t_hour"] - <-Reducer 10 [SIMPLE_EDGE] - SHUFFLE [RS_41] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_149] (rows=15977923 width=7) - Conds:RS_205._col2=RS_157._col0(Inner),Output:["_col0","_col1"] - <-Map 8 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_157] - PartitionCols:_col0 - Select Operator [SEL_154] (rows=511 width=4) - Output:["_col0"] - Filter Operator [FIL_153] (rows=511 width=7) - predicate:wp_char_count BETWEEN 5000 AND 5200 - TableScan [TS_3] (rows=4602 width=7) - default@web_page,web_page,Tbl:COMPLETE,Col:COMPLETE,Output:["wp_web_page_sk","wp_char_count"] - <-Map 21 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_205] - PartitionCols:_col2 - Select Operator [SEL_204] (rows=143895111 width=11) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_203] (rows=143895111 width=11) - predicate:((ws_ship_hdemo_sk BETWEEN DynamicValue(RS_45_household_demographics_hd_demo_sk_min) AND DynamicValue(RS_45_household_demographics_hd_demo_sk_max) and in_bloom_filter(ws_ship_hdemo_sk, DynamicValue(RS_45_household_demographics_hd_demo_sk_bloom_filter))) and (ws_sold_time_sk BETWEEN DynamicValue(RS_42_time_dim_t_time_sk_min) AND DynamicValue(RS_42_time_dim_t_time_sk_max) and in_bloom_filter(ws_sold_time_sk, DynamicValue(RS_42_time_dim_t_time_sk_bloom_filter))) and (ws_web_page_sk BETWEEN DynamicValue(RS_39_web_page_wp_web_page_sk_min) AND DynamicValue(RS_39_web_page_wp_web_page_sk_max) and in_bloom_filter(ws_web_page_sk, DynamicValue(RS_39_web_page_wp_web_page_sk_bloom_filter))) and ws_ship_hdemo_sk is not null and ws_sold_time_sk is not null and ws_web_page_sk is not null) - TableScan [TS_26] (rows=144002668 width=11) - default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"] - <-Reducer 14 [BROADCAST_EDGE] vectorized - BROADCAST [RS_198] - Group By Operator [GBY_197] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 8 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_162] - Group By Operator [GBY_160] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_158] (rows=511 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_154] - <-Reducer 17 [BROADCAST_EDGE] vectorized - BROADCAST [RS_200] - Group By Operator [GBY_199] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 15 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_176] - Group By Operator [GBY_174] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_172] (rows=9095 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_168] - <-Reducer 20 [BROADCAST_EDGE] vectorized - BROADCAST [RS_202] - Group By Operator [GBY_201] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 18 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_188] - Group By Operator [GBY_186] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_184] (rows=655 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_180] + PARTITION_ONLY_SHUFFLE [RS_206] + Group By Operator [GBY_205] (rows=1 width=8) + Output:["_col0"],aggregations:["count(VALUE._col0)"] + <-Reducer 12 [CUSTOM_SIMPLE_EDGE] + PARTITION_ONLY_SHUFFLE [RS_49] + Group By Operator [GBY_48] (rows=1 width=8) + Output:["_col0"],aggregations:["count()"] + Merge Join Operator [MERGEJOIN_151] (rows=153010 width=8) + Conds:RS_44._col1=RS_183._col0(Inner) + <-Map 18 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_183] + PartitionCols:_col0 + Select Operator [SEL_180] (rows=655 width=4) + Output:["_col0"] + Filter Operator [FIL_179] (rows=655 width=8) + predicate:(hd_dep_count = 8) + TableScan [TS_9] (rows=7200 width=8) + default@household_demographics,household_demographics,Tbl:COMPLETE,Col:COMPLETE,Output:["hd_demo_sk","hd_dep_count"] + <-Reducer 11 [SIMPLE_EDGE] + SHUFFLE [RS_44] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_150] (rows=1681936 width=3) + Conds:RS_41._col0=RS_171._col0(Inner),Output:["_col1"] + <-Map 15 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_171] + PartitionCols:_col0 + Select Operator [SEL_168] (rows=9095 width=4) + Output:["_col0"] + Filter Operator [FIL_166] (rows=9095 width=8) + predicate:t_hour BETWEEN 14 AND 15 + TableScan [TS_6] (rows=86400 width=8) + default@time_dim,time_dim,Tbl:COMPLETE,Col:COMPLETE,Output:["t_time_sk","t_hour"] + <-Reducer 10 [SIMPLE_EDGE] + SHUFFLE [RS_41] + PartitionCols:_col0 + Merge Join Operator [MERGEJOIN_149] (rows=15977923 width=7) + Conds:RS_204._col2=RS_157._col0(Inner),Output:["_col0","_col1"] + <-Map 8 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_157] + PartitionCols:_col0 + Select Operator [SEL_154] (rows=511 width=4) + Output:["_col0"] + Filter Operator [FIL_153] (rows=511 width=7) + predicate:wp_char_count BETWEEN 5000 AND 5200 + TableScan [TS_3] (rows=4602 width=7) + default@web_page,web_page,Tbl:COMPLETE,Col:COMPLETE,Output:["wp_web_page_sk","wp_char_count"] + <-Map 21 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_204] + PartitionCols:_col2 + Select Operator [SEL_203] (rows=143895111 width=11) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_202] (rows=143895111 width=11) + predicate:((ws_ship_hdemo_sk BETWEEN DynamicValue(RS_45_household_demographics_hd_demo_sk_min) AND DynamicValue(RS_45_household_demographics_hd_demo_sk_max) and in_bloom_filter(ws_ship_hdemo_sk, DynamicValue(RS_45_household_demographics_hd_demo_sk_bloom_filter))) and (ws_sold_time_sk BETWEEN DynamicValue(RS_42_time_dim_t_time_sk_min) AND DynamicValue(RS_42_time_dim_t_time_sk_max) and in_bloom_filter(ws_sold_time_sk, DynamicValue(RS_42_time_dim_t_time_sk_bloom_filter))) and (ws_web_page_sk BETWEEN DynamicValue(RS_39_web_page_wp_web_page_sk_min) AND DynamicValue(RS_39_web_page_wp_web_page_sk_max) and in_bloom_filter(ws_web_page_sk, DynamicValue(RS_39_web_page_wp_web_page_sk_bloom_filter))) and ws_ship_hdemo_sk is not null and ws_sold_time_sk is not null and ws_web_page_sk is not null) + TableScan [TS_26] (rows=144002668 width=11) + default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"] + <-Reducer 14 [BROADCAST_EDGE] vectorized + BROADCAST [RS_197] + Group By Operator [GBY_196] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 8 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_162] + Group By Operator [GBY_160] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_158] (rows=511 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_154] + <-Reducer 17 [BROADCAST_EDGE] vectorized + BROADCAST [RS_199] + Group By Operator [GBY_198] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 15 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_176] + Group By Operator [GBY_174] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_172] (rows=9095 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_168] + <-Reducer 20 [BROADCAST_EDGE] vectorized + BROADCAST [RS_201] + Group By Operator [GBY_200] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 18 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_188] + Group By Operator [GBY_186] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_184] (rows=655 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_180] <-Reducer 5 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_196] - Select Operator [SEL_195] (rows=1 width=112) - Output:["_col0"] - Group By Operator [GBY_194] (rows=1 width=8) - Output:["_col0"],aggregations:["count(VALUE._col0)"] - <-Reducer 4 [CUSTOM_SIMPLE_EDGE] - PARTITION_ONLY_SHUFFLE [RS_23] - Group By Operator [GBY_22] (rows=1 width=8) - Output:["_col0"],aggregations:["count()"] - Merge Join Operator [MERGEJOIN_148] (rows=153010 width=8) - Conds:RS_18._col1=RS_181._col0(Inner) - <-Map 18 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_181] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_180] - <-Reducer 3 [SIMPLE_EDGE] - SHUFFLE [RS_18] - PartitionCols:_col1 - Merge Join Operator [MERGEJOIN_147] (rows=1681936 width=3) - Conds:RS_15._col0=RS_169._col0(Inner),Output:["_col1"] - <-Map 15 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_169] - PartitionCols:_col0 - Select Operator [SEL_167] (rows=9095 width=4) - Output:["_col0"] - Filter Operator [FIL_165] (rows=9095 width=8) - predicate:t_hour BETWEEN 6 AND 7 - Please refer to the previous TableScan [TS_6] - <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_15] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_146] (rows=15977923 width=7) - Conds:RS_193._col2=RS_155._col0(Inner),Output:["_col0","_col1"] - <-Map 8 [SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_155] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_154] - <-Map 1 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_193] - PartitionCols:_col2 - Select Operator [SEL_192] (rows=143895111 width=11) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_191] (rows=143895111 width=11) - predicate:((ws_ship_hdemo_sk BETWEEN DynamicValue(RS_19_household_demographics_hd_demo_sk_min) AND DynamicValue(RS_19_household_demographics_hd_demo_sk_max) and in_bloom_filter(ws_ship_hdemo_sk, DynamicValue(RS_19_household_demographics_hd_demo_sk_bloom_filter))) and (ws_sold_time_sk BETWEEN DynamicValue(RS_16_time_dim_t_time_sk_min) AND DynamicValue(RS_16_time_dim_t_time_sk_max) and in_bloom_filter(ws_sold_time_sk, DynamicValue(RS_16_time_dim_t_time_sk_bloom_filter))) and (ws_web_page_sk BETWEEN DynamicValue(RS_13_web_page_wp_web_page_sk_min) AND DynamicValue(RS_13_web_page_wp_web_page_sk_max) and in_bloom_filter(ws_web_page_sk, DynamicValue(RS_13_web_page_wp_web_page_sk_bloom_filter))) and ws_ship_hdemo_sk is not null and ws_sold_time_sk is not null and ws_web_page_sk is not null) - TableScan [TS_0] (rows=144002668 width=11) - default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"] - <-Reducer 16 [BROADCAST_EDGE] vectorized - BROADCAST [RS_178] - Group By Operator [GBY_177] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 15 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_175] - Group By Operator [GBY_173] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_170] (rows=9095 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_167] - <-Reducer 19 [BROADCAST_EDGE] vectorized - BROADCAST [RS_190] - Group By Operator [GBY_189] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 18 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_187] - Group By Operator [GBY_185] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_182] (rows=655 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_180] - <-Reducer 9 [BROADCAST_EDGE] vectorized - BROADCAST [RS_164] - Group By Operator [GBY_163] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 8 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_161] - Group By Operator [GBY_159] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_156] (rows=511 width=4) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_154] + PARTITION_ONLY_SHUFFLE [RS_195] + Group By Operator [GBY_194] (rows=1 width=8) + Output:["_col0"],aggregations:["count(VALUE._col0)"] + <-Reducer 4 [CUSTOM_SIMPLE_EDGE] + PARTITION_ONLY_SHUFFLE [RS_23] + Group By Operator [GBY_22] (rows=1 width=8) + Output:["_col0"],aggregations:["count()"] + Merge Join Operator [MERGEJOIN_148] (rows=153010 width=8) + Conds:RS_18._col1=RS_181._col0(Inner) + <-Map 18 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_181] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_180] + <-Reducer 3 [SIMPLE_EDGE] + SHUFFLE [RS_18] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_147] (rows=1681936 width=3) + Conds:RS_15._col0=RS_169._col0(Inner),Output:["_col1"] + <-Map 15 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_169] + PartitionCols:_col0 + Select Operator [SEL_167] (rows=9095 width=4) + Output:["_col0"] + Filter Operator [FIL_165] (rows=9095 width=8) + predicate:t_hour BETWEEN 6 AND 7 + Please refer to the previous TableScan [TS_6] + <-Reducer 2 [SIMPLE_EDGE] + SHUFFLE [RS_15] + PartitionCols:_col0 + Merge Join Operator [MERGEJOIN_146] (rows=15977923 width=7) + Conds:RS_193._col2=RS_155._col0(Inner),Output:["_col0","_col1"] + <-Map 8 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_155] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_154] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_193] + PartitionCols:_col2 + Select Operator [SEL_192] (rows=143895111 width=11) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_191] (rows=143895111 width=11) + predicate:((ws_ship_hdemo_sk BETWEEN DynamicValue(RS_19_household_demographics_hd_demo_sk_min) AND DynamicValue(RS_19_household_demographics_hd_demo_sk_max) and in_bloom_filter(ws_ship_hdemo_sk, DynamicValue(RS_19_household_demographics_hd_demo_sk_bloom_filter))) and (ws_sold_time_sk BETWEEN DynamicValue(RS_16_time_dim_t_time_sk_min) AND DynamicValue(RS_16_time_dim_t_time_sk_max) and in_bloom_filter(ws_sold_time_sk, DynamicValue(RS_16_time_dim_t_time_sk_bloom_filter))) and (ws_web_page_sk BETWEEN DynamicValue(RS_13_web_page_wp_web_page_sk_min) AND DynamicValue(RS_13_web_page_wp_web_page_sk_max) and in_bloom_filter(ws_web_page_sk, DynamicValue(RS_13_web_page_wp_web_page_sk_bloom_filter))) and ws_ship_hdemo_sk is not null and ws_sold_time_sk is not null and ws_web_page_sk is not null) + TableScan [TS_0] (rows=144002668 width=11) + default@web_sales,web_sales,Tbl:COMPLETE,Col:COMPLETE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"] + <-Reducer 16 [BROADCAST_EDGE] vectorized + BROADCAST [RS_178] + Group By Operator [GBY_177] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 15 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_175] + Group By Operator [GBY_173] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_170] (rows=9095 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_167] + <-Reducer 19 [BROADCAST_EDGE] vectorized + BROADCAST [RS_190] + Group By Operator [GBY_189] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 18 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_187] + Group By Operator [GBY_185] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_182] (rows=655 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_180] + <-Reducer 9 [BROADCAST_EDGE] vectorized + BROADCAST [RS_164] + Group By Operator [GBY_163] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 8 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_161] + Group By Operator [GBY_159] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_156] (rows=511 width=4) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_154]
