http://git-wip-us.apache.org/repos/asf/hive/blob/851c8aba/ql/src/test/results/clientpositive/perf/tez/query14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query14.q.out b/ql/src/test/results/clientpositive/perf/tez/query14.q.out index 6d996b5..b9efa45 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query14.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query14.q.out @@ -1,6 +1,6 @@ -Warning: Shuffle Join MERGEJOIN[1454][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product -Warning: Shuffle Join MERGEJOIN[1466][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product -Warning: Shuffle Join MERGEJOIN[1478][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product +Warning: Shuffle Join MERGEJOIN[1455][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product +Warning: Shuffle Join MERGEJOIN[1468][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product +Warning: Shuffle Join MERGEJOIN[1481][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 @@ -314,1135 +314,1141 @@ Stage-0 limit:100 Stage-1 Reducer 8 vectorized - File Output Operator [FS_1739] - Limit [LIM_1738] (rows=100 width=237) + File Output Operator [FS_1743] + Limit [LIM_1742] (rows=100 width=237) Number of rows:100 - Select Operator [SEL_1737] (rows=1016388080 width=237) + Select Operator [SEL_1741] (rows=1016388080 width=237) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] <-Reducer 7 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1736] - Select Operator [SEL_1735] (rows=1016388080 width=237) + SHUFFLE [RS_1740] + Select Operator [SEL_1739] (rows=1016388080 width=237) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Group By Operator [GBY_1734] (rows=1016388080 width=237) + Group By Operator [GBY_1738] (rows=1016388080 width=237) Output:["_col0","_col1","_col2","_col3","_col5","_col6"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4 <-Union 6 [SIMPLE_EDGE] <-Reducer 12 [CONTAINS] - Reduce Output Operator [RS_1471] + Reduce Output Operator [RS_1474] PartitionCols:_col0, _col1, _col2, _col3, _col4 - Group By Operator [GBY_1470] (rows=2032776160 width=237) + Group By Operator [GBY_1473] (rows=2032776160 width=237) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0L - Select Operator [SEL_1468] (rows=116155905 width=264) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_1467] (rows=116155905 width=264) - predicate:(_col5 > _col1) - Merge Join Operator [MERGEJOIN_1466] (rows=348467716 width=264) - Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"] - <-Reducer 11 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_1745] - Select Operator [SEL_1744] (rows=1 width=8) - Filter Operator [FIL_1743] (rows=1 width=8) - predicate:(sq_count_check(_col0) <= 1) - Group By Operator [GBY_1742] (rows=1 width=8) - Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_1741] (rows=1 width=8) - Group By Operator [GBY_1740] (rows=1 width=8) - Output:["_col0"],aggregations:["count(VALUE._col0)"] - <-Union 10 [CUSTOM_SIMPLE_EDGE] - <-Reducer 19 [CONTAINS] - Reduce Output Operator [RS_1495] - Group By Operator [GBY_1494] (rows=1 width=8) - Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_1493] (rows=1108786976 width=108) - Output:["_col0"] - Select Operator [SEL_1491] (rows=316788826 width=135) + Top N Key Operator [TNK_1472] (rows=406555232 width=237) + keys:_col0, _col1, _col2, _col3, 0L,sort order:+++++,top n:100 + Select Operator [SEL_1470] (rows=116155905 width=264) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Filter Operator [FIL_1469] (rows=116155905 width=264) + predicate:(_col5 > _col1) + Merge Join Operator [MERGEJOIN_1468] (rows=348467716 width=264) + Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"] + <-Reducer 11 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1749] + Select Operator [SEL_1748] (rows=1 width=8) + Filter Operator [FIL_1747] (rows=1 width=8) + predicate:(sq_count_check(_col0) <= 1) + Group By Operator [GBY_1746] (rows=1 width=8) + Output:["_col0"],aggregations:["count()"] + Select Operator [SEL_1745] (rows=1 width=8) + Group By Operator [GBY_1744] (rows=1 width=8) + Output:["_col0"],aggregations:["count(VALUE._col0)"] + <-Union 10 [CUSTOM_SIMPLE_EDGE] + <-Reducer 19 [CONTAINS] + Reduce Output Operator [RS_1499] + Group By Operator [GBY_1498] (rows=1 width=8) + Output:["_col0"],aggregations:["count(_col0)"] + Select Operator [SEL_1497] (rows=1108786976 width=108) Output:["_col0"] - Merge Join Operator [MERGEJOIN_1490] (rows=316788826 width=135) - Conds:RS_1817._col0=RS_1804._col0(Inner),Output:["_col1"] - <-Map 21 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1804] - PartitionCols:_col0 - Select Operator [SEL_1799] (rows=8116 width=1119) - Output:["_col0"] - Filter Operator [FIL_1798] (rows=8116 width=1119) - predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000) - TableScan [TS_13] (rows=73049 width=1119) - default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] - <-Map 17 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1817] - PartitionCols:_col0 - Select Operator [SEL_1815] (rows=287989836 width=135) - Output:["_col0","_col1"] - Filter Operator [FIL_1814] (rows=287989836 width=135) - predicate:((cs_sold_date_sk BETWEEN DynamicValue(RS_17_date_dim_d_date_sk_min) AND DynamicValue(RS_17_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_17_date_dim_d_date_sk_bloom_filter))) and 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 22 [BROADCAST_EDGE] vectorized - BROADCAST [RS_1813] - Group By Operator [GBY_1812] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 21 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_1810] - Group By Operator [GBY_1808] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_1801] (rows=8116 width=1119) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_1799] - <-Reducer 35 [CONTAINS] - Reduce Output Operator [RS_1531] - Group By Operator [GBY_1530] (rows=1 width=8) - Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_1529] (rows=1108786976 width=108) - Output:["_col0"] - Select Operator [SEL_1527] (rows=158402938 width=135) + Select Operator [SEL_1495] (rows=316788826 width=135) + Output:["_col0"] + Merge Join Operator [MERGEJOIN_1494] (rows=316788826 width=135) + Conds:RS_1821._col0=RS_1808._col0(Inner),Output:["_col1"] + <-Map 21 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1808] + PartitionCols:_col0 + Select Operator [SEL_1803] (rows=8116 width=1119) + Output:["_col0"] + Filter Operator [FIL_1802] (rows=8116 width=1119) + predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000) + TableScan [TS_13] (rows=73049 width=1119) + default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] + <-Map 17 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1821] + PartitionCols:_col0 + Select Operator [SEL_1819] (rows=287989836 width=135) + Output:["_col0","_col1"] + Filter Operator [FIL_1818] (rows=287989836 width=135) + predicate:((cs_sold_date_sk BETWEEN DynamicValue(RS_17_date_dim_d_date_sk_min) AND DynamicValue(RS_17_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_17_date_dim_d_date_sk_bloom_filter))) and 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 22 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1817] + Group By Operator [GBY_1816] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 21 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1814] + Group By Operator [GBY_1812] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1805] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1803] + <-Reducer 35 [CONTAINS] + Reduce Output Operator [RS_1535] + Group By Operator [GBY_1534] (rows=1 width=8) + Output:["_col0"],aggregations:["count(_col0)"] + Select Operator [SEL_1533] (rows=1108786976 width=108) Output:["_col0"] - Merge Join Operator [MERGEJOIN_1526] (rows=158402938 width=135) - Conds:RS_1845._col0=RS_1832._col0(Inner),Output:["_col1"] - <-Map 37 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1832] - PartitionCols:_col0 - Select Operator [SEL_1827] (rows=8116 width=1119) - Output:["_col0"] - Filter Operator [FIL_1826] (rows=8116 width=1119) - predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000) - TableScan [TS_24] (rows=73049 width=1119) - default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] - <-Map 33 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1845] - PartitionCols:_col0 - Select Operator [SEL_1843] (rows=144002668 width=135) - Output:["_col0","_col1"] - Filter Operator [FIL_1842] (rows=144002668 width=135) - predicate:((ws_sold_date_sk BETWEEN DynamicValue(RS_28_date_dim_d_date_sk_min) AND DynamicValue(RS_28_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_28_date_dim_d_date_sk_bloom_filter))) and 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 38 [BROADCAST_EDGE] vectorized - BROADCAST [RS_1841] - Group By Operator [GBY_1840] (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 - SHUFFLE [RS_1838] - Group By Operator [GBY_1836] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_1829] (rows=8116 width=1119) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_1827] - <-Reducer 9 [CONTAINS] - Reduce Output Operator [RS_1465] - Group By Operator [GBY_1464] (rows=1 width=8) - Output:["_col0"],aggregations:["count(_col0)"] - Select Operator [SEL_1463] (rows=1108786976 width=108) - Output:["_col0"] - Select Operator [SEL_1461] (rows=633595212 width=88) + Select Operator [SEL_1531] (rows=158402938 width=135) + Output:["_col0"] + Merge Join Operator [MERGEJOIN_1530] (rows=158402938 width=135) + Conds:RS_1849._col0=RS_1836._col0(Inner),Output:["_col1"] + <-Map 37 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1836] + PartitionCols:_col0 + Select Operator [SEL_1831] (rows=8116 width=1119) + Output:["_col0"] + Filter Operator [FIL_1830] (rows=8116 width=1119) + predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000) + TableScan [TS_24] (rows=73049 width=1119) + default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] + <-Map 33 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1849] + PartitionCols:_col0 + Select Operator [SEL_1847] (rows=144002668 width=135) + Output:["_col0","_col1"] + Filter Operator [FIL_1846] (rows=144002668 width=135) + predicate:((ws_sold_date_sk BETWEEN DynamicValue(RS_28_date_dim_d_date_sk_min) AND DynamicValue(RS_28_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_28_date_dim_d_date_sk_bloom_filter))) and 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 38 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1845] + Group By Operator [GBY_1844] (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 + SHUFFLE [RS_1842] + Group By Operator [GBY_1840] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1833] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1831] + <-Reducer 9 [CONTAINS] + Reduce Output Operator [RS_1467] + Group By Operator [GBY_1466] (rows=1 width=8) + Output:["_col0"],aggregations:["count(_col0)"] + Select Operator [SEL_1465] (rows=1108786976 width=108) Output:["_col0"] - Merge Join Operator [MERGEJOIN_1460] (rows=633595212 width=88) - Conds:RS_1641._col0=RS_1622._col0(Inner),Output:["_col1"] - <-Map 102 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1622] - PartitionCols:_col0 - Select Operator [SEL_1611] (rows=8116 width=1119) - Output:["_col0"] - Filter Operator [FIL_1610] (rows=8116 width=1119) - predicate:(d_date_sk is not null and d_year BETWEEN 1999 AND 2001) - TableScan [TS_97] (rows=73049 width=1119) - default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] - <-Map 1 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1641] - PartitionCols:_col0 - Select Operator [SEL_1639] (rows=575995635 width=88) - Output:["_col0","_col1"] - Filter Operator [FIL_1638] (rows=575995635 width=88) - predicate:((ss_sold_date_sk BETWEEN DynamicValue(RS_7_date_dim_d_date_sk_min) AND DynamicValue(RS_7_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_7_date_dim_d_date_sk_bloom_filter))) and 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 108 [BROADCAST_EDGE] vectorized - BROADCAST [RS_1637] - Group By Operator [GBY_1636] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 102 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_1634] - Group By Operator [GBY_1629] (rows=1 width=12) - Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_1619] (rows=8116 width=1119) - Output:["_col0"] - Please refer to the previous Select Operator [SEL_1611] - <-Reducer 29 [CUSTOM_SIMPLE_EDGE] vectorized - PARTITION_ONLY_SHUFFLE [RS_1748] - Select Operator [SEL_1747] (rows=1 width=120) - Output:["_col0"] - Group By Operator [GBY_1746] (rows=1 width=120) - Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"] - <-Union 28 [CUSTOM_SIMPLE_EDGE] - <-Reducer 27 [CONTAINS] - Reduce Output Operator [RS_1513] - Group By Operator [GBY_1512] (rows=1 width=120) - Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"] - Select Operator [SEL_1511] (rows=1108786976 width=108) - Output:["_col0"] - Select Operator [SEL_1509] (rows=316788826 width=135) - Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_1508] (rows=316788826 width=135) - Conds:RS_1824._col0=RS_1805._col0(Inner),Output:["_col1","_col2"] - <-Map 21 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1805] + Select Operator [SEL_1463] (rows=633595212 width=88) + Output:["_col0"] + Merge Join Operator [MERGEJOIN_1462] (rows=633595212 width=88) + Conds:RS_1645._col0=RS_1626._col0(Inner),Output:["_col1"] + <-Map 102 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1626] + PartitionCols:_col0 + Select Operator [SEL_1615] (rows=8116 width=1119) + Output:["_col0"] + Filter Operator [FIL_1614] (rows=8116 width=1119) + predicate:(d_date_sk is not null and d_year BETWEEN 1999 AND 2001) + TableScan [TS_97] (rows=73049 width=1119) + default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1645] + PartitionCols:_col0 + Select Operator [SEL_1643] (rows=575995635 width=88) + Output:["_col0","_col1"] + Filter Operator [FIL_1642] (rows=575995635 width=88) + predicate:((ss_sold_date_sk BETWEEN DynamicValue(RS_7_date_dim_d_date_sk_min) AND DynamicValue(RS_7_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_7_date_dim_d_date_sk_bloom_filter))) and 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 108 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1641] + Group By Operator [GBY_1640] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 102 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1638] + Group By Operator [GBY_1633] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1623] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1615] + <-Reducer 29 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1752] + Select Operator [SEL_1751] (rows=1 width=120) + Output:["_col0"] + Group By Operator [GBY_1750] (rows=1 width=120) + Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"] + <-Union 28 [CUSTOM_SIMPLE_EDGE] + <-Reducer 27 [CONTAINS] + Reduce Output Operator [RS_1517] + Group By Operator [GBY_1516] (rows=1 width=120) + Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"] + Select Operator [SEL_1515] (rows=1108786976 width=108) + Output:["_col0"] + Select Operator [SEL_1513] (rows=316788826 width=135) + Output:["_col0","_col1"] + Merge Join Operator [MERGEJOIN_1512] (rows=316788826 width=135) + Conds:RS_1828._col0=RS_1809._col0(Inner),Output:["_col1","_col2"] + <-Map 21 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1809] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_1803] + <-Map 47 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1828] + PartitionCols:_col0 + Select Operator [SEL_1826] (rows=287989836 width=135) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_1825] (rows=287989836 width=135) + predicate:((cs_sold_date_sk BETWEEN DynamicValue(RS_62_date_dim_d_date_sk_min) AND DynamicValue(RS_62_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_62_date_dim_d_date_sk_bloom_filter))) and cs_sold_date_sk is not null) + TableScan [TS_55] (rows=287989836 width=135) + default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity","cs_list_price"] + <-Reducer 26 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1824] + Group By Operator [GBY_1823] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 21 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1815] + Group By Operator [GBY_1813] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1807] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1803] + <-Reducer 41 [CONTAINS] + Reduce Output Operator [RS_1553] + Group By Operator [GBY_1552] (rows=1 width=120) + Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"] + Select Operator [SEL_1551] (rows=1108786976 width=108) + Output:["_col0"] + Select Operator [SEL_1549] (rows=158402938 width=135) + Output:["_col0","_col1"] + Merge Join Operator [MERGEJOIN_1548] (rows=158402938 width=135) + Conds:RS_1856._col0=RS_1837._col0(Inner),Output:["_col1","_col2"] + <-Map 37 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1837] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_1831] + <-Map 48 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1856] + PartitionCols:_col0 + Select Operator [SEL_1854] (rows=144002668 width=135) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_1853] (rows=144002668 width=135) + predicate:((ws_sold_date_sk BETWEEN DynamicValue(RS_73_date_dim_d_date_sk_min) AND DynamicValue(RS_73_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_73_date_dim_d_date_sk_bloom_filter))) and ws_sold_date_sk is not null) + TableScan [TS_66] (rows=144002668 width=135) + default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"] + <-Reducer 40 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1852] + Group By Operator [GBY_1851] (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 + SHUFFLE [RS_1843] + Group By Operator [GBY_1841] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1835] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1831] + <-Reducer 45 [CONTAINS] + Reduce Output Operator [RS_1571] + Group By Operator [GBY_1570] (rows=1 width=120) + Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"] + Select Operator [SEL_1569] (rows=1108786976 width=108) + Output:["_col0"] + Select Operator [SEL_1567] (rows=633595212 width=88) + Output:["_col0","_col1"] + Merge Join Operator [MERGEJOIN_1566] (rows=633595212 width=88) + Conds:RS_1863._col0=RS_1627._col0(Inner),Output:["_col1","_col2"] + <-Map 102 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1627] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_1615] + <-Map 43 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1863] + PartitionCols:_col0 + Select Operator [SEL_1861] (rows=575995635 width=88) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_1860] (rows=575995635 width=88) + predicate:((ss_sold_date_sk BETWEEN DynamicValue(RS_52_date_dim_d_date_sk_min) AND DynamicValue(RS_52_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_52_date_dim_d_date_sk_bloom_filter))) and ss_sold_date_sk is not null) + TableScan [TS_45] (rows=575995635 width=88) + default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity","ss_list_price"] + <-Reducer 109 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1859] + Group By Operator [GBY_1858] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 102 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1639] + Group By Operator [GBY_1634] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1625] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1615] + <-Reducer 57 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1772] + Group By Operator [GBY_1771] (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 56 [SIMPLE_EDGE] + SHUFFLE [RS_369] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_368] (rows=696935432 width=135) + Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2 + Select Operator [SEL_366] (rows=696935432 width=135) + Output:["_col0","_col1","_col2","_col3"] + Merge Join Operator [MERGEJOIN_1430] (rows=696935432 width=135) + Conds:RS_362._col1=RS_1703._col0(Inner),RS_362._col1=RS_1762._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"] + <-Map 63 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1703] + PartitionCols:_col0 + Select Operator [SEL_1687] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1678] (rows=462000 width=1436) + predicate:i_item_sk is not null + TableScan [TS_91] (rows=462000 width=1436) + default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"] + <-Reducer 80 [ONE_TO_ONE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1762] + PartitionCols:_col0 + Group By Operator [GBY_1761] (rows=254100 width=1436) + Output:["_col0"],keys:KEY._col0 + <-Reducer 79 [SIMPLE_EDGE] + SHUFFLE [RS_356] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_1799] - <-Map 47 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1824] + Group By Operator [GBY_355] (rows=508200 width=1436) + Output:["_col0"],keys:_col0 + Merge Join Operator [MERGEJOIN_1429] (rows=508200 width=1436) + Conds:RS_1699._col1, _col2, _col3=RS_1760._col0, _col1, _col2(Inner),Output:["_col0"] + <-Map 63 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1699] + PartitionCols:_col1, _col2, _col3 + Select Operator [SEL_1683] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1674] (rows=462000 width=1436) + predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null) + Please refer to the previous TableScan [TS_91] + <-Reducer 85 [ONE_TO_ONE_EDGE] vectorized + FORWARD [RS_1760] + PartitionCols:_col0, _col1, _col2 + Select Operator [SEL_1759] (rows=1 width=108) + Output:["_col0","_col1","_col2"] + Filter Operator [FIL_1758] (rows=1 width=108) + predicate:(_col3 = 3L) + Group By Operator [GBY_1757] (rows=304916424 width=108) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2 + <-Union 84 [SIMPLE_EDGE] + <-Reducer 83 [CONTAINS] vectorized + Reduce Output Operator [RS_1897] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_1896] (rows=609832849 width=108) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 + Group By Operator [GBY_1895] (rows=348477374 width=88) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2 + <-Reducer 82 [SIMPLE_EDGE] + SHUFFLE [RS_300] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_299] (rows=696954748 width=88) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7 + Merge Join Operator [MERGEJOIN_1424] (rows=696954748 width=88) + Conds:RS_295._col1=RS_1700._col0(Inner),Output:["_col5","_col6","_col7"] + <-Map 63 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1700] + PartitionCols:_col0 + Select Operator [SEL_1684] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1675] (rows=462000 width=1436) + predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null) + Please refer to the previous TableScan [TS_91] + <-Reducer 101 [SIMPLE_EDGE] + SHUFFLE [RS_295] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_1408] (rows=633595212 width=88) + Conds:RS_1871._col0=RS_1616._col0(Inner),Output:["_col1"] + <-Map 102 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1616] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_1615] + <-Map 100 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1871] + PartitionCols:_col0 + Select Operator [SEL_1870] (rows=575995635 width=88) + Output:["_col0","_col1"] + Filter Operator [FIL_1869] (rows=575995635 width=88) + predicate:((ss_item_sk BETWEEN DynamicValue(RS_107_iss_i_item_sk_min) AND DynamicValue(RS_107_iss_i_item_sk_max) and in_bloom_filter(ss_item_sk, DynamicValue(RS_107_iss_i_item_sk_bloom_filter))) and (ss_sold_date_sk BETWEEN DynamicValue(RS_104_d1_d_date_sk_min) AND DynamicValue(RS_104_d1_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_104_d1_d_date_sk_bloom_filter))) and ss_item_sk is not null and ss_sold_date_sk is not null) + TableScan [TS_94] (rows=575995635 width=88) + default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"] + <-Reducer 103 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1866] + Group By Operator [GBY_1865] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 102 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1635] + Group By Operator [GBY_1630] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1617] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1615] + <-Reducer 71 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1868] + Group By Operator [GBY_1867] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 63 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1714] + Group By Operator [GBY_1708] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1692] (rows=462000 width=1436) + Output:["_col0"] + Select Operator [SEL_1681] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1672] (rows=462000 width=1436) + predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null) + Please refer to the previous TableScan [TS_91] + <-Reducer 93 [CONTAINS] vectorized + Reduce Output Operator [RS_1903] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_1902] (rows=609832849 width=108) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 + Group By Operator [GBY_1901] (rows=174233858 width=135) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2 + <-Reducer 92 [SIMPLE_EDGE] + SHUFFLE [RS_320] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_319] (rows=348467716 width=135) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7 + Merge Join Operator [MERGEJOIN_1426] (rows=348467716 width=135) + Conds:RS_315._col1=RS_1701._col0(Inner),Output:["_col5","_col6","_col7"] + <-Map 63 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1701] + PartitionCols:_col0 + Select Operator [SEL_1685] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1676] (rows=462000 width=1436) + predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null) + Please refer to the previous TableScan [TS_91] + <-Reducer 104 [SIMPLE_EDGE] + SHUFFLE [RS_315] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_1410] (rows=316788826 width=135) + Conds:RS_1881._col0=RS_1618._col0(Inner),Output:["_col1"] + <-Map 102 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1618] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_1615] + <-Map 110 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1881] + PartitionCols:_col0 + Select Operator [SEL_1880] (rows=287989836 width=135) + Output:["_col0","_col1"] + Filter Operator [FIL_1879] (rows=287989836 width=135) + predicate:((cs_item_sk BETWEEN DynamicValue(RS_127_ics_i_item_sk_min) AND DynamicValue(RS_127_ics_i_item_sk_max) and in_bloom_filter(cs_item_sk, DynamicValue(RS_127_ics_i_item_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_124_d2_d_date_sk_min) AND DynamicValue(RS_124_d2_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_124_d2_d_date_sk_bloom_filter))) and 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"] + <-Reducer 105 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1876] + Group By Operator [GBY_1875] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 102 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1636] + Group By Operator [GBY_1631] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1619] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1615] + <-Reducer 74 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1878] + Group By Operator [GBY_1877] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 63 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1715] + Group By Operator [GBY_1709] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1694] (rows=462000 width=1436) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1681] + <-Reducer 96 [CONTAINS] vectorized + Reduce Output Operator [RS_1909] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_1908] (rows=609832849 width=108) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2 + Group By Operator [GBY_1907] (rows=87121617 width=135) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2 + <-Reducer 95 [SIMPLE_EDGE] + SHUFFLE [RS_341] + PartitionCols:_col0, _col1, _col2 + Group By Operator [GBY_340] (rows=174243235 width=135) + Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7 + Merge Join Operator [MERGEJOIN_1428] (rows=174243235 width=135) + Conds:RS_336._col1=RS_1702._col0(Inner),Output:["_col5","_col6","_col7"] + <-Map 63 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1702] + PartitionCols:_col0 + Select Operator [SEL_1686] (rows=462000 width=1436) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1677] (rows=462000 width=1436) + predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null) + Please refer to the previous TableScan [TS_91] + <-Reducer 106 [SIMPLE_EDGE] + SHUFFLE [RS_336] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_1412] (rows=158402938 width=135) + Conds:RS_1891._col0=RS_1620._col0(Inner),Output:["_col1"] + <-Map 102 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1620] + PartitionCols:_col0 + Please refer to the previous Select Operator [SEL_1615] + <-Map 111 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1891] + PartitionCols:_col0 + Select Operator [SEL_1890] (rows=144002668 width=135) + Output:["_col0","_col1"] + Filter Operator [FIL_1889] (rows=144002668 width=135) + predicate:((ws_item_sk BETWEEN DynamicValue(RS_148_iws_i_item_sk_min) AND DynamicValue(RS_148_iws_i_item_sk_max) and in_bloom_filter(ws_item_sk, DynamicValue(RS_148_iws_i_item_sk_bloom_filter))) and (ws_sold_date_sk BETWEEN DynamicValue(RS_145_d3_d_date_sk_min) AND DynamicValue(RS_145_d3_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_145_d3_d_date_sk_bloom_filter))) and ws_item_sk is not null and ws_sold_date_sk is not null) + TableScan [TS_135] (rows=144002668 width=135) + default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"] + <-Reducer 107 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1886] + Group By Operator [GBY_1885] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 102 [CUSTOM_SIMPLE_EDGE] vectorized + SHUFFLE [RS_1637] + Group By Operator [GBY_1632] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1621] (rows=8116 width=1119) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1615] + <-Reducer 77 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1888] + Group By Operator [GBY_1887] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] + <-Map 63 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1716] + Group By Operator [GBY_1710] (rows=1 width=12) + Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] + Select Operator [SEL_1696] (rows=462000 width=1436) + Output:["_col0"] + Please refer to the previous Select Operator [SEL_1681] + <-Reducer 55 [SIMPLE_EDGE] + SHUFFLE [RS_362] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_1422] (rows=316788826 width=135) + Conds:RS_1770._col0=RS_1660._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 53 [SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1660] PartitionCols:_col0 - Select Operator [SEL_1822] (rows=287989836 width=135) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_1821] (rows=287989836 width=135) - predicate:((cs_sold_date_sk BETWEEN DynamicValue(RS_62_date_dim_d_date_sk_min) AND DynamicValue(RS_62_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_62_date_dim_d_date_sk_bloom_filter))) and cs_sold_date_sk is not null) - TableScan [TS_55] (rows=287989836 width=135) - default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity","cs_list_price"] - <-Reducer 26 [BROADCAST_EDGE] vectorized - BROADCAST [RS_1820] - Group By Operator [GBY_1819] (rows=1 width=12) + Select Operator [SEL_1657] (rows=18262 width=1119) + Output:["_col0"] + Filter Operator [FIL_1656] (rows=18262 width=1119) + predicate:((d_moy = 11) and (d_year = 2000) and d_date_sk is not null) + TableScan [TS_85] (rows=73049 width=1119) + default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"] + <-Map 112 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_1770] + PartitionCols:_col0 + Select Operator [SEL_1769] (rows=287989836 width=135) + Output:["_col0","_col1","_col2","_col3"] + Filter Operator [FIL_1768] (rows=287989836 width=135) + predicate:((cs_item_sk BETWEEN DynamicValue(RS_363_item_i_item_sk_min) AND DynamicValue(RS_363_item_i_item_sk_max) and in_bloom_filter(cs_item_sk, DynamicValue(RS_363_item_i_item_sk_bloom_filter))) and (cs_item_sk BETWEEN DynamicValue(RS_364_item_i_item_sk_min) AND DynamicValue(RS_364_item_i_item_sk_max) and in_bloom_filter(cs_item_sk, DynamicValue(RS_364_item_i_item_sk_bloom_filter))) and (cs_sold_date_sk BETWEEN DynamicValue(RS_360_date_dim_d_date_sk_min) AND DynamicValue(RS_360_date_dim_d_date_sk_max) and in_bloom_filter(cs_sold_date_sk, DynamicValue(RS_360_date_dim_d_date_sk_bloom_filter))) and cs_item_sk is not null and cs_sold_date_sk is not null) + TableScan [TS_271] (rows=287989836 width=135) + default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk","cs_quantity","cs_list_price"] + <-Reducer 58 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1754] + Group By Operator [GBY_1753] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(VALUE._col0)","max(VALUE._col1)","bloom_filter(VALUE._col2, expectedEntries=1000000)"] - <-Map 21 [CUSTOM_SIMPLE_EDGE] vectorized - SHUFFLE [RS_1811] - Group By Operator [GBY_1809] (rows=1 width=12) + <-Map 53 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1668] + Group By Operator [GBY_1665] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_1803] (rows=8116 width=1119) + Select Operator [SEL_1661] (rows=18262 width=1119) Output:["_col0"] - Please refer to the previous Select Operator [SEL_1799] - <-Reducer 41 [CONTAINS] - Reduce Output Operator [RS_1549] - Group By Operator [GBY_1548] (rows=1 width=120) - Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"] - Select Operator [SEL_1547] (rows=1108786976 width=108) - Output:["_col0"] - Select Operator [SEL_1545] (rows=158402938 width=135) - Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_1544] (rows=158402938 width=135) - Conds:RS_1852._col0=RS_1833._col0(Inner),Output:["_col1","_col2"] - <-Map 37 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1833] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_1827] - <-Map 48 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1852] - PartitionCols:_col0 - Select Operator [SEL_1850] (rows=144002668 width=135) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_1849] (rows=144002668 width=135) - predicate:((ws_sold_date_sk BETWEEN DynamicValue(RS_73_date_dim_d_date_sk_min) AND DynamicValue(RS_73_date_dim_d_date_sk_max) and in_bloom_filter(ws_sold_date_sk, DynamicValue(RS_73_date_dim_d_date_sk_bloom_filter))) and ws_sold_date_sk is not null) - TableScan [TS_66] (rows=144002668 width=135) - default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"] - <-Reducer 40 [BROADCAST_EDGE] vectorized - BROADCAST [RS_1848] - Group By Operator [GBY_1847] (rows=1 width=12) + Please refer to the previous Select Operator [SEL_1657] + <-Reducer 81 [BROADCAST_EDGE] vectorized + BROADCAST [RS_1767] + Group By Operator [GBY_1766] (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 - SHUFFLE [RS_1839] - Group By Operator [GBY_1837] (rows=1 width=12) + <-Reducer 80 [CUSTOM_SIMPLE_EDGE] vectorized + PARTITION_ONLY_SHUFFLE [RS_1765] + Group By Operator [GBY_1764] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_1831] (rows=8116 width=1119) + Select Operator [SEL_1763] (rows=254100 width=1436) Output:["_col0"] - Please refer to the previous Select Operator [SEL_1827] - <-Reducer 45 [CONTAINS] - Reduce Output Operator [RS_1567] - Group By Operator [GBY_1566] (rows=1 width=120) - Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"] - Select Operator [SEL_1565] (rows=1108786976 width=108) - Output:["_col0"] - Select Operator [SEL_1563] (rows=633595212 width=88) - Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_1562] (rows=633595212 width=88) - Conds:RS_1859._col0=RS_1623._col0(Inner),Output:["_col1","_col2"] - <-Map 102 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1623] - PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_1611] - <-Map 43 [SIMPLE_EDGE] vectorized - SHUFFLE [RS_1859] - PartitionCols:_col0 - Select Operator [SEL_1857] (rows=575995635 width=88) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_1856] (rows=575995635 width=88) - predicate:((ss_sold_date_sk BETWEEN DynamicValue(RS_52_date_dim_d_date_sk_min) AND DynamicValue(RS_52_date_dim_d_date_sk_max) and in_bloom_filter(ss_sold_date_sk, DynamicValue(RS_52_date_dim_d_date_sk_bloom_filter))) and ss_sold_date_sk is not null) - TableScan [TS_45] (rows=575995635 width=88) - default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity","ss_list_price"] - <-Reducer 109 [BROADCAST_EDGE] vectorized - BROADCAST [RS_1855] - Group By Operator [GBY_1854] (rows=1 width=12) + Please refer
<TRUNCATED>
