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>