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:19 UTC
[05/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/query49.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query49.q.out b/ql/src/test/results/clientpositive/perf/tez/query49.q.out
index 3a9c640..47f37a2 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query49.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query49.q.out
@@ -277,44 +277,44 @@ Stage-0
limit:100
Stage-1
Reducer 11 vectorized
- File Output Operator [FS_179]
- Limit [LIM_178] (rows=100 width=101)
+ File Output Operator [FS_205]
+ Limit [LIM_204] (rows=100 width=101)
Number of rows:100
- Select Operator [SEL_177] (rows=5915494 width=101)
+ Select Operator [SEL_203] (rows=5915494 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Reducer 10 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_176]
- Select Operator [SEL_175] (rows=5915494 width=101)
+ SHUFFLE [RS_202]
+ Select Operator [SEL_201] (rows=5915494 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Group By Operator [GBY_174] (rows=5915494 width=101)
+ Group By Operator [GBY_200] (rows=5915494 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
<-Union 9 [SIMPLE_EDGE]
<-Reducer 22 [CONTAINS] vectorized
- Reduce Output Operator [RS_215]
+ Reduce Output Operator [RS_241]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_214] (rows=11830988 width=101)
+ Group By Operator [GBY_240] (rows=11830988 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"],keys:_col0, _col3, _col4, _col1, _col2
- Select Operator [SEL_213] (rows=8604378 width=88)
+ Select Operator [SEL_239] (rows=8604378 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_212] (rows=8604378 width=88)
+ Filter Operator [FIL_238] (rows=8604378 width=88)
predicate:((_col0 <= 10) or (rank_window_1 <= 10))
- PTF Operator [PTF_211] (rows=12906568 width=88)
+ PTF Operator [PTF_237] (rows=12906568 width=88)
Function definitions:[{},{"name:":"windowingtablefunction","order by:":"(CAST( _col4 AS decimal(15,4)) / CAST( _col5 AS decimal(15,4))) ASC NULLS FIRST","partition by:":"0"}]
- Select Operator [SEL_210] (rows=12906568 width=88)
+ Select Operator [SEL_236] (rows=12906568 width=88)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Reducer 21 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_209]
+ SHUFFLE [RS_235]
PartitionCols:0
- Select Operator [SEL_208] (rows=12906568 width=88)
+ Select Operator [SEL_234] (rows=12906568 width=88)
Output:["rank_window_0","_col0","_col1","_col2","_col3","_col4"]
- PTF Operator [PTF_207] (rows=12906568 width=88)
+ PTF Operator [PTF_233] (rows=12906568 width=88)
Function definitions:[{},{"name:":"windowingtablefunction","order by:":"(CAST( _col1 AS decimal(15,4)) / CAST( _col2 AS decimal(15,4))) ASC NULLS FIRST","partition by:":"0"}]
- Select Operator [SEL_206] (rows=12906568 width=88)
+ Select Operator [SEL_232] (rows=12906568 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Reducer 20 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_205]
+ SHUFFLE [RS_231]
PartitionCols:0
- Group By Operator [GBY_204] (rows=12906568 width=88)
+ Group By Operator [GBY_230] (rows=12906568 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)","sum(VALUE._col3)"],keys:KEY._col0
<-Reducer 19 [SIMPLE_EDGE]
SHUFFLE [RS_89]
@@ -324,13 +324,13 @@ Stage-0
Select Operator [SEL_86] (rows=25813137 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"]
Merge Join Operator [MERGEJOIN_146] (rows=25813137 width=88)
- Conds:RS_83._col1, _col2=RS_203._col0, _col1(Inner),Output:["_col1","_col3","_col4","_col11","_col12"]
+ Conds:RS_83._col1, _col2=RS_229._col0, _col1(Inner),Output:["_col1","_col3","_col4","_col11","_col12"]
<-Map 27 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_203]
+ SHUFFLE [RS_229]
PartitionCols:_col0, _col1
- Select Operator [SEL_202] (rows=19197050 width=77)
+ Select Operator [SEL_228] (rows=19197050 width=77)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_201] (rows=19197050 width=77)
+ Filter Operator [FIL_227] (rows=19197050 width=77)
predicate:((sr_return_amt > 10000) and sr_item_sk is not null and sr_ticket_number is not null)
TableScan [TS_77] (rows=57591150 width=77)
default@store_returns,sr,Tbl:COMPLETE,Col:NONE,Output:["sr_item_sk","sr_ticket_number","sr_return_quantity","sr_return_amt"]
@@ -338,61 +338,61 @@ Stage-0
SHUFFLE [RS_83]
PartitionCols:_col1, _col2
Merge Join Operator [MERGEJOIN_145] (rows=23466488 width=88)
- Conds:RS_200._col0=RS_154._col0(Inner),Output:["_col1","_col2","_col3","_col4"]
+ Conds:RS_226._col0=RS_180._col0(Inner),Output:["_col1","_col2","_col3","_col4"]
<-Map 12 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_154]
+ SHUFFLE [RS_180]
PartitionCols:_col0
- Select Operator [SEL_151] (rows=18262 width=1119)
+ Select Operator [SEL_177] (rows=18262 width=1119)
Output:["_col0"]
- Filter Operator [FIL_150] (rows=18262 width=1119)
+ Filter Operator [FIL_176] (rows=18262 width=1119)
predicate:((d_moy = 12) and (d_year = 2000) and d_date_sk is not null)
TableScan [TS_3] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 26 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_200]
+ SHUFFLE [RS_226]
PartitionCols:_col0
- Select Operator [SEL_199] (rows=21333171 width=88)
+ Select Operator [SEL_225] (rows=21333171 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_198] (rows=21333171 width=88)
+ Filter Operator [FIL_224] (rows=21333171 width=88)
predicate:((ss_net_paid > 0) and (ss_net_profit > 1) and (ss_quantity > 0) and ss_item_sk is not null and ss_sold_date_sk is not null and ss_ticket_number is not null)
TableScan [TS_71] (rows=575995635 width=88)
default@store_sales,sts,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_ticket_number","ss_quantity","ss_net_paid","ss_net_profit"]
<-Reducer 8 [CONTAINS] vectorized
- Reduce Output Operator [RS_173]
+ Reduce Output Operator [RS_199]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_172] (rows=11830988 width=101)
+ Group By Operator [GBY_198] (rows=11830988 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"],keys:_col0, _col3, _col4, _col1, _col2
- Select Operator [SEL_171] (rows=3226610 width=135)
+ Select Operator [SEL_197] (rows=3226610 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Group By Operator [GBY_170] (rows=3226610 width=135)
+ Group By Operator [GBY_196] (rows=3226610 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
<-Union 7 [SIMPLE_EDGE]
<-Reducer 17 [CONTAINS] vectorized
- Reduce Output Operator [RS_197]
+ Reduce Output Operator [RS_223]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_196] (rows=6453220 width=135)
+ Group By Operator [GBY_222] (rows=6453220 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],keys:_col0, _col3, _col4, _col1, _col2
- Select Operator [SEL_195] (rows=4302070 width=135)
+ Select Operator [SEL_221] (rows=4302070 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_194] (rows=4302070 width=135)
+ Filter Operator [FIL_220] (rows=4302070 width=135)
predicate:((_col0 <= 10) or (rank_window_1 <= 10))
- PTF Operator [PTF_193] (rows=6453105 width=135)
+ PTF Operator [PTF_219] (rows=6453105 width=135)
Function definitions:[{},{"name:":"windowingtablefunction","order by:":"(CAST( _col4 AS decimal(15,4)) / CAST( _col5 AS decimal(15,4))) ASC NULLS FIRST","partition by:":"0"}]
- Select Operator [SEL_192] (rows=6453105 width=135)
+ Select Operator [SEL_218] (rows=6453105 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Reducer 16 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_191]
+ SHUFFLE [RS_217]
PartitionCols:0
- Select Operator [SEL_190] (rows=6453105 width=135)
+ Select Operator [SEL_216] (rows=6453105 width=135)
Output:["rank_window_0","_col0","_col1","_col2","_col3","_col4"]
- PTF Operator [PTF_189] (rows=6453105 width=135)
+ PTF Operator [PTF_215] (rows=6453105 width=135)
Function definitions:[{},{"name:":"windowingtablefunction","order by:":"(CAST( _col1 AS decimal(15,4)) / CAST( _col2 AS decimal(15,4))) ASC NULLS FIRST","partition by:":"0"}]
- Select Operator [SEL_188] (rows=6453105 width=135)
+ Select Operator [SEL_214] (rows=6453105 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Reducer 15 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_187]
+ SHUFFLE [RS_213]
PartitionCols:0
- Group By Operator [GBY_186] (rows=6453105 width=135)
+ Group By Operator [GBY_212] (rows=6453105 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)","sum(VALUE._col3)"],keys:KEY._col0
<-Reducer 14 [SIMPLE_EDGE]
SHUFFLE [RS_50]
@@ -402,13 +402,13 @@ Stage-0
Select Operator [SEL_47] (rows=12906211 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
Merge Join Operator [MERGEJOIN_144] (rows=12906211 width=135)
- Conds:RS_44._col1, _col2=RS_185._col0, _col1(Inner),Output:["_col1","_col3","_col4","_col11","_col12"]
+ Conds:RS_44._col1, _col2=RS_211._col0, _col1(Inner),Output:["_col1","_col3","_col4","_col11","_col12"]
<-Map 25 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_185]
+ SHUFFLE [RS_211]
PartitionCols:_col0, _col1
- Select Operator [SEL_184] (rows=9599627 width=106)
+ Select Operator [SEL_210] (rows=9599627 width=106)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_183] (rows=9599627 width=106)
+ Filter Operator [FIL_209] (rows=9599627 width=106)
predicate:((cr_return_amount > 10000) and cr_item_sk is not null and cr_order_number is not null)
TableScan [TS_38] (rows=28798881 width=106)
default@catalog_returns,cr,Tbl:COMPLETE,Col:NONE,Output:["cr_item_sk","cr_order_number","cr_return_quantity","cr_return_amount"]
@@ -416,46 +416,46 @@ Stage-0
SHUFFLE [RS_44]
PartitionCols:_col1, _col2
Merge Join Operator [MERGEJOIN_143] (rows=11732919 width=135)
- Conds:RS_182._col0=RS_153._col0(Inner),Output:["_col1","_col2","_col3","_col4"]
+ Conds:RS_208._col0=RS_179._col0(Inner),Output:["_col1","_col2","_col3","_col4"]
<-Map 12 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_153]
+ SHUFFLE [RS_179]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_151]
+ Please refer to the previous Select Operator [SEL_177]
<-Map 24 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_182]
+ SHUFFLE [RS_208]
PartitionCols:_col0
- Select Operator [SEL_181] (rows=10666290 width=135)
+ Select Operator [SEL_207] (rows=10666290 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_180] (rows=10666290 width=135)
+ Filter Operator [FIL_206] (rows=10666290 width=135)
predicate:((cs_net_paid > 0) and (cs_net_profit > 1) and (cs_quantity > 0) and cs_item_sk is not null and cs_order_number is not null and cs_sold_date_sk is not null)
TableScan [TS_32] (rows=287989836 width=135)
default@catalog_sales,cs,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk","cs_order_number","cs_quantity","cs_net_paid","cs_net_profit"]
<-Reducer 6 [CONTAINS] vectorized
- Reduce Output Operator [RS_169]
+ Reduce Output Operator [RS_195]
PartitionCols:_col0, _col1, _col2, _col3, _col4
- Group By Operator [GBY_168] (rows=6453220 width=135)
+ Group By Operator [GBY_194] (rows=6453220 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],keys:_col0, _col3, _col4, _col1, _col2
- Select Operator [SEL_167] (rows=2151150 width=135)
+ Select Operator [SEL_193] (rows=2151150 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_166] (rows=2151150 width=135)
+ Filter Operator [FIL_192] (rows=2151150 width=135)
predicate:((_col0 <= 10) or (rank_window_1 <= 10))
- PTF Operator [PTF_165] (rows=3226726 width=135)
+ PTF Operator [PTF_191] (rows=3226726 width=135)
Function definitions:[{},{"name:":"windowingtablefunction","order by:":"(CAST( _col4 AS decimal(15,4)) / CAST( _col5 AS decimal(15,4))) ASC NULLS FIRST","partition by:":"0"}]
- Select Operator [SEL_164] (rows=3226726 width=135)
+ Select Operator [SEL_190] (rows=3226726 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Reducer 5 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_163]
+ SHUFFLE [RS_189]
PartitionCols:0
- Select Operator [SEL_162] (rows=3226726 width=135)
+ Select Operator [SEL_188] (rows=3226726 width=135)
Output:["rank_window_0","_col0","_col1","_col2","_col3","_col4"]
- PTF Operator [PTF_161] (rows=3226726 width=135)
+ PTF Operator [PTF_187] (rows=3226726 width=135)
Function definitions:[{},{"name:":"windowingtablefunction","order by:":"(CAST( _col1 AS decimal(15,4)) / CAST( _col2 AS decimal(15,4))) ASC NULLS FIRST","partition by:":"0"}]
- Select Operator [SEL_160] (rows=3226726 width=135)
+ Select Operator [SEL_186] (rows=3226726 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Reducer 4 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_159]
+ SHUFFLE [RS_185]
PartitionCols:0
- Group By Operator [GBY_158] (rows=3226726 width=135)
+ Group By Operator [GBY_184] (rows=3226726 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)","sum(VALUE._col3)"],keys:KEY._col0
<-Reducer 3 [SIMPLE_EDGE]
SHUFFLE [RS_18]
@@ -465,13 +465,13 @@ Stage-0
Select Operator [SEL_15] (rows=6453452 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
Merge Join Operator [MERGEJOIN_142] (rows=6453452 width=135)
- Conds:RS_12._col1, _col2=RS_157._col0, _col1(Inner),Output:["_col1","_col3","_col4","_col11","_col12"]
+ Conds:RS_12._col1, _col2=RS_183._col0, _col1(Inner),Output:["_col1","_col3","_col4","_col11","_col12"]
<-Map 23 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_157]
+ SHUFFLE [RS_183]
PartitionCols:_col0, _col1
- Select Operator [SEL_156] (rows=4799489 width=92)
+ Select Operator [SEL_182] (rows=4799489 width=92)
Output:["_col0","_col1","_col2","_col3"]
- Filter Operator [FIL_155] (rows=4799489 width=92)
+ Filter Operator [FIL_181] (rows=4799489 width=92)
predicate:((wr_return_amt > 10000) and wr_item_sk is not null and wr_order_number is not null)
TableScan [TS_6] (rows=14398467 width=92)
default@web_returns,wr,Tbl:COMPLETE,Col:NONE,Output:["wr_item_sk","wr_order_number","wr_return_quantity","wr_return_amt"]
@@ -479,17 +479,17 @@ Stage-0
SHUFFLE [RS_12]
PartitionCols:_col1, _col2
Merge Join Operator [MERGEJOIN_141] (rows=5866775 width=135)
- Conds:RS_149._col0=RS_152._col0(Inner),Output:["_col1","_col2","_col3","_col4"]
+ Conds:RS_175._col0=RS_178._col0(Inner),Output:["_col1","_col2","_col3","_col4"]
<-Map 12 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_152]
+ SHUFFLE [RS_178]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_151]
+ Please refer to the previous Select Operator [SEL_177]
<-Map 1 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_149]
+ SHUFFLE [RS_175]
PartitionCols:_col0
- Select Operator [SEL_148] (rows=5333432 width=135)
+ Select Operator [SEL_174] (rows=5333432 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_147] (rows=5333432 width=135)
+ Filter Operator [FIL_173] (rows=5333432 width=135)
predicate:((ws_net_paid > 0) and (ws_net_profit > 1) and (ws_quantity > 0) and ws_item_sk is not null and ws_order_number is not null and ws_sold_date_sk is not null)
TableScan [TS_0] (rows=144002668 width=135)
default@web_sales,ws,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_order_number","ws_quantity","ws_net_paid","ws_net_profit"]
http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/perf/tez/query5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query5.q.out b/ql/src/test/results/clientpositive/perf/tez/query5.q.out
index f13b767..f074ed1 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query5.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query5.q.out
@@ -278,26 +278,26 @@ Stage-0
limit:100
Stage-1
Reducer 8 vectorized
- File Output Operator [FS_158]
- Limit [LIM_157] (rows=100 width=110)
+ File Output Operator [FS_202]
+ Limit [LIM_201] (rows=100 width=110)
Number of rows:100
- Select Operator [SEL_156] (rows=1136898901 width=110)
+ Select Operator [SEL_200] (rows=1136898901 width=110)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Reducer 7 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_155]
- Select Operator [SEL_154] (rows=1136898901 width=110)
+ SHUFFLE [RS_199]
+ Select Operator [SEL_198] (rows=1136898901 width=110)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Group By Operator [GBY_153] (rows=1136898901 width=110)
+ Group By Operator [GBY_197] (rows=1136898901 width=110)
Output:["_col0","_col1","_col3","_col4","_col5"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)"],keys:KEY._col0, KEY._col1, KEY._col2
<-Union 6 [SIMPLE_EDGE]
<-Reducer 13 [CONTAINS] vectorized
- Reduce Output Operator [RS_168]
+ Reduce Output Operator [RS_212]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_167] (rows=2273797803 width=110)
+ Group By Operator [GBY_211] (rows=2273797803 width=110)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)","sum(_col3)","sum(_col4)"],keys:_col0, _col1, 0L
- Select Operator [SEL_166] (rows=191657181 width=132)
+ Select Operator [SEL_210] (rows=191657181 width=132)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Group By Operator [GBY_165] (rows=191657181 width=132)
+ Group By Operator [GBY_209] (rows=191657181 width=132)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)","sum(VALUE._col3)"],keys:KEY._col0
<-Reducer 12 [SIMPLE_EDGE]
SHUFFLE [RS_47]
@@ -305,13 +305,13 @@ Stage-0
Group By Operator [GBY_46] (rows=383314363 width=132)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col2)","sum(_col4)","sum(_col3)","sum(_col5)"],keys:_col9
Merge Join Operator [MERGEJOIN_135] (rows=383314363 width=132)
- Conds:RS_42._col0=RS_164._col0(Inner),Output:["_col2","_col3","_col4","_col5","_col9"]
+ Conds:RS_42._col0=RS_208._col0(Inner),Output:["_col2","_col3","_col4","_col5","_col9"]
<-Map 21 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_164]
+ SHUFFLE [RS_208]
PartitionCols:_col0
- Select Operator [SEL_163] (rows=46000 width=460)
+ Select Operator [SEL_207] (rows=46000 width=460)
Output:["_col0","_col1"]
- Filter Operator [FIL_162] (rows=46000 width=460)
+ Filter Operator [FIL_206] (rows=46000 width=460)
predicate:cp_catalog_page_sk is not null
TableScan [TS_36] (rows=46000 width=460)
default@catalog_page,catalog_page,Tbl:COMPLETE,Col:NONE,Output:["cp_catalog_page_sk","cp_catalog_page_id"]
@@ -319,43 +319,43 @@ Stage-0
SHUFFLE [RS_42]
PartitionCols:_col0
Merge Join Operator [MERGEJOIN_134] (rows=348467596 width=132)
- Conds:Union 19._col1=RS_144._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
+ Conds:Union 19._col1=RS_188._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
<-Map 10 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_144]
+ SHUFFLE [RS_188]
PartitionCols:_col0
- Select Operator [SEL_142] (rows=8116 width=1119)
+ Select Operator [SEL_186] (rows=8116 width=1119)
Output:["_col0"]
- Filter Operator [FIL_141] (rows=8116 width=1119)
+ Filter Operator [FIL_185] (rows=8116 width=1119)
predicate:(CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-08-04 00:00:00.0' AND TIMESTAMP'1998-08-18 00:00:00.0' and d_date_sk is not null)
TableScan [TS_8] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
<-Union 19 [SIMPLE_EDGE]
<-Map 18 [CONTAINS] vectorized
- Reduce Output Operator [RS_178]
+ Reduce Output Operator [RS_222]
PartitionCols:_col1
- Select Operator [SEL_177] (rows=287989836 width=135)
+ Select Operator [SEL_221] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_176] (rows=287989836 width=135)
+ Filter Operator [FIL_220] (rows=287989836 width=135)
predicate:(cs_catalog_page_sk is not null and cs_sold_date_sk is not null)
- TableScan [TS_25] (rows=287989836 width=135)
+ TableScan [TS_163] (rows=287989836 width=135)
Output:["cs_sold_date_sk","cs_catalog_page_sk","cs_ext_sales_price","cs_net_profit"]
<-Map 20 [CONTAINS] vectorized
- Reduce Output Operator [RS_181]
+ Reduce Output Operator [RS_225]
PartitionCols:_col1
- Select Operator [SEL_180] (rows=28798881 width=106)
+ Select Operator [SEL_224] (rows=28798881 width=106)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_179] (rows=28798881 width=106)
+ Filter Operator [FIL_223] (rows=28798881 width=106)
predicate:(cr_catalog_page_sk is not null and cr_returned_date_sk is not null)
- TableScan [TS_28] (rows=28798881 width=106)
+ TableScan [TS_168] (rows=28798881 width=106)
Output:["cr_returned_date_sk","cr_catalog_page_sk","cr_return_amount","cr_net_loss"]
<-Reducer 16 [CONTAINS] vectorized
- Reduce Output Operator [RS_175]
+ Reduce Output Operator [RS_219]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_174] (rows=2273797803 width=110)
+ Group By Operator [GBY_218] (rows=2273797803 width=110)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)","sum(_col3)","sum(_col4)"],keys:_col0, _col1, 0L
- Select Operator [SEL_173] (rows=182955399 width=135)
+ Select Operator [SEL_217] (rows=182955399 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Group By Operator [GBY_172] (rows=182955399 width=135)
+ Group By Operator [GBY_216] (rows=182955399 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)","sum(VALUE._col3)"],keys:KEY._col0
<-Reducer 15 [SIMPLE_EDGE]
SHUFFLE [RS_80]
@@ -363,13 +363,13 @@ Stage-0
Group By Operator [GBY_79] (rows=365910798 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col2)","sum(_col4)","sum(_col3)","sum(_col5)"],keys:_col9
Merge Join Operator [MERGEJOIN_137] (rows=365910798 width=135)
- Conds:RS_75._col0=RS_171._col0(Inner),Output:["_col2","_col3","_col4","_col5","_col9"]
+ Conds:RS_75._col0=RS_215._col0(Inner),Output:["_col2","_col3","_col4","_col5","_col9"]
<-Map 27 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_171]
+ SHUFFLE [RS_215]
PartitionCols:_col0
- Select Operator [SEL_170] (rows=84 width=1850)
+ Select Operator [SEL_214] (rows=84 width=1850)
Output:["_col0","_col1"]
- Filter Operator [FIL_169] (rows=84 width=1850)
+ Filter Operator [FIL_213] (rows=84 width=1850)
predicate:web_site_sk is not null
TableScan [TS_69] (rows=84 width=1850)
default@web_site,web_site,Tbl:COMPLETE,Col:NONE,Output:["web_site_sk","web_site_id"]
@@ -377,54 +377,54 @@ Stage-0
SHUFFLE [RS_75]
PartitionCols:_col0
Merge Join Operator [MERGEJOIN_136] (rows=332646173 width=135)
- Conds:Union 23._col1=RS_145._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
+ Conds:Union 23._col1=RS_189._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
<-Map 10 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_145]
+ SHUFFLE [RS_189]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_142]
+ Please refer to the previous Select Operator [SEL_186]
<-Union 23 [SIMPLE_EDGE]
<-Map 22 [CONTAINS] vectorized
- Reduce Output Operator [RS_184]
+ Reduce Output Operator [RS_228]
PartitionCols:_col1
- Select Operator [SEL_183] (rows=144002668 width=135)
+ Select Operator [SEL_227] (rows=144002668 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_182] (rows=144002668 width=135)
+ Filter Operator [FIL_226] (rows=144002668 width=135)
predicate:(ws_sold_date_sk is not null and ws_web_site_sk is not null)
- TableScan [TS_51] (rows=144002668 width=135)
+ TableScan [TS_173] (rows=144002668 width=135)
Output:["ws_sold_date_sk","ws_web_site_sk","ws_ext_sales_price","ws_net_profit"]
<-Reducer 25 [CONTAINS]
- Reduce Output Operator [RS_72]
+ Reduce Output Operator [RS_181]
PartitionCols:_col1
- Select Operator [SEL_63] (rows=158402938 width=135)
+ Select Operator [SEL_179] (rows=158402938 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Merge Join Operator [MERGEJOIN_131] (rows=158402938 width=135)
- Conds:RS_187._col0, _col2=RS_190._col1, _col2(Inner),Output:["_col1","_col3","_col6","_col7"]
+ Merge Join Operator [MERGEJOIN_178] (rows=158402938 width=135)
+ Conds:RS_231._col0, _col2=RS_234._col1, _col2(Inner),Output:["_col1","_col3","_col6","_col7"]
<-Map 24 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_187]
+ SHUFFLE [RS_231]
PartitionCols:_col0, _col2
- Select Operator [SEL_186] (rows=144002668 width=135)
+ Select Operator [SEL_230] (rows=144002668 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_185] (rows=144002668 width=135)
+ Filter Operator [FIL_229] (rows=144002668 width=135)
predicate:(ws_item_sk is not null and ws_order_number is not null and ws_web_site_sk is not null)
TableScan [TS_54] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_item_sk","ws_web_site_sk","ws_order_number"]
<-Map 26 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_190]
+ SHUFFLE [RS_234]
PartitionCols:_col1, _col2
- Select Operator [SEL_189] (rows=14398467 width=92)
+ Select Operator [SEL_233] (rows=14398467 width=92)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Filter Operator [FIL_188] (rows=14398467 width=92)
+ Filter Operator [FIL_232] (rows=14398467 width=92)
predicate:(wr_item_sk is not null and wr_order_number is not null and wr_returned_date_sk is not null)
TableScan [TS_57] (rows=14398467 width=92)
default@web_returns,web_returns,Tbl:COMPLETE,Col:NONE,Output:["wr_returned_date_sk","wr_item_sk","wr_order_number","wr_return_amt","wr_net_loss"]
<-Reducer 5 [CONTAINS] vectorized
- Reduce Output Operator [RS_152]
+ Reduce Output Operator [RS_196]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_151] (rows=2273797803 width=110)
+ Group By Operator [GBY_195] (rows=2273797803 width=110)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)","sum(_col3)","sum(_col4)"],keys:_col0, _col1, 0L
- Select Operator [SEL_150] (rows=383320021 width=87)
+ Select Operator [SEL_194] (rows=383320021 width=87)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Group By Operator [GBY_149] (rows=383320021 width=87)
+ Group By Operator [GBY_193] (rows=383320021 width=87)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","sum(VALUE._col2)","sum(VALUE._col3)"],keys:KEY._col0
<-Reducer 4 [SIMPLE_EDGE]
SHUFFLE [RS_22]
@@ -432,13 +432,13 @@ Stage-0
Group By Operator [GBY_21] (rows=766640042 width=87)
Output:["_col0","_col1","_col2","_col3","_col4"],aggregations:["sum(_col2)","sum(_col4)","sum(_col3)","sum(_col5)"],keys:_col9
Merge Join Operator [MERGEJOIN_133] (rows=766640042 width=87)
- Conds:RS_17._col0=RS_148._col0(Inner),Output:["_col2","_col3","_col4","_col5","_col9"]
+ Conds:RS_17._col0=RS_192._col0(Inner),Output:["_col2","_col3","_col4","_col5","_col9"]
<-Map 17 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_148]
+ SHUFFLE [RS_192]
PartitionCols:_col0
- Select Operator [SEL_147] (rows=1704 width=1910)
+ Select Operator [SEL_191] (rows=1704 width=1910)
Output:["_col0","_col1"]
- Filter Operator [FIL_146] (rows=1704 width=1910)
+ Filter Operator [FIL_190] (rows=1704 width=1910)
predicate:s_store_sk is not null
TableScan [TS_11] (rows=1704 width=1910)
default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_store_id"]
@@ -446,28 +446,28 @@ Stage-0
SHUFFLE [RS_17]
PartitionCols:_col0
Merge Join Operator [MERGEJOIN_132] (rows=696945478 width=87)
- Conds:Union 2._col1=RS_143._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
+ Conds:Union 2._col1=RS_187._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
<-Map 10 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_143]
+ SHUFFLE [RS_187]
PartitionCols:_col0
- Please refer to the previous Select Operator [SEL_142]
+ Please refer to the previous Select Operator [SEL_186]
<-Union 2 [SIMPLE_EDGE]
<-Map 1 [CONTAINS] vectorized
- Reduce Output Operator [RS_140]
+ Reduce Output Operator [RS_184]
PartitionCols:_col1
- Select Operator [SEL_139] (rows=575995635 width=88)
+ Select Operator [SEL_183] (rows=575995635 width=88)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_138] (rows=575995635 width=88)
+ Filter Operator [FIL_182] (rows=575995635 width=88)
predicate:(ss_sold_date_sk is not null and ss_store_sk is not null)
- TableScan [TS_0] (rows=575995635 width=88)
+ TableScan [TS_138] (rows=575995635 width=88)
Output:["ss_sold_date_sk","ss_store_sk","ss_ext_sales_price","ss_net_profit"]
<-Map 9 [CONTAINS] vectorized
- Reduce Output Operator [RS_161]
+ Reduce Output Operator [RS_205]
PartitionCols:_col1
- Select Operator [SEL_160] (rows=57591150 width=77)
+ Select Operator [SEL_204] (rows=57591150 width=77)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Filter Operator [FIL_159] (rows=57591150 width=77)
+ Filter Operator [FIL_203] (rows=57591150 width=77)
predicate:(sr_returned_date_sk is not null and sr_store_sk is not null)
- TableScan [TS_3] (rows=57591150 width=77)
+ TableScan [TS_148] (rows=57591150 width=77)
Output:["sr_returned_date_sk","sr_store_sk","sr_return_amt","sr_net_loss"]
http://git-wip-us.apache.org/repos/asf/hive/blob/2842f88e/ql/src/test/results/clientpositive/perf/tez/query54.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/tez/query54.q.out b/ql/src/test/results/clientpositive/perf/tez/query54.q.out
index 699adb8..386ea4b 100644
--- a/ql/src/test/results/clientpositive/perf/tez/query54.q.out
+++ b/ql/src/test/results/clientpositive/perf/tez/query54.q.out
@@ -143,25 +143,25 @@ Stage-0
limit:100
Stage-1
Reducer 9 vectorized
- File Output Operator [FS_249]
- Limit [LIM_248] (rows=100 width=158)
+ File Output Operator [FS_259]
+ Limit [LIM_258] (rows=100 width=158)
Number of rows:100
- Select Operator [SEL_247] (rows=1614130953450400 width=158)
+ Select Operator [SEL_257] (rows=1614130953450400 width=158)
Output:["_col0","_col1","_col2"]
<-Reducer 8 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_246]
- Select Operator [SEL_245] (rows=1614130953450400 width=158)
+ SHUFFLE [RS_256]
+ Select Operator [SEL_255] (rows=1614130953450400 width=158)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_244] (rows=1614130953450400 width=158)
+ Group By Operator [GBY_254] (rows=1614130953450400 width=158)
Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
<-Reducer 7 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_243]
+ SHUFFLE [RS_253]
PartitionCols:_col0
- Group By Operator [GBY_242] (rows=3228261906900801 width=158)
+ Group By Operator [GBY_252] (rows=3228261906900801 width=158)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_241] (rows=3228261906900801 width=158)
+ Select Operator [SEL_251] (rows=3228261906900801 width=158)
Output:["_col0"]
- Group By Operator [GBY_240] (rows=3228261906900801 width=158)
+ Group By Operator [GBY_250] (rows=3228261906900801 width=158)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0
<-Reducer 6 [SIMPLE_EDGE]
SHUFFLE [RS_119]
@@ -181,42 +181,42 @@ Stage-0
Merge Join Operator [MERGEJOIN_183] (rows=9131 width=1128)
Conds:(Right Outer),Output:["_col0"]
<-Reducer 28 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_231]
- Group By Operator [GBY_230] (rows=9131 width=1119)
+ PARTITION_ONLY_SHUFFLE [RS_241]
+ Group By Operator [GBY_240] (rows=9131 width=1119)
Output:["_col0"],keys:KEY._col0
<-Map 25 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_219]
+ SHUFFLE [RS_229]
PartitionCols:_col0
- Group By Operator [GBY_216] (rows=18262 width=1119)
+ Group By Operator [GBY_226] (rows=18262 width=1119)
Output:["_col0"],keys:_col0
- Select Operator [SEL_213] (rows=18262 width=1119)
+ Select Operator [SEL_223] (rows=18262 width=1119)
Output:["_col0"]
- Filter Operator [FIL_211] (rows=18262 width=1119)
+ Filter Operator [FIL_221] (rows=18262 width=1119)
predicate:((d_moy = 3) and (d_year = 1999))
TableScan [TS_73] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_month_seq","d_year","d_moy"]
<-Reducer 31 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_239]
- Select Operator [SEL_238] (rows=1 width=8)
- Filter Operator [FIL_237] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_249]
+ Select Operator [SEL_248] (rows=1 width=8)
+ Filter Operator [FIL_247] (rows=1 width=8)
predicate:(sq_count_check(_col0) <= 1)
- Group By Operator [GBY_236] (rows=1 width=8)
+ Group By Operator [GBY_246] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Reducer 30 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_235]
- Group By Operator [GBY_234] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_245]
+ Group By Operator [GBY_244] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_233] (rows=9131 width=1119)
- Group By Operator [GBY_232] (rows=9131 width=1119)
+ Select Operator [SEL_243] (rows=9131 width=1119)
+ Group By Operator [GBY_242] (rows=9131 width=1119)
Output:["_col0"],keys:KEY._col0
<-Map 25 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_220]
+ SHUFFLE [RS_230]
PartitionCols:_col0
- Group By Operator [GBY_217] (rows=18262 width=1119)
+ Group By Operator [GBY_227] (rows=18262 width=1119)
Output:["_col0"],keys:_col0
- Select Operator [SEL_214] (rows=18262 width=1119)
+ Select Operator [SEL_224] (rows=18262 width=1119)
Output:["_col0"]
- Please refer to the previous Filter Operator [FIL_211]
+ Please refer to the previous Filter Operator [FIL_221]
<-Reducer 5 [CUSTOM_SIMPLE_EDGE]
PARTITION_ONLY_SHUFFLE [RS_113]
Select Operator [SEL_108] (rows=6363893803988 width=1217)
@@ -224,34 +224,34 @@ Stage-0
Merge Join Operator [MERGEJOIN_185] (rows=6363893803988 width=1217)
Conds:(Left Outer),Output:["_col2","_col4","_col10","_col13"]
<-Reducer 26 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_223]
- Group By Operator [GBY_221] (rows=9131 width=1119)
+ PARTITION_ONLY_SHUFFLE [RS_233]
+ Group By Operator [GBY_231] (rows=9131 width=1119)
Output:["_col0"],keys:KEY._col0
<-Map 25 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_218]
+ SHUFFLE [RS_228]
PartitionCols:_col0
- Group By Operator [GBY_215] (rows=18262 width=1119)
+ Group By Operator [GBY_225] (rows=18262 width=1119)
Output:["_col0"],keys:_col0
- Select Operator [SEL_212] (rows=18262 width=1119)
+ Select Operator [SEL_222] (rows=18262 width=1119)
Output:["_col0"]
- Please refer to the previous Filter Operator [FIL_211]
+ Please refer to the previous Filter Operator [FIL_221]
<-Reducer 4 [CUSTOM_SIMPLE_EDGE]
PARTITION_ONLY_SHUFFLE [RS_105]
Merge Join Operator [MERGEJOIN_184] (rows=696954748 width=97)
Conds:(Inner),Output:["_col2","_col4","_col10"]
<-Reducer 27 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_229]
- Select Operator [SEL_228] (rows=1 width=8)
- Filter Operator [FIL_227] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_239]
+ Select Operator [SEL_238] (rows=1 width=8)
+ Filter Operator [FIL_237] (rows=1 width=8)
predicate:(sq_count_check(_col0) <= 1)
- Group By Operator [GBY_226] (rows=1 width=8)
+ Group By Operator [GBY_236] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Reducer 26 [CUSTOM_SIMPLE_EDGE] vectorized
- PARTITION_ONLY_SHUFFLE [RS_225]
- Group By Operator [GBY_224] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_235]
+ Group By Operator [GBY_234] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_222] (rows=9131 width=1119)
- Please refer to the previous Group By Operator [GBY_221]
+ Select Operator [SEL_232] (rows=9131 width=1119)
+ Please refer to the previous Group By Operator [GBY_231]
<-Reducer 3 [CUSTOM_SIMPLE_EDGE]
PARTITION_ONLY_SHUFFLE [RS_102]
Merge Join Operator [MERGEJOIN_182] (rows=696954748 width=88)
@@ -260,36 +260,36 @@ Stage-0
SHUFFLE [RS_100]
PartitionCols:_col5
Merge Join Operator [MERGEJOIN_181] (rows=316240138 width=135)
- Conds:RS_69._col0=RS_210._col1(Inner),Output:["_col5"]
+ Conds:RS_69._col0=RS_220._col1(Inner),Output:["_col5"]
<-Reducer 12 [SIMPLE_EDGE]
SHUFFLE [RS_69]
PartitionCols:_col0
Merge Join Operator [MERGEJOIN_177] (rows=44000000 width=1014)
- Conds:RS_195._col1, _col2=RS_198._col0, _col1(Inner),Output:["_col0"]
+ Conds:RS_205._col1, _col2=RS_208._col0, _col1(Inner),Output:["_col0"]
<-Map 11 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_195]
+ SHUFFLE [RS_205]
PartitionCols:_col1, _col2
- Select Operator [SEL_194] (rows=40000000 width=1014)
+ Select Operator [SEL_204] (rows=40000000 width=1014)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_193] (rows=40000000 width=1014)
+ Filter Operator [FIL_203] (rows=40000000 width=1014)
predicate:(ca_address_sk is not null and ca_county is not null and ca_state is not null)
TableScan [TS_29] (rows=40000000 width=1014)
default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_county","ca_state"]
<-Map 14 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_198]
+ SHUFFLE [RS_208]
PartitionCols:_col0, _col1
- Select Operator [SEL_197] (rows=1704 width=1910)
+ Select Operator [SEL_207] (rows=1704 width=1910)
Output:["_col0","_col1"]
- Filter Operator [FIL_196] (rows=1704 width=1910)
+ Filter Operator [FIL_206] (rows=1704 width=1910)
predicate:(s_county is not null and s_state is not null)
TableScan [TS_32] (rows=1704 width=1910)
default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_county","s_state"]
<-Reducer 20 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_210]
+ SHUFFLE [RS_220]
PartitionCols:_col1
- Select Operator [SEL_209] (rows=287491029 width=135)
+ Select Operator [SEL_219] (rows=287491029 width=135)
Output:["_col0","_col1"]
- Group By Operator [GBY_208] (rows=287491029 width=135)
+ Group By Operator [GBY_218] (rows=287491029 width=135)
Output:["_col0","_col1"],keys:KEY._col0, KEY._col1
<-Reducer 19 [SIMPLE_EDGE]
SHUFFLE [RS_63]
@@ -297,13 +297,13 @@ Stage-0
Group By Operator [GBY_62] (rows=574982058 width=135)
Output:["_col0","_col1"],keys:_col10, _col9
Merge Join Operator [MERGEJOIN_180] (rows=574982058 width=135)
- Conds:RS_58._col1=RS_207._col0(Inner),Output:["_col9","_col10"]
+ Conds:RS_58._col1=RS_217._col0(Inner),Output:["_col9","_col10"]
<-Map 24 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_207]
+ SHUFFLE [RS_217]
PartitionCols:_col0
- Select Operator [SEL_206] (rows=80000000 width=860)
+ Select Operator [SEL_216] (rows=80000000 width=860)
Output:["_col0","_col1"]
- Filter Operator [FIL_205] (rows=80000000 width=860)
+ Filter Operator [FIL_215] (rows=80000000 width=860)
predicate:(c_current_addr_sk is not null and c_customer_sk is not null)
TableScan [TS_49] (rows=80000000 width=860)
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_addr_sk"]
@@ -311,13 +311,13 @@ Stage-0
SHUFFLE [RS_58]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_179] (rows=522710951 width=135)
- Conds:RS_55._col2=RS_204._col0(Inner),Output:["_col1"]
+ Conds:RS_55._col2=RS_214._col0(Inner),Output:["_col1"]
<-Map 23 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_204]
+ SHUFFLE [RS_214]
PartitionCols:_col0
- Select Operator [SEL_203] (rows=115500 width=1436)
+ Select Operator [SEL_213] (rows=115500 width=1436)
Output:["_col0"]
- Filter Operator [FIL_202] (rows=115500 width=1436)
+ Filter Operator [FIL_212] (rows=115500 width=1436)
predicate:((i_category = 'Jewelry') and (i_class = 'consignment') and i_item_sk is not null)
TableScan [TS_46] (rows=462000 width=1436)
default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_class","i_category"]
@@ -325,55 +325,55 @@ Stage-0
SHUFFLE [RS_55]
PartitionCols:_col2
Merge Join Operator [MERGEJOIN_178] (rows=475191764 width=135)
- Conds:Union 16._col0=RS_201._col0(Inner),Output:["_col1","_col2"]
+ Conds:Union 16._col0=RS_211._col0(Inner),Output:["_col1","_col2"]
<-Map 22 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_201]
+ SHUFFLE [RS_211]
PartitionCols:_col0
- Select Operator [SEL_200] (rows=18262 width=1119)
+ Select Operator [SEL_210] (rows=18262 width=1119)
Output:["_col0"]
- Filter Operator [FIL_199] (rows=18262 width=1119)
+ Filter Operator [FIL_209] (rows=18262 width=1119)
predicate:((d_moy = 3) and (d_year = 1999) and d_date_sk is not null)
TableScan [TS_43] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Union 16 [SIMPLE_EDGE]
<-Map 15 [CONTAINS] vectorized
- Reduce Output Operator [RS_252]
+ Reduce Output Operator [RS_262]
PartitionCols:_col0
- Select Operator [SEL_251] (rows=287989836 width=135)
+ Select Operator [SEL_261] (rows=287989836 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_250] (rows=287989836 width=135)
+ Filter Operator [FIL_260] (rows=287989836 width=135)
predicate:(cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
- TableScan [TS_35] (rows=287989836 width=135)
+ TableScan [TS_187] (rows=287989836 width=135)
Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk"]
<-Map 21 [CONTAINS] vectorized
- Reduce Output Operator [RS_255]
+ Reduce Output Operator [RS_265]
PartitionCols:_col0
- Select Operator [SEL_254] (rows=144002668 width=135)
+ Select Operator [SEL_264] (rows=144002668 width=135)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_253] (rows=144002668 width=135)
+ Filter Operator [FIL_263] (rows=144002668 width=135)
predicate:(ws_bill_customer_sk is not null and ws_item_sk is not null and ws_sold_date_sk is not null)
- TableScan [TS_38] (rows=144002668 width=135)
+ TableScan [TS_192] (rows=144002668 width=135)
Output:["ws_sold_date_sk","ws_item_sk","ws_bill_customer_sk"]
<-Reducer 2 [SIMPLE_EDGE]
SHUFFLE [RS_99]
PartitionCols:_col1
Merge Join Operator [MERGEJOIN_176] (rows=633595212 width=88)
- Conds:RS_189._col0=RS_192._col0(Inner),Output:["_col1","_col2","_col4"]
+ Conds:RS_199._col0=RS_202._col0(Inner),Output:["_col1","_col2","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_189]
+ SHUFFLE [RS_199]
PartitionCols:_col0
- Select Operator [SEL_188] (rows=575995635 width=88)
+ Select Operator [SEL_198] (rows=575995635 width=88)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_187] (rows=575995635 width=88)
+ Filter Operator [FIL_197] (rows=575995635 width=88)
predicate:(ss_customer_sk is not null and ss_sold_date_sk is not null)
TableScan [TS_23] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_ext_sales_price"]
<-Map 10 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_192]
+ SHUFFLE [RS_202]
PartitionCols:_col0
- Select Operator [SEL_191] (rows=73049 width=1119)
+ Select Operator [SEL_201] (rows=73049 width=1119)
Output:["_col0","_col1"]
- Filter Operator [FIL_190] (rows=73049 width=1119)
+ Filter Operator [FIL_200] (rows=73049 width=1119)
predicate:d_date_sk is not null
TableScan [TS_26] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]