You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by mm...@apache.org on 2018/04/27 06:47:07 UTC
[34/51] [partial] hive git commit: HIVE-19269: Vectorization: Turn On
by Default (Matt McCline, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/230cc4bb/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
index 872f9c9..9827d3b 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
@@ -119,11 +119,11 @@ Stage-3
Number of rows:100
Select Operator [SEL_4] (rows=100 width=178)
Output:["_col0","_col1"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_3]
- Limit [LIM_2] (rows=100 width=178)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_10]
+ Limit [LIM_9] (rows=100 width=178)
Number of rows:100
- Select Operator [SEL_1] (rows=500 width=178)
+ Select Operator [SEL_8] (rows=500 width=178)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=178)
default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
@@ -158,15 +158,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 llap
- File Output Operator [FS_8]
- Group By Operator [GBY_6] (rows=1 width=16)
+ Reducer 2 vectorized, llap
+ File Output Operator [FS_14]
+ Group By Operator [GBY_13] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_5]
- Group By Operator [GBY_4] (rows=1 width=16)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_12]
+ Group By Operator [GBY_11] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
- Select Operator [SEL_2] (rows=500 width=95)
+ Select Operator [SEL_10] (rows=500 width=95)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=95)
default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
@@ -192,15 +192,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 llap
- File Output Operator [FS_7]
- Group By Operator [GBY_5] (rows=1 width=8)
+ Reducer 2 vectorized, llap
+ File Output Operator [FS_13]
+ Group By Operator [GBY_12] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_4]
- Group By Operator [GBY_3] (rows=1 width=8)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_11]
+ Group By Operator [GBY_10] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_2] (rows=500 width=102)
+ Select Operator [SEL_9] (rows=500 width=102)
TableScan [TS_0] (rows=500 width=102)
default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:COMPLETE
@@ -217,15 +217,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 llap
- File Output Operator [FS_8]
- Group By Operator [GBY_6] (rows=1 width=16)
+ Reducer 2 vectorized, llap
+ File Output Operator [FS_14]
+ Group By Operator [GBY_13] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_5]
- Group By Operator [GBY_4] (rows=1 width=16)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_12]
+ Group By Operator [GBY_11] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
- Select Operator [SEL_2] (rows=500 width=95)
+ Select Operator [SEL_10] (rows=500 width=95)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=95)
default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
@@ -269,9 +269,9 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 llap
- File Output Operator [FS_15]
- Group By Operator [GBY_13] (rows=1 width=8)
+ Reducer 3 vectorized, llap
+ File Output Operator [FS_26]
+ Group By Operator [GBY_25] (rows=1 width=8)
Output:["_col0"],aggregations:["sum(VALUE._col0)"]
<-Reducer 2 [CUSTOM_SIMPLE_EDGE] llap
PARTITION_ONLY_SHUFFLE [RS_12]
@@ -279,19 +279,19 @@ Stage-0
Output:["_col0"],aggregations:["sum(hash(_col0,_col1,_col2,_col3))"]
Merge Join Operator [MERGEJOIN_18] (rows=27556 width=356)
Conds:(Inner),Output:["_col0","_col1","_col2","_col3"]
- <-Map 1 [XPROD_EDGE] llap
- XPROD_EDGE [RS_6]
- Select Operator [SEL_2] (rows=166 width=178)
+ <-Map 1 [XPROD_EDGE] vectorized, llap
+ XPROD_EDGE [RS_21]
+ Select Operator [SEL_20] (rows=166 width=178)
Output:["_col0","_col1"]
- Filter Operator [FIL_16] (rows=166 width=178)
+ Filter Operator [FIL_19] (rows=166 width=178)
predicate:(key < 10)
TableScan [TS_0] (rows=500 width=178)
default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
- <-Map 4 [XPROD_EDGE] llap
- XPROD_EDGE [RS_7]
- Select Operator [SEL_5] (rows=166 width=178)
+ <-Map 4 [XPROD_EDGE] vectorized, llap
+ XPROD_EDGE [RS_24]
+ Select Operator [SEL_23] (rows=166 width=178)
Output:["_col0","_col1"]
- Filter Operator [FIL_17] (rows=166 width=178)
+ Filter Operator [FIL_22] (rows=166 width=178)
predicate:(key < 10)
TableScan [TS_3] (rows=500 width=178)
default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
@@ -309,18 +309,18 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 llap
- File Output Operator [FS_6]
- Select Operator [SEL_5] (rows=10 width=97)
+ Reducer 2 vectorized, llap
+ File Output Operator [FS_12]
+ Select Operator [SEL_11] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_4] (rows=10 width=101)
+ Group By Operator [GBY_10] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_3]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_9]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_2] (rows=10 width=101)
+ Group By Operator [GBY_8] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_1] (rows=20 width=88)
+ Select Operator [SEL_7] (rows=20 width=88)
Output:["key","c_int","c_float"]
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -339,27 +339,27 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 llap
- File Output Operator [FS_11]
- Select Operator [SEL_10] (rows=5 width=20)
+ Reducer 3 vectorized, llap
+ File Output Operator [FS_21]
+ Select Operator [SEL_20] (rows=5 width=20)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_9] (rows=5 width=20)
+ Group By Operator [GBY_19] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
- <-Reducer 2 [SIMPLE_EDGE] llap
- SHUFFLE [RS_8]
+ <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_18]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=5 width=20)
+ Group By Operator [GBY_17] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0, _col1
- Select Operator [SEL_5] (rows=10 width=101)
+ Select Operator [SEL_16] (rows=10 width=101)
Output:["_col0","_col1"]
- Group By Operator [GBY_4] (rows=10 width=101)
+ Group By Operator [GBY_15] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_3]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_2] (rows=10 width=101)
+ Group By Operator [GBY_13] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_1] (rows=20 width=88)
+ Select Operator [SEL_12] (rows=20 width=88)
Output:["key","c_int","c_float"]
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -381,15 +381,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 llap
- File Output Operator [FS_29]
- Select Operator [SEL_27] (rows=1 width=20)
+ Reducer 4 vectorized, llap
+ File Output Operator [FS_59]
+ Select Operator [SEL_58] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_26]
- Select Operator [SEL_25] (rows=1 width=28)
+ <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_57]
+ Select Operator [SEL_56] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_24] (rows=1 width=20)
+ Group By Operator [GBY_55] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_23]
@@ -399,45 +399,45 @@ Stage-0
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
Merge Join Operator [MERGEJOIN_39] (rows=1 width=20)
- Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 0)}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_17]
+ Conds:RS_42._col0=RS_48._col0(Inner),RS_48._col0=RS_54._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 0)}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_42]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=84)
+ Select Operator [SEL_41] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_36] (rows=18 width=84)
+ Filter Operator [FIL_40] (rows=18 width=84)
predicate:key is not null
TableScan [TS_0] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Reducer 6 [SIMPLE_EDGE] llap
- SHUFFLE [RS_18]
+ <-Reducer 6 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_48]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=1 width=97)
+ Select Operator [SEL_47] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_8] (rows=1 width=101)
+ Group By Operator [GBY_46] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
+ <-Map 5 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_45]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_6] (rows=1 width=101)
+ Group By Operator [GBY_44] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_37] (rows=4 width=93)
+ Filter Operator [FIL_43] (rows=4 width=93)
predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 8 [SIMPLE_EDGE] llap
- SHUFFLE [RS_19]
+ <-Reducer 8 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_54]
PartitionCols:_col0
- Select Operator [SEL_16] (rows=1 width=89)
+ Select Operator [SEL_53] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=1 width=93)
+ Group By Operator [GBY_52] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_14]
+ <-Map 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_51]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=1 width=93)
+ Group By Operator [GBY_50] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_38] (rows=4 width=93)
+ Filter Operator [FIL_49] (rows=4 width=93)
predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_10] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -459,15 +459,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 llap
- File Output Operator [FS_29]
- Select Operator [SEL_27] (rows=1 width=20)
+ Reducer 4 vectorized, llap
+ File Output Operator [FS_59]
+ Select Operator [SEL_58] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_26]
- Select Operator [SEL_25] (rows=1 width=28)
+ <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_57]
+ Select Operator [SEL_56] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_24] (rows=1 width=20)
+ Group By Operator [GBY_55] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_23]
@@ -477,45 +477,45 @@ Stage-0
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
Merge Join Operator [MERGEJOIN_39] (rows=1 width=20)
- Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col1 >= 1) or (_col4 >= 1L))} {((UDFToLong(_col1) + _col4) >= 0)} {((_col3 + _col6) >= 0)}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_17]
+ Conds:RS_42._col0=RS_48._col0(Inner),RS_48._col0=RS_54._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col1 >= 1) or (_col4 >= 1L))} {((UDFToLong(_col1) + _col4) >= 0)} {((_col3 + _col6) >= 0)}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_42]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=84)
+ Select Operator [SEL_41] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_36] (rows=18 width=84)
+ Filter Operator [FIL_40] (rows=18 width=84)
predicate:((c_int > 0) and key is not null)
TableScan [TS_0] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Reducer 6 [SIMPLE_EDGE] llap
- SHUFFLE [RS_18]
+ <-Reducer 6 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_48]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=1 width=97)
+ Select Operator [SEL_47] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_8] (rows=1 width=101)
+ Group By Operator [GBY_46] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
+ <-Map 5 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_45]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_6] (rows=1 width=101)
+ Group By Operator [GBY_44] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_37] (rows=2 width=93)
+ Filter Operator [FIL_43] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 8 [SIMPLE_EDGE] llap
- SHUFFLE [RS_19]
+ <-Reducer 8 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_54]
PartitionCols:_col0
- Select Operator [SEL_16] (rows=1 width=89)
+ Select Operator [SEL_53] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=1 width=93)
+ Group By Operator [GBY_52] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_14]
+ <-Map 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_51]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=1 width=93)
+ Group By Operator [GBY_50] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_38] (rows=2 width=93)
+ Filter Operator [FIL_49] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_10] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -536,9 +536,9 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 llap
- File Output Operator [FS_26]
- Group By Operator [GBY_24] (rows=1 width=20)
+ Reducer 3 vectorized, llap
+ File Output Operator [FS_53]
+ Group By Operator [GBY_52] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_23]
@@ -548,45 +548,45 @@ Stage-0
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
Merge Join Operator [MERGEJOIN_36] (rows=1 width=20)
- Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 2)}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_17]
+ Conds:RS_39._col0=RS_45._col0(Inner),RS_45._col0=RS_51._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 2)}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_39]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=84)
+ Select Operator [SEL_38] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_33] (rows=18 width=84)
+ Filter Operator [FIL_37] (rows=18 width=84)
predicate:key is not null
TableScan [TS_0] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Reducer 5 [SIMPLE_EDGE] llap
- SHUFFLE [RS_18]
+ <-Reducer 5 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_45]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=1 width=97)
+ Select Operator [SEL_44] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_8] (rows=1 width=101)
+ Group By Operator [GBY_43] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_42]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_6] (rows=1 width=101)
+ Group By Operator [GBY_41] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_34] (rows=2 width=93)
+ Filter Operator [FIL_40] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_19]
+ <-Reducer 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_51]
PartitionCols:_col0
- Select Operator [SEL_16] (rows=1 width=89)
+ Select Operator [SEL_50] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=1 width=93)
+ Group By Operator [GBY_49] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [SIMPLE_EDGE] llap
- SHUFFLE [RS_14]
+ <-Map 6 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_48]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=1 width=93)
+ Group By Operator [GBY_47] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_35] (rows=2 width=93)
+ Filter Operator [FIL_46] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_10] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -608,13 +608,13 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 llap
- File Output Operator [FS_28]
- Select Operator [SEL_27] (rows=1 width=20)
+ Reducer 4 vectorized, llap
+ File Output Operator [FS_57]
+ Select Operator [SEL_56] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_26]
- Group By Operator [GBY_24] (rows=1 width=20)
+ <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_55]
+ Group By Operator [GBY_54] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_23]
@@ -624,45 +624,45 @@ Stage-0
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
Merge Join Operator [MERGEJOIN_38] (rows=1 width=20)
- Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col1 >= 1) or (_col4 >= 1L))} {((UDFToLong(_col1) + _col4) >= 0)} {((_col3 + _col6) >= 0)}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_17]
+ Conds:RS_41._col0=RS_47._col0(Inner),RS_47._col0=RS_53._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col1 >= 1) or (_col4 >= 1L))} {((UDFToLong(_col1) + _col4) >= 0)} {((_col3 + _col6) >= 0)}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_41]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=84)
+ Select Operator [SEL_40] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_35] (rows=18 width=84)
+ Filter Operator [FIL_39] (rows=18 width=84)
predicate:((c_int > 0) and key is not null)
TableScan [TS_0] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Reducer 6 [SIMPLE_EDGE] llap
- SHUFFLE [RS_18]
+ <-Reducer 6 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_47]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=1 width=97)
+ Select Operator [SEL_46] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_8] (rows=1 width=101)
+ Group By Operator [GBY_45] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
+ <-Map 5 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_44]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_6] (rows=1 width=101)
+ Group By Operator [GBY_43] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_36] (rows=2 width=93)
+ Filter Operator [FIL_42] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 8 [SIMPLE_EDGE] llap
- SHUFFLE [RS_19]
+ <-Reducer 8 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_53]
PartitionCols:_col0
- Select Operator [SEL_16] (rows=1 width=89)
+ Select Operator [SEL_52] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=1 width=93)
+ Group By Operator [GBY_51] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_14]
+ <-Map 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_50]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=1 width=93)
+ Group By Operator [GBY_49] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_37] (rows=2 width=93)
+ Filter Operator [FIL_48] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_10] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -683,9 +683,9 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 llap
- File Output Operator [FS_26]
- Group By Operator [GBY_24] (rows=1 width=20)
+ Reducer 3 vectorized, llap
+ File Output Operator [FS_53]
+ Group By Operator [GBY_52] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_23]
@@ -695,45 +695,45 @@ Stage-0
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
Merge Join Operator [MERGEJOIN_36] (rows=1 width=20)
- Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 0)}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_17]
+ Conds:RS_39._col0=RS_45._col0(Inner),RS_45._col0=RS_51._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 0)}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_39]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=84)
+ Select Operator [SEL_38] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_33] (rows=18 width=84)
+ Filter Operator [FIL_37] (rows=18 width=84)
predicate:key is not null
TableScan [TS_0] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Reducer 5 [SIMPLE_EDGE] llap
- SHUFFLE [RS_18]
+ <-Reducer 5 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_45]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=1 width=97)
+ Select Operator [SEL_44] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_8] (rows=1 width=101)
+ Group By Operator [GBY_43] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_42]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_6] (rows=1 width=101)
+ Group By Operator [GBY_41] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_34] (rows=2 width=93)
+ Filter Operator [FIL_40] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_19]
+ <-Reducer 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_51]
PartitionCols:_col0
- Select Operator [SEL_16] (rows=1 width=89)
+ Select Operator [SEL_50] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=1 width=93)
+ Group By Operator [GBY_49] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [SIMPLE_EDGE] llap
- SHUFFLE [RS_14]
+ <-Map 6 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_48]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=1 width=93)
+ Group By Operator [GBY_47] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_35] (rows=2 width=93)
+ Filter Operator [FIL_46] (rows=2 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (c_float > 0) and key is not null)
TableScan [TS_10] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -772,50 +772,50 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 llap
- File Output Operator [FS_25]
- Select Operator [SEL_24] (rows=3 width=87)
+ Reducer 4 vectorized, llap
+ File Output Operator [FS_33]
+ Select Operator [SEL_32] (rows=3 width=87)
Output:["_col0"]
<-Union 3 [SIMPLE_EDGE]
- <-Reducer 2 [CONTAINS] llap
- Reduce Output Operator [RS_23]
- Select Operator [SEL_5] (rows=1 width=87)
+ <-Reducer 2 [CONTAINS] vectorized, llap
+ Reduce Output Operator [RS_31]
+ Select Operator [SEL_30] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_4] (rows=1 width=8)
+ Group By Operator [GBY_29] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_3]
- Group By Operator [GBY_2] (rows=1 width=8)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_28]
+ Group By Operator [GBY_27] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_1] (rows=20 width=80)
+ Select Operator [SEL_26] (rows=20 width=80)
Output:["key"]
TableScan [TS_0] (rows=20 width=80)
default@cbo_t3,s1,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 6 [CONTAINS] llap
- Reduce Output Operator [RS_23]
- Select Operator [SEL_12] (rows=1 width=87)
+ <-Reducer 6 [CONTAINS] vectorized, llap
+ Reduce Output Operator [RS_39]
+ Select Operator [SEL_38] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_11] (rows=1 width=8)
+ Group By Operator [GBY_37] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 5 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_10]
- Group By Operator [GBY_9] (rows=1 width=8)
+ <-Map 5 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_36]
+ Group By Operator [GBY_35] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_8] (rows=20 width=80)
+ Select Operator [SEL_34] (rows=20 width=80)
Output:["key"]
TableScan [TS_7] (rows=20 width=80)
default@cbo_t3,s2,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 8 [CONTAINS] llap
- Reduce Output Operator [RS_23]
- Select Operator [SEL_20] (rows=1 width=87)
+ <-Reducer 8 [CONTAINS] vectorized, llap
+ Reduce Output Operator [RS_45]
+ Select Operator [SEL_44] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_19] (rows=1 width=8)
+ Group By Operator [GBY_43] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 7 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_18]
- Group By Operator [GBY_17] (rows=1 width=8)
+ <-Map 7 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_42]
+ Group By Operator [GBY_41] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_16] (rows=20 width=80)
+ Select Operator [SEL_40] (rows=20 width=80)
Output:["key"]
TableScan [TS_15] (rows=20 width=80)
default@cbo_t3,s3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -845,63 +845,63 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 5 llap
- File Output Operator [FS_30]
- Select Operator [SEL_29] (rows=1 width=95)
+ Reducer 5 vectorized, llap
+ File Output Operator [FS_41]
+ Select Operator [SEL_40] (rows=1 width=95)
Output:["_col0","_col1"]
- <-Reducer 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_28]
- Group By Operator [GBY_26] (rows=1 width=95)
+ <-Reducer 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_39]
+ Group By Operator [GBY_38] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
<-Union 3 [SIMPLE_EDGE]
- <-Reducer 2 [CONTAINS] llap
- Reduce Output Operator [RS_25]
+ <-Reducer 2 [CONTAINS] vectorized, llap
+ Reduce Output Operator [RS_37]
PartitionCols:_col0
- Group By Operator [GBY_24] (rows=1 width=95)
+ Group By Operator [GBY_36] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_5] (rows=1 width=87)
+ Select Operator [SEL_35] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_4] (rows=1 width=8)
+ Group By Operator [GBY_34] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_3]
- Group By Operator [GBY_2] (rows=1 width=8)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_33]
+ Group By Operator [GBY_32] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_1] (rows=20 width=80)
+ Select Operator [SEL_31] (rows=20 width=80)
Output:["key"]
TableScan [TS_0] (rows=20 width=80)
default@cbo_t3,s1,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 7 [CONTAINS] llap
- Reduce Output Operator [RS_25]
+ <-Reducer 7 [CONTAINS] vectorized, llap
+ Reduce Output Operator [RS_48]
PartitionCols:_col0
- Group By Operator [GBY_24] (rows=1 width=95)
+ Group By Operator [GBY_47] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_12] (rows=1 width=87)
+ Select Operator [SEL_46] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_11] (rows=1 width=8)
+ Group By Operator [GBY_45] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 6 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_10]
- Group By Operator [GBY_9] (rows=1 width=8)
+ <-Map 6 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_44]
+ Group By Operator [GBY_43] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_8] (rows=20 width=80)
+ Select Operator [SEL_42] (rows=20 width=80)
Output:["key"]
TableScan [TS_7] (rows=20 width=80)
default@cbo_t3,s2,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 9 [CONTAINS] llap
- Reduce Output Operator [RS_25]
+ <-Reducer 9 [CONTAINS] vectorized, llap
+ Reduce Output Operator [RS_55]
PartitionCols:_col0
- Group By Operator [GBY_24] (rows=1 width=95)
+ Group By Operator [GBY_54] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_20] (rows=1 width=87)
+ Select Operator [SEL_53] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_19] (rows=1 width=8)
+ Group By Operator [GBY_52] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 8 [CUSTOM_SIMPLE_EDGE] llap
- PARTITION_ONLY_SHUFFLE [RS_18]
- Group By Operator [GBY_17] (rows=1 width=8)
+ <-Map 8 [CUSTOM_SIMPLE_EDGE] vectorized, llap
+ PARTITION_ONLY_SHUFFLE [RS_51]
+ Group By Operator [GBY_50] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_16] (rows=20 width=80)
+ Select Operator [SEL_49] (rows=20 width=80)
Output:["key"]
TableScan [TS_15] (rows=20 width=80)
default@cbo_t3,s3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -922,22 +922,22 @@ Stage-0
Reducer 2 llap
File Output Operator [FS_10]
Merge Join Operator [MERGEJOIN_15] (rows=18 width=85)
- Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_6]
+ Conds:RS_18._col0=RS_21._col0(Inner),Output:["_col0"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_18]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=6 width=85)
+ Select Operator [SEL_17] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_13] (rows=6 width=85)
+ Filter Operator [FIL_16] (rows=6 width=85)
predicate:(UDFToDouble(key) >= 1.0D)
TableScan [TS_0] (rows=20 width=80)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_21]
PartitionCols:_col0
- Select Operator [SEL_5] (rows=6 width=85)
+ Select Operator [SEL_20] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_14] (rows=6 width=85)
+ Filter Operator [FIL_19] (rows=6 width=85)
predicate:(UDFToDouble(key) >= 1.0D)
TableScan [TS_3] (rows=20 width=80)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -960,18 +960,18 @@ Stage-0
Select Operator [SEL_7] (rows=80 width=7)
Output:["_col0","_col1"]
Merge Join Operator [MERGEJOIN_11] (rows=80 width=7)
- Conds:RS_4._col0=RS_5._col0(Left Outer),Output:["_col1","_col3"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_4]
+ Conds:RS_13._col0=RS_15._col0(Left Outer),Output:["_col1","_col3"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_13]
PartitionCols:_col0
- Select Operator [SEL_1] (rows=20 width=84)
+ Select Operator [SEL_12] (rows=20 width=84)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=20 width=84)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_5]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_15]
PartitionCols:_col0
- Select Operator [SEL_3] (rows=20 width=84)
+ Select Operator [SEL_14] (rows=20 width=84)
Output:["_col0","_col1"]
TableScan [TS_2] (rows=20 width=84)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -994,18 +994,18 @@ Stage-0
Select Operator [SEL_7] (rows=80 width=7)
Output:["_col0","_col1"]
Merge Join Operator [MERGEJOIN_9] (rows=80 width=7)
- Conds:RS_4._col0=RS_5._col0(Outer),Output:["_col1","_col3"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_4]
+ Conds:RS_11._col0=RS_13._col0(Outer),Output:["_col1","_col3"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_11]
PartitionCols:_col0
- Select Operator [SEL_1] (rows=20 width=84)
+ Select Operator [SEL_10] (rows=20 width=84)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=20 width=84)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_5]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_13]
PartitionCols:_col0
- Select Operator [SEL_3] (rows=20 width=84)
+ Select Operator [SEL_12] (rows=20 width=84)
Output:["_col0","_col1"]
TableScan [TS_2] (rows=20 width=84)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -1028,31 +1028,31 @@ Stage-0
Select Operator [SEL_13] (rows=194 width=100)
Output:["_col0","_col1","_col2","_col3","_col4"]
Merge Join Operator [MERGEJOIN_24] (rows=194 width=100)
- Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col4","_col5","_col6"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_9]
+ Conds:RS_27._col0=RS_30._col0(Inner),RS_27._col0=RS_33._col0(Inner),Output:["_col1","_col2","_col4","_col5","_col6"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_27]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=87)
+ Select Operator [SEL_26] (rows=18 width=87)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_21] (rows=18 width=87)
+ Filter Operator [FIL_25] (rows=18 width=87)
predicate:key is not null
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_10]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_30]
PartitionCols:_col0
- Select Operator [SEL_5] (rows=18 width=84)
+ Select Operator [SEL_29] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_22] (rows=18 width=84)
+ Filter Operator [FIL_28] (rows=18 width=84)
predicate:key is not null
TableScan [TS_3] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_11]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_33]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=18 width=84)
+ Select Operator [SEL_32] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (rows=18 width=84)
+ Filter Operator [FIL_31] (rows=18 width=84)
predicate:key is not null
TableScan [TS_6] (rows=20 width=84)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -1075,31 +1075,31 @@ Stage-0
Select Operator [SEL_13] (rows=194 width=177)
Output:["_col0","_col1","_col2","_col3"]
Merge Join Operator [MERGEJOIN_24] (rows=194 width=177)
- Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col0","_col1","_col3","_col4"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_9]
+ Conds:RS_27._col0=RS_30._col0(Inner),RS_27._col0=RS_33._col0(Inner),Output:["_col0","_col1","_col3","_col4"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_27]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=18 width=84)
+ Select Operator [SEL_26] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_21] (rows=18 width=84)
+ Filter Operator [FIL_25] (rows=18 width=84)
predicate:key is not null
TableScan [TS_0] (rows=20 width=84)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_10]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_30]
PartitionCols:_col0
- Select Operator [SEL_5] (rows=18 width=80)
+ Select Operator [SEL_29] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_22] (rows=18 width=80)
+ Filter Operator [FIL_28] (rows=18 width=80)
predicate:key is not null
TableScan [TS_3] (rows=20 width=80)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_11]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_33]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=18 width=84)
+ Select Operator [SEL_32] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (rows=18 width=84)
+ Filter Operator [FIL_31] (rows=18 width=84)
predicate:key is not null
TableScan [TS_6] (rows=20 width=84)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -1122,31 +1122,31 @@ Stage-0
Select Operator [SEL_13] (rows=48 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"]
Merge Join Operator [MERGEJOIN_24] (rows=48 width=101)
- Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"],residual filter predicates:{((_col1 + _col4) = 2)} {((_col1 > 0) or (_col6 >= 0))}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_9]
+ Conds:RS_27._col0=RS_30._col0(Inner),RS_27._col0=RS_33._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"],residual filter predicates:{((_col1 + _col4) = 2)} {((_col1 > 0) or (_col6 >= 0))}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_27]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=8 width=93)
+ Select Operator [SEL_26] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_21] (rows=8 width=93)
+ Filter Operator [FIL_25] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_10]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_30]
PartitionCols:_col0
- Select Operator [SEL_5] (rows=8 width=89)
+ Select Operator [SEL_29] (rows=8 width=89)
Output:["_col0","_col1"]
- Filter Operator [FIL_22] (rows=8 width=93)
+ Filter Operator [FIL_28] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_11]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_33]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=18 width=84)
+ Select Operator [SEL_32] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (rows=18 width=84)
+ Filter Operator [FIL_31] (rows=18 width=84)
predicate:key is not null
TableScan [TS_6] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -1169,31 +1169,31 @@ Stage-0
Select Operator [SEL_13] (rows=48 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"]
Merge Join Operator [MERGEJOIN_24] (rows=48 width=101)
- Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"],residual filter predicates:{((_col1 + _col4) = 2)} {((_col1 > 0) or (_col6 >= 0))}
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_9]
+ Conds:RS_27._col0=RS_30._col0(Inner),RS_27._col0=RS_33._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"],residual filter predicates:{((_col1 + _col4) = 2)} {((_col1 > 0) or (_col6 >= 0))}
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_27]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=8 width=93)
+ Select Operator [SEL_26] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_21] (rows=8 width=93)
+ Filter Operator [FIL_25] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_10]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_30]
PartitionCols:_col0
- Select Operator [SEL_5] (rows=8 width=89)
+ Select Operator [SEL_29] (rows=8 width=89)
Output:["_col0","_col1"]
- Filter Operator [FIL_22] (rows=8 width=93)
+ Filter Operator [FIL_28] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_11]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_33]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=18 width=84)
+ Select Operator [SEL_32] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (rows=18 width=84)
+ Filter Operator [FIL_31] (rows=18 width=84)
predicate:key is not null
TableScan [TS_6] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -1212,24 +1212,24 @@ Stage-0
Fetch Operator
limit:1
Stage-1
- Reducer 3 llap
- File Output Operator [FS_9]
- Limit [LIM_8] (rows=1 width=97)
+ Reducer 3 vectorized, llap
+ File Output Operator [FS_18]
+ Limit [LIM_17] (rows=1 width=97)
Number of rows:1
- Select Operator [SEL_7] (rows=10 width=97)
+ Select Operator [SEL_16] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- <-Reducer 2 [SIMPLE_EDGE] llap
- SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=97)
+ <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_15]
+ Select Operator [SEL_14] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_4] (rows=10 width=101)
+ Group By Operator [GBY_13] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_3]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_12]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_2] (rows=10 width=101)
+ Group By Operator [GBY_11] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_1] (rows=20 width=88)
+ Select Operator [SEL_10] (rows=20 width=88)
Output:["key","c_int","c_float"]
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -1249,31 +1249,31 @@ Stage-0
Fetch Operator
limit:1
Stage-1
- Reducer 4 llap
- File Output Operator [FS_14]
- Limit [LIM_13] (rows=1 width=20)
+ Reducer 4 vectorized, llap
+ File Output Operator [FS_26]
+ Limit [LIM_25] (rows=1 width=20)
Number of rows:1
- Select Operator [SEL_12] (rows=5 width=20)
+ Select Operator [SEL_24] (rows=5 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_11]
- Group By Operator [GBY_9] (rows=5 width=20)
+ <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_23]
+ Group By Operator [GBY_22] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
- <-Reducer 2 [SIMPLE_EDGE] llap
- SHUFFLE [RS_8]
+ <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_21]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=5 width=20)
+ Group By Operator [GBY_20] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
- Select Operator [SEL_5] (rows=10 width=101)
+ Select Operator [SEL_19] (rows=10 width=101)
Output:["_col0","_col1"]
- Group By Operator [GBY_4] (rows=10 width=101)
+ Group By Operator [GBY_18] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_3]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_17]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_2] (rows=10 width=101)
+ Group By Operator [GBY_16] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_1] (rows=20 width=88)
+ Select Operator [SEL_15] (rows=20 width=88)
Output:["key","c_int","c_float"]
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -1309,27 +1309,27 @@ Stage-0
Fetch Operator
limit:5
Stage-1
- Reducer 4 llap
- File Output Operator [FS_13]
- Limit [LIM_12] (rows=5 width=89)
+ Reducer 4 vectorized, llap
+ File Output Operator [FS_24]
+ Limit [LIM_23] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_11] (rows=5 width=89)
+ Select Operator [SEL_22] (rows=5 width=89)
Output:["_col0","_col1"]
- <-Reducer 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_10]
- Limit [LIM_8] (rows=5 width=89)
+ <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_21]
+ Limit [LIM_20] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_7] (rows=5 width=89)
+ Select Operator [SEL_19] (rows=5 width=89)
Output:["_col0","_col1"]
- <-Reducer 2 [SIMPLE_EDGE] llap
- SHUFFLE [RS_6]
- Limit [LIM_4] (rows=5 width=89)
+ <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_18]
+ Limit [LIM_17] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_3] (rows=20 width=84)
+ Select Operator [SEL_16] (rows=20 width=84)
Output:["_col0","_col1"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=20 width=84)
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_15]
+ Select Operator [SEL_14] (rows=20 width=84)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=20 width=84)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
@@ -1353,17 +1353,17 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 6 llap
- File Output Operator [FS_42]
- Limit [LIM_40] (rows=1 width=28)
+ Reducer 6 vectorized, llap
+ File Output Operator [FS_83]
+ Limit [LIM_82] (rows=1 width=28)
Number of rows:5
- Select Operator [SEL_39] (rows=1 width=28)
+ Select Operator [SEL_81] (rows=1 width=28)
Output:["_col0","_col1","_col2"]
- <-Reducer 5 [SIMPLE_EDGE] llap
- SHUFFLE [RS_38]
- Select Operator [SEL_37] (rows=1 width=28)
+ <-Reducer 5 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_80]
+ Select Operator [SEL_79] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_36] (rows=1 width=20)
+ Group By Operator [GBY_78] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 4 [SIMPLE_EDGE] llap
SHUFFLE [RS_35]
@@ -1373,61 +1373,61 @@ Stage-0
Select Operator [SEL_33] (rows=2 width=20)
Output:["_col4","_col6"]
Merge Join Operator [MERGEJOIN_54] (rows=2 width=20)
- Conds:RS_29._col0=RS_30._col0(Inner),RS_30._col0=RS_31._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 + _col1) >= 0)} {((_col3 > 0) or (_col6 >= 0))}
- <-Map 10 [SIMPLE_EDGE] llap
- SHUFFLE [RS_31]
+ Conds:RS_64._col0=RS_74._col0(Inner),RS_74._col0=RS_77._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 + _col1) >= 0)} {((_col3 > 0) or (_col6 >= 0))}
+ <-Map 10 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_77]
PartitionCols:_col0
- Select Operator [SEL_28] (rows=18 width=84)
+ Select Operator [SEL_76] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_53] (rows=18 width=84)
+ Filter Operator [FIL_75] (rows=18 width=84)
predicate:key is not null
TableScan [TS_26] (rows=20 width=84)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
- <-Reducer 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_29]
+ <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_64]
PartitionCols:_col0
- Filter Operator [FIL_11] (rows=2 width=105)
+ Filter Operator [FIL_63] (rows=2 width=105)
predicate:_col0 is not null
- Limit [LIM_9] (rows=3 width=105)
+ Limit [LIM_62] (rows=3 width=105)
Number of rows:5
- Select Operator [SEL_8] (rows=3 width=105)
+ Select Operator [SEL_61] (rows=3 width=105)
Output:["_col0","_col1"]
- <-Reducer 2 [SIMPLE_EDGE] llap
- SHUFFLE [RS_7]
- Select Operator [SEL_6] (rows=3 width=105)
+ <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_60]
+ Select Operator [SEL_59] (rows=3 width=105)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_5] (rows=3 width=101)
+ Group By Operator [GBY_58] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_4]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_57]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_3] (rows=3 width=101)
+ Group By Operator [GBY_56] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_50] (rows=6 width=93)
+ Filter Operator [FIL_55] (rows=6 width=93)
predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)))
TableScan [TS_0] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 9 [SIMPLE_EDGE] llap
- SHUFFLE [RS_30]
+ <-Reducer 9 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_74]
PartitionCols:_col0
- Filter Operator [FIL_24] (rows=2 width=97)
+ Filter Operator [FIL_73] (rows=2 width=97)
predicate:_col0 is not null
- Limit [LIM_22] (rows=3 width=97)
+ Limit [LIM_72] (rows=3 width=97)
Number of rows:5
- Select Operator [SEL_21] (rows=3 width=97)
+ Select Operator [SEL_71] (rows=3 width=97)
Output:["_col0","_col1","_col2"]
- <-Reducer 8 [SIMPLE_EDGE] llap
- SHUFFLE [RS_20]
- Select Operator [SEL_19] (rows=3 width=97)
+ <-Reducer 8 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_70]
+ Select Operator [SEL_69] (rows=3 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_18] (rows=3 width=101)
+ Group By Operator [GBY_68] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_17]
+ <-Map 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_67]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_16] (rows=3 width=101)
+ Group By Operator [GBY_66] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_52] (rows=6 width=93)
+ Filter Operator [FIL_65] (rows=6 width=93)
predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)))
TableScan [TS_13] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
@@ -1450,24 +1450,24 @@ Stage-0
Select Operator [SEL_11] (rows=8 width=4)
Output:["_col0"]
Merge Join Operator [MERGEJOIN_17] (rows=8 width=4)
- Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col1"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_8]
+ Conds:RS_20._col0=RS_24._col0(Left Semi),Output:["_col1"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_20]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=8 width=93)
+ Select Operator [SEL_19] (rows=8 width=93)
Output:["_col0","_col1"]
- Filter Operator [FIL_15] (rows=8 width=93)
+ Filter Operator [FIL_18] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_9]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_24]
PartitionCols:_col0
- Group By Operator [GBY_7] (rows=6 width=85)
+ Group By Operator [GBY_23] (rows=6 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_5] (rows=18 width=80)
+ Select Operator [SEL_22] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_16] (rows=18 width=80)
+ Filter Operator [FIL_21] (rows=18 width=80)
predicate:key is not null
TableScan [TS_3] (rows=20 width=80)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -1490,35 +1490,35 @@ Stage-0
Select Operator [SEL_17] (rows=14 width=93)
Output:["_col0","_col1","_col2"]
Merge Join Operator [MERGEJOIN_28] (rows=14 width=93)
- Conds:RS_13._col0=RS_14._col0(Left Semi),RS_13._col0=RS_15._col0(Left Semi),Output:["_col0","_col1","_col2"]
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_13]
+ Conds:RS_31._col0=RS_35._col0(Left Semi),RS_31._col0=RS_39._col0(Left Semi),Output:["_col0","_col1","_col2"]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_31]
PartitionCols:_col0
- Select Operator [SEL_2] (rows=8 width=93)
+ Select Operator [SEL_30] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_25] (rows=8 width=93)
+ Filter Operator [FIL_29] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 3 [SIMPLE_EDGE] llap
- SHUFFLE [RS_14]
+ <-Map 3 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_35]
PartitionCols:_col0
- Group By Operator [GBY_10] (rows=3 width=85)
+ Group By Operator [GBY_34] (rows=3 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_5] (rows=8 width=85)
+ Select Operator [SEL_33] (rows=8 width=85)
Output:["_col0"]
- Filter Operator [FIL_26] (rows=8 width=93)
+ Filter Operator [FIL_32] (rows=8 width=93)
predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
TableScan [TS_3] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_15]
+ <-Map 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_39]
PartitionCols:_col0
- Group By Operator [GBY_12] (rows=7 width=85)
+ Group By Operator [GBY_38] (rows=7 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_8] (rows=18 width=80)
+ Select Operator [SEL_37] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_27] (rows=18 width=80)
+ Filter Operator [FIL_36] (rows=18 width=80)
predicate:key is not null
TableScan [TS_6] (rows=20 width=80)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -1540,15 +1540,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 5 llap
- File Output Operator [FS_34]
- Select Operator [SEL_33] (rows=1 width=101)
+ Reducer 5 vectorized, llap
+ File Output Operator [FS_68]
+ Select Operator [SEL_67] (rows=1 width=101)
Output:["_col0","_col1","_col2"]
- <-Reducer 4 [SIMPLE_EDGE] llap
- SHUFFLE [RS_32]
- Select Operator [SEL_31] (rows=1 width=101)
+ <-Reducer 4 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_66]
+ Select Operator [SEL_65] (rows=1 width=101)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_30] (rows=1 width=101)
+ Group By Operator [GBY_64] (rows=1 width=101)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_29]
@@ -1556,53 +1556,53 @@ Stage-0
Group By Operator [GBY_28] (rows=1 width=101)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
Merge Join Operator [MERGEJOIN_44] (rows=1 width=93)
- Conds:RS_23._col0=RS_24._col0(Left Semi),RS_23._col0=RS_25._col0(Left Semi),Output:["_col0","_col1"]
- <-Map 8 [SIMPLE_EDGE] llap
- SHUFFLE [RS_25]
+ Conds:RS_52._col0=RS_59._col0(Left Semi),RS_52._col0=RS_63._col0(Left Semi),Output:["_col0","_col1"]
+ <-Map 8 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_63]
PartitionCols:_col0
- Group By Operator [GBY_22] (rows=3 width=85)
+ Group By Operator [GBY_62] (rows=3 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_18] (rows=6 width=85)
+ Select Operator [SEL_61] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_43] (rows=6 width=85)
+ Filter Operator [FIL_60] (rows=6 width=85)
predicate:(UDFToDouble(key) > 0.0D)
TableScan [TS_16] (rows=20 width=80)
default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 2 [SIMPLE_EDGE] llap
- SHUFFLE [RS_23]
+ <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_52]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=1 width=93)
+ Select Operator [SEL_51] (rows=1 width=93)
Output:["_col0","_col1"]
- Filter Operator [FIL_7] (rows=1 width=101)
+ Filter Operator [FIL_50] (rows=1 width=101)
predicate:(((UDFToDouble(_col2) + UDFToDouble(_col3)) >= 0.0D) and ((UDFToDouble(_col2) >= 1.0D) or (_col3 >= 1L)))
- Select Operator [SEL_6] (rows=1 width=101)
+ Select Operator [SEL_49] (rows=1 width=101)
Output:["_col2","_col3"]
- Group By Operator [GBY_5] (rows=1 width=101)
+ Group By Operator [GBY_48] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] llap
- SHUFFLE [RS_4]
+ <-Map 1 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_47]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_3] (rows=1 width=101)
+ Group By Operator [GBY_46] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_41] (rows=1 width=93)
+ Filter Operator [FIL_45] (rows=1 width=93)
predicate:((((c_int + 1) + 1) >= 0) and (((c_int + 1) > 0) or (UDFToDouble(key) >= 0.0D)) and ((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (UDFToDouble(key) > 0.0D) and (c_float > 0))
TableScan [TS_0] (rows=20 width=88)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Reducer 7 [SIMPLE_EDGE] llap
- SHUFFLE [RS_24]
+ <-Reducer 7 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_59]
PartitionCols:_col0
- Group By Operator [GBY_20] (rows=1 width=85)
+ Group By Operator [GBY_58] (rows=1 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_15] (rows=1 width=85)
+ Select Operator [SEL_57] (rows=1 width=85)
Output:["_col0"]
- Group By Operator [GBY_14] (rows=1 width=93)
+ Group By Operator [GBY_56] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [SIMPLE_EDGE] llap
- SHUFFLE [RS_13]
+ <-Map 6 [SIMPLE_EDGE] vectorized, llap
+ SHUFFLE [RS_55]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_12] (rows=1 width=93)
+ Group By Operator [GBY_54] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_42] (rows=1 width=93)
+ Filter Operator [FIL_53] (rows=1 width=93)
predicate:(((UDFToFloat(c_int) + c_float) >= 0) and ((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and ((c_int >= 1) or (c_float >= 1)) and (UDFToDouble(key) > 0.0D) and (c_float > 0))
TableScan [TS_9] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","
<TRUNCATED>