You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by px...@apache.org on 2017/01/24 21:51:47 UTC
[2/3] hive git commit: HIVE-15716: Add TPCDS query14.q to
HivePerfCliDriver (Pengcheng Xiong)
http://git-wip-us.apache.org/repos/asf/hive/blob/3f8656fc/ql/src/test/results/clientpositive/perf/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query14.q.out b/ql/src/test/results/clientpositive/perf/query14.q.out
new file mode 100644
index 0000000..171a22a
--- /dev/null
+++ b/ql/src/test/results/clientpositive/perf/query14.q.out
@@ -0,0 +1,1568 @@
+Warning: Shuffle Join MERGEJOIN[916][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 114' is a cross product
+Warning: Shuffle Join MERGEJOIN[917][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 115' is a cross product
+Warning: Shuffle Join MERGEJOIN[914][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 61' is a cross product
+Warning: Shuffle Join MERGEJOIN[915][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 62' is a cross product
+Warning: Shuffle Join MERGEJOIN[912][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 5' is a cross product
+Warning: Shuffle Join MERGEJOIN[913][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 6' is a cross product
+PREHOOK: query: explain
+with cross_items as
+ (select i_item_sk ss_item_sk
+ from item,
+ (select iss.i_brand_id brand_id
+ ,iss.i_class_id class_id
+ ,iss.i_category_id category_id
+ from store_sales
+ ,item iss
+ ,date_dim d1
+ where ss_item_sk = iss.i_item_sk
+ and ss_sold_date_sk = d1.d_date_sk
+ and d1.d_year between 1999 AND 1999 + 2
+ intersect
+ select ics.i_brand_id
+ ,ics.i_class_id
+ ,ics.i_category_id
+ from catalog_sales
+ ,item ics
+ ,date_dim d2
+ where cs_item_sk = ics.i_item_sk
+ and cs_sold_date_sk = d2.d_date_sk
+ and d2.d_year between 1999 AND 1999 + 2
+ intersect
+ select iws.i_brand_id
+ ,iws.i_class_id
+ ,iws.i_category_id
+ from web_sales
+ ,item iws
+ ,date_dim d3
+ where ws_item_sk = iws.i_item_sk
+ and ws_sold_date_sk = d3.d_date_sk
+ and d3.d_year between 1999 AND 1999 + 2) x
+ where i_brand_id = brand_id
+ and i_class_id = class_id
+ and i_category_id = category_id
+),
+ avg_sales as
+ (select avg(quantity*list_price) average_sales
+ from (select ss_quantity quantity
+ ,ss_list_price list_price
+ from store_sales
+ ,date_dim
+ where ss_sold_date_sk = d_date_sk
+ and d_year between 1999 and 2001
+ union all
+ select cs_quantity quantity
+ ,cs_list_price list_price
+ from catalog_sales
+ ,date_dim
+ where cs_sold_date_sk = d_date_sk
+ and d_year between 1998 and 1998 + 2
+ union all
+ select ws_quantity quantity
+ ,ws_list_price list_price
+ from web_sales
+ ,date_dim
+ where ws_sold_date_sk = d_date_sk
+ and d_year between 1998 and 1998 + 2) x)
+ select channel, i_brand_id,i_class_id,i_category_id,sum(sales), sum(number_sales)
+ from(
+ select 'store' channel, i_brand_id,i_class_id
+ ,i_category_id,sum(ss_quantity*ss_list_price) sales
+ , count(*) number_sales
+ from store_sales
+ ,item
+ ,date_dim
+ where ss_item_sk in (select ss_item_sk from cross_items)
+ and ss_item_sk = i_item_sk
+ and ss_sold_date_sk = d_date_sk
+ and d_year = 1998+2
+ and d_moy = 11
+ group by i_brand_id,i_class_id,i_category_id
+ having sum(ss_quantity*ss_list_price) > (select average_sales from avg_sales)
+ union all
+ select 'catalog' channel, i_brand_id,i_class_id,i_category_id, sum(cs_quantity*cs_list_price) sales, count(*) number_sales
+ from catalog_sales
+ ,item
+ ,date_dim
+ where cs_item_sk in (select ss_item_sk from cross_items)
+ and cs_item_sk = i_item_sk
+ and cs_sold_date_sk = d_date_sk
+ and d_year = 1998+2
+ and d_moy = 11
+ group by i_brand_id,i_class_id,i_category_id
+ having sum(cs_quantity*cs_list_price) > (select average_sales from avg_sales)
+ union all
+ select 'web' channel, i_brand_id,i_class_id,i_category_id, sum(ws_quantity*ws_list_price) sales , count(*) number_sales
+ from web_sales
+ ,item
+ ,date_dim
+ where ws_item_sk in (select ss_item_sk from cross_items)
+ and ws_item_sk = i_item_sk
+ and ws_sold_date_sk = d_date_sk
+ and d_year = 1998+2
+ and d_moy = 11
+ group by i_brand_id,i_class_id,i_category_id
+ having sum(ws_quantity*ws_list_price) > (select average_sales from avg_sales)
+ ) y
+ group by rollup (channel, i_brand_id,i_class_id,i_category_id)
+ order by channel,i_brand_id,i_class_id,i_category_id
+ limit 100
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+with cross_items as
+ (select i_item_sk ss_item_sk
+ from item,
+ (select iss.i_brand_id brand_id
+ ,iss.i_class_id class_id
+ ,iss.i_category_id category_id
+ from store_sales
+ ,item iss
+ ,date_dim d1
+ where ss_item_sk = iss.i_item_sk
+ and ss_sold_date_sk = d1.d_date_sk
+ and d1.d_year between 1999 AND 1999 + 2
+ intersect
+ select ics.i_brand_id
+ ,ics.i_class_id
+ ,ics.i_category_id
+ from catalog_sales
+ ,item ics
+ ,date_dim d2
+ where cs_item_sk = ics.i_item_sk
+ and cs_sold_date_sk = d2.d_date_sk
+ and d2.d_year between 1999 AND 1999 + 2
+ intersect
+ select iws.i_brand_id
+ ,iws.i_class_id
+ ,iws.i_category_id
+ from web_sales
+ ,item iws
+ ,date_dim d3
+ where ws_item_sk = iws.i_item_sk
+ and ws_sold_date_sk = d3.d_date_sk
+ and d3.d_year between 1999 AND 1999 + 2) x
+ where i_brand_id = brand_id
+ and i_class_id = class_id
+ and i_category_id = category_id
+),
+ avg_sales as
+ (select avg(quantity*list_price) average_sales
+ from (select ss_quantity quantity
+ ,ss_list_price list_price
+ from store_sales
+ ,date_dim
+ where ss_sold_date_sk = d_date_sk
+ and d_year between 1999 and 2001
+ union all
+ select cs_quantity quantity
+ ,cs_list_price list_price
+ from catalog_sales
+ ,date_dim
+ where cs_sold_date_sk = d_date_sk
+ and d_year between 1998 and 1998 + 2
+ union all
+ select ws_quantity quantity
+ ,ws_list_price list_price
+ from web_sales
+ ,date_dim
+ where ws_sold_date_sk = d_date_sk
+ and d_year between 1998 and 1998 + 2) x)
+ select channel, i_brand_id,i_class_id,i_category_id,sum(sales), sum(number_sales)
+ from(
+ select 'store' channel, i_brand_id,i_class_id
+ ,i_category_id,sum(ss_quantity*ss_list_price) sales
+ , count(*) number_sales
+ from store_sales
+ ,item
+ ,date_dim
+ where ss_item_sk in (select ss_item_sk from cross_items)
+ and ss_item_sk = i_item_sk
+ and ss_sold_date_sk = d_date_sk
+ and d_year = 1998+2
+ and d_moy = 11
+ group by i_brand_id,i_class_id,i_category_id
+ having sum(ss_quantity*ss_list_price) > (select average_sales from avg_sales)
+ union all
+ select 'catalog' channel, i_brand_id,i_class_id,i_category_id, sum(cs_quantity*cs_list_price) sales, count(*) number_sales
+ from catalog_sales
+ ,item
+ ,date_dim
+ where cs_item_sk in (select ss_item_sk from cross_items)
+ and cs_item_sk = i_item_sk
+ and cs_sold_date_sk = d_date_sk
+ and d_year = 1998+2
+ and d_moy = 11
+ group by i_brand_id,i_class_id,i_category_id
+ having sum(cs_quantity*cs_list_price) > (select average_sales from avg_sales)
+ union all
+ select 'web' channel, i_brand_id,i_class_id,i_category_id, sum(ws_quantity*ws_list_price) sales , count(*) number_sales
+ from web_sales
+ ,item
+ ,date_dim
+ where ws_item_sk in (select ss_item_sk from cross_items)
+ and ws_item_sk = i_item_sk
+ and ws_sold_date_sk = d_date_sk
+ and d_year = 1998+2
+ and d_moy = 11
+ group by i_brand_id,i_class_id,i_category_id
+ having sum(ws_quantity*ws_list_price) > (select average_sales from avg_sales)
+ ) y
+ group by rollup (channel, i_brand_id,i_class_id,i_category_id)
+ order by channel,i_brand_id,i_class_id,i_category_id
+ limit 100
+POSTHOOK: type: QUERY
+Plan optimized by CBO.
+
+Vertex dependency in root stage
+Reducer 100 <- Map 103 (SIMPLE_EDGE), Reducer 99 (SIMPLE_EDGE)
+Reducer 101 <- Reducer 100 (SIMPLE_EDGE), Union 94 (CONTAINS)
+Reducer 105 <- Map 104 (SIMPLE_EDGE), Map 108 (SIMPLE_EDGE)
+Reducer 106 <- Map 109 (SIMPLE_EDGE), Reducer 105 (SIMPLE_EDGE)
+Reducer 107 <- Reducer 106 (SIMPLE_EDGE), Union 94 (CONTAINS)
+Reducer 111 <- Map 110 (SIMPLE_EDGE), Map 116 (SIMPLE_EDGE), Union 112 (CONTAINS)
+Reducer 113 <- Union 112 (CUSTOM_SIMPLE_EDGE)
+Reducer 114 <- Reducer 113 (CUSTOM_SIMPLE_EDGE), Reducer 126 (CUSTOM_SIMPLE_EDGE)
+Reducer 115 <- Reducer 114 (CUSTOM_SIMPLE_EDGE), Reducer 137 (CUSTOM_SIMPLE_EDGE), Union 7 (CONTAINS)
+Reducer 118 <- Map 117 (SIMPLE_EDGE), Map 119 (SIMPLE_EDGE), Union 112 (CONTAINS)
+Reducer 12 <- Map 11 (SIMPLE_EDGE), Map 13 (SIMPLE_EDGE), Union 3 (CONTAINS)
+Reducer 121 <- Map 120 (SIMPLE_EDGE), Map 122 (SIMPLE_EDGE), Union 112 (CONTAINS)
+Reducer 124 <- Map 123 (SIMPLE_EDGE), Map 127 (SIMPLE_EDGE), Union 125 (CONTAINS)
+Reducer 126 <- Union 125 (CUSTOM_SIMPLE_EDGE)
+Reducer 129 <- Map 128 (SIMPLE_EDGE), Map 130 (SIMPLE_EDGE), Union 125 (CONTAINS)
+Reducer 132 <- Map 131 (SIMPLE_EDGE), Map 133 (SIMPLE_EDGE), Union 125 (CONTAINS)
+Reducer 135 <- Map 134 (SIMPLE_EDGE), Map 138 (SIMPLE_EDGE)
+Reducer 136 <- Map 139 (SIMPLE_EDGE), Reducer 135 (SIMPLE_EDGE), Reducer 142 (SIMPLE_EDGE)
+Reducer 137 <- Reducer 136 (SIMPLE_EDGE)
+Reducer 141 <- Map 140 (SIMPLE_EDGE), Reducer 148 (SIMPLE_EDGE)
+Reducer 142 <- Reducer 141 (SIMPLE_EDGE)
+Reducer 144 <- Map 143 (SIMPLE_EDGE), Map 149 (SIMPLE_EDGE)
+Reducer 145 <- Map 150 (SIMPLE_EDGE), Reducer 144 (SIMPLE_EDGE)
+Reducer 146 <- Reducer 145 (SIMPLE_EDGE), Union 147 (CONTAINS)
+Reducer 148 <- Union 147 (SIMPLE_EDGE)
+Reducer 15 <- Map 14 (SIMPLE_EDGE), Map 16 (SIMPLE_EDGE), Union 3 (CONTAINS)
+Reducer 152 <- Map 151 (SIMPLE_EDGE), Map 155 (SIMPLE_EDGE)
+Reducer 153 <- Map 156 (SIMPLE_EDGE), Reducer 152 (SIMPLE_EDGE)
+Reducer 154 <- Reducer 153 (SIMPLE_EDGE), Union 147 (CONTAINS)
+Reducer 158 <- Map 157 (SIMPLE_EDGE), Map 161 (SIMPLE_EDGE)
+Reducer 159 <- Map 162 (SIMPLE_EDGE), Reducer 158 (SIMPLE_EDGE)
+Reducer 160 <- Reducer 159 (SIMPLE_EDGE), Union 147 (CONTAINS)
+Reducer 18 <- Map 17 (SIMPLE_EDGE), Map 21 (SIMPLE_EDGE), Union 19 (CONTAINS)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 10 (SIMPLE_EDGE), Union 3 (CONTAINS)
+Reducer 20 <- Union 19 (CUSTOM_SIMPLE_EDGE)
+Reducer 23 <- Map 22 (SIMPLE_EDGE), Map 24 (SIMPLE_EDGE), Union 19 (CONTAINS)
+Reducer 26 <- Map 25 (SIMPLE_EDGE), Map 27 (SIMPLE_EDGE), Union 19 (CONTAINS)
+Reducer 29 <- Map 28 (SIMPLE_EDGE), Map 32 (SIMPLE_EDGE)
+Reducer 30 <- Map 33 (SIMPLE_EDGE), Reducer 29 (SIMPLE_EDGE), Reducer 36 (SIMPLE_EDGE)
+Reducer 31 <- Reducer 30 (SIMPLE_EDGE)
+Reducer 35 <- Map 34 (SIMPLE_EDGE), Reducer 42 (SIMPLE_EDGE)
+Reducer 36 <- Reducer 35 (SIMPLE_EDGE)
+Reducer 38 <- Map 37 (SIMPLE_EDGE), Map 43 (SIMPLE_EDGE)
+Reducer 39 <- Map 44 (SIMPLE_EDGE), Reducer 38 (SIMPLE_EDGE)
+Reducer 4 <- Union 3 (CUSTOM_SIMPLE_EDGE)
+Reducer 40 <- Reducer 39 (SIMPLE_EDGE), Union 41 (CONTAINS)
+Reducer 42 <- Union 41 (SIMPLE_EDGE)
+Reducer 46 <- Map 45 (SIMPLE_EDGE), Map 49 (SIMPLE_EDGE)
+Reducer 47 <- Map 50 (SIMPLE_EDGE), Reducer 46 (SIMPLE_EDGE)
+Reducer 48 <- Reducer 47 (SIMPLE_EDGE), Union 41 (CONTAINS)
+Reducer 5 <- Reducer 20 (CUSTOM_SIMPLE_EDGE), Reducer 4 (CUSTOM_SIMPLE_EDGE)
+Reducer 52 <- Map 51 (SIMPLE_EDGE), Map 55 (SIMPLE_EDGE)
+Reducer 53 <- Map 56 (SIMPLE_EDGE), Reducer 52 (SIMPLE_EDGE)
+Reducer 54 <- Reducer 53 (SIMPLE_EDGE), Union 41 (CONTAINS)
+Reducer 58 <- Map 57 (SIMPLE_EDGE), Map 63 (SIMPLE_EDGE), Union 59 (CONTAINS)
+Reducer 6 <- Reducer 31 (CUSTOM_SIMPLE_EDGE), Reducer 5 (CUSTOM_SIMPLE_EDGE), Union 7 (CONTAINS)
+Reducer 60 <- Union 59 (CUSTOM_SIMPLE_EDGE)
+Reducer 61 <- Reducer 60 (CUSTOM_SIMPLE_EDGE), Reducer 73 (CUSTOM_SIMPLE_EDGE)
+Reducer 62 <- Reducer 61 (CUSTOM_SIMPLE_EDGE), Reducer 84 (CUSTOM_SIMPLE_EDGE), Union 7 (CONTAINS)
+Reducer 65 <- Map 64 (SIMPLE_EDGE), Map 66 (SIMPLE_EDGE), Union 59 (CONTAINS)
+Reducer 68 <- Map 67 (SIMPLE_EDGE), Map 69 (SIMPLE_EDGE), Union 59 (CONTAINS)
+Reducer 71 <- Map 70 (SIMPLE_EDGE), Map 74 (SIMPLE_EDGE), Union 72 (CONTAINS)
+Reducer 73 <- Union 72 (CUSTOM_SIMPLE_EDGE)
+Reducer 76 <- Map 75 (SIMPLE_EDGE), Map 77 (SIMPLE_EDGE), Union 72 (CONTAINS)
+Reducer 79 <- Map 78 (SIMPLE_EDGE), Map 80 (SIMPLE_EDGE), Union 72 (CONTAINS)
+Reducer 8 <- Union 7 (SIMPLE_EDGE)
+Reducer 82 <- Map 81 (SIMPLE_EDGE), Map 85 (SIMPLE_EDGE)
+Reducer 83 <- Map 86 (SIMPLE_EDGE), Reducer 82 (SIMPLE_EDGE), Reducer 89 (SIMPLE_EDGE)
+Reducer 84 <- Reducer 83 (SIMPLE_EDGE)
+Reducer 88 <- Map 87 (SIMPLE_EDGE), Reducer 95 (SIMPLE_EDGE)
+Reducer 89 <- Reducer 88 (SIMPLE_EDGE)
+Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
+Reducer 91 <- Map 90 (SIMPLE_EDGE), Map 96 (SIMPLE_EDGE)
+Reducer 92 <- Map 97 (SIMPLE_EDGE), Reducer 91 (SIMPLE_EDGE)
+Reducer 93 <- Reducer 92 (SIMPLE_EDGE), Union 94 (CONTAINS)
+Reducer 95 <- Union 94 (SIMPLE_EDGE)
+Reducer 99 <- Map 102 (SIMPLE_EDGE), Map 98 (SIMPLE_EDGE)
+
+Stage-0
+ Fetch Operator
+ limit:100
+ Stage-1
+ Reducer 9
+ File Output Operator [FS_596]
+ Limit [LIM_595] (rows=100 width=406)
+ Number of rows:100
+ Select Operator [SEL_594] (rows=1016388080 width=406)
+ Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ <-Reducer 8 [SIMPLE_EDGE]
+ SHUFFLE [RS_593]
+ Select Operator [SEL_592] (rows=1016388080 width=406)
+ Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Group By Operator [GBY_591] (rows=1016388080 width=406)
+ 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 7 [SIMPLE_EDGE]
+ <-Reducer 115 [CONTAINS]
+ Reduce Output Operator [RS_590]
+ PartitionCols:_col0, _col1, _col2, _col3, _col4
+ Group By Operator [GBY_589] (rows=2032776160 width=406)
+ Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0
+ Select Operator [SEL_586] (rows=58081078 width=433)
+ Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Filter Operator [FIL_585] (rows=58081078 width=433)
+ predicate:(_col5 > _col1)
+ Merge Join Operator [MERGEJOIN_917] (rows=174243235 width=433)
+ Conds:(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
+ <-Reducer 114 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_582]
+ Merge Join Operator [MERGEJOIN_916] (rows=1 width=297)
+ Conds:(Left Outer),Output:["_col1"]
+ <-Reducer 113 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_579]
+ Select Operator [SEL_436] (rows=1 width=8)
+ Filter Operator [FIL_435] (rows=1 width=8)
+ predicate:(sq_count_check(_col0) <= 1)
+ Group By Operator [GBY_433] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count()"]
+ Select Operator [SEL_428] (rows=1 width=8)
+ Group By Operator [GBY_427] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(VALUE._col0)"]
+ <-Union 112 [CUSTOM_SIMPLE_EDGE]
+ <-Reducer 111 [CONTAINS]
+ Reduce Output Operator [RS_426]
+ Group By Operator [GBY_425] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(_col0)"]
+ Select Operator [SEL_424] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_401] (rows=633595212 width=88)
+ Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_897] (rows=633595212 width=88)
+ Conds:RS_398._col0=RS_399._col0(Inner),Output:["_col1"]
+ <-Map 110 [SIMPLE_EDGE]
+ SHUFFLE [RS_398]
+ PartitionCols:_col0
+ Select Operator [SEL_394] (rows=575995635 width=88)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_842] (rows=575995635 width=88)
+ predicate:ss_sold_date_sk is not null
+ TableScan [TS_392] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+ <-Map 116 [SIMPLE_EDGE]
+ SHUFFLE [RS_399]
+ PartitionCols:_col0
+ Select Operator [SEL_397] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_843] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_395] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 118 [CONTAINS]
+ Reduce Output Operator [RS_426]
+ Group By Operator [GBY_425] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(_col0)"]
+ Select Operator [SEL_424] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_411] (rows=316788826 width=135)
+ Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_898] (rows=316788826 width=135)
+ Conds:RS_408._col0=RS_409._col0(Inner),Output:["_col1"]
+ <-Map 117 [SIMPLE_EDGE]
+ SHUFFLE [RS_408]
+ PartitionCols:_col0
+ Select Operator [SEL_404] (rows=287989836 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_844] (rows=287989836 width=135)
+ predicate:cs_sold_date_sk is not null
+ TableScan [TS_402] (rows=287989836 width=135)
+ default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity"]
+ <-Map 119 [SIMPLE_EDGE]
+ SHUFFLE [RS_409]
+ PartitionCols:_col0
+ Select Operator [SEL_407] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_845] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ TableScan [TS_405] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 121 [CONTAINS]
+ Reduce Output Operator [RS_426]
+ Group By Operator [GBY_425] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(_col0)"]
+ Select Operator [SEL_424] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_423] (rows=158402938 width=135)
+ Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_899] (rows=158402938 width=135)
+ Conds:RS_420._col0=RS_421._col0(Inner),Output:["_col1"]
+ <-Map 120 [SIMPLE_EDGE]
+ SHUFFLE [RS_420]
+ PartitionCols:_col0
+ Select Operator [SEL_416] (rows=144002668 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_846] (rows=144002668 width=135)
+ predicate:ws_sold_date_sk is not null
+ TableScan [TS_414] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity"]
+ <-Map 122 [SIMPLE_EDGE]
+ SHUFFLE [RS_421]
+ PartitionCols:_col0
+ Select Operator [SEL_419] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_847] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ TableScan [TS_417] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 126 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_580]
+ Group By Operator [GBY_473] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+ <-Union 125 [CUSTOM_SIMPLE_EDGE]
+ <-Reducer 124 [CONTAINS]
+ Reduce Output Operator [RS_472]
+ Group By Operator [GBY_471] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_469] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_446] (rows=633595212 width=88)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_900] (rows=633595212 width=88)
+ Conds:RS_443._col0=RS_444._col0(Inner),Output:["_col1","_col2"]
+ <-Map 123 [SIMPLE_EDGE]
+ SHUFFLE [RS_443]
+ PartitionCols:_col0
+ Select Operator [SEL_439] (rows=575995635 width=88)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_848] (rows=575995635 width=88)
+ predicate:ss_sold_date_sk is not null
+ TableScan [TS_437] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity","ss_list_price"]
+ <-Map 127 [SIMPLE_EDGE]
+ SHUFFLE [RS_444]
+ PartitionCols:_col0
+ Select Operator [SEL_442] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_849] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_440] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 129 [CONTAINS]
+ Reduce Output Operator [RS_472]
+ Group By Operator [GBY_471] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_469] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_456] (rows=316788826 width=135)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_901] (rows=316788826 width=135)
+ Conds:RS_453._col0=RS_454._col0(Inner),Output:["_col1","_col2"]
+ <-Map 128 [SIMPLE_EDGE]
+ SHUFFLE [RS_453]
+ PartitionCols:_col0
+ Select Operator [SEL_449] (rows=287989836 width=135)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_850] (rows=287989836 width=135)
+ predicate:cs_sold_date_sk is not null
+ TableScan [TS_447] (rows=287989836 width=135)
+ default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity","cs_list_price"]
+ <-Map 130 [SIMPLE_EDGE]
+ SHUFFLE [RS_454]
+ PartitionCols:_col0
+ Select Operator [SEL_452] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_851] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ TableScan [TS_450] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 132 [CONTAINS]
+ Reduce Output Operator [RS_472]
+ Group By Operator [GBY_471] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_469] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_468] (rows=158402938 width=135)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_902] (rows=158402938 width=135)
+ Conds:RS_465._col0=RS_466._col0(Inner),Output:["_col1","_col2"]
+ <-Map 131 [SIMPLE_EDGE]
+ SHUFFLE [RS_465]
+ PartitionCols:_col0
+ Select Operator [SEL_461] (rows=144002668 width=135)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_852] (rows=144002668 width=135)
+ predicate:ws_sold_date_sk is not null
+ TableScan [TS_459] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"]
+ <-Map 133 [SIMPLE_EDGE]
+ SHUFFLE [RS_466]
+ PartitionCols:_col0
+ Select Operator [SEL_464] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_853] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ TableScan [TS_462] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 137 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_583]
+ Group By Operator [GBY_577] (rows=174243235 width=135)
+ Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 136 [SIMPLE_EDGE]
+ SHUFFLE [RS_576]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_575] (rows=348486471 width=135)
+ Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2
+ Select Operator [SEL_573] (rows=348486471 width=135)
+ Output:["_col0","_col1","_col2","_col3"]
+ Merge Join Operator [MERGEJOIN_911] (rows=348486471 width=135)
+ Conds:RS_569._col1=RS_570._col0(Inner),RS_569._col1=RS_571._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ <-Map 139 [SIMPLE_EDGE]
+ SHUFFLE [RS_570]
+ PartitionCols:_col0
+ Select Operator [SEL_483] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_856] (rows=462000 width=1436)
+ predicate:i_item_sk is not null
+ TableScan [TS_481] (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 135 [SIMPLE_EDGE]
+ SHUFFLE [RS_569]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_903] (rows=158402938 width=135)
+ Conds:RS_566._col0=RS_567._col0(Inner),Output:["_col1","_col2","_col3"]
+ <-Map 134 [SIMPLE_EDGE]
+ SHUFFLE [RS_566]
+ PartitionCols:_col0
+ Select Operator [SEL_477] (rows=144002668 width=135)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_854] (rows=144002668 width=135)
+ predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
+ TableScan [TS_475] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_quantity","ws_list_price"]
+ <-Map 138 [SIMPLE_EDGE]
+ SHUFFLE [RS_567]
+ PartitionCols:_col0
+ Select Operator [SEL_480] (rows=18262 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_855] (rows=18262 width=1119)
+ predicate:((d_year = 2000) and (d_moy = 11) and d_date_sk is not null)
+ TableScan [TS_478] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
+ <-Reducer 142 [SIMPLE_EDGE]
+ SHUFFLE [RS_571]
+ PartitionCols:_col0
+ Group By Operator [GBY_564] (rows=254100 width=1436)
+ Output:["_col0"],keys:KEY._col0
+ <-Reducer 141 [SIMPLE_EDGE]
+ SHUFFLE [RS_563]
+ PartitionCols:_col0
+ Group By Operator [GBY_562] (rows=508200 width=1436)
+ Output:["_col0"],keys:_col0
+ Merge Join Operator [MERGEJOIN_910] (rows=508200 width=1436)
+ Conds:RS_558._col1, _col2, _col3=RS_559._col0, _col1, _col2(Inner),Output:["_col0"]
+ <-Map 140 [SIMPLE_EDGE]
+ SHUFFLE [RS_558]
+ PartitionCols:_col1, _col2, _col3
+ Select Operator [SEL_486] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_857] (rows=462000 width=1436)
+ predicate:(i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_484] (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 148 [SIMPLE_EDGE]
+ SHUFFLE [RS_559]
+ PartitionCols:_col0, _col1, _col2
+ Select Operator [SEL_557] (rows=1 width=108)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_556] (rows=1 width=108)
+ predicate:(_col3 = 3)
+ Group By Operator [GBY_555] (rows=304916424 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Union 147 [SIMPLE_EDGE]
+ <-Reducer 146 [CONTAINS]
+ Reduce Output Operator [RS_554]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_553] (rows=609832849 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
+ Group By Operator [GBY_506] (rows=348477374 width=88)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 145 [SIMPLE_EDGE]
+ SHUFFLE [RS_505]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_504] (rows=696954748 width=88)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
+ Select Operator [SEL_502] (rows=696954748 width=88)
+ Output:["_col0","_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_905] (rows=696954748 width=88)
+ Conds:RS_499._col1=RS_500._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 150 [SIMPLE_EDGE]
+ SHUFFLE [RS_500]
+ PartitionCols:_col0
+ Select Operator [SEL_495] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_860] (rows=462000 width=1436)
+ predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_493] (rows=462000 width=1436)
+ default@item,iss,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
+ <-Reducer 144 [SIMPLE_EDGE]
+ SHUFFLE [RS_499]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_904] (rows=633595212 width=88)
+ Conds:RS_496._col0=RS_497._col0(Inner),Output:["_col1"]
+ <-Map 143 [SIMPLE_EDGE]
+ SHUFFLE [RS_496]
+ PartitionCols:_col0
+ Select Operator [SEL_489] (rows=575995635 width=88)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_858] (rows=575995635 width=88)
+ predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
+ TableScan [TS_487] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"]
+ <-Map 149 [SIMPLE_EDGE]
+ SHUFFLE [RS_497]
+ PartitionCols:_col0
+ Select Operator [SEL_492] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_859] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_490] (rows=73049 width=1119)
+ default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 154 [CONTAINS]
+ Reduce Output Operator [RS_554]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_553] (rows=609832849 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
+ Group By Operator [GBY_527] (rows=174233858 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 153 [SIMPLE_EDGE]
+ SHUFFLE [RS_526]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_525] (rows=348467716 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
+ Select Operator [SEL_523] (rows=348467716 width=135)
+ Output:["_col0","_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_907] (rows=348467716 width=135)
+ Conds:RS_520._col1=RS_521._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 156 [SIMPLE_EDGE]
+ SHUFFLE [RS_521]
+ PartitionCols:_col0
+ Select Operator [SEL_516] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_863] (rows=462000 width=1436)
+ predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_514] (rows=462000 width=1436)
+ default@item,ics,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
+ <-Reducer 152 [SIMPLE_EDGE]
+ SHUFFLE [RS_520]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_906] (rows=316788826 width=135)
+ Conds:RS_517._col0=RS_518._col0(Inner),Output:["_col1"]
+ <-Map 151 [SIMPLE_EDGE]
+ SHUFFLE [RS_517]
+ PartitionCols:_col0
+ Select Operator [SEL_510] (rows=287989836 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_861] (rows=287989836 width=135)
+ predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
+ TableScan [TS_508] (rows=287989836 width=135)
+ default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk"]
+ <-Map 155 [SIMPLE_EDGE]
+ SHUFFLE [RS_518]
+ PartitionCols:_col0
+ Select Operator [SEL_513] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_862] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_511] (rows=73049 width=1119)
+ default@date_dim,d2,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 160 [CONTAINS]
+ Reduce Output Operator [RS_554]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_553] (rows=609832849 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
+ Group By Operator [GBY_549] (rows=87121617 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 159 [SIMPLE_EDGE]
+ SHUFFLE [RS_548]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_547] (rows=174243235 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
+ Select Operator [SEL_545] (rows=174243235 width=135)
+ Output:["_col0","_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_909] (rows=174243235 width=135)
+ Conds:RS_542._col1=RS_543._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 162 [SIMPLE_EDGE]
+ SHUFFLE [RS_543]
+ PartitionCols:_col0
+ Select Operator [SEL_538] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_866] (rows=462000 width=1436)
+ predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_536] (rows=462000 width=1436)
+ default@item,iws,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
+ <-Reducer 158 [SIMPLE_EDGE]
+ SHUFFLE [RS_542]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_908] (rows=158402938 width=135)
+ Conds:RS_539._col0=RS_540._col0(Inner),Output:["_col1"]
+ <-Map 157 [SIMPLE_EDGE]
+ SHUFFLE [RS_539]
+ PartitionCols:_col0
+ Select Operator [SEL_532] (rows=144002668 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_864] (rows=144002668 width=135)
+ predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
+ TableScan [TS_530] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"]
+ <-Map 161 [SIMPLE_EDGE]
+ SHUFFLE [RS_540]
+ PartitionCols:_col0
+ Select Operator [SEL_535] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_865] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_533] (rows=73049 width=1119)
+ default@date_dim,d3,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 6 [CONTAINS]
+ Reduce Output Operator [RS_590]
+ PartitionCols:_col0, _col1, _col2, _col3, _col4
+ Group By Operator [GBY_589] (rows=2032776160 width=406)
+ Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0
+ Select Operator [SEL_194] (rows=232318249 width=386)
+ Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Filter Operator [FIL_193] (rows=232318249 width=386)
+ predicate:(_col5 > _col1)
+ Merge Join Operator [MERGEJOIN_913] (rows=696954748 width=386)
+ Conds:(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
+ <-Reducer 31 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_191]
+ Group By Operator [GBY_185] (rows=696954748 width=88)
+ Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 30 [SIMPLE_EDGE]
+ SHUFFLE [RS_184]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_183] (rows=1393909496 width=88)
+ Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col3)","count()"],keys:_col0, _col1, _col2
+ Select Operator [SEL_181] (rows=1393909496 width=88)
+ Output:["_col0","_col1","_col2","_col3"]
+ Merge Join Operator [MERGEJOIN_881] (rows=1393909496 width=88)
+ Conds:RS_177._col1=RS_178._col0(Inner),RS_177._col1=RS_179._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ <-Map 33 [SIMPLE_EDGE]
+ SHUFFLE [RS_178]
+ PartitionCols:_col0
+ Select Operator [SEL_91] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_806] (rows=462000 width=1436)
+ predicate:i_item_sk is not null
+ TableScan [TS_89] (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 29 [SIMPLE_EDGE]
+ SHUFFLE [RS_177]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_873] (rows=633595212 width=88)
+ Conds:RS_174._col0=RS_175._col0(Inner),Output:["_col1","_col2","_col3"]
+ <-Map 28 [SIMPLE_EDGE]
+ SHUFFLE [RS_174]
+ PartitionCols:_col0
+ Select Operator [SEL_85] (rows=575995635 width=88)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_804] (rows=575995635 width=88)
+ predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
+ TableScan [TS_83] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_quantity","ss_list_price"]
+ <-Map 32 [SIMPLE_EDGE]
+ SHUFFLE [RS_175]
+ PartitionCols:_col0
+ Select Operator [SEL_88] (rows=18262 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_805] (rows=18262 width=1119)
+ predicate:((d_year = 2000) and (d_moy = 11) and d_date_sk is not null)
+ TableScan [TS_86] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
+ <-Reducer 36 [SIMPLE_EDGE]
+ SHUFFLE [RS_179]
+ PartitionCols:_col0
+ Group By Operator [GBY_172] (rows=254100 width=1436)
+ Output:["_col0"],keys:KEY._col0
+ <-Reducer 35 [SIMPLE_EDGE]
+ SHUFFLE [RS_171]
+ PartitionCols:_col0
+ Group By Operator [GBY_170] (rows=508200 width=1436)
+ Output:["_col0"],keys:_col0
+ Merge Join Operator [MERGEJOIN_880] (rows=508200 width=1436)
+ Conds:RS_166._col1, _col2, _col3=RS_167._col0, _col1, _col2(Inner),Output:["_col0"]
+ <-Map 34 [SIMPLE_EDGE]
+ SHUFFLE [RS_166]
+ PartitionCols:_col1, _col2, _col3
+ Select Operator [SEL_94] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_807] (rows=462000 width=1436)
+ predicate:(i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_92] (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 42 [SIMPLE_EDGE]
+ SHUFFLE [RS_167]
+ PartitionCols:_col0, _col1, _col2
+ Select Operator [SEL_165] (rows=1 width=108)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_164] (rows=1 width=108)
+ predicate:(_col3 = 3)
+ Group By Operator [GBY_163] (rows=304916424 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Union 41 [SIMPLE_EDGE]
+ <-Reducer 40 [CONTAINS]
+ Reduce Output Operator [RS_162]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_161] (rows=609832849 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
+ Group By Operator [GBY_114] (rows=348477374 width=88)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 39 [SIMPLE_EDGE]
+ SHUFFLE [RS_113]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_112] (rows=696954748 width=88)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
+ Select Operator [SEL_110] (rows=696954748 width=88)
+ Output:["_col0","_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_875] (rows=696954748 width=88)
+ Conds:RS_107._col1=RS_108._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 44 [SIMPLE_EDGE]
+ SHUFFLE [RS_108]
+ PartitionCols:_col0
+ Select Operator [SEL_103] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_810] (rows=462000 width=1436)
+ predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_101] (rows=462000 width=1436)
+ default@item,iss,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
+ <-Reducer 38 [SIMPLE_EDGE]
+ SHUFFLE [RS_107]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_874] (rows=633595212 width=88)
+ Conds:RS_104._col0=RS_105._col0(Inner),Output:["_col1"]
+ <-Map 37 [SIMPLE_EDGE]
+ SHUFFLE [RS_104]
+ PartitionCols:_col0
+ Select Operator [SEL_97] (rows=575995635 width=88)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_808] (rows=575995635 width=88)
+ predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
+ TableScan [TS_95] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"]
+ <-Map 43 [SIMPLE_EDGE]
+ SHUFFLE [RS_105]
+ PartitionCols:_col0
+ Select Operator [SEL_100] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_809] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_98] (rows=73049 width=1119)
+ default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 48 [CONTAINS]
+ Reduce Output Operator [RS_162]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_161] (rows=609832849 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
+ Group By Operator [GBY_135] (rows=174233858 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 47 [SIMPLE_EDGE]
+ SHUFFLE [RS_134]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_133] (rows=348467716 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
+ Select Operator [SEL_131] (rows=348467716 width=135)
+ Output:["_col0","_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_877] (rows=348467716 width=135)
+ Conds:RS_128._col1=RS_129._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 50 [SIMPLE_EDGE]
+ SHUFFLE [RS_129]
+ PartitionCols:_col0
+ Select Operator [SEL_124] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_813] (rows=462000 width=1436)
+ predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_122] (rows=462000 width=1436)
+ default@item,ics,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
+ <-Reducer 46 [SIMPLE_EDGE]
+ SHUFFLE [RS_128]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_876] (rows=316788826 width=135)
+ Conds:RS_125._col0=RS_126._col0(Inner),Output:["_col1"]
+ <-Map 45 [SIMPLE_EDGE]
+ SHUFFLE [RS_125]
+ PartitionCols:_col0
+ Select Operator [SEL_118] (rows=287989836 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_811] (rows=287989836 width=135)
+ predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
+ TableScan [TS_116] (rows=287989836 width=135)
+ default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk"]
+ <-Map 49 [SIMPLE_EDGE]
+ SHUFFLE [RS_126]
+ PartitionCols:_col0
+ Select Operator [SEL_121] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_812] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_119] (rows=73049 width=1119)
+ default@date_dim,d2,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 54 [CONTAINS]
+ Reduce Output Operator [RS_162]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_161] (rows=609832849 width=108)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
+ Group By Operator [GBY_157] (rows=87121617 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 53 [SIMPLE_EDGE]
+ SHUFFLE [RS_156]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_155] (rows=174243235 width=135)
+ Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
+ Select Operator [SEL_153] (rows=174243235 width=135)
+ Output:["_col0","_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_879] (rows=174243235 width=135)
+ Conds:RS_150._col1=RS_151._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 56 [SIMPLE_EDGE]
+ SHUFFLE [RS_151]
+ PartitionCols:_col0
+ Select Operator [SEL_146] (rows=462000 width=1436)
+ Output:["_col0","_col1","_col2","_col3"]
+ Filter Operator [FIL_816] (rows=462000 width=1436)
+ predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ TableScan [TS_144] (rows=462000 width=1436)
+ default@item,iws,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
+ <-Reducer 52 [SIMPLE_EDGE]
+ SHUFFLE [RS_150]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_878] (rows=158402938 width=135)
+ Conds:RS_147._col0=RS_148._col0(Inner),Output:["_col1"]
+ <-Map 51 [SIMPLE_EDGE]
+ SHUFFLE [RS_147]
+ PartitionCols:_col0
+ Select Operator [SEL_140] (rows=144002668 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_814] (rows=144002668 width=135)
+ predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
+ TableScan [TS_138] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"]
+ <-Map 55 [SIMPLE_EDGE]
+ SHUFFLE [RS_148]
+ PartitionCols:_col0
+ Select Operator [SEL_143] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_815] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_141] (rows=73049 width=1119)
+ default@date_dim,d3,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 5 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_190]
+ Merge Join Operator [MERGEJOIN_912] (rows=1 width=297)
+ Conds:(Left Outer),Output:["_col1"]
+ <-Reducer 20 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_188]
+ Group By Operator [GBY_81] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+ <-Union 19 [CUSTOM_SIMPLE_EDGE]
+ <-Reducer 18 [CONTAINS]
+ Reduce Output Operator [RS_80]
+ Group By Operator [GBY_79] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_77] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_54] (rows=633595212 width=88)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_870] (rows=633595212 width=88)
+ Conds:RS_51._col0=RS_52._col0(Inner),Output:["_col1","_col2"]
+ <-Map 17 [SIMPLE_EDGE]
+ SHUFFLE [RS_51]
+ PartitionCols:_col0
+ Select Operator [SEL_47] (rows=575995635 width=88)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_798] (rows=575995635 width=88)
+ predicate: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"]
+ <-Map 21 [SIMPLE_EDGE]
+ SHUFFLE [RS_52]
+ PartitionCols:_col0
+ Select Operator [SEL_50] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_799] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_48] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 23 [CONTAINS]
+ Reduce Output Operator [RS_80]
+ Group By Operator [GBY_79] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_77] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_64] (rows=316788826 width=135)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_871] (rows=316788826 width=135)
+ Conds:RS_61._col0=RS_62._col0(Inner),Output:["_col1","_col2"]
+ <-Map 22 [SIMPLE_EDGE]
+ SHUFFLE [RS_61]
+ PartitionCols:_col0
+ Select Operator [SEL_57] (rows=287989836 width=135)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_800] (rows=287989836 width=135)
+ predicate: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"]
+ <-Map 24 [SIMPLE_EDGE]
+ SHUFFLE [RS_62]
+ PartitionCols:_col0
+
<TRUNCATED>