You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kg...@apache.org on 2018/06/11 06:35:21 UTC
[07/14] hive git commit: HIVE-19237: Only use an operatorId once in a
plan (Zoltan Haindrich reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/perf/tez/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query14.q.out b/ql/src/test/results/clientpositive/perf/tez/query14.q.out
index 6366d14..4d27064 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query14.q.out
@@ -1,6 +1,6 @@
-Warning: Shuffle Join MERGEJOIN[893][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
-Warning: Shuffle Join MERGEJOIN[894][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
-Warning: Shuffle Join MERGEJOIN[895][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product
+Warning: Shuffle Join MERGEJOIN[902][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
+Warning: Shuffle Join MERGEJOIN[914][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
+Warning: Shuffle Join MERGEJOIN[926][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product
PREHOOK: query: explain
with cross_items as
(select i_item_sk ss_item_sk
@@ -281,203 +281,203 @@ Stage-0
limit:100
Stage-1
Reducer 8 vectorized
- File Output Operator [FS_972]
- Limit [LIM_971] (rows=100 width=237)
+ File Output Operator [FS_1134]
+ Limit [LIM_1133] (rows=100 width=237)
Number of rows:100
- Select Operator [SEL_970] (rows=1016388080 width=237)
+ Select Operator [SEL_1132] (rows=1016388080 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Reducer 7 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_969]
- Select Operator [SEL_968] (rows=1016388080 width=237)
+ SHUFFLE [RS_1131]
+ Select Operator [SEL_1130] (rows=1016388080 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Group By Operator [GBY_967] (rows=1016388080 width=237)
+ Group By Operator [GBY_1129] (rows=1016388080 width=237)
Output:["_col0","_col1","_col2","_col3","_col5","_col6"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
<-Union 6 [SIMPLE_EDGE]
<-Reducer 12 [CONTAINS]
- Reduce Output Operator [RS_571]
+ Reduce Output Operator [RS_919]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_570] (rows=2032776160 width=237)
+ Group By Operator [GBY_918] (rows=2032776160 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0L
- Select Operator [SEL_377] (rows=116155905 width=264)
+ Select Operator [SEL_916] (rows=116155905 width=264)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_376] (rows=116155905 width=264)
+ Filter Operator [FIL_915] (rows=116155905 width=264)
predicate:(_col5 > _col1)
- Merge Join Operator [MERGEJOIN_894] (rows=348467716 width=264)
+ Merge Join Operator [MERGEJOIN_914] (rows=348467716 width=264)
Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
<-Reducer 11 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_978]
- Select Operator [SEL_977] (rows=1 width=8)
- Filter Operator [FIL_976] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_1140]
+ Select Operator [SEL_1139] (rows=1 width=8)
+ Filter Operator [FIL_1138] (rows=1 width=8)
predicate:(sq_count_check(_col0) <= 1)
- Group By Operator [GBY_975] (rows=1 width=8)
+ Group By Operator [GBY_1137] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_974] (rows=1 width=8)
- Group By Operator [GBY_973] (rows=1 width=8)
+ Select Operator [SEL_1136] (rows=1 width=8)
+ Group By Operator [GBY_1135] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Union 10 [CUSTOM_SIMPLE_EDGE]
<-Reducer 19 [CONTAINS]
- Reduce Output Operator [RS_223]
- Group By Operator [GBY_222] (rows=1 width=8)
+ Reduce Output Operator [RS_943]
+ Group By Operator [GBY_942] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_220] (rows=1108786976 width=108)
+ Select Operator [SEL_941] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_208] (rows=316788826 width=135)
+ Select Operator [SEL_939] (rows=316788826 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_864] (rows=316788826 width=135)
- Conds:RS_1016._col0=RS_1022._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_938] (rows=316788826 width=135)
+ Conds:RS_1178._col0=RS_1184._col0(Inner),Output:["_col1"]
<-Map 21 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1022]
+ SHUFFLE [RS_1184]
PartitionCols:_col0
- Select Operator [SEL_1019] (rows=8116 width=1119)
+ Select Operator [SEL_1181] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_1018] (rows=8116 width=1119)
+ Filter Operator [FIL_1180] (rows=8116 width=1119)
predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000)
TableScan [TS_13] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 17 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1016]
+ SHUFFLE [RS_1178]
PartitionCols:_col0
- Select Operator [SEL_1014] (rows=287989836 width=135)
+ Select Operator [SEL_1176] (rows=287989836 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_1013] (rows=287989836 width=135)
+ Filter Operator [FIL_1175] (rows=287989836 width=135)
predicate:cs_sold_date_sk is not null
TableScan [TS_10] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_quantity"]
<-Reducer 33 [CONTAINS]
- Reduce Output Operator [RS_223]
- Group By Operator [GBY_222] (rows=1 width=8)
+ Reduce Output Operator [RS_979]
+ Group By Operator [GBY_978] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_220] (rows=1108786976 width=108)
+ Select Operator [SEL_977] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_219] (rows=158402938 width=135)
+ Select Operator [SEL_975] (rows=158402938 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_865] (rows=158402938 width=135)
- Conds:RS_1034._col0=RS_1040._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_974] (rows=158402938 width=135)
+ Conds:RS_1196._col0=RS_1202._col0(Inner),Output:["_col1"]
<-Map 35 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1040]
+ SHUFFLE [RS_1202]
PartitionCols:_col0
- Select Operator [SEL_1037] (rows=8116 width=1119)
+ Select Operator [SEL_1199] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_1036] (rows=8116 width=1119)
+ Filter Operator [FIL_1198] (rows=8116 width=1119)
predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000)
TableScan [TS_24] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 31 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1034]
+ SHUFFLE [RS_1196]
PartitionCols:_col0
- Select Operator [SEL_1032] (rows=144002668 width=135)
+ Select Operator [SEL_1194] (rows=144002668 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_1031] (rows=144002668 width=135)
+ Filter Operator [FIL_1193] (rows=144002668 width=135)
predicate:ws_sold_date_sk is not null
TableScan [TS_21] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity"]
<-Reducer 9 [CONTAINS]
- Reduce Output Operator [RS_223]
- Group By Operator [GBY_222] (rows=1 width=8)
+ Reduce Output Operator [RS_913]
+ Group By Operator [GBY_912] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_220] (rows=1108786976 width=108)
+ Select Operator [SEL_911] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_198] (rows=633595212 width=88)
+ Select Operator [SEL_909] (rows=633595212 width=88)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_863] (rows=633595212 width=88)
- Conds:RS_899._col0=RS_908._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_908] (rows=633595212 width=88)
+ Conds:RS_1061._col0=RS_1070._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_908]
+ SHUFFLE [RS_1070]
PartitionCols:_col0
- Select Operator [SEL_902] (rows=8116 width=1119)
+ Select Operator [SEL_1064] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_901] (rows=8116 width=1119)
+ Filter Operator [FIL_1063] (rows=8116 width=1119)
predicate:(d_date_sk is not null and d_year BETWEEN 1999 AND 2001)
TableScan [TS_97] (rows=73049 width=1119)
default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 1 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_899]
+ SHUFFLE [RS_1061]
PartitionCols:_col0
- Select Operator [SEL_897] (rows=575995635 width=88)
+ Select Operator [SEL_1059] (rows=575995635 width=88)
Output:["_col0","_col1"]
- Filter Operator [FIL_896] (rows=575995635 width=88)
+ Filter Operator [FIL_1058] (rows=575995635 width=88)
predicate:ss_sold_date_sk is not null
TableScan [TS_0] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
<-Reducer 27 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_981]
- Select Operator [SEL_980] (rows=1 width=120)
+ PARTITION_ONLY_SHUFFLE [RS_1143]
+ Select Operator [SEL_1142] (rows=1 width=120)
Output:["_col0"]
- Group By Operator [GBY_979] (rows=1 width=120)
+ Group By Operator [GBY_1141] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"]
<-Union 26 [CUSTOM_SIMPLE_EDGE]
<-Reducer 25 [CONTAINS]
- Reduce Output Operator [RS_268]
- Group By Operator [GBY_267] (rows=1 width=120)
+ Reduce Output Operator [RS_961]
+ Group By Operator [GBY_960] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_265] (rows=1108786976 width=108)
+ Select Operator [SEL_959] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_253] (rows=316788826 width=135)
+ Select Operator [SEL_957] (rows=316788826 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_867] (rows=316788826 width=135)
- Conds:RS_1029._col0=RS_1023._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_956] (rows=316788826 width=135)
+ Conds:RS_1191._col0=RS_1185._col0(Inner),Output:["_col1","_col2"]
<-Map 21 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1023]
+ SHUFFLE [RS_1185]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1019]
+ Please refer to the previous Select Operator [SEL_1181]
<-Map 43 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1029]
+ SHUFFLE [RS_1191]
PartitionCols:_col0
- Select Operator [SEL_1027] (rows=287989836 width=135)
+ Select Operator [SEL_1189] (rows=287989836 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_1026] (rows=287989836 width=135)
+ Filter Operator [FIL_1188] (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"]
<-Reducer 37 [CONTAINS]
- Reduce Output Operator [RS_268]
- Group By Operator [GBY_267] (rows=1 width=120)
+ Reduce Output Operator [RS_997]
+ Group By Operator [GBY_996] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_265] (rows=1108786976 width=108)
+ Select Operator [SEL_995] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_264] (rows=158402938 width=135)
+ Select Operator [SEL_993] (rows=158402938 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_868] (rows=158402938 width=135)
- Conds:RS_1047._col0=RS_1041._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_992] (rows=158402938 width=135)
+ Conds:RS_1209._col0=RS_1203._col0(Inner),Output:["_col1","_col2"]
<-Map 35 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1041]
+ SHUFFLE [RS_1203]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1037]
+ Please refer to the previous Select Operator [SEL_1199]
<-Map 44 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1047]
+ SHUFFLE [RS_1209]
PartitionCols:_col0
- Select Operator [SEL_1045] (rows=144002668 width=135)
+ Select Operator [SEL_1207] (rows=144002668 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_1044] (rows=144002668 width=135)
+ Filter Operator [FIL_1206] (rows=144002668 width=135)
predicate:ws_sold_date_sk is not null
TableScan [TS_66] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_quantity","ws_list_price"]
<-Reducer 41 [CONTAINS]
- Reduce Output Operator [RS_268]
- Group By Operator [GBY_267] (rows=1 width=120)
+ Reduce Output Operator [RS_1015]
+ Group By Operator [GBY_1014] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_265] (rows=1108786976 width=108)
+ Select Operator [SEL_1013] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_243] (rows=633595212 width=88)
+ Select Operator [SEL_1011] (rows=633595212 width=88)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_866] (rows=633595212 width=88)
- Conds:RS_1052._col0=RS_909._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_1010] (rows=633595212 width=88)
+ Conds:RS_1214._col0=RS_1071._col0(Inner),Output:["_col1","_col2"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_909]
+ SHUFFLE [RS_1071]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_902]
+ Please refer to the previous Select Operator [SEL_1064]
<-Map 39 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1052]
+ SHUFFLE [RS_1214]
PartitionCols:_col0
- Select Operator [SEL_1050] (rows=575995635 width=88)
+ Select Operator [SEL_1212] (rows=575995635 width=88)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_1049] (rows=575995635 width=88)
+ Filter Operator [FIL_1211] (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"]
<-Reducer 52 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_992]
- Group By Operator [GBY_991] (rows=348467716 width=135)
+ PARTITION_ONLY_SHUFFLE [RS_1154]
+ Group By Operator [GBY_1153] (rows=348467716 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 51 [SIMPLE_EDGE]
SHUFFLE [RS_369]
@@ -487,13 +487,13 @@ Stage-0
Select Operator [SEL_366] (rows=696935432 width=135)
Output:["_col0","_col1","_col2","_col3"]
Merge Join Operator [MERGEJOIN_877] (rows=696935432 width=135)
- Conds:RS_362._col1=RS_956._col0(Inner),RS_362._col1=RS_990._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ Conds:RS_362._col1=RS_1118._col0(Inner),RS_362._col1=RS_1152._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_956]
+ SHUFFLE [RS_1118]
PartitionCols:_col0
- Select Operator [SEL_944] (rows=462000 width=1436)
+ Select Operator [SEL_1106] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_935] (rows=462000 width=1436)
+ Filter Operator [FIL_1097] (rows=462000 width=1436)
predicate:i_item_sk is not null
TableScan [TS_91] (rows=462000 width=1436)
default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id"]
@@ -501,29 +501,29 @@ Stage-0
SHUFFLE [RS_362]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_869] (rows=316788826 width=135)
- Conds:RS_984._col0=RS_927._col0(Inner),Output:["_col1","_col2","_col3"]
+ Conds:RS_1146._col0=RS_1089._col0(Inner),Output:["_col1","_col2","_col3"]
<-Map 49 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_927]
+ SHUFFLE [RS_1089]
PartitionCols:_col0
- Select Operator [SEL_925] (rows=18262 width=1119)
+ Select Operator [SEL_1087] (rows=18262 width=1119)
Output:["_col0"]
- Filter Operator [FIL_924] (rows=18262 width=1119)
+ Filter Operator [FIL_1086] (rows=18262 width=1119)
predicate:((d_moy = 11) and (d_year = 2000) and d_date_sk is not null)
TableScan [TS_85] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 91 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_984]
+ SHUFFLE [RS_1146]
PartitionCols:_col0
- Select Operator [SEL_983] (rows=287989836 width=135)
+ Select Operator [SEL_1145] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_982] (rows=287989836 width=135)
+ Filter Operator [FIL_1144] (rows=287989836 width=135)
predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
TableScan [TS_271] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk","cs_quantity","cs_list_price"]
<-Reducer 68 [ONE_TO_ONE_EDGE] vectorized
- FORWARD [RS_990]
+ FORWARD [RS_1152]
PartitionCols:_col0
- Group By Operator [GBY_989] (rows=254100 width=1436)
+ Group By Operator [GBY_1151] (rows=254100 width=1436)
Output:["_col0"],keys:KEY._col0
<-Reducer 67 [SIMPLE_EDGE]
SHUFFLE [RS_356]
@@ -531,31 +531,31 @@ Stage-0
Group By Operator [GBY_355] (rows=508200 width=1436)
Output:["_col0"],keys:_col0
Merge Join Operator [MERGEJOIN_876] (rows=508200 width=1436)
- Conds:RS_952._col1, _col2, _col3=RS_988._col0, _col1, _col2(Inner),Output:["_col0"]
+ Conds:RS_1114._col1, _col2, _col3=RS_1150._col0, _col1, _col2(Inner),Output:["_col0"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_952]
+ SHUFFLE [RS_1114]
PartitionCols:_col1, _col2, _col3
- Select Operator [SEL_940] (rows=462000 width=1436)
+ Select Operator [SEL_1102] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_931] (rows=462000 width=1436)
+ Filter Operator [FIL_1093] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_91]
<-Reducer 72 [ONE_TO_ONE_EDGE] vectorized
- FORWARD [RS_988]
+ FORWARD [RS_1150]
PartitionCols:_col0, _col1, _col2
- Select Operator [SEL_987] (rows=1 width=108)
+ Select Operator [SEL_1149] (rows=1 width=108)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_986] (rows=1 width=108)
+ Filter Operator [FIL_1148] (rows=1 width=108)
predicate:(_col3 = 3L)
- Group By Operator [GBY_985] (rows=304916424 width=108)
+ Group By Operator [GBY_1147] (rows=304916424 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Union 71 [SIMPLE_EDGE]
<-Reducer 70 [CONTAINS] vectorized
- Reduce Output Operator [RS_1074]
+ Reduce Output Operator [RS_1236]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_1073] (rows=609832849 width=108)
+ Group By Operator [GBY_1235] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_1072] (rows=348477374 width=88)
+ Group By Operator [GBY_1234] (rows=348477374 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 69 [SIMPLE_EDGE]
SHUFFLE [RS_300]
@@ -563,39 +563,39 @@ Stage-0
Group By Operator [GBY_299] (rows=696954748 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7
Merge Join Operator [MERGEJOIN_871] (rows=696954748 width=88)
- Conds:RS_295._col1=RS_953._col0(Inner),Output:["_col5","_col6","_col7"]
+ Conds:RS_295._col1=RS_1115._col0(Inner),Output:["_col5","_col6","_col7"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_953]
+ SHUFFLE [RS_1115]
PartitionCols:_col0
- Select Operator [SEL_941] (rows=462000 width=1436)
+ Select Operator [SEL_1103] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_932] (rows=462000 width=1436)
+ Filter Operator [FIL_1094] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_91]
<-Reducer 85 [SIMPLE_EDGE]
SHUFFLE [RS_295]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_855] (rows=633595212 width=88)
- Conds:RS_1056._col0=RS_903._col0(Inner),Output:["_col1"]
+ Conds:RS_1218._col0=RS_1065._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_903]
+ SHUFFLE [RS_1065]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_902]
+ Please refer to the previous Select Operator [SEL_1064]
<-Map 84 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1056]
+ SHUFFLE [RS_1218]
PartitionCols:_col0
- Select Operator [SEL_1055] (rows=575995635 width=88)
+ Select Operator [SEL_1217] (rows=575995635 width=88)
Output:["_col0","_col1"]
- Filter Operator [FIL_1054] (rows=575995635 width=88)
+ Filter Operator [FIL_1216] (rows=575995635 width=88)
predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
TableScan [TS_94] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"]
<-Reducer 79 [CONTAINS] vectorized
- Reduce Output Operator [RS_1080]
+ Reduce Output Operator [RS_1242]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_1079] (rows=609832849 width=108)
+ Group By Operator [GBY_1241] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_1078] (rows=174233858 width=135)
+ Group By Operator [GBY_1240] (rows=174233858 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 78 [SIMPLE_EDGE]
SHUFFLE [RS_320]
@@ -603,39 +603,39 @@ Stage-0
Group By Operator [GBY_319] (rows=348467716 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7
Merge Join Operator [MERGEJOIN_873] (rows=348467716 width=135)
- Conds:RS_315._col1=RS_954._col0(Inner),Output:["_col5","_col6","_col7"]
+ Conds:RS_315._col1=RS_1116._col0(Inner),Output:["_col5","_col6","_col7"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_954]
+ SHUFFLE [RS_1116]
PartitionCols:_col0
- Select Operator [SEL_942] (rows=462000 width=1436)
+ Select Operator [SEL_1104] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_933] (rows=462000 width=1436)
+ Filter Operator [FIL_1095] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_91]
<-Reducer 87 [SIMPLE_EDGE]
SHUFFLE [RS_315]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_857] (rows=316788826 width=135)
- Conds:RS_1062._col0=RS_904._col0(Inner),Output:["_col1"]
+ Conds:RS_1224._col0=RS_1066._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_904]
+ SHUFFLE [RS_1066]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_902]
+ Please refer to the previous Select Operator [SEL_1064]
<-Map 89 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1062]
+ SHUFFLE [RS_1224]
PartitionCols:_col0
- Select Operator [SEL_1061] (rows=287989836 width=135)
+ Select Operator [SEL_1223] (rows=287989836 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_1060] (rows=287989836 width=135)
+ Filter Operator [FIL_1222] (rows=287989836 width=135)
predicate:(cs_item_sk is not null and cs_sold_date_sk is not null)
TableScan [TS_114] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk"]
<-Reducer 82 [CONTAINS] vectorized
- Reduce Output Operator [RS_1086]
+ Reduce Output Operator [RS_1248]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_1085] (rows=609832849 width=108)
+ Group By Operator [GBY_1247] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_1084] (rows=87121617 width=135)
+ Group By Operator [GBY_1246] (rows=87121617 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 81 [SIMPLE_EDGE]
SHUFFLE [RS_341]
@@ -643,173 +643,173 @@ Stage-0
Group By Operator [GBY_340] (rows=174243235 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count()"],keys:_col5, _col6, _col7
Merge Join Operator [MERGEJOIN_875] (rows=174243235 width=135)
- Conds:RS_336._col1=RS_955._col0(Inner),Output:["_col5","_col6","_col7"]
+ Conds:RS_336._col1=RS_1117._col0(Inner),Output:["_col5","_col6","_col7"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_955]
+ SHUFFLE [RS_1117]
PartitionCols:_col0
- Select Operator [SEL_943] (rows=462000 width=1436)
+ Select Operator [SEL_1105] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_934] (rows=462000 width=1436)
+ Filter Operator [FIL_1096] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_91]
<-Reducer 88 [SIMPLE_EDGE]
SHUFFLE [RS_336]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_859] (rows=158402938 width=135)
- Conds:RS_1068._col0=RS_905._col0(Inner),Output:["_col1"]
+ Conds:RS_1230._col0=RS_1067._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_905]
+ SHUFFLE [RS_1067]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_902]
+ Please refer to the previous Select Operator [SEL_1064]
<-Map 90 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1068]
+ SHUFFLE [RS_1230]
PartitionCols:_col0
- Select Operator [SEL_1067] (rows=144002668 width=135)
+ Select Operator [SEL_1229] (rows=144002668 width=135)
Output:["_col0","_col1"]
- Filter Operator [FIL_1066] (rows=144002668 width=135)
+ Filter Operator [FIL_1228] (rows=144002668 width=135)
predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
TableScan [TS_135] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk"]
<-Reducer 16 [CONTAINS]
- Reduce Output Operator [RS_571]
+ Reduce Output Operator [RS_931]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_570] (rows=2032776160 width=237)
+ Group By Operator [GBY_930] (rows=2032776160 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0L
- Select Operator [SEL_567] (rows=58081078 width=264)
+ Select Operator [SEL_928] (rows=58081078 width=264)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_566] (rows=58081078 width=264)
+ Filter Operator [FIL_927] (rows=58081078 width=264)
predicate:(_col5 > _col1)
- Merge Join Operator [MERGEJOIN_895] (rows=174243235 width=264)
+ Merge Join Operator [MERGEJOIN_926] (rows=174243235 width=264)
Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
<-Reducer 15 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_998]
- Select Operator [SEL_997] (rows=1 width=8)
- Filter Operator [FIL_996] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_1160]
+ Select Operator [SEL_1159] (rows=1 width=8)
+ Filter Operator [FIL_1158] (rows=1 width=8)
predicate:(sq_count_check(_col0) <= 1)
- Group By Operator [GBY_995] (rows=1 width=8)
+ Group By Operator [GBY_1157] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_994] (rows=1 width=8)
- Group By Operator [GBY_993] (rows=1 width=8)
+ Select Operator [SEL_1156] (rows=1 width=8)
+ Group By Operator [GBY_1155] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Union 14 [CUSTOM_SIMPLE_EDGE]
<-Reducer 13 [CONTAINS]
- Reduce Output Operator [RS_413]
- Group By Operator [GBY_412] (rows=1 width=8)
+ Reduce Output Operator [RS_925]
+ Group By Operator [GBY_924] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_410] (rows=1108786976 width=108)
+ Select Operator [SEL_923] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_388] (rows=633595212 width=88)
+ Select Operator [SEL_921] (rows=633595212 width=88)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_878] (rows=633595212 width=88)
- Conds:RS_900._col0=RS_910._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_920] (rows=633595212 width=88)
+ Conds:RS_1062._col0=RS_1072._col0(Inner),Output:["_col1"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_910]
+ SHUFFLE [RS_1072]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_902]
+ Please refer to the previous Select Operator [SEL_1064]
<-Map 1 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_900]
+ SHUFFLE [RS_1062]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_897]
+ Please refer to the previous Select Operator [SEL_1059]
<-Reducer 20 [CONTAINS]
- Reduce Output Operator [RS_413]
- Group By Operator [GBY_412] (rows=1 width=8)
+ Reduce Output Operator [RS_949]
+ Group By Operator [GBY_948] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_410] (rows=1108786976 width=108)
+ Select Operator [SEL_947] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_398] (rows=316788826 width=135)
+ Select Operator [SEL_945] (rows=316788826 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_879] (rows=316788826 width=135)
- Conds:RS_1017._col0=RS_1024._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_944] (rows=316788826 width=135)
+ Conds:RS_1179._col0=RS_1186._col0(Inner),Output:["_col1"]
<-Map 21 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1024]
+ SHUFFLE [RS_1186]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1019]
+ Please refer to the previous Select Operator [SEL_1181]
<-Map 17 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1017]
+ SHUFFLE [RS_1179]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1014]
+ Please refer to the previous Select Operator [SEL_1176]
<-Reducer 34 [CONTAINS]
- Reduce Output Operator [RS_413]
- Group By Operator [GBY_412] (rows=1 width=8)
+ Reduce Output Operator [RS_985]
+ Group By Operator [GBY_984] (rows=1 width=8)
Output:["_col0"],aggregations:["count(_col0)"]
- Select Operator [SEL_410] (rows=1108786976 width=108)
+ Select Operator [SEL_983] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_409] (rows=158402938 width=135)
+ Select Operator [SEL_981] (rows=158402938 width=135)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_880] (rows=158402938 width=135)
- Conds:RS_1035._col0=RS_1042._col0(Inner),Output:["_col1"]
+ Merge Join Operator [MERGEJOIN_980] (rows=158402938 width=135)
+ Conds:RS_1197._col0=RS_1204._col0(Inner),Output:["_col1"]
<-Map 35 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1042]
+ SHUFFLE [RS_1204]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1037]
+ Please refer to the previous Select Operator [SEL_1199]
<-Map 31 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1035]
+ SHUFFLE [RS_1197]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1032]
+ Please refer to the previous Select Operator [SEL_1194]
<-Reducer 30 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_1001]
- Select Operator [SEL_1000] (rows=1 width=120)
+ PARTITION_ONLY_SHUFFLE [RS_1163]
+ Select Operator [SEL_1162] (rows=1 width=120)
Output:["_col0"]
- Group By Operator [GBY_999] (rows=1 width=120)
+ Group By Operator [GBY_1161] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"]
<-Union 29 [CUSTOM_SIMPLE_EDGE]
<-Reducer 28 [CONTAINS]
- Reduce Output Operator [RS_458]
- Group By Operator [GBY_457] (rows=1 width=120)
+ Reduce Output Operator [RS_967]
+ Group By Operator [GBY_966] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_455] (rows=1108786976 width=108)
+ Select Operator [SEL_965] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_443] (rows=316788826 width=135)
+ Select Operator [SEL_963] (rows=316788826 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_882] (rows=316788826 width=135)
- Conds:RS_1030._col0=RS_1025._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_962] (rows=316788826 width=135)
+ Conds:RS_1192._col0=RS_1187._col0(Inner),Output:["_col1","_col2"]
<-Map 21 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1025]
+ SHUFFLE [RS_1187]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1019]
+ Please refer to the previous Select Operator [SEL_1181]
<-Map 43 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1030]
+ SHUFFLE [RS_1192]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1027]
+ Please refer to the previous Select Operator [SEL_1189]
<-Reducer 38 [CONTAINS]
- Reduce Output Operator [RS_458]
- Group By Operator [GBY_457] (rows=1 width=120)
+ Reduce Output Operator [RS_1003]
+ Group By Operator [GBY_1002] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_455] (rows=1108786976 width=108)
+ Select Operator [SEL_1001] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_454] (rows=158402938 width=135)
+ Select Operator [SEL_999] (rows=158402938 width=135)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_883] (rows=158402938 width=135)
- Conds:RS_1048._col0=RS_1043._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_998] (rows=158402938 width=135)
+ Conds:RS_1210._col0=RS_1205._col0(Inner),Output:["_col1","_col2"]
<-Map 35 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1043]
+ SHUFFLE [RS_1205]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1037]
+ Please refer to the previous Select Operator [SEL_1199]
<-Map 44 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1048]
+ SHUFFLE [RS_1210]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1045]
+ Please refer to the previous Select Operator [SEL_1207]
<-Reducer 42 [CONTAINS]
- Reduce Output Operator [RS_458]
- Group By Operator [GBY_457] (rows=1 width=120)
+ Reduce Output Operator [RS_1021]
+ Group By Operator [GBY_1020] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_455] (rows=1108786976 width=108)
+ Select Operator [SEL_1019] (rows=1108786976 width=108)
Output:["_col0"]
- Select Operator [SEL_433] (rows=633595212 width=88)
+ Select Operator [SEL_1017] (rows=633595212 width=88)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_881] (rows=633595212 width=88)
- Conds:RS_1053._col0=RS_911._col0(Inner),Output:["_col1","_col2"]
+ Merge Join Operator [MERGEJOIN_1016] (rows=633595212 width=88)
+ Conds:RS_1215._col0=RS_1073._col0(Inner),Output:["_col1","_col2"]
<-Map 86 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_911]
+ SHUFFLE [RS_1073]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_902]
+ Please refer to the previous Select Operator [SEL_1064]
<-Map 39 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1053]
+ SHUFFLE [RS_1215]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_1050]
+ Please refer to the previous Select Operator [SEL_1212]
<-Reducer 55 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_1012]
- Group By Operator [GBY_1011] (rows=174243235 width=135)
+ PARTITION_ONLY_SHUFFLE [RS_1174]
+ Group By Operator [GBY_1173] (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 54 [SIMPLE_EDGE]
SHUFFLE [RS_559]
@@ -819,37 +819,37 @@ Stage-0
Select Operator [SEL_556] (rows=348486471 width=135)
Output:["_col0","_col1","_col2","_col3"]
Merge Join Operator [MERGEJOIN_892] (rows=348486471 width=135)
- Conds:RS_552._col1=RS_958._col0(Inner),RS_552._col1=RS_1010._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
+ Conds:RS_552._col1=RS_1120._col0(Inner),RS_552._col1=RS_1172._col0(Inner),Output:["_col2","_col3","_col8","_col9","_col10"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_958]
+ SHUFFLE [RS_1120]
PartitionCols:_col0
- Select Operator [SEL_946] (rows=462000 width=1436)
+ Select Operator [SEL_1108] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_937] (rows=462000 width=1436)
+ Filter Operator [FIL_1099] (rows=462000 width=1436)
predicate:i_item_sk is not null
Please refer to the previous TableScan [TS_91]
<-Reducer 53 [SIMPLE_EDGE]
SHUFFLE [RS_552]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_884] (rows=158402938 width=135)
- Conds:RS_1004._col0=RS_928._col0(Inner),Output:["_col1","_col2","_col3"]
+ Conds:RS_1166._col0=RS_1090._col0(Inner),Output:["_col1","_col2","_col3"]
<-Map 49 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_928]
+ SHUFFLE [RS_1090]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_925]
+ Please refer to the previous Select Operator [SEL_1087]
<-Map 92 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_1004]
+ SHUFFLE [RS_1166]
PartitionCols:_col0
- Select Operator [SEL_1003] (rows=144002668 width=135)
+ Select Operator [SEL_1165] (rows=144002668 width=135)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_1002] (rows=144002668 width=135)
+ Filter Operator [FIL_1164] (rows=144002668 width=135)
predicate:(ws_item_sk is not null and ws_sold_date_sk is not null)
TableScan [TS_461] (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"]
<-Reducer 77 [ONE_TO_ONE_EDGE] vectorized
- FORWARD [RS_1010]
+ FORWARD [RS_1172]
PartitionCols:_col0
- Group By Operator [GBY_1009] (rows=254100 width=1436)
+ Group By Operator [GBY_1171] (rows=254100 width=1436)
Output:["_col0"],keys:KEY._col0
<-Reducer 76 [SIMPLE_EDGE]
SHUFFLE [RS_546]
@@ -857,198 +857,198 @@ Stage-0
Group By Operator [GBY_545] (rows=508200 width=1436)
Output:["_col0"],keys:_col0
Merge Join Operator [MERGEJOIN_891] (rows=508200 width=1436)
- Conds:RS_957._col1, _col2, _col3=RS_1008._col0, _col1, _col2(Inner),Output:["_col0"]
+ Conds:RS_1119._col1, _col2, _col3=RS_1170._col0, _col1, _col2(Inner),Output:["_col0"]
<-Map 56 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_957]
+ SHUFFLE [RS_1119]
PartitionCols:_col1, _col2, _col3
- Select Operator [SEL_945] (rows=462000 width=1436)
+ Select Operator [SEL_1107] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_936] (rows=462000 width=1436)
+ Filter Operator [FIL_1098] (rows=462000 width=1436)
predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_91]
<-Reducer 75 [ONE_TO_ONE_EDGE] vectorized
- FORWARD [RS_1008]
+ FORWARD [RS_1170]
PartitionCols:_col0, _col1, _col2
- Select Operator [SEL_1007] (rows=1 width=108)
+ Select Operator [SEL_1169] (rows=1 width=108)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_1006] (rows=1 width=108)
+ Filter Operator [FIL_1168] (rows=1 width=108)
predicate:(_col3 = 3L)
- Group By Operator [GBY_1005] (rows=304916424 width=108)
+ Group By Operator [GBY_1167] (rows=304916424 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Union 74 [SIMPLE_EDGE]
<-Reducer 73 [CONTAINS] vectorized
- Reduce Output Operator [RS_1077]
+ Reduce Output Operator [RS_1239]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_1076] (rows=609832849 width=108)
+ Group By Operator [GBY_1238] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_1075] (rows=348477374 width=88)
+ Group By Operator [GBY_1237] (rows=348477374 width=88)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 69 [SIMPLE_EDGE]
SHUFFLE [RS_490]
PartitionCols:_col0, _col1, _col2
Please refer to the previous Group By Operator [GBY_299]
<-Reducer 80 [CONTAINS] vectorized
- Reduce Output Operator [RS_1083]
+ Reduce Output Operator [RS_1245]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_1082] (rows=609832849 width=108)
+ Group By Operator [GBY_1244] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_1081] (rows=174233858 width=135)
+ Group By Operator [GBY_1243] (rows=174233858 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 78 [SIMPLE_EDGE]
SHUFFLE [RS_510]
PartitionCols:_col0, _col1, _col2
Please refer to the previous Group By Operator [GBY_319]
<-Reducer 83 [CONTAINS] vectorized
- Reduce Output Operator [RS_1089]
+ Reduce Output Operator [RS_1251]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_1088] (rows=609832849 width=108)
+ Group By Operator [GBY_1250] (rows=609832849 width=108)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(_col3)"],keys:_col0, _col1, _col2
- Group By Operator [GBY_1087] (rows=87121617 width=135)
+ Group By Operator [GBY_1249] (rows=87121617 width=135)
Output:["_col0","_col1","_col2","_col3"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Reducer 81 [SIMPLE_EDGE]
SHUFFLE [RS_531]
PartitionCols:_col0, _col1, _col2
Please refer to the previous Group By Operator [GBY_340]
<-Reducer 5 [CONTAINS]
- Reduce Output Operator [RS_571]
+ Reduce Output Operator [RS_907]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_570] (rows=2032776160 width=237)
+ Group By Operator [GBY_906] (rows=2032776160 width=237)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col4)","sum(_col5)"],keys:_col0, _col1, _col2, _col3, 0L
- Select Operator [SEL_188] (rows=232318249 width=217)
+ Select Operator [SEL_904] (rows=232318249 width=217)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_187] (rows=232318249 width=217)
+ Filter Operator [FIL_903] (rows=232318249 width=217)
predicate:(_col5 > _col1)
- Merge Join Operator [MERGEJOIN_893] (rows=696954748 width=217)
+ Merge Join Operator [MERGEJOIN_902] (rows=696954748 width=217)
Conds:(Inner),(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
<-Reducer 24 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_920]
- Select Operator [SEL_919] (rows=1 width=120)
+ PARTITION_ONLY_SHUFFLE [RS_1082]
+ Select Operator [SEL_1081] (rows=1 width=120)
Output:["_col0"]
- Group By Operator [GBY_918] (rows=1 width=120)
+ Group By Operator [GBY_1080] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"]
<-Union 23 [CUSTOM_SIMPLE_EDGE]
<-Reducer 22 [CONTAINS]
- Reduce Output Operator [RS_79]
- Group By Operator [GBY_78] (rows=1 width=120)
+ Reduce Output Operator [RS_955]
+ Group By Operator [GBY_954] (rows=1 width=120)
Output:["_col0","_col1"],aggregations:["sum(_col0)","count(_col0)"]
- Select Operator [SEL_76] (rows=1108786976 width=108)
+ Select Operator [SEL_953] (rows=11
<TRUNCATED>