You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2017/04/13 20:50:18 UTC
[13/26] hive git commit: HIVE-15708 : Upgrade calcite version to 1.12
(Remus Rusanu via Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/be59e024/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
index 051d837..9284353 100644
--- a/ql/src/test/results/clientpositive/perf/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/query14.q.out
@@ -1,9 +1,6 @@
-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[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[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
+Warning: Shuffle Join MERGEJOIN[906][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
+Warning: Shuffle Join MERGEJOIN[907][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 60' is a cross product
+Warning: Shuffle Join MERGEJOIN[908][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 112' is a cross product
PREHOOK: query: explain
with cross_items as
(select i_item_sk ss_item_sk
@@ -213,598 +210,680 @@ 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 103 <- Map 102 (SIMPLE_EDGE), Map 106 (SIMPLE_EDGE)
+Reducer 104 <- Map 107 (SIMPLE_EDGE), Reducer 103 (SIMPLE_EDGE)
+Reducer 105 <- Reducer 104 (SIMPLE_EDGE), Union 92 (CONTAINS)
+Reducer 109 <- Map 108 (SIMPLE_EDGE), Map 113 (SIMPLE_EDGE), Union 110 (CONTAINS)
+Reducer 11 <- Map 10 (SIMPLE_EDGE), Map 12 (SIMPLE_EDGE), Union 3 (CONTAINS)
+Reducer 111 <- Union 110 (CUSTOM_SIMPLE_EDGE)
+Reducer 112 <- Reducer 111 (CUSTOM_SIMPLE_EDGE), Reducer 123 (CUSTOM_SIMPLE_EDGE), Reducer 134 (CUSTOM_SIMPLE_EDGE), Union 6 (CONTAINS)
+Reducer 115 <- Map 114 (SIMPLE_EDGE), Map 116 (SIMPLE_EDGE), Union 110 (CONTAINS)
+Reducer 118 <- Map 117 (SIMPLE_EDGE), Map 119 (SIMPLE_EDGE), Union 110 (CONTAINS)
+Reducer 121 <- Map 120 (SIMPLE_EDGE), Map 124 (SIMPLE_EDGE), Union 122 (CONTAINS)
+Reducer 123 <- Union 122 (CUSTOM_SIMPLE_EDGE)
+Reducer 126 <- Map 125 (SIMPLE_EDGE), Map 127 (SIMPLE_EDGE), Union 122 (CONTAINS)
+Reducer 129 <- Map 128 (SIMPLE_EDGE), Map 130 (SIMPLE_EDGE), Union 122 (CONTAINS)
+Reducer 132 <- Map 131 (SIMPLE_EDGE), Map 135 (SIMPLE_EDGE)
+Reducer 133 <- Map 136 (SIMPLE_EDGE), Reducer 132 (SIMPLE_EDGE), Reducer 139 (SIMPLE_EDGE)
+Reducer 134 <- Reducer 133 (SIMPLE_EDGE)
+Reducer 138 <- Map 137 (SIMPLE_EDGE), Reducer 145 (SIMPLE_EDGE)
+Reducer 139 <- Reducer 138 (SIMPLE_EDGE)
+Reducer 14 <- Map 13 (SIMPLE_EDGE), Map 15 (SIMPLE_EDGE), Union 3 (CONTAINS)
+Reducer 141 <- Map 140 (SIMPLE_EDGE), Map 146 (SIMPLE_EDGE)
+Reducer 142 <- Map 147 (SIMPLE_EDGE), Reducer 141 (SIMPLE_EDGE)
+Reducer 143 <- Reducer 142 (SIMPLE_EDGE), Union 144 (CONTAINS)
+Reducer 145 <- Union 144 (SIMPLE_EDGE)
+Reducer 149 <- Map 148 (SIMPLE_EDGE), Map 152 (SIMPLE_EDGE)
+Reducer 150 <- Map 153 (SIMPLE_EDGE), Reducer 149 (SIMPLE_EDGE)
+Reducer 151 <- Reducer 150 (SIMPLE_EDGE), Union 144 (CONTAINS)
+Reducer 155 <- Map 154 (SIMPLE_EDGE), Map 158 (SIMPLE_EDGE)
+Reducer 156 <- Map 159 (SIMPLE_EDGE), Reducer 155 (SIMPLE_EDGE)
+Reducer 157 <- Reducer 156 (SIMPLE_EDGE), Union 144 (CONTAINS)
+Reducer 17 <- Map 16 (SIMPLE_EDGE), Map 20 (SIMPLE_EDGE), Union 18 (CONTAINS)
+Reducer 19 <- Union 18 (CUSTOM_SIMPLE_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 9 (SIMPLE_EDGE), Union 3 (CONTAINS)
+Reducer 22 <- Map 21 (SIMPLE_EDGE), Map 23 (SIMPLE_EDGE), Union 18 (CONTAINS)
+Reducer 25 <- Map 24 (SIMPLE_EDGE), Map 26 (SIMPLE_EDGE), Union 18 (CONTAINS)
+Reducer 28 <- Map 27 (SIMPLE_EDGE), Map 31 (SIMPLE_EDGE)
+Reducer 29 <- Map 32 (SIMPLE_EDGE), Reducer 28 (SIMPLE_EDGE), Reducer 35 (SIMPLE_EDGE)
+Reducer 30 <- Reducer 29 (SIMPLE_EDGE)
+Reducer 34 <- Map 33 (SIMPLE_EDGE), Reducer 41 (SIMPLE_EDGE)
+Reducer 35 <- Reducer 34 (SIMPLE_EDGE)
+Reducer 37 <- Map 36 (SIMPLE_EDGE), Map 42 (SIMPLE_EDGE)
+Reducer 38 <- Map 43 (SIMPLE_EDGE), Reducer 37 (SIMPLE_EDGE)
+Reducer 39 <- Reducer 38 (SIMPLE_EDGE), Union 40 (CONTAINS)
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)
+Reducer 41 <- Union 40 (SIMPLE_EDGE)
+Reducer 45 <- Map 44 (SIMPLE_EDGE), Map 48 (SIMPLE_EDGE)
+Reducer 46 <- Map 49 (SIMPLE_EDGE), Reducer 45 (SIMPLE_EDGE)
+Reducer 47 <- Reducer 46 (SIMPLE_EDGE), Union 40 (CONTAINS)
+Reducer 5 <- Reducer 19 (CUSTOM_SIMPLE_EDGE), Reducer 30 (CUSTOM_SIMPLE_EDGE), Reducer 4 (CUSTOM_SIMPLE_EDGE), Union 6 (CONTAINS)
+Reducer 51 <- Map 50 (SIMPLE_EDGE), Map 54 (SIMPLE_EDGE)
+Reducer 52 <- Map 55 (SIMPLE_EDGE), Reducer 51 (SIMPLE_EDGE)
+Reducer 53 <- Reducer 52 (SIMPLE_EDGE), Union 40 (CONTAINS)
+Reducer 57 <- Map 56 (SIMPLE_EDGE), Map 61 (SIMPLE_EDGE), Union 58 (CONTAINS)
+Reducer 59 <- Union 58 (CUSTOM_SIMPLE_EDGE)
+Reducer 60 <- Reducer 59 (CUSTOM_SIMPLE_EDGE), Reducer 71 (CUSTOM_SIMPLE_EDGE), Reducer 82 (CUSTOM_SIMPLE_EDGE), Union 6 (CONTAINS)
+Reducer 63 <- Map 62 (SIMPLE_EDGE), Map 64 (SIMPLE_EDGE), Union 58 (CONTAINS)
+Reducer 66 <- Map 65 (SIMPLE_EDGE), Map 67 (SIMPLE_EDGE), Union 58 (CONTAINS)
+Reducer 69 <- Map 68 (SIMPLE_EDGE), Map 72 (SIMPLE_EDGE), Union 70 (CONTAINS)
+Reducer 7 <- Union 6 (SIMPLE_EDGE)
+Reducer 71 <- Union 70 (CUSTOM_SIMPLE_EDGE)
+Reducer 74 <- Map 73 (SIMPLE_EDGE), Map 75 (SIMPLE_EDGE), Union 70 (CONTAINS)
+Reducer 77 <- Map 76 (SIMPLE_EDGE), Map 78 (SIMPLE_EDGE), Union 70 (CONTAINS)
+Reducer 8 <- Reducer 7 (SIMPLE_EDGE)
+Reducer 80 <- Map 79 (SIMPLE_EDGE), Map 83 (SIMPLE_EDGE)
+Reducer 81 <- Map 84 (SIMPLE_EDGE), Reducer 80 (SIMPLE_EDGE), Reducer 87 (SIMPLE_EDGE)
+Reducer 82 <- Reducer 81 (SIMPLE_EDGE)
+Reducer 86 <- Map 85 (SIMPLE_EDGE), Reducer 93 (SIMPLE_EDGE)
+Reducer 87 <- Reducer 86 (SIMPLE_EDGE)
+Reducer 89 <- Map 88 (SIMPLE_EDGE), Map 94 (SIMPLE_EDGE)
+Reducer 90 <- Map 95 (SIMPLE_EDGE), Reducer 89 (SIMPLE_EDGE)
+Reducer 91 <- Reducer 90 (SIMPLE_EDGE), Union 92 (CONTAINS)
+Reducer 93 <- Union 92 (SIMPLE_EDGE)
+Reducer 97 <- Map 100 (SIMPLE_EDGE), Map 96 (SIMPLE_EDGE)
+Reducer 98 <- Map 101 (SIMPLE_EDGE), Reducer 97 (SIMPLE_EDGE)
+Reducer 99 <- Reducer 98 (SIMPLE_EDGE), Union 92 (CONTAINS)
Stage-0
Fetch Operator
limit:100
Stage-1
- Reducer 9
- File Output Operator [FS_596]
- Limit [LIM_595] (rows=100 width=406)
+ Reducer 8
+ File Output Operator [FS_590]
+ Limit [LIM_589] (rows=100 width=405)
Number of rows:100
- Select Operator [SEL_594] (rows=1016388080 width=406)
+ Select Operator [SEL_588] (rows=1016388080 width=405)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- <-Reducer 8 [SIMPLE_EDGE]
- SHUFFLE [RS_593]
- Select Operator [SEL_592] (rows=1016388080 width=406)
+ <-Reducer 7 [SIMPLE_EDGE]
+ SHUFFLE [RS_587]
+ Select Operator [SEL_586] (rows=1016388080 width=405)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Group By Operator [GBY_591] (rows=1016388080 width=406)
+ Group By Operator [GBY_585] (rows=1016388080 width=405)
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]
+ <-Union 6 [SIMPLE_EDGE]
+ <-Reducer 112 [CONTAINS]
+ Reduce Output Operator [RS_584]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_589] (rows=2032776160 width=406)
+ Group By Operator [GBY_583] (rows=2032776160 width=405)
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)
+ Select Operator [SEL_580] (rows=58081078 width=432)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_585] (rows=58081078 width=433)
+ Filter Operator [FIL_579] (rows=58081078 width=432)
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)
+ Merge Join Operator [MERGEJOIN_908] (rows=174243235 width=432)
+ Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
+ <-Reducer 111 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_575]
+ Select Operator [SEL_432] (rows=1 width=8)
+ Filter Operator [FIL_431] (rows=1 width=8)
+ predicate:(sq_count_check(_col0) <= 1)
+ Group By Operator [GBY_429] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count()"]
+ Select Operator [SEL_424] (rows=1 width=8)
+ Group By Operator [GBY_423] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(VALUE._col0)"]
+ <-Union 110 [CUSTOM_SIMPLE_EDGE]
+ <-Reducer 109 [CONTAINS]
+ Reduce Output Operator [RS_422]
+ Group By Operator [GBY_421] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(_col0)"]
+ Select Operator [SEL_420] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_397] (rows=633595212 width=88)
+ Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_891] (rows=633595212 width=88)
+ Conds:RS_394._col0=RS_395._col0(Inner),Output:["_col1"]
+ <-Map 108 [SIMPLE_EDGE]
+ SHUFFLE [RS_394]
+ PartitionCols:_col0
+ Select Operator [SEL_390] (rows=575995635 width=88)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_836] (rows=575995635 width=88)
+ predicate:ss_sold_date_sk is not null
+ TableScan [TS_388] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+ <-Map 113 [SIMPLE_EDGE]
+ SHUFFLE [RS_395]
+ PartitionCols:_col0
+ Select Operator [SEL_393] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_837] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ TableScan [TS_391] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 115 [CONTAINS]
+ Reduce Output Operator [RS_422]
+ Group By Operator [GBY_421] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(_col0)"]
+ Select Operator [SEL_420] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_407] (rows=316788826 width=135)
+ Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_892] (rows=316788826 width=135)
+ Conds:RS_404._col0=RS_405._col0(Inner),Output:["_col1"]
+ <-Map 114 [SIMPLE_EDGE]
+ SHUFFLE [RS_404]
+ PartitionCols:_col0
+ Select Operator [SEL_400] (rows=287989836 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_838] (rows=287989836 width=135)
+ predicate:cs_sold_date_sk is not null
+ TableScan [TS_398] (rows=287989836 width=135)
+ default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity"]
+ <-Map 116 [SIMPLE_EDGE]
+ SHUFFLE [RS_405]
+ PartitionCols:_col0
+ Select Operator [SEL_403] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_839] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ TableScan [TS_401] (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_422]
+ Group By Operator [GBY_421] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(_col0)"]
+ Select Operator [SEL_420] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_419] (rows=158402938 width=135)
+ Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_893] (rows=158402938 width=135)
+ Conds:RS_416._col0=RS_417._col0(Inner),Output:["_col1"]
+ <-Map 117 [SIMPLE_EDGE]
+ SHUFFLE [RS_416]
+ PartitionCols:_col0
+ Select Operator [SEL_412] (rows=144002668 width=135)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_840] (rows=144002668 width=135)
+ predicate:ws_sold_date_sk is not null
+ TableScan [TS_410] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity"]
+ <-Map 119 [SIMPLE_EDGE]
+ SHUFFLE [RS_417]
+ PartitionCols:_col0
+ Select Operator [SEL_415] (rows=8116 width=1119)
+ Output:["_col0"]
+ Filter Operator [FIL_841] (rows=8116 width=1119)
+ predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ TableScan [TS_413] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 123 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_576]
+ Group By Operator [GBY_469] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+ <-Union 122 [CUSTOM_SIMPLE_EDGE]
+ <-Reducer 121 [CONTAINS]
+ Reduce Output Operator [RS_468]
+ Group By Operator [GBY_467] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_465] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_442] (rows=633595212 width=88)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_894] (rows=633595212 width=88)
+ Conds:RS_439._col0=RS_440._col0(Inner),Output:["_col1","_col2"]
+ <-Map 120 [SIMPLE_EDGE]
+ SHUFFLE [RS_439]
+ PartitionCols:_col0
+ Select Operator [SEL_435] (rows=575995635 width=88)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_842] (rows=575995635 width=88)
+ predicate:ss_sold_date_sk is not null
+ TableScan [TS_433] (rows=575995635 width=88)
+ default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity","ss_list_price"]
+ <-Map 124 [SIMPLE_EDGE]
+ SHUFFLE [RS_440]
+ PartitionCols:_col0
+ Select Operator [SEL_438] (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_436] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 126 [CONTAINS]
+ Reduce Output Operator [RS_468]
+ Group By Operator [GBY_467] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_465] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_452] (rows=316788826 width=135)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_895] (rows=316788826 width=135)
+ Conds:RS_449._col0=RS_450._col0(Inner),Output:["_col1","_col2"]
+ <-Map 125 [SIMPLE_EDGE]
+ SHUFFLE [RS_449]
+ PartitionCols:_col0
+ Select Operator [SEL_445] (rows=287989836 width=135)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_844] (rows=287989836 width=135)
+ predicate:cs_sold_date_sk is not null
+ TableScan [TS_443] (rows=287989836 width=135)
+ default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity","cs_list_price"]
+ <-Map 127 [SIMPLE_EDGE]
+ SHUFFLE [RS_450]
+ PartitionCols:_col0
+ Select Operator [SEL_448] (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_446] (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_468]
+ Group By Operator [GBY_467] (rows=1 width=288)
+ Output:["_col0"],aggregations:["avg(_col0)"]
+ Select Operator [SEL_465] (rows=1108786976 width=108)
+ Output:["_col0"]
+ Select Operator [SEL_464] (rows=158402938 width=135)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_896] (rows=158402938 width=135)
+ Conds:RS_461._col0=RS_462._col0(Inner),Output:["_col1","_col2"]
+ <-Map 128 [SIMPLE_EDGE]
+ SHUFFLE [RS_461]
+ PartitionCols:_col0
+ Select Operator [SEL_457] (rows=144002668 width=135)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_846] (rows=144002668 width=135)
+ predicate:ws_sold_date_sk is not null
+ TableScan [TS_455] (rows=144002668 width=135)
+ default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"]
+ <-Map 130 [SIMPLE_EDGE]
+ SHUFFLE [RS_462]
+ PartitionCols:_col0
+ Select Operator [SEL_460] (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_458] (rows=73049 width=1119)
+ default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
+ <-Reducer 134 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_577]
+ Group By Operator [GBY_573] (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]
+ <-Reducer 133 [SIMPLE_EDGE]
+ SHUFFLE [RS_572]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_575] (rows=348486471 width=135)
+ Group By Operator [GBY_571] (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)
+ Select Operator [SEL_569] (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]
+ Merge Join Operator [MERGEJOIN_905] (rows=348486471 width=135)
+ Conds:RS_565._col1=RS_566._col0(Inner),RS_565._col1=RS_567._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ <-Map 136 [SIMPLE_EDGE]
+ SHUFFLE [RS_566]
PartitionCols:_col0
- Select Operator [SEL_483] (rows=462000 width=1436)
+ Select Operator [SEL_479] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_856] (rows=462000 width=1436)
+ Filter Operator [FIL_850] (rows=462000 width=1436)
predicate:i_item_sk is not null
- TableScan [TS_481] (rows=462000 width=1436)
+ TableScan [TS_477] (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]
+ <-Reducer 132 [SIMPLE_EDGE]
+ SHUFFLE [RS_565]
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]
+ Merge Join Operator [MERGEJOIN_897] (rows=158402938 width=135)
+ Conds:RS_562._col0=RS_563._col0(Inner),Output:["_col1","_col2","_col3"]
+ <-Map 131 [SIMPLE_EDGE]
+ SHUFFLE [RS_562]
PartitionCols:_col0
- Select Operator [SEL_477] (rows=144002668 width=135)
+ Select Operator [SEL_473] (rows=144002668 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_854] (rows=144002668 width=135)
+ Filter Operator [FIL_848] (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)
+ TableScan [TS_471] (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]
+ <-Map 135 [SIMPLE_EDGE]
+ SHUFFLE [RS_563]
PartitionCols:_col0
- Select Operator [SEL_480] (rows=18262 width=1119)
+ Select Operator [SEL_476] (rows=18262 width=1119)
Output:["_col0"]
- Filter Operator [FIL_855] (rows=18262 width=1119)
+ Filter Operator [FIL_849] (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)
+ TableScan [TS_474] (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]
+ <-Reducer 139 [SIMPLE_EDGE]
+ SHUFFLE [RS_567]
PartitionCols:_col0
- Group By Operator [GBY_564] (rows=254100 width=1436)
+ Group By Operator [GBY_560] (rows=254100 width=1436)
Output:["_col0"],keys:KEY._col0
- <-Reducer 141 [SIMPLE_EDGE]
- SHUFFLE [RS_563]
+ <-Reducer 138 [SIMPLE_EDGE]
+ SHUFFLE [RS_559]
PartitionCols:_col0
- Group By Operator [GBY_562] (rows=508200 width=1436)
+ Group By Operator [GBY_558] (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]
+ Merge Join Operator [MERGEJOIN_904] (rows=508200 width=1436)
+ Conds:RS_554._col1, _col2, _col3=RS_555._col0, _col1, _col2(Inner),Output:["_col0"]
+ <-Map 137 [SIMPLE_EDGE]
+ SHUFFLE [RS_554]
PartitionCols:_col1, _col2, _col3
- Select Operator [SEL_486] (rows=462000 width=1436)
+ Select Operator [SEL_482] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_857] (rows=462000 width=1436)
+ Filter Operator [FIL_851] (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 and i_item_sk is not null)
- TableScan [TS_484] (rows=462000 width=1436)
+ TableScan [TS_480] (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]
+ <-Reducer 145 [SIMPLE_EDGE]
+ SHUFFLE [RS_555]
PartitionCols:_col0, _col1, _col2
- Select Operator [SEL_557] (rows=1 width=108)
+ Select Operator [SEL_553] (rows=1 width=108)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_556] (rows=1 width=108)
+ Filter Operator [FIL_552] (rows=1 width=108)
predicate:(_col3 = 3)
- Group By Operator [GBY_555] (rows=304916424 width=108)
+ Group By Operator [GBY_551] (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]
+ <-Union 144 [SIMPLE_EDGE]
+ <-Reducer 143 [CONTAINS]
+ Reduce Output Operator [RS_550]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_553] (rows=609832849 width=108)
+ Group By Operator [GBY_549] (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)
+ Group By Operator [GBY_502] (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]
+ <-Reducer 142 [SIMPLE_EDGE]
+ SHUFFLE [RS_501]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_504] (rows=696954748 width=88)
+ Group By Operator [GBY_500] (rows=696954748 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
- Select Operator [SEL_502] (rows=696954748 width=88)
+ Select Operator [SEL_498] (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]
+ Merge Join Operator [MERGEJOIN_899] (rows=696954748 width=88)
+ Conds:RS_495._col1=RS_496._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 147 [SIMPLE_EDGE]
+ SHUFFLE [RS_496]
PartitionCols:_col0
- Select Operator [SEL_495] (rows=462000 width=1436)
+ Select Operator [SEL_491] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_860] (rows=462000 width=1436)
+ Filter Operator [FIL_854] (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)
+ TableScan [TS_489] (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]
+ <-Reducer 141 [SIMPLE_EDGE]
+ SHUFFLE [RS_495]
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]
+ Merge Join Operator [MERGEJOIN_898] (rows=633595212 width=88)
+ Conds:RS_492._col0=RS_493._col0(Inner),Output:["_col1"]
+ <-Map 140 [SIMPLE_EDGE]
+ SHUFFLE [RS_492]
PartitionCols:_col0
- Select Operator [SEL_489] (rows=575995635 width=88)
+ Select Operator [SEL_485] (rows=575995635 width=88)
Output:["_col0","_col1"]
- Filter Operator [FIL_858] (rows=575995635 width=88)
+ Filter Operator [FIL_852] (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)
+ TableScan [TS_483] (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]
+ <-Map 146 [SIMPLE_EDGE]
+ SHUFFLE [RS_493]
PartitionCols:_col0
- Select Operator [SEL_492] (rows=8116 width=1119)
+ Select Operator [SEL_488] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_859] (rows=8116 width=1119)
+ Filter Operator [FIL_853] (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)
+ TableScan [TS_486] (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]
+ <-Reducer 151 [CONTAINS]
+ Reduce Output Operator [RS_550]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_553] (rows=609832849 width=108)
+ Group By Operator [GBY_549] (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)
+ Group By Operator [GBY_523] (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]
+ <-Reducer 150 [SIMPLE_EDGE]
+ SHUFFLE [RS_522]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_525] (rows=348467716 width=135)
+ Group By Operator [GBY_521] (rows=348467716 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
- Select Operator [SEL_523] (rows=348467716 width=135)
+ Select Operator [SEL_519] (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]
+ Merge Join Operator [MERGEJOIN_901] (rows=348467716 width=135)
+ Conds:RS_516._col1=RS_517._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 153 [SIMPLE_EDGE]
+ SHUFFLE [RS_517]
PartitionCols:_col0
- Select Operator [SEL_516] (rows=462000 width=1436)
+ Select Operator [SEL_512] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_863] (rows=462000 width=1436)
+ Filter Operator [FIL_857] (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)
+ TableScan [TS_510] (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]
+ <-Reducer 149 [SIMPLE_EDGE]
+ SHUFFLE [RS_516]
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]
+ Merge Join Operator [MERGEJOIN_900] (rows=316788826 width=135)
+ Conds:RS_513._col0=RS_514._col0(Inner),Output:["_col1"]
+ <-Map 148 [SIMPLE_EDGE]
+ SHUFFLE [RS_513]
PartitionCols:_col0
- Select Operator [SEL_510] (rows=287989836 width=135)
+ Select Operator [SEL_506] (rows=287989836 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_861] (rows=287989836 width=135)
+ Filter Operator [FIL_855] (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)
+ TableScan [TS_504] (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]
+ <-Map 152 [SIMPLE_EDGE]
+ SHUFFLE [RS_514]
PartitionCols:_col0
- Select Operator [SEL_513] (rows=8116 width=1119)
+ Select Operator [SEL_509] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_862] (rows=8116 width=1119)
+ Filter Operator [FIL_856] (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)
+ TableScan [TS_507] (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]
+ <-Reducer 157 [CONTAINS]
+ Reduce Output Operator [RS_550]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_553] (rows=609832849 width=108)
+ Group By Operator [GBY_549] (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)
+ Group By Operator [GBY_545] (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]
+ <-Reducer 156 [SIMPLE_EDGE]
+ SHUFFLE [RS_544]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_547] (rows=174243235 width=135)
+ Group By Operator [GBY_543] (rows=174243235 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(1)"],keys:_col0, _col1, _col2
- Select Operator [SEL_545] (rows=174243235 width=135)
+ Select Operator [SEL_541] (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]
+ Merge Join Operator [MERGEJOIN_903] (rows=174243235 width=135)
+ Conds:RS_538._col1=RS_539._col0(Inner),Output:["_col5","_col6","_col7"]
+ <-Map 159 [SIMPLE_EDGE]
+ SHUFFLE [RS_539]
PartitionCols:_col0
- Select Operator [SEL_538] (rows=462000 width=1436)
+ Select Operator [SEL_534] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_866] (rows=462000 width=1436)
+ 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_536] (rows=462000 width=1436)
+ TableScan [TS_532] (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]
+ <-Reducer 155 [SIMPLE_EDGE]
+ SHUFFLE [RS_538]
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]
+ Merge Join Operator [MERGEJOIN_902] (rows=158402938 width=135)
+ Conds:RS_535._col0=RS_536._col0(Inner),Output:["_col1"]
+ <-Map 154 [SIMPLE_EDGE]
+ SHUFFLE [RS_535]
PartitionCols:_col0
- Select Operator [SEL_532] (rows=144002668 width=135)
+ Select Operator [SEL_528] (rows=144002668 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_864] (rows=144002668 width=135)
+ Filter Operator [FIL_858] (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)
+ TableScan [TS_526] (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]
+ <-Map 158 [SIMPLE_EDGE]
+ SHUFFLE [RS_536]
PartitionCols:_col0
- Select Operator [SEL_535] (rows=8116 width=1119)
+ Select Operator [SEL_531] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_865] (rows=8116 width=1119)
+ Filter Operator [FIL_859] (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)
+ TableScan [TS_529] (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]
+ <-Reducer 5 [CONTAINS]
+ Reduce Output Operator [RS_584]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_589] (rows=2032776160 width=406)
+ Group By Operator [GBY_583] (rows=2032776160 width=405)
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)
+ Select Operator [SEL_192] (rows=232318249 width=385)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_193] (rows=232318249 width=386)
+ Filter Operator [FIL_191] (rows=232318249 width=385)
predicate:(_col5 > _col1)
- Merge Join Operator [MERGEJOIN_913] (rows=696954748 width=386)
-
<TRUNCATED>