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/29 06:45:22 UTC
[1/3] hive git commit: HIVE-19350: Vectorization: Turn off
vectorization for explainuser_1.q / spark_explainuser_1 (Matt McCline,
reviewed by Vineet Garg)
Repository: hive
Updated Branches:
refs/heads/master 8349dbde5 -> fc750ed38
http://git-wip-us.apache.org/repos/asf/hive/blob/fc750ed3/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out b/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
index ada2eb4..4a36dd4 100644
--- a/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
@@ -50,10 +50,10 @@ Stage-2
Move Operator
table:{"name:":"default.src_orc_merge_test_part"}
Stage-1
- Map 1 vectorized
- File Output Operator [FS_5]
+ Map 1
+ File Output Operator [FS_3]
table:{"name:":"default.src_orc_merge_test_part"}
- Select Operator [SEL_4] (rows=500 width=10)
+ Select Operator [SEL_1] (rows=500 width=10)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=10)
default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
@@ -83,20 +83,20 @@ Stage-2
Move Operator
table:{"name:":"default.src_orc_merge_test_part"}
Stage-1
- Reducer 2 vectorized
- File Output Operator [FS_14]
+ Reducer 2
+ File Output Operator [FS_7]
table:{"name:":"default.src_orc_merge_test_part"}
- Select Operator [SEL_13] (rows=100 width=10)
+ Select Operator [SEL_6] (rows=100 width=10)
Output:["_col0","_col1"]
- Limit [LIM_12] (rows=100 width=10)
+ Limit [LIM_5] (rows=100 width=10)
Number of rows:100
- Select Operator [SEL_11] (rows=100 width=10)
+ Select Operator [SEL_4] (rows=100 width=10)
Output:["_col0","_col1"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_10]
- Limit [LIM_9] (rows=100 width=10)
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
+ Limit [LIM_2] (rows=100 width=10)
Number of rows:100
- Select Operator [SEL_8] (rows=500 width=10)
+ Select Operator [SEL_1] (rows=500 width=10)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=10)
default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
@@ -124,15 +124,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 vectorized
- File Output Operator [FS_14]
- Group By Operator [GBY_13] (rows=1 width=16)
+ Reducer 2
+ File Output Operator [FS_8]
+ Group By Operator [GBY_6] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_12]
- Group By Operator [GBY_11] (rows=1 width=16)
+ <-Map 1 [GROUP]
+ GROUP [RS_5]
+ Group By Operator [GBY_4] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
- Select Operator [SEL_10] (rows=500 width=94)
+ Select Operator [SEL_2] (rows=500 width=94)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=94)
default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
@@ -158,15 +158,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 vectorized
- File Output Operator [FS_13]
- Group By Operator [GBY_12] (rows=1 width=8)
+ Reducer 2
+ File Output Operator [FS_7]
+ Group By Operator [GBY_5] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_11]
- Group By Operator [GBY_10] (rows=1 width=8)
+ <-Map 1 [GROUP]
+ GROUP [RS_4]
+ Group By Operator [GBY_3] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_9] (rows=500 width=94)
+ Select Operator [SEL_2] (rows=500 width=94)
TableScan [TS_0] (rows=500 width=94)
default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE
@@ -183,15 +183,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 vectorized
- File Output Operator [FS_14]
- Group By Operator [GBY_13] (rows=1 width=16)
+ Reducer 2
+ File Output Operator [FS_8]
+ Group By Operator [GBY_6] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_12]
- Group By Operator [GBY_11] (rows=1 width=16)
+ <-Map 1 [GROUP]
+ GROUP [RS_5]
+ Group By Operator [GBY_4] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
- Select Operator [SEL_10] (rows=500 width=94)
+ Select Operator [SEL_2] (rows=500 width=94)
Output:["_col0","_col1"]
TableScan [TS_0] (rows=500 width=94)
default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
@@ -234,29 +234,29 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 vectorized
- File Output Operator [FS_28]
- Group By Operator [GBY_27] (rows=1 width=8)
+ Reducer 2
+ File Output Operator [FS_15]
+ Group By Operator [GBY_13] (rows=1 width=8)
Output:["_col0"],aggregations:["sum(VALUE._col0)"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_26]
- Group By Operator [GBY_25] (rows=1 width=8)
+ <-Map 1 [GROUP]
+ GROUP [RS_12]
+ Group By Operator [GBY_11] (rows=1 width=8)
Output:["_col0"],aggregations:["sum(hash(_col0,_col1,_col2,_col3))"]
- Map Join Operator [MAPJOIN_24] (rows=27556 width=22)
+ Map Join Operator [MAPJOIN_18] (rows=27556 width=22)
Conds:(Inner),Output:["_col0","_col1","_col2","_col3"]
- <-Select Operator [SEL_23] (rows=166 width=10)
+ <-Select Operator [SEL_2] (rows=166 width=10)
Output:["_col0","_col1"]
- Filter Operator [FIL_22] (rows=166 width=10)
+ Filter Operator [FIL_16] (rows=166 width=10)
predicate:(key < 10)
TableScan [TS_0] (rows=500 width=10)
default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
Map Reduce Local Work
Stage-2
- Map 3 vectorized
- keys: [HASHTABLESINK_31]
- Select Operator [SEL_30] (rows=166 width=10)
+ Map 3
+ keys: [HASHTABLESINK_20]
+ Select Operator [SEL_5] (rows=166 width=10)
Output:["_col0","_col1"]
- Filter Operator [FIL_29] (rows=166 width=10)
+ Filter Operator [FIL_17] (rows=166 width=10)
predicate:(key < 10)
TableScan [TS_3] (rows=500 width=10)
default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
@@ -275,18 +275,18 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 2 vectorized
- File Output Operator [FS_12]
- Select Operator [SEL_11] (rows=10 width=97)
+ Reducer 2
+ File Output Operator [FS_6]
+ Select Operator [SEL_5] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_10] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [GROUP] vectorized
- GROUP [RS_9]
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_8] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_7] (rows=20 width=88)
+ Select Operator [SEL_1] (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"]
@@ -305,27 +305,27 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 vectorized
- File Output Operator [FS_21]
- Select Operator [SEL_20] (rows=5 width=20)
+ Reducer 3
+ File Output Operator [FS_11]
+ Select Operator [SEL_10] (rows=5 width=20)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_19] (rows=5 width=20)
+ Group By Operator [GBY_9] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
- <-Reducer 2 [GROUP] vectorized
- GROUP [RS_18]
+ <-Reducer 2 [GROUP]
+ GROUP [RS_8]
PartitionCols:_col0, _col1
- Group By Operator [GBY_17] (rows=5 width=20)
+ Group By Operator [GBY_7] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0, _col1
- Select Operator [SEL_16] (rows=10 width=101)
+ Select Operator [SEL_5] (rows=10 width=101)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [GROUP] vectorized
- GROUP [RS_14]
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_12] (rows=20 width=88)
+ Select Operator [SEL_1] (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"]
@@ -347,15 +347,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 vectorized
- File Output Operator [FS_54]
- Select Operator [SEL_53] (rows=1 width=20)
+ Reducer 4
+ File Output Operator [FS_31]
+ Select Operator [SEL_29] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SORT] vectorized
- SORT [RS_52]
- Select Operator [SEL_51] (rows=1 width=28)
+ <-Reducer 3 [SORT]
+ SORT [RS_28]
+ Select Operator [SEL_27] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_50] (rows=1 width=20)
+ Group By Operator [GBY_26] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [GROUP]
GROUP [RS_25]
@@ -368,44 +368,44 @@ Stage-0
predicate:(((_col3 + _col6) >= 0) and ((_col3 > 0) or (_col1 >= 0)))
Join Operator [JOIN_20] (rows=3 width=18)
Output:["_col1","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":1,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_37]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_17]
PartitionCols:_col0
- Select Operator [SEL_36] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_35] (rows=18 width=84)
+ Filter Operator [FIL_32] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_43]
+ <-Reducer 6 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_18]
PartitionCols:_col0
- Select Operator [SEL_42] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_41] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [GROUP] vectorized
- GROUP [RS_40]
+ <-Map 5 [GROUP]
+ GROUP [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_39] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_38] (rows=4 width=93)
+ Filter Operator [FIL_33] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_49]
+ <-Reducer 8 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_19]
PartitionCols:_col0
- Select Operator [SEL_48] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_47] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [GROUP] vectorized
- GROUP [RS_46]
+ <-Map 7 [GROUP]
+ GROUP [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_45] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_44] (rows=4 width=93)
+ Filter Operator [FIL_34] (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"]
@@ -427,15 +427,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 vectorized
- File Output Operator [FS_55]
- Select Operator [SEL_54] (rows=1 width=20)
+ Reducer 4
+ File Output Operator [FS_32]
+ Select Operator [SEL_30] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SORT] vectorized
- SORT [RS_53]
- Select Operator [SEL_52] (rows=1 width=28)
+ <-Reducer 3 [SORT]
+ SORT [RS_29]
+ Select Operator [SEL_28] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_51] (rows=1 width=20)
+ Group By Operator [GBY_27] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [GROUP]
GROUP [RS_26]
@@ -448,44 +448,44 @@ Stage-0
predicate:(((UDFToLong(_col1) + _col4) >= 0) and ((_col1 >= 1) or (_col4 >= 1L)) and ((_col3 + _col6) >= 0))
Join Operator [JOIN_20] (rows=3 width=18)
Output:["_col1","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":1,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_38]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_17]
PartitionCols:_col0
- Select Operator [SEL_37] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_36] (rows=18 width=84)
+ Filter Operator [FIL_33] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_44]
+ <-Reducer 6 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_18]
PartitionCols:_col0
- Select Operator [SEL_43] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_42] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [GROUP] vectorized
- GROUP [RS_41]
+ <-Map 5 [GROUP]
+ GROUP [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_40] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_39] (rows=2 width=93)
+ Filter Operator [FIL_34] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_50]
+ <-Reducer 8 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_19]
PartitionCols:_col0
- Select Operator [SEL_49] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_48] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [GROUP] vectorized
- GROUP [RS_47]
+ <-Map 7 [GROUP]
+ GROUP [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_46] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_45] (rows=2 width=93)
+ Filter Operator [FIL_35] (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"]
@@ -506,9 +506,9 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 vectorized
- File Output Operator [FS_48]
- Group By Operator [GBY_47] (rows=1 width=20)
+ Reducer 3
+ File Output Operator [FS_28]
+ Group By Operator [GBY_26] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [GROUP]
GROUP [RS_25]
@@ -521,44 +521,44 @@ Stage-0
predicate:(((_col3 + _col6) >= 2) and ((_col3 > 0) or (_col1 >= 0)))
Join Operator [JOIN_20] (rows=3 width=18)
Output:["_col1","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":1,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_34]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_17]
PartitionCols:_col0
- Select Operator [SEL_33] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_32] (rows=18 width=84)
+ Filter Operator [FIL_29] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_40]
+ <-Reducer 5 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_18]
PartitionCols:_col0
- Select Operator [SEL_39] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_38] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 4 [GROUP] vectorized
- GROUP [RS_37]
+ <-Map 4 [GROUP]
+ GROUP [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_36] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_35] (rows=2 width=93)
+ Filter Operator [FIL_30] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_46]
+ <-Reducer 7 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_19]
PartitionCols:_col0
- Select Operator [SEL_45] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_44] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [GROUP] vectorized
- GROUP [RS_43]
+ <-Map 6 [GROUP]
+ GROUP [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_42] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_41] (rows=2 width=93)
+ Filter Operator [FIL_31] (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"]
@@ -580,13 +580,13 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 vectorized
- File Output Operator [FS_53]
- Select Operator [SEL_52] (rows=1 width=20)
+ Reducer 4
+ File Output Operator [FS_31]
+ Select Operator [SEL_30] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SORT] vectorized
- SORT [RS_51]
- Group By Operator [GBY_50] (rows=1 width=20)
+ <-Reducer 3 [SORT]
+ SORT [RS_29]
+ Group By Operator [GBY_27] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [GROUP]
GROUP [RS_26]
@@ -599,44 +599,44 @@ Stage-0
predicate:(((UDFToLong(_col1) + _col4) >= 0) and ((_col1 >= 1) or (_col4 >= 1L)) and ((_col3 + _col6) >= 0))
Join Operator [JOIN_20] (rows=3 width=18)
Output:["_col1","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":1,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_37]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_17]
PartitionCols:_col0
- Select Operator [SEL_36] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_35] (rows=18 width=84)
+ Filter Operator [FIL_32] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_43]
+ <-Reducer 6 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_18]
PartitionCols:_col0
- Select Operator [SEL_42] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_41] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [GROUP] vectorized
- GROUP [RS_40]
+ <-Map 5 [GROUP]
+ GROUP [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_39] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_38] (rows=2 width=93)
+ Filter Operator [FIL_33] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_49]
+ <-Reducer 8 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_19]
PartitionCols:_col0
- Select Operator [SEL_48] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_47] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [GROUP] vectorized
- GROUP [RS_46]
+ <-Map 7 [GROUP]
+ GROUP [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_45] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_44] (rows=2 width=93)
+ Filter Operator [FIL_34] (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"]
@@ -657,9 +657,9 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 vectorized
- File Output Operator [FS_48]
- Group By Operator [GBY_47] (rows=1 width=20)
+ Reducer 3
+ File Output Operator [FS_28]
+ Group By Operator [GBY_26] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 2 [GROUP]
GROUP [RS_25]
@@ -672,44 +672,44 @@ Stage-0
predicate:(((_col3 + _col6) >= 0) and ((_col3 > 0) or (_col1 >= 0)))
Join Operator [JOIN_20] (rows=3 width=18)
Output:["_col1","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":1,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_34]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_17]
PartitionCols:_col0
- Select Operator [SEL_33] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_32] (rows=18 width=84)
+ Filter Operator [FIL_29] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_40]
+ <-Reducer 5 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_18]
PartitionCols:_col0
- Select Operator [SEL_39] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_38] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 4 [GROUP] vectorized
- GROUP [RS_37]
+ <-Map 4 [GROUP]
+ GROUP [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_36] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_35] (rows=2 width=93)
+ Filter Operator [FIL_30] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_46]
+ <-Reducer 7 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_19]
PartitionCols:_col0
- Select Operator [SEL_45] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_44] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [GROUP] vectorized
- GROUP [RS_43]
+ <-Map 6 [GROUP]
+ GROUP [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_42] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_41] (rows=2 width=93)
+ Filter Operator [FIL_31] (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"]
@@ -748,49 +748,49 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 vectorized
- File Output Operator [FS_45]
- Select Operator [SEL_44] (rows=3 width=87)
+ Reducer 3
+ File Output Operator [FS_25]
+ Select Operator [SEL_24] (rows=3 width=87)
Output:["_col0"]
- <-Reducer 2 [SORT] vectorized
- SORT [RS_31]
- Select Operator [SEL_30] (rows=1 width=87)
+ <-Reducer 2 [SORT]
+ SORT [RS_23]
+ Select Operator [SEL_5] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_29] (rows=1 width=8)
+ Group By Operator [GBY_4] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_28]
- Group By Operator [GBY_27] (rows=1 width=8)
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
+ Group By Operator [GBY_2] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_26] (rows=20 width=80)
+ Select Operator [SEL_1] (rows=20 width=80)
Output:["key"]
TableScan [TS_0] (rows=20 width=80)
default@cbo_t3,s1,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 5 [SORT] vectorized
- SORT [RS_37]
- Select Operator [SEL_36] (rows=1 width=87)
+ <-Reducer 5 [SORT]
+ SORT [RS_23]
+ Select Operator [SEL_12] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_35] (rows=1 width=8)
+ Group By Operator [GBY_11] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 4 [GROUP] vectorized
- GROUP [RS_34]
- Group By Operator [GBY_33] (rows=1 width=8)
+ <-Map 4 [GROUP]
+ GROUP [RS_10]
+ Group By Operator [GBY_9] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_32] (rows=20 width=80)
+ Select Operator [SEL_8] (rows=20 width=80)
Output:["key"]
TableScan [TS_7] (rows=20 width=80)
default@cbo_t3,s2,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
- <-Reducer 7 [SORT] vectorized
- SORT [RS_43]
- Select Operator [SEL_42] (rows=1 width=87)
+ <-Reducer 7 [SORT]
+ SORT [RS_23]
+ Select Operator [SEL_20] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_41] (rows=1 width=8)
+ Group By Operator [GBY_19] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 6 [GROUP] vectorized
- GROUP [RS_40]
- Group By Operator [GBY_39] (rows=1 width=8)
+ <-Map 6 [GROUP]
+ GROUP [RS_18]
+ Group By Operator [GBY_17] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_38] (rows=20 width=80)
+ Select Operator [SEL_16] (rows=20 width=80)
Output:["key"]
TableScan [TS_15] (rows=20 width=80)
default@cbo_t3,s3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -820,62 +820,62 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 4 vectorized
- File Output Operator [FS_55]
- Select Operator [SEL_54] (rows=1 width=95)
+ Reducer 4
+ File Output Operator [FS_30]
+ Select Operator [SEL_29] (rows=1 width=95)
Output:["_col0","_col1"]
- <-Reducer 3 [SORT] vectorized
- SORT [RS_53]
- Group By Operator [GBY_52] (rows=1 width=95)
+ <-Reducer 3 [SORT]
+ SORT [RS_28]
+ Group By Operator [GBY_26] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
- <-Reducer 2 [GROUP] vectorized
- GROUP [RS_37]
+ <-Reducer 2 [GROUP]
+ GROUP [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_36] (rows=1 width=95)
+ Group By Operator [GBY_24] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_35] (rows=1 width=87)
+ Select Operator [SEL_5] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_34] (rows=1 width=8)
+ Group By Operator [GBY_4] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [GROUP] vectorized
- GROUP [RS_33]
- Group By Operator [GBY_32] (rows=1 width=8)
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
+ Group By Operator [GBY_2] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_31] (rows=20 width=80)
+ Select Operator [SEL_1] (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 [GROUP] vectorized
- GROUP [RS_44]
+ <-Reducer 6 [GROUP]
+ GROUP [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_43] (rows=1 width=95)
+ Group By Operator [GBY_24] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_42] (rows=1 width=87)
+ Select Operator [SEL_12] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_41] (rows=1 width=8)
+ Group By Operator [GBY_11] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 5 [GROUP] vectorized
- GROUP [RS_40]
- Group By Operator [GBY_39] (rows=1 width=8)
+ <-Map 5 [GROUP]
+ GROUP [RS_10]
+ Group By Operator [GBY_9] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_38] (rows=20 width=80)
+ Select Operator [SEL_8] (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 [GROUP] vectorized
- GROUP [RS_51]
+ <-Reducer 8 [GROUP]
+ GROUP [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_50] (rows=1 width=95)
+ Group By Operator [GBY_24] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_49] (rows=1 width=87)
+ Select Operator [SEL_20] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_48] (rows=1 width=8)
+ Group By Operator [GBY_19] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 7 [GROUP] vectorized
- GROUP [RS_47]
- Group By Operator [GBY_46] (rows=1 width=8)
+ <-Map 7 [GROUP]
+ GROUP [RS_18]
+ Group By Operator [GBY_17] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_45] (rows=20 width=80)
+ Select Operator [SEL_16] (rows=20 width=80)
Output:["key"]
TableScan [TS_15] (rows=20 width=80)
default@cbo_t3,s3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
@@ -897,21 +897,21 @@ Stage-0
File Output Operator [FS_10]
Join Operator [JOIN_8] (rows=18 width=85)
Output:["_col0"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"}],keys:{"0":"_col0","1":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_15]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_6]
PartitionCols:_col0
- Select Operator [SEL_14] (rows=6 width=85)
+ Select Operator [SEL_2] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_13] (rows=6 width=85)
+ Filter Operator [FIL_11] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_18]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_7]
PartitionCols:_col0
- Select Operator [SEL_17] (rows=6 width=85)
+ Select Operator [SEL_5] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_16] (rows=6 width=85)
+ Filter Operator [FIL_12] (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"]
@@ -935,17 +935,17 @@ Stage-0
Output:["_col0","_col1"]
Join Operator [JOIN_6] (rows=80 width=7)
Output:["_col1","_col3"],condition map:[{"":"{\"type\":\"Left Outer\",\"left\":0,\"right\":1}"}],keys:{"0":"_col0","1":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_10]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_4]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=20 width=84)
+ Select Operator [SEL_1] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_12]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_5]
PartitionCols:_col0
- Select Operator [SEL_11] (rows=20 width=84)
+ Select Operator [SEL_3] (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"]
@@ -969,17 +969,17 @@ Stage-0
Output:["_col0","_col1"]
Join Operator [JOIN_6] (rows=80 width=7)
Output:["_col1","_col3"],condition map:[{"":"{\"type\":\"Outer\",\"left\":0,\"right\":1}"}],keys:{"0":"_col0","1":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_10]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_4]
PartitionCols:_col0
- Select Operator [SEL_9] (rows=20 width=84)
+ Select Operator [SEL_1] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_12]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_5]
PartitionCols:_col0
- Select Operator [SEL_11] (rows=20 width=84)
+ Select Operator [SEL_3] (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"]
@@ -1003,30 +1003,30 @@ Stage-0
Output:["_col0","_col1","_col2","_col3","_col4"]
Join Operator [JOIN_12] (rows=194 width=100)
Output:["_col1","_col2","_col4","_col5","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_20]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_9]
PartitionCols:_col0
- Select Operator [SEL_19] (rows=18 width=87)
+ Select Operator [SEL_2] (rows=18 width=87)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_18] (rows=18 width=87)
+ Filter Operator [FIL_15] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_23]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_10]
PartitionCols:_col0
- Select Operator [SEL_22] (rows=18 width=84)
+ Select Operator [SEL_5] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_21] (rows=18 width=84)
+ Filter Operator [FIL_16] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_26]
+ <-Map 4 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_11]
PartitionCols:_col0
- Select Operator [SEL_25] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_24] (rows=18 width=84)
+ Filter Operator [FIL_17] (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"]
@@ -1050,30 +1050,30 @@ Stage-0
Output:["_col0","_col1","_col2","_col3"]
Join Operator [JOIN_12] (rows=194 width=177)
Output:["_col0","_col1","_col3","_col4"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_20]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_9]
PartitionCols:_col0
- Select Operator [SEL_19] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_18] (rows=18 width=84)
+ Filter Operator [FIL_15] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_23]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_10]
PartitionCols:_col0
- Select Operator [SEL_22] (rows=18 width=80)
+ Select Operator [SEL_5] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_21] (rows=18 width=80)
+ Filter Operator [FIL_16] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_26]
+ <-Map 4 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_11]
PartitionCols:_col0
- Select Operator [SEL_25] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_24] (rows=18 width=84)
+ Filter Operator [FIL_17] (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"]
@@ -1099,30 +1099,30 @@ Stage-0
predicate:(((_col1 + _col4) = 2) and ((_col1 > 0) or (_col6 >= 0)))
Join Operator [JOIN_12] (rows=96 width=100)
Output:["_col1","_col2","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_22]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_9]
PartitionCols:_col0
- Select Operator [SEL_21] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_20] (rows=8 width=93)
+ Filter Operator [FIL_17] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_25]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_10]
PartitionCols:_col0
- Select Operator [SEL_24] (rows=8 width=89)
+ Select Operator [SEL_5] (rows=8 width=89)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (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_3] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 4 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_28]
+ <-Map 4 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_11]
PartitionCols:_col0
- Select Operator [SEL_27] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_26] (rows=18 width=84)
+ Filter Operator [FIL_19] (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"]
@@ -1148,30 +1148,30 @@ Stage-0
predicate:(((_col1 + _col4) = 2) and ((_col1 > 0) or (_col6 >= 0)))
Join Operator [JOIN_12] (rows=96 width=100)
Output:["_col1","_col2","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":0,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_22]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_9]
PartitionCols:_col0
- Select Operator [SEL_21] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_20] (rows=8 width=93)
+ Filter Operator [FIL_17] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_25]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_10]
PartitionCols:_col0
- Select Operator [SEL_24] (rows=8 width=89)
+ Select Operator [SEL_5] (rows=8 width=89)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (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_3] (rows=20 width=88)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
- <-Map 4 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_28]
+ <-Map 4 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_11]
PartitionCols:_col0
- Select Operator [SEL_27] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_26] (rows=18 width=84)
+ Filter Operator [FIL_19] (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"]
@@ -1190,24 +1190,24 @@ Stage-0
Fetch Operator
limit:1
Stage-1
- Reducer 3 vectorized
- File Output Operator [FS_18]
- Limit [LIM_17] (rows=1 width=97)
+ Reducer 3
+ File Output Operator [FS_9]
+ Limit [LIM_8] (rows=1 width=97)
Number of rows:1
- Select Operator [SEL_16] (rows=10 width=97)
+ Select Operator [SEL_7] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- <-Reducer 2 [SORT] vectorized
- SORT [RS_15]
- Select Operator [SEL_14] (rows=10 width=97)
+ <-Reducer 2 [SORT]
+ SORT [RS_6]
+ Select Operator [SEL_5] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_13] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [GROUP] vectorized
- GROUP [RS_12]
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_11] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_10] (rows=20 width=88)
+ Select Operator [SEL_1] (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"]
@@ -1227,31 +1227,31 @@ Stage-0
Fetch Operator
limit:1
Stage-1
- Reducer 4 vectorized
- File Output Operator [FS_26]
- Limit [LIM_25] (rows=1 width=20)
+ Reducer 4
+ File Output Operator [FS_14]
+ Limit [LIM_13] (rows=1 width=20)
Number of rows:1
- Select Operator [SEL_24] (rows=5 width=20)
+ Select Operator [SEL_12] (rows=5 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SORT] vectorized
- SORT [RS_23]
- Group By Operator [GBY_22] (rows=5 width=20)
+ <-Reducer 3 [SORT]
+ SORT [RS_11]
+ Group By Operator [GBY_9] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
- <-Reducer 2 [GROUP] vectorized
- GROUP [RS_21]
+ <-Reducer 2 [GROUP]
+ GROUP [RS_8]
PartitionCols:_col0, _col1
- Group By Operator [GBY_20] (rows=5 width=20)
+ Group By Operator [GBY_7] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
- Select Operator [SEL_19] (rows=10 width=101)
+ Select Operator [SEL_5] (rows=10 width=101)
Output:["_col0","_col1"]
- Group By Operator [GBY_18] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [GROUP] vectorized
- GROUP [RS_17]
+ <-Map 1 [GROUP]
+ GROUP [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_16] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_15] (rows=20 width=88)
+ Select Operator [SEL_1] (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"]
@@ -1287,27 +1287,27 @@ Stage-0
Fetch Operator
limit:5
Stage-1
- Reducer 4 vectorized
- File Output Operator [FS_24]
- Limit [LIM_23] (rows=5 width=89)
+ Reducer 4
+ File Output Operator [FS_13]
+ Limit [LIM_12] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_22] (rows=5 width=89)
+ Select Operator [SEL_11] (rows=5 width=89)
Output:["_col0","_col1"]
- <-Reducer 3 [SORT] vectorized
- SORT [RS_21]
- Limit [LIM_20] (rows=5 width=89)
+ <-Reducer 3 [SORT]
+ SORT [RS_10]
+ Limit [LIM_8] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_19] (rows=5 width=89)
+ Select Operator [SEL_7] (rows=5 width=89)
Output:["_col0","_col1"]
- <-Reducer 2 [SORT] vectorized
- SORT [RS_18]
- Limit [LIM_17] (rows=5 width=89)
+ <-Reducer 2 [SORT]
+ SORT [RS_6]
+ Limit [LIM_4] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_16] (rows=20 width=84)
+ Select Operator [SEL_3] (rows=20 width=84)
Output:["_col0","_col1"]
- <-Map 1 [SORT] vectorized
- SORT [RS_15]
- Select Operator [SEL_14] (rows=20 width=84)
+ <-Map 1 [SORT]
+ SORT [RS_2]
+ Select Operator [SEL_1] (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"]
@@ -1331,17 +1331,17 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 6 vectorized
- File Output Operator [FS_76]
- Limit [LIM_75] (rows=1 width=28)
+ Reducer 6
+ File Output Operator [FS_44]
+ Limit [LIM_42] (rows=1 width=28)
Number of rows:5
- Select Operator [SEL_74] (rows=1 width=28)
+ Select Operator [SEL_41] (rows=1 width=28)
Output:["_col0","_col1","_col2"]
- <-Reducer 5 [SORT] vectorized
- SORT [RS_73]
- Select Operator [SEL_72] (rows=1 width=28)
+ <-Reducer 5 [SORT]
+ SORT [RS_40]
+ Select Operator [SEL_39] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_71] (rows=1 width=20)
+ Group By Operator [GBY_38] (rows=1 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 4 [GROUP]
GROUP [RS_37]
@@ -1354,60 +1354,60 @@ Stage-0
predicate:(((_col3 + _col1) >= 0) and ((_col3 > 0) or (_col6 >= 0)))
Join Operator [JOIN_32] (rows=6 width=19)
Output:["_col1","_col3","_col4","_col6"],condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Inner\",\"left\":1,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 10 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_70]
+ <-Map 10 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_31]
PartitionCols:_col0
- Select Operator [SEL_69] (rows=18 width=84)
+ Select Operator [SEL_28] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_68] (rows=18 width=84)
+ Filter Operator [FIL_47] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_57]
+ <-Reducer 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_29]
PartitionCols:_col0
- Filter Operator [FIL_56] (rows=2 width=105)
+ Filter Operator [FIL_11] (rows=2 width=105)
predicate:_col0 is not null
- Limit [LIM_55] (rows=3 width=105)
+ Limit [LIM_9] (rows=3 width=105)
Number of rows:5
- Select Operator [SEL_54] (rows=3 width=105)
+ Select Operator [SEL_8] (rows=3 width=105)
Output:["_col0","_col1"]
- <-Reducer 2 [SORT] vectorized
- SORT [RS_53]
- Select Operator [SEL_52] (rows=3 width=105)
+ <-Reducer 2 [SORT]
+ SORT [RS_7]
+ Select Operator [SEL_6] (rows=3 width=105)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_51] (rows=3 width=101)
+ Group By Operator [GBY_5] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [GROUP] vectorized
- GROUP [RS_50]
+ <-Map 1 [GROUP]
+ GROUP [RS_4]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_49] (rows=3 width=101)
+ Group By Operator [GBY_3] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_48] (rows=6 width=93)
+ Filter Operator [FIL_45] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_67]
+ <-Reducer 9 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_30]
PartitionCols:_col0
- Filter Operator [FIL_66] (rows=2 width=97)
+ Filter Operator [FIL_24] (rows=2 width=97)
predicate:_col0 is not null
- Limit [LIM_65] (rows=3 width=97)
+ Limit [LIM_22] (rows=3 width=97)
Number of rows:5
- Select Operator [SEL_64] (rows=3 width=97)
+ Select Operator [SEL_21] (rows=3 width=97)
Output:["_col0","_col1","_col2"]
- <-Reducer 8 [SORT] vectorized
- SORT [RS_63]
- Select Operator [SEL_62] (rows=3 width=97)
+ <-Reducer 8 [SORT]
+ SORT [RS_20]
+ Select Operator [SEL_19] (rows=3 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_61] (rows=3 width=101)
+ Group By Operator [GBY_18] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [GROUP] vectorized
- GROUP [RS_60]
+ <-Map 7 [GROUP]
+ GROUP [RS_17]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_59] (rows=3 width=101)
+ Group By Operator [GBY_16] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_58] (rows=6 width=93)
+ Filter Operator [FIL_46] (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"]
@@ -1431,23 +1431,23 @@ Stage-0
Output:["_col0"]
Join Operator [JOIN_10] (rows=8 width=4)
Output:["_col1"],condition map:[{"":"{\"type\":\"Left Semi\",\"left\":0,\"right\":1}"}],keys:{"0":"_col0","1":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_17]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_8]
PartitionCols:_col0
- Select Operator [SEL_16] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1"]
- Filter Operator [FIL_15] (rows=8 width=93)
+ Filter Operator [FIL_13] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_21]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_9]
PartitionCols:_col0
- Group By Operator [GBY_20] (rows=6 width=85)
+ Group By Operator [GBY_7] (rows=6 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_19] (rows=18 width=80)
+ Select Operator [SEL_5] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_18] (rows=18 width=80)
+ Filter Operator [FIL_14] (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"]
@@ -1471,34 +1471,34 @@ Stage-0
Output:["_col0","_col1","_col2"]
Join Operator [JOIN_16] (rows=14 width=93)
Output:["_col0","_col1","_col2"],condition map:[{"":"{\"type\":\"Left Semi\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Left Semi\",\"left\":0,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_24]
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_13]
PartitionCols:_col0
- Select Operator [SEL_23] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_22] (rows=8 width=93)
+ Filter Operator [FIL_19] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_28]
+ <-Map 3 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_14]
PartitionCols:_col0
- Group By Operator [GBY_27] (rows=3 width=85)
+ Group By Operator [GBY_10] (rows=3 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_26] (rows=8 width=85)
+ Select Operator [SEL_5] (rows=8 width=85)
Output:["_col0"]
- Filter Operator [FIL_25] (rows=8 width=93)
+ Filter Operator [FIL_20] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_32]
+ <-Map 4 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_15]
PartitionCols:_col0
- Group By Operator [GBY_31] (rows=7 width=85)
+ Group By Operator [GBY_12] (rows=7 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_30] (rows=18 width=80)
+ Select Operator [SEL_8] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_29] (rows=18 width=80)
+ Filter Operator [FIL_21] (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"]
@@ -1520,15 +1520,15 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 5 vectorized
- File Output Operator [FS_61]
- Select Operator [SEL_60] (rows=1 width=101)
+ Reducer 5
+ File Output Operator [FS_34]
+ Select Operator [SEL_33] (rows=1 width=101)
Output:["_col0","_col1","_col2"]
- <-Reducer 4 [SORT] vectorized
- SORT [RS_59]
- Select Operator [SEL_58] (rows=1 width=101)
+ <-Reducer 4 [SORT]
+ SORT [RS_32]
+ Select Operator [SEL_31] (rows=1 width=101)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_57] (rows=1 width=101)
+ Group By Operator [GBY_30] (rows=1 width=101)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
<-Reducer 3 [GROUP]
GROUP [RS_29]
@@ -1537,52 +1537,52 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
Join Operator [JOIN_26] (rows=1 width=93)
Output:["_col0","_col1"],condition map:[{"":"{\"type\":\"Left Semi\",\"left\":0,\"right\":1}"},{"":"{\"type\":\"Left Semi\",\"left\":0,\"right\":2}"}],keys:{"0":"_col0","1":"_col0","2":"_col0"}
- <-Map 8 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_56]
+ <-Map 8 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_55] (rows=3 width=85)
+ Group By Operator [GBY_22] (rows=3 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_54] (rows=6 width=85)
+ Select Operator [SEL_18] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_53] (rows=6 width=85)
+ Filter Operator [FIL_37] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_45]
+ <-Reducer 2 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_23]
PartitionCols:_col0
- Select Operator [SEL_44] (rows=1 width=93)
+ Select Operator [SEL_8] (rows=1 width=93)
Output:["_col0","_col1"]
- Filter Operator [FIL_43] (rows=1 width=101)
+ Filter Operator [FIL_7] (rows=1 width=101)
predicate:(((UDFToDouble(_col2) + UDFToDouble(_col3)) >= 0.0D) and ((UDFToDouble(_col2) >= 1.0D) or (_col3 >= 1L)))
- Select Operator [SEL_42] (rows=1 width=101)
+ Select Operator [SEL_6] (rows=1 width=101)
Output:["_col2","_col3"]
- Group By Operator [GBY_41] (rows=1 width=101)
+ Group By Operator [GBY_5] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [GROUP] vectorized
- GROUP [RS_40]
+ <-Map 1 [GROUP]
+ GROUP [RS_4]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_39] (rows=1 width=101)
+ Group By Operator [GBY_3] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_38] (rows=1 width=93)
+ Filter Operator [FIL_35] (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 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_52]
+ <-Reducer 7 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_24]
PartitionCols:_col0
- Group By Operator [GBY_51] (rows=1 width=85)
+ Group By Operator [GBY_20] (rows=1 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_50] (rows=1 width=85)
+ Select Operator [SEL_15] (rows=1 width=85)
Output:["_col0"]
- Group By Operator [GBY_49] (rows=1 width=93)
+ Group By Operator [GBY_14] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [GROUP] vectorized
- GROUP [RS_48]
+ <-Map 6 [GROUP]
+ GROUP [RS_13]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_47] (rows=1 width=93)
+ Group By Operator [GBY_12] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_46] (rows=1 width=93)
+ Filter Operator [FIL_36] (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","c_float"]
@@ -1644,9 +1644,9 @@ Stage-0
Fetch Operator
limit:-1
Stage-1
- Reducer 3 vectorized
- File Output Operator [FS_23]
- Group By Operator [GBY_22] (rows=1 width=8)
+ Reducer 3
+ File Output Operator [FS_15]
+ Group By Operator [GBY_13] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Reducer 2 [GROUP]
GROUP [RS_12]
@@ -1654,14 +1654,14 @@ Stage-0
Output:["_col0"],aggregations:["count('2014')"]
Join Operator [JOIN_8] (rows=400 width=8)
condition map:[{"":"{\"type\":\"Inner\",\"left\":0,\"right\":1}"}],keys:{}
- <-Map 1 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_19]
- Select Operator [SEL_18] (rows=20 width=88)
+ <-Map 1 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_6]
+ Select Operator [SEL_2] (rows=20 width=88)
TableScan [TS_0] (rows=20 width=21)
default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE
- <-Map 4 [PARTITION-LEVEL SORT] vectorized
- PARTITION-LEVEL SORT [RS_21]
- Select Operator [SEL_20] (rows=20 width=88)
+ <-Map 4 [PARTITION-LEVEL SORT]
+ PARTITION-LEVEL SORT [RS_7]
+ Select Operator [SEL_5] (rows=20 width=88)
TableScan [TS_3] (rows=20 width=21)
default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE
@@ -1699,30 +1699,30 @@ Stage-0
predicate:_col3 is null
Join Operator [JOIN_16] (rows=500 width=179)
Output:["_col0","_col1","_col3"],condition map:[{"":"{\"type\":\"Left Outer\",\"left\":0,\"right\":1}"}],keys:{"0":"_col1
<TRUNCATED>
[3/3] hive git commit: HIVE-19350: Vectorization: Turn off
vectorization for explainuser_1.q / spark_explainuser_1 (Matt McCline,
reviewed by Vineet Garg)
Posted by mm...@apache.org.
HIVE-19350: Vectorization: Turn off vectorization for explainuser_1.q / spark_explainuser_1 (Matt McCline, reviewed by Vineet Garg)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/fc750ed3
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/fc750ed3
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/fc750ed3
Branch: refs/heads/master
Commit: fc750ed38570940df567fe94297c44387d053301
Parents: 8349dbd
Author: Matt McCline <mm...@hortonworks.com>
Authored: Sun Apr 29 01:45:13 2018 -0500
Committer: Matt McCline <mm...@hortonworks.com>
Committed: Sun Apr 29 01:45:13 2018 -0500
----------------------------------------------------------------------
.../test/queries/clientpositive/explainuser_1.q | 1 +
.../clientpositive/spark_explainuser_1.q | 1 +
.../clientpositive/llap/explainuser_1.q.out | 2408 +++++++++---------
.../spark/spark_explainuser_1.q.out | 2288 ++++++++---------
4 files changed, 2350 insertions(+), 2348 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/fc750ed3/ql/src/test/queries/clientpositive/explainuser_1.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/explainuser_1.q b/ql/src/test/queries/clientpositive/explainuser_1.q
index 9675989..0772fb9 100644
--- a/ql/src/test/queries/clientpositive/explainuser_1.q
+++ b/ql/src/test/queries/clientpositive/explainuser_1.q
@@ -7,6 +7,7 @@
--! qt:dataset:cbo_t3
--! qt:dataset:cbo_t2
--! qt:dataset:cbo_t1
+set hive.vectorized.execution.enabled=false;
set hive.strict.checks.bucketing=false;
set hive.mapred.mode=nonstrict;
http://git-wip-us.apache.org/repos/asf/hive/blob/fc750ed3/ql/src/test/queries/clientpositive/spark_explainuser_1.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/spark_explainuser_1.q b/ql/src/test/queries/clientpositive/spark_explainuser_1.q
index 92e6554..7a11665 100644
--- a/ql/src/test/queries/clientpositive/spark_explainuser_1.q
+++ b/ql/src/test/queries/clientpositive/spark_explainuser_1.q
@@ -7,6 +7,7 @@
--! qt:dataset:cbo_t3
--! qt:dataset:cbo_t2
--! qt:dataset:cbo_t1
+set hive.vectorized.execution.enabled=false;
set hive.strict.checks.bucketing=false;
set hive.mapred.mode=nonstrict;
[2/3] hive git commit: HIVE-19350: Vectorization: Turn off
vectorization for explainuser_1.q / spark_explainuser_1 (Matt McCline,
reviewed by Vineet Garg)
Posted by mm...@apache.org.
http://git-wip-us.apache.org/repos/asf/hive/blob/fc750ed3/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 9827d3b..872f9c9 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] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_10]
- Limit [LIM_9] (rows=100 width=178)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_3]
+ Limit [LIM_2] (rows=100 width=178)
Number of rows:100
- Select Operator [SEL_8] (rows=500 width=178)
+ Select Operator [SEL_1] (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 vectorized, llap
- File Output Operator [FS_14]
- Group By Operator [GBY_13] (rows=1 width=16)
+ Reducer 2 llap
+ File Output Operator [FS_8]
+ Group By Operator [GBY_6] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_12]
- Group By Operator [GBY_11] (rows=1 width=16)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_5]
+ Group By Operator [GBY_4] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
- Select Operator [SEL_10] (rows=500 width=95)
+ Select Operator [SEL_2] (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 vectorized, llap
- File Output Operator [FS_13]
- Group By Operator [GBY_12] (rows=1 width=8)
+ Reducer 2 llap
+ File Output Operator [FS_7]
+ Group By Operator [GBY_5] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_11]
- Group By Operator [GBY_10] (rows=1 width=8)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_4]
+ Group By Operator [GBY_3] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Select Operator [SEL_9] (rows=500 width=102)
+ Select Operator [SEL_2] (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 vectorized, llap
- File Output Operator [FS_14]
- Group By Operator [GBY_13] (rows=1 width=16)
+ Reducer 2 llap
+ File Output Operator [FS_8]
+ Group By Operator [GBY_6] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_12]
- Group By Operator [GBY_11] (rows=1 width=16)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_5]
+ Group By Operator [GBY_4] (rows=1 width=16)
Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
- Select Operator [SEL_10] (rows=500 width=95)
+ Select Operator [SEL_2] (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 vectorized, llap
- File Output Operator [FS_26]
- Group By Operator [GBY_25] (rows=1 width=8)
+ Reducer 3 llap
+ File Output Operator [FS_15]
+ Group By Operator [GBY_13] (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] vectorized, llap
- XPROD_EDGE [RS_21]
- Select Operator [SEL_20] (rows=166 width=178)
+ <-Map 1 [XPROD_EDGE] llap
+ XPROD_EDGE [RS_6]
+ Select Operator [SEL_2] (rows=166 width=178)
Output:["_col0","_col1"]
- Filter Operator [FIL_19] (rows=166 width=178)
+ Filter Operator [FIL_16] (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] vectorized, llap
- XPROD_EDGE [RS_24]
- Select Operator [SEL_23] (rows=166 width=178)
+ <-Map 4 [XPROD_EDGE] llap
+ XPROD_EDGE [RS_7]
+ Select Operator [SEL_5] (rows=166 width=178)
Output:["_col0","_col1"]
- Filter Operator [FIL_22] (rows=166 width=178)
+ Filter Operator [FIL_17] (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 vectorized, llap
- File Output Operator [FS_12]
- Select Operator [SEL_11] (rows=10 width=97)
+ Reducer 2 llap
+ File Output Operator [FS_6]
+ Select Operator [SEL_5] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_10] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_9]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_8] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_7] (rows=20 width=88)
+ Select Operator [SEL_1] (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 vectorized, llap
- File Output Operator [FS_21]
- Select Operator [SEL_20] (rows=5 width=20)
+ Reducer 3 llap
+ File Output Operator [FS_11]
+ Select Operator [SEL_10] (rows=5 width=20)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_19] (rows=5 width=20)
+ Group By Operator [GBY_9] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
- <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_18]
+ <-Reducer 2 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_8]
PartitionCols:_col0, _col1
- Group By Operator [GBY_17] (rows=5 width=20)
+ Group By Operator [GBY_7] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0, _col1
- Select Operator [SEL_16] (rows=10 width=101)
+ Select Operator [SEL_5] (rows=10 width=101)
Output:["_col0","_col1"]
- Group By Operator [GBY_15] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_14]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_13] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_12] (rows=20 width=88)
+ Select Operator [SEL_1] (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 vectorized, llap
- File Output Operator [FS_59]
- Select Operator [SEL_58] (rows=1 width=20)
+ Reducer 4 llap
+ File Output Operator [FS_29]
+ Select Operator [SEL_27] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_57]
- Select Operator [SEL_56] (rows=1 width=28)
+ <-Reducer 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_26]
+ Select Operator [SEL_25] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_55] (rows=1 width=20)
+ Group By Operator [GBY_24] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_41] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_40] (rows=18 width=84)
+ Filter Operator [FIL_36] (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] vectorized, llap
- SHUFFLE [RS_48]
+ <-Reducer 6 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
PartitionCols:_col0
- Select Operator [SEL_47] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_46] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_45]
+ <-Map 5 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_44] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_43] (rows=4 width=93)
+ Filter Operator [FIL_37] (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] vectorized, llap
- SHUFFLE [RS_54]
+ <-Reducer 8 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_19]
PartitionCols:_col0
- Select Operator [SEL_53] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_52] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_51]
+ <-Map 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_50] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_49] (rows=4 width=93)
+ Filter Operator [FIL_38] (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 vectorized, llap
- File Output Operator [FS_59]
- Select Operator [SEL_58] (rows=1 width=20)
+ Reducer 4 llap
+ File Output Operator [FS_29]
+ Select Operator [SEL_27] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_57]
- Select Operator [SEL_56] (rows=1 width=28)
+ <-Reducer 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_26]
+ Select Operator [SEL_25] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_55] (rows=1 width=20)
+ Group By Operator [GBY_24] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_41] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_40] (rows=18 width=84)
+ Filter Operator [FIL_36] (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] vectorized, llap
- SHUFFLE [RS_48]
+ <-Reducer 6 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
PartitionCols:_col0
- Select Operator [SEL_47] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_46] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_45]
+ <-Map 5 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_44] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_43] (rows=2 width=93)
+ Filter Operator [FIL_37] (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] vectorized, llap
- SHUFFLE [RS_54]
+ <-Reducer 8 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_19]
PartitionCols:_col0
- Select Operator [SEL_53] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_52] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_51]
+ <-Map 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_50] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_49] (rows=2 width=93)
+ Filter Operator [FIL_38] (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 vectorized, llap
- File Output Operator [FS_53]
- Group By Operator [GBY_52] (rows=1 width=20)
+ Reducer 3 llap
+ File Output Operator [FS_26]
+ Group By Operator [GBY_24] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_38] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_37] (rows=18 width=84)
+ Filter Operator [FIL_33] (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] vectorized, llap
- SHUFFLE [RS_45]
+ <-Reducer 5 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
PartitionCols:_col0
- Select Operator [SEL_44] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_43] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 4 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_42]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_41] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_40] (rows=2 width=93)
+ Filter Operator [FIL_34] (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] vectorized, llap
- SHUFFLE [RS_51]
+ <-Reducer 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_19]
PartitionCols:_col0
- Select Operator [SEL_50] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_49] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_48]
+ <-Map 6 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_47] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_46] (rows=2 width=93)
+ Filter Operator [FIL_35] (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 vectorized, llap
- File Output Operator [FS_57]
- Select Operator [SEL_56] (rows=1 width=20)
+ Reducer 4 llap
+ File Output Operator [FS_28]
+ Select Operator [SEL_27] (rows=1 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_55]
- Group By Operator [GBY_54] (rows=1 width=20)
+ <-Reducer 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_26]
+ Group By Operator [GBY_24] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_40] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_39] (rows=18 width=84)
+ Filter Operator [FIL_35] (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] vectorized, llap
- SHUFFLE [RS_47]
+ <-Reducer 6 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
PartitionCols:_col0
- Select Operator [SEL_46] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_45] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 5 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_44]
+ <-Map 5 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_43] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_42] (rows=2 width=93)
+ Filter Operator [FIL_36] (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] vectorized, llap
- SHUFFLE [RS_53]
+ <-Reducer 8 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_19]
PartitionCols:_col0
- Select Operator [SEL_52] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_51] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_50]
+ <-Map 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_49] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_48] (rows=2 width=93)
+ Filter Operator [FIL_37] (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 vectorized, llap
- File Output Operator [FS_53]
- Group By Operator [GBY_52] (rows=1 width=20)
+ Reducer 3 llap
+ File Output Operator [FS_26]
+ Group By Operator [GBY_24] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_38] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_37] (rows=18 width=84)
+ Filter Operator [FIL_33] (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] vectorized, llap
- SHUFFLE [RS_45]
+ <-Reducer 5 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
PartitionCols:_col0
- Select Operator [SEL_44] (rows=1 width=97)
+ Select Operator [SEL_9] (rows=1 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_43] (rows=1 width=101)
+ Group By Operator [GBY_8] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 4 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_42]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_41] (rows=1 width=101)
+ Group By Operator [GBY_6] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_40] (rows=2 width=93)
+ Filter Operator [FIL_34] (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] vectorized, llap
- SHUFFLE [RS_51]
+ <-Reducer 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_19]
PartitionCols:_col0
- Select Operator [SEL_50] (rows=1 width=89)
+ Select Operator [SEL_16] (rows=1 width=89)
Output:["_col0","_col1"]
- Group By Operator [GBY_49] (rows=1 width=93)
+ Group By Operator [GBY_15] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_48]
+ <-Map 6 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_14]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_47] (rows=1 width=93)
+ Group By Operator [GBY_13] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_46] (rows=2 width=93)
+ Filter Operator [FIL_35] (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 vectorized, llap
- File Output Operator [FS_33]
- Select Operator [SEL_32] (rows=3 width=87)
+ Reducer 4 llap
+ File Output Operator [FS_25]
+ Select Operator [SEL_24] (rows=3 width=87)
Output:["_col0"]
<-Union 3 [SIMPLE_EDGE]
- <-Reducer 2 [CONTAINS] vectorized, llap
- Reduce Output Operator [RS_31]
- Select Operator [SEL_30] (rows=1 width=87)
+ <-Reducer 2 [CONTAINS] llap
+ Reduce Output Operator [RS_23]
+ Select Operator [SEL_5] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_29] (rows=1 width=8)
+ Group By Operator [GBY_4] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_28]
- Group By Operator [GBY_27] (rows=1 width=8)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_3]
+ Group By Operator [GBY_2] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_26] (rows=20 width=80)
+ Select Operator [SEL_1] (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] vectorized, llap
- Reduce Output Operator [RS_39]
- Select Operator [SEL_38] (rows=1 width=87)
+ <-Reducer 6 [CONTAINS] llap
+ Reduce Output Operator [RS_23]
+ Select Operator [SEL_12] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_37] (rows=1 width=8)
+ Group By Operator [GBY_11] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 5 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_36]
- Group By Operator [GBY_35] (rows=1 width=8)
+ <-Map 5 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_10]
+ Group By Operator [GBY_9] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_34] (rows=20 width=80)
+ Select Operator [SEL_8] (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] vectorized, llap
- Reduce Output Operator [RS_45]
- Select Operator [SEL_44] (rows=1 width=87)
+ <-Reducer 8 [CONTAINS] llap
+ Reduce Output Operator [RS_23]
+ Select Operator [SEL_20] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_43] (rows=1 width=8)
+ Group By Operator [GBY_19] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 7 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_42]
- Group By Operator [GBY_41] (rows=1 width=8)
+ <-Map 7 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_18]
+ Group By Operator [GBY_17] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_40] (rows=20 width=80)
+ Select Operator [SEL_16] (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 vectorized, llap
- File Output Operator [FS_41]
- Select Operator [SEL_40] (rows=1 width=95)
+ Reducer 5 llap
+ File Output Operator [FS_30]
+ Select Operator [SEL_29] (rows=1 width=95)
Output:["_col0","_col1"]
- <-Reducer 4 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_39]
- Group By Operator [GBY_38] (rows=1 width=95)
+ <-Reducer 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_28]
+ Group By Operator [GBY_26] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
<-Union 3 [SIMPLE_EDGE]
- <-Reducer 2 [CONTAINS] vectorized, llap
- Reduce Output Operator [RS_37]
+ <-Reducer 2 [CONTAINS] llap
+ Reduce Output Operator [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_36] (rows=1 width=95)
+ Group By Operator [GBY_24] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_35] (rows=1 width=87)
+ Select Operator [SEL_5] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_34] (rows=1 width=8)
+ Group By Operator [GBY_4] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_33]
- Group By Operator [GBY_32] (rows=1 width=8)
+ <-Map 1 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_3]
+ Group By Operator [GBY_2] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_31] (rows=20 width=80)
+ Select Operator [SEL_1] (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] vectorized, llap
- Reduce Output Operator [RS_48]
+ <-Reducer 7 [CONTAINS] llap
+ Reduce Output Operator [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_47] (rows=1 width=95)
+ Group By Operator [GBY_24] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_46] (rows=1 width=87)
+ Select Operator [SEL_12] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_45] (rows=1 width=8)
+ Group By Operator [GBY_11] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 6 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_44]
- Group By Operator [GBY_43] (rows=1 width=8)
+ <-Map 6 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_10]
+ Group By Operator [GBY_9] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_42] (rows=20 width=80)
+ Select Operator [SEL_8] (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] vectorized, llap
- Reduce Output Operator [RS_55]
+ <-Reducer 9 [CONTAINS] llap
+ Reduce Output Operator [RS_25]
PartitionCols:_col0
- Group By Operator [GBY_54] (rows=1 width=95)
+ Group By Operator [GBY_24] (rows=1 width=95)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Select Operator [SEL_53] (rows=1 width=87)
+ Select Operator [SEL_20] (rows=1 width=87)
Output:["_col0"]
- Group By Operator [GBY_52] (rows=1 width=8)
+ Group By Operator [GBY_19] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
- <-Map 8 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_51]
- Group By Operator [GBY_50] (rows=1 width=8)
+ <-Map 8 [CUSTOM_SIMPLE_EDGE] llap
+ PARTITION_ONLY_SHUFFLE [RS_18]
+ Group By Operator [GBY_17] (rows=1 width=8)
Output:["_col0"],aggregations:["count(key)"]
- Select Operator [SEL_49] (rows=20 width=80)
+ Select Operator [SEL_16] (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_18._col0=RS_21._col0(Inner),Output:["_col0"]
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_18]
+ Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0"]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_6]
PartitionCols:_col0
- Select Operator [SEL_17] (rows=6 width=85)
+ Select Operator [SEL_2] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_16] (rows=6 width=85)
+ Filter Operator [FIL_13] (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] vectorized, llap
- SHUFFLE [RS_21]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
PartitionCols:_col0
- Select Operator [SEL_20] (rows=6 width=85)
+ Select Operator [SEL_5] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_19] (rows=6 width=85)
+ Filter Operator [FIL_14] (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_13._col0=RS_15._col0(Left Outer),Output:["_col1","_col3"]
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_13]
+ Conds:RS_4._col0=RS_5._col0(Left Outer),Output:["_col1","_col3"]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_4]
PartitionCols:_col0
- Select Operator [SEL_12] (rows=20 width=84)
+ Select Operator [SEL_1] (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] vectorized, llap
- SHUFFLE [RS_15]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_5]
PartitionCols:_col0
- Select Operator [SEL_14] (rows=20 width=84)
+ Select Operator [SEL_3] (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_11._col0=RS_13._col0(Outer),Output:["_col1","_col3"]
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_11]
+ Conds:RS_4._col0=RS_5._col0(Outer),Output:["_col1","_col3"]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_4]
PartitionCols:_col0
- Select Operator [SEL_10] (rows=20 width=84)
+ Select Operator [SEL_1] (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] vectorized, llap
- SHUFFLE [RS_13]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_5]
PartitionCols:_col0
- Select Operator [SEL_12] (rows=20 width=84)
+ Select Operator [SEL_3] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_26] (rows=18 width=87)
+ Select Operator [SEL_2] (rows=18 width=87)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_25] (rows=18 width=87)
+ Filter Operator [FIL_21] (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] vectorized, llap
- SHUFFLE [RS_30]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_10]
PartitionCols:_col0
- Select Operator [SEL_29] (rows=18 width=84)
+ Select Operator [SEL_5] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_28] (rows=18 width=84)
+ Filter Operator [FIL_22] (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] vectorized, llap
- SHUFFLE [RS_33]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_11]
PartitionCols:_col0
- Select Operator [SEL_32] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_31] (rows=18 width=84)
+ Filter Operator [FIL_23] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_26] (rows=18 width=84)
+ Select Operator [SEL_2] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_25] (rows=18 width=84)
+ Filter Operator [FIL_21] (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] vectorized, llap
- SHUFFLE [RS_30]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_10]
PartitionCols:_col0
- Select Operator [SEL_29] (rows=18 width=80)
+ Select Operator [SEL_5] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_28] (rows=18 width=80)
+ Filter Operator [FIL_22] (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] vectorized, llap
- SHUFFLE [RS_33]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_11]
PartitionCols:_col0
- Select Operator [SEL_32] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_31] (rows=18 width=84)
+ Filter Operator [FIL_23] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_26] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_25] (rows=8 width=93)
+ Filter Operator [FIL_21] (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] vectorized, llap
- SHUFFLE [RS_30]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_10]
PartitionCols:_col0
- Select Operator [SEL_29] (rows=8 width=89)
+ Select Operator [SEL_5] (rows=8 width=89)
Output:["_col0","_col1"]
- Filter Operator [FIL_28] (rows=8 width=93)
+ Filter Operator [FIL_22] (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] vectorized, llap
- SHUFFLE [RS_33]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_11]
PartitionCols:_col0
- Select Operator [SEL_32] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_31] (rows=18 width=84)
+ Filter Operator [FIL_23] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_26] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_25] (rows=8 width=93)
+ Filter Operator [FIL_21] (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] vectorized, llap
- SHUFFLE [RS_30]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_10]
PartitionCols:_col0
- Select Operator [SEL_29] (rows=8 width=89)
+ Select Operator [SEL_5] (rows=8 width=89)
Output:["_col0","_col1"]
- Filter Operator [FIL_28] (rows=8 width=93)
+ Filter Operator [FIL_22] (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] vectorized, llap
- SHUFFLE [RS_33]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_11]
PartitionCols:_col0
- Select Operator [SEL_32] (rows=18 width=84)
+ Select Operator [SEL_8] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_31] (rows=18 width=84)
+ Filter Operator [FIL_23] (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 vectorized, llap
- File Output Operator [FS_18]
- Limit [LIM_17] (rows=1 width=97)
+ Reducer 3 llap
+ File Output Operator [FS_9]
+ Limit [LIM_8] (rows=1 width=97)
Number of rows:1
- Select Operator [SEL_16] (rows=10 width=97)
+ Select Operator [SEL_7] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_15]
- Select Operator [SEL_14] (rows=10 width=97)
+ <-Reducer 2 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_6]
+ Select Operator [SEL_5] (rows=10 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_13] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_12]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_11] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_10] (rows=20 width=88)
+ Select Operator [SEL_1] (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 vectorized, llap
- File Output Operator [FS_26]
- Limit [LIM_25] (rows=1 width=20)
+ Reducer 4 llap
+ File Output Operator [FS_14]
+ Limit [LIM_13] (rows=1 width=20)
Number of rows:1
- Select Operator [SEL_24] (rows=5 width=20)
+ Select Operator [SEL_12] (rows=5 width=20)
Output:["_col0","_col1","_col2"]
- <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_23]
- Group By Operator [GBY_22] (rows=5 width=20)
+ <-Reducer 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_11]
+ Group By Operator [GBY_9] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
- <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_21]
+ <-Reducer 2 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_8]
PartitionCols:_col0, _col1
- Group By Operator [GBY_20] (rows=5 width=20)
+ Group By Operator [GBY_7] (rows=5 width=20)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
- Select Operator [SEL_19] (rows=10 width=101)
+ Select Operator [SEL_5] (rows=10 width=101)
Output:["_col0","_col1"]
- Group By Operator [GBY_18] (rows=10 width=101)
+ Group By Operator [GBY_4] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_17]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_3]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_16] (rows=10 width=101)
+ Group By Operator [GBY_2] (rows=10 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Select Operator [SEL_15] (rows=20 width=88)
+ Select Operator [SEL_1] (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 vectorized, llap
- File Output Operator [FS_24]
- Limit [LIM_23] (rows=5 width=89)
+ Reducer 4 llap
+ File Output Operator [FS_13]
+ Limit [LIM_12] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_22] (rows=5 width=89)
+ Select Operator [SEL_11] (rows=5 width=89)
Output:["_col0","_col1"]
- <-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_21]
- Limit [LIM_20] (rows=5 width=89)
+ <-Reducer 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_10]
+ Limit [LIM_8] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_19] (rows=5 width=89)
+ Select Operator [SEL_7] (rows=5 width=89)
Output:["_col0","_col1"]
- <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_18]
- Limit [LIM_17] (rows=5 width=89)
+ <-Reducer 2 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_6]
+ Limit [LIM_4] (rows=5 width=89)
Number of rows:5
- Select Operator [SEL_16] (rows=20 width=84)
+ Select Operator [SEL_3] (rows=20 width=84)
Output:["_col0","_col1"]
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_15]
- Select Operator [SEL_14] (rows=20 width=84)
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_2]
+ Select Operator [SEL_1] (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 vectorized, llap
- File Output Operator [FS_83]
- Limit [LIM_82] (rows=1 width=28)
+ Reducer 6 llap
+ File Output Operator [FS_42]
+ Limit [LIM_40] (rows=1 width=28)
Number of rows:5
- Select Operator [SEL_81] (rows=1 width=28)
+ Select Operator [SEL_39] (rows=1 width=28)
Output:["_col0","_col1","_col2"]
- <-Reducer 5 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_80]
- Select Operator [SEL_79] (rows=1 width=28)
+ <-Reducer 5 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_38]
+ Select Operator [SEL_37] (rows=1 width=28)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_78] (rows=1 width=20)
+ Group By Operator [GBY_36] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_76] (rows=18 width=84)
+ Select Operator [SEL_28] (rows=18 width=84)
Output:["_col0","_col1"]
- Filter Operator [FIL_75] (rows=18 width=84)
+ Filter Operator [FIL_53] (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] vectorized, llap
- SHUFFLE [RS_64]
+ <-Reducer 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_29]
PartitionCols:_col0
- Filter Operator [FIL_63] (rows=2 width=105)
+ Filter Operator [FIL_11] (rows=2 width=105)
predicate:_col0 is not null
- Limit [LIM_62] (rows=3 width=105)
+ Limit [LIM_9] (rows=3 width=105)
Number of rows:5
- Select Operator [SEL_61] (rows=3 width=105)
+ Select Operator [SEL_8] (rows=3 width=105)
Output:["_col0","_col1"]
- <-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_60]
- Select Operator [SEL_59] (rows=3 width=105)
+ <-Reducer 2 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_7]
+ Select Operator [SEL_6] (rows=3 width=105)
Output:["_col0","_col1","_col2","_col3"]
- Group By Operator [GBY_58] (rows=3 width=101)
+ Group By Operator [GBY_5] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_57]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_4]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_56] (rows=3 width=101)
+ Group By Operator [GBY_3] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_55] (rows=6 width=93)
+ Filter Operator [FIL_50] (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] vectorized, llap
- SHUFFLE [RS_74]
+ <-Reducer 9 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_30]
PartitionCols:_col0
- Filter Operator [FIL_73] (rows=2 width=97)
+ Filter Operator [FIL_24] (rows=2 width=97)
predicate:_col0 is not null
- Limit [LIM_72] (rows=3 width=97)
+ Limit [LIM_22] (rows=3 width=97)
Number of rows:5
- Select Operator [SEL_71] (rows=3 width=97)
+ Select Operator [SEL_21] (rows=3 width=97)
Output:["_col0","_col1","_col2"]
- <-Reducer 8 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_70]
- Select Operator [SEL_69] (rows=3 width=97)
+ <-Reducer 8 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_20]
+ Select Operator [SEL_19] (rows=3 width=97)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_68] (rows=3 width=101)
+ Group By Operator [GBY_18] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 7 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_67]
+ <-Map 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_17]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_66] (rows=3 width=101)
+ Group By Operator [GBY_16] (rows=3 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_65] (rows=6 width=93)
+ Filter Operator [FIL_52] (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_20._col0=RS_24._col0(Left Semi),Output:["_col1"]
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_20]
+ Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col1"]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_8]
PartitionCols:_col0
- Select Operator [SEL_19] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1"]
- Filter Operator [FIL_18] (rows=8 width=93)
+ Filter Operator [FIL_15] (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] vectorized, llap
- SHUFFLE [RS_24]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_9]
PartitionCols:_col0
- Group By Operator [GBY_23] (rows=6 width=85)
+ Group By Operator [GBY_7] (rows=6 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_22] (rows=18 width=80)
+ Select Operator [SEL_5] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_21] (rows=18 width=80)
+ Filter Operator [FIL_16] (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_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]
+ 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]
PartitionCols:_col0
- Select Operator [SEL_30] (rows=8 width=93)
+ Select Operator [SEL_2] (rows=8 width=93)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_29] (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] vectorized, llap
- SHUFFLE [RS_35]
+ <-Map 3 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_14]
PartitionCols:_col0
- Group By Operator [GBY_34] (rows=3 width=85)
+ Group By Operator [GBY_10] (rows=3 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_33] (rows=8 width=85)
+ Select Operator [SEL_5] (rows=8 width=85)
Output:["_col0"]
- Filter Operator [FIL_32] (rows=8 width=93)
+ Filter Operator [FIL_26] (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] vectorized, llap
- SHUFFLE [RS_39]
+ <-Map 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_15]
PartitionCols:_col0
- Group By Operator [GBY_38] (rows=7 width=85)
+ Group By Operator [GBY_12] (rows=7 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_37] (rows=18 width=80)
+ Select Operator [SEL_8] (rows=18 width=80)
Output:["_col0"]
- Filter Operator [FIL_36] (rows=18 width=80)
+ Filter Operator [FIL_27] (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 vectorized, llap
- File Output Operator [FS_68]
- Select Operator [SEL_67] (rows=1 width=101)
+ Reducer 5 llap
+ File Output Operator [FS_34]
+ Select Operator [SEL_33] (rows=1 width=101)
Output:["_col0","_col1","_col2"]
- <-Reducer 4 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_66]
- Select Operator [SEL_65] (rows=1 width=101)
+ <-Reducer 4 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_32]
+ Select Operator [SEL_31] (rows=1 width=101)
Output:["_col0","_col1","_col2"]
- Group By Operator [GBY_64] (rows=1 width=101)
+ Group By Operator [GBY_30] (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_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]
+ 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]
PartitionCols:_col0
- Group By Operator [GBY_62] (rows=3 width=85)
+ Group By Operator [GBY_22] (rows=3 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_61] (rows=6 width=85)
+ Select Operator [SEL_18] (rows=6 width=85)
Output:["_col0"]
- Filter Operator [FIL_60] (rows=6 width=85)
+ Filter Operator [FIL_43] (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] vectorized, llap
- SHUFFLE [RS_52]
+ <-Reducer 2 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_23]
PartitionCols:_col0
- Select Operator [SEL_51] (rows=1 width=93)
+ Select Operator [SEL_8] (rows=1 width=93)
Output:["_col0","_col1"]
- Filter Operator [FIL_50] (rows=1 width=101)
+ Filter Operator [FIL_7] (rows=1 width=101)
predicate:(((UDFToDouble(_col2) + UDFToDouble(_col3)) >= 0.0D) and ((UDFToDouble(_col2) >= 1.0D) or (_col3 >= 1L)))
- Select Operator [SEL_49] (rows=1 width=101)
+ Select Operator [SEL_6] (rows=1 width=101)
Output:["_col2","_col3"]
- Group By Operator [GBY_48] (rows=1 width=101)
+ Group By Operator [GBY_5] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_47]
+ <-Map 1 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_4]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_46] (rows=1 width=101)
+ Group By Operator [GBY_3] (rows=1 width=101)
Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
- Filter Operator [FIL_45] (rows=1 width=93)
+ Filter Operator [FIL_41] (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] vectorized, llap
- SHUFFLE [RS_59]
+ <-Reducer 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_24]
PartitionCols:_col0
- Group By Operator [GBY_58] (rows=1 width=85)
+ Group By Operator [GBY_20] (rows=1 width=85)
Output:["_col0"],keys:_col0
- Select Operator [SEL_57] (rows=1 width=85)
+ Select Operator [SEL_15] (rows=1 width=85)
Output:["_col0"]
- Group By Operator [GBY_56] (rows=1 width=93)
+ Group By Operator [GBY_14] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
- <-Map 6 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_55]
+ <-Map 6 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_13]
PartitionCols:_col0, _col1, _col2
- Group By Operator [GBY_54] (rows=1 width=93)
+ Group By Operator [GBY_12] (rows=1 width=93)
Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
- Filter Operator [FIL_53] (rows=1 width=93)
+ Filter Operator [FIL_42] (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>