You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2018/06/25 16:04:41 UTC
[38/51] [partial] hive git commit: HIVE-12342 : Set default value of
hive.optimize.index.filter to true (Igor Kryvenko via Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/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 7b99494..f87fe36 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
@@ -398,7 +398,7 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col4, _col1
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
- Merge Join Operator [MERGEJOIN_39] (rows=1 width=20)
+ Merge Join Operator [MERGEJOIN_57] (rows=1 width=20)
Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 0)}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_17]
@@ -476,7 +476,7 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col4
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
- Merge Join Operator [MERGEJOIN_39] (rows=1 width=20)
+ Merge Join Operator [MERGEJOIN_57] (rows=1 width=20)
Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col1 >= 1) or (_col4 >= 1L))} {((UDFToLong(_col1) + _col4) >= 0)} {((_col3 + _col6) >= 0)}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_17]
@@ -547,7 +547,7 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col4
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
- Merge Join Operator [MERGEJOIN_36] (rows=1 width=20)
+ Merge Join Operator [MERGEJOIN_54] (rows=1 width=20)
Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 2)}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_17]
@@ -623,7 +623,7 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col4
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
- Merge Join Operator [MERGEJOIN_38] (rows=1 width=20)
+ Merge Join Operator [MERGEJOIN_56] (rows=1 width=20)
Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col1 >= 1) or (_col4 >= 1L))} {((UDFToLong(_col1) + _col4) >= 0)} {((_col3 + _col6) >= 0)}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_17]
@@ -694,7 +694,7 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col4
Select Operator [SEL_21] (rows=1 width=20)
Output:["_col1","_col4"]
- Merge Join Operator [MERGEJOIN_36] (rows=1 width=20)
+ Merge Join Operator [MERGEJOIN_54] (rows=1 width=20)
Conds:RS_17._col0=RS_18._col0(Inner),RS_18._col0=RS_19._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 > 0) or (_col1 >= 0))} {((_col3 + _col6) >= 0)}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_17]
@@ -921,7 +921,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_10]
- Merge Join Operator [MERGEJOIN_15] (rows=18 width=85)
+ Merge Join Operator [MERGEJOIN_25] (rows=18 width=85)
Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_6]
@@ -959,7 +959,7 @@ Stage-0
File Output Operator [FS_8]
Select Operator [SEL_7] (rows=80 width=7)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_11] (rows=80 width=7)
+ Merge Join Operator [MERGEJOIN_16] (rows=80 width=7)
Conds:RS_4._col0=RS_5._col0(Left Outer),Output:["_col1","_col3"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_4]
@@ -1027,7 +1027,7 @@ Stage-0
File Output Operator [FS_14]
Select Operator [SEL_13] (rows=194 width=100)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Merge Join Operator [MERGEJOIN_24] (rows=194 width=100)
+ Merge Join Operator [MERGEJOIN_42] (rows=194 width=100)
Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
@@ -1074,7 +1074,7 @@ Stage-0
File Output Operator [FS_14]
Select Operator [SEL_13] (rows=194 width=177)
Output:["_col0","_col1","_col2","_col3"]
- Merge Join Operator [MERGEJOIN_24] (rows=194 width=177)
+ Merge Join Operator [MERGEJOIN_42] (rows=194 width=177)
Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col0","_col1","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
@@ -1121,7 +1121,7 @@ Stage-0
File Output Operator [FS_14]
Select Operator [SEL_13] (rows=40 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Merge Join Operator [MERGEJOIN_24] (rows=40 width=101)
+ Merge Join Operator [MERGEJOIN_42] (rows=40 width=101)
Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"],residual filter predicates:{((_col1 + _col4) = 2)} {((_col1 > 0) or (_col6 >= 0))}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
@@ -1168,7 +1168,7 @@ Stage-0
File Output Operator [FS_14]
Select Operator [SEL_13] (rows=40 width=101)
Output:["_col0","_col1","_col2","_col3","_col4"]
- Merge Join Operator [MERGEJOIN_24] (rows=40 width=101)
+ Merge Join Operator [MERGEJOIN_42] (rows=40 width=101)
Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"],residual filter predicates:{((_col1 + _col4) = 2)} {((_col1 > 0) or (_col6 >= 0))}
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
@@ -1372,7 +1372,7 @@ Stage-0
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col4, _col6
Select Operator [SEL_33] (rows=2 width=20)
Output:["_col4","_col6"]
- Merge Join Operator [MERGEJOIN_54] (rows=2 width=20)
+ Merge Join Operator [MERGEJOIN_64] (rows=2 width=20)
Conds:RS_29._col0=RS_30._col0(Inner),RS_30._col0=RS_31._col0(Inner),Output:["_col1","_col3","_col4","_col6"],residual filter predicates:{((_col3 + _col1) >= 0)} {((_col3 > 0) or (_col6 >= 0))}
<-Map 10 [SIMPLE_EDGE] llap
SHUFFLE [RS_31]
@@ -1449,7 +1449,7 @@ Stage-0
File Output Operator [FS_12]
Select Operator [SEL_11] (rows=9 width=4)
Output:["_col0"]
- Merge Join Operator [MERGEJOIN_17] (rows=9 width=4)
+ Merge Join Operator [MERGEJOIN_27] (rows=9 width=4)
Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col1"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
@@ -1489,7 +1489,7 @@ Stage-0
File Output Operator [FS_18]
Select Operator [SEL_17] (rows=14 width=93)
Output:["_col0","_col1","_col2"]
- Merge Join Operator [MERGEJOIN_28] (rows=14 width=93)
+ Merge Join Operator [MERGEJOIN_46] (rows=14 width=93)
Conds:RS_13._col0=RS_14._col0(Left Semi),RS_13._col0=RS_15._col0(Left Semi),Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_13]
@@ -1555,7 +1555,7 @@ Stage-0
PartitionCols:_col0, _col1
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)
+ Merge Join Operator [MERGEJOIN_62] (rows=1 width=93)
Conds:RS_23._col0=RS_24._col0(Left Semi),RS_23._col0=RS_25._col0(Left Semi),Output:["_col0","_col1"]
<-Map 8 [SIMPLE_EDGE] llap
SHUFFLE [RS_25]
@@ -1717,7 +1717,7 @@ Stage-0
Output:["_col0","_col1"]
Filter Operator [FIL_17] (rows=365 width=179)
predicate:_col3 is null
- Merge Join Operator [MERGEJOIN_22] (rows=500 width=179)
+ Merge Join Operator [MERGEJOIN_27] (rows=500 width=179)
Conds:RS_14._col1=RS_15._col0(Left Outer),Output:["_col0","_col1","_col3"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_14]
@@ -1779,7 +1779,7 @@ Stage-0
Output:["_col0","_col1"]
Filter Operator [FIL_16] (rows=185 width=179)
predicate:_col4 is null
- Merge Join Operator [MERGEJOIN_21] (rows=250 width=179)
+ Merge Join Operator [MERGEJOIN_31] (rows=250 width=179)
Conds:GBY_4._col0, _col1=SEL_12._col0, _col1(Left Outer),Output:["_col0","_col1","_col4"]
<-Select Operator [SEL_12] (rows=83 width=182)
Output:["_col0","_col1","_col2"]
@@ -1845,7 +1845,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=131 width=178)
+ Merge Join Operator [MERGEJOIN_37] (rows=131 width=178)
Conds:RS_8._col0, _col1=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
@@ -1897,7 +1897,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=131 width=178)
+ Merge Join Operator [MERGEJOIN_37] (rows=131 width=178)
Conds:RS_8._col0, _col1=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
@@ -1939,7 +1939,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=131 width=178)
+ Merge Join Operator [MERGEJOIN_27] (rows=131 width=178)
Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col0","_col1"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
@@ -1987,7 +1987,7 @@ Stage-0
File Output Operator [FS_22]
Select Operator [SEL_21] (rows=7 width=8)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_32] (rows=7 width=8)
+ Merge Join Operator [MERGEJOIN_52] (rows=7 width=8)
Conds:RS_18._col1, _col4=RS_19._col0, _col1(Left Semi),Output:["_col0","_col3"]
<-Map 6 [SIMPLE_EDGE] llap
SHUFFLE [RS_19]
@@ -2003,7 +2003,7 @@ Stage-0
<-Reducer 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_18]
PartitionCols:_col1, _col4
- Merge Join Operator [MERGEJOIN_31] (rows=7 width=16)
+ Merge Join Operator [MERGEJOIN_51] (rows=7 width=16)
Conds:RS_13._col0=RS_14._col1(Inner),Output:["_col0","_col1","_col3","_col4"]
<-Map 5 [SIMPLE_EDGE] llap
SHUFFLE [RS_14]
@@ -2055,7 +2055,7 @@ Stage-0
Stage-1
Reducer 4 llap
File Output Operator [FS_31]
- Merge Join Operator [MERGEJOIN_44] (rows=32 width=186)
+ Merge Join Operator [MERGEJOIN_54] (rows=32 width=186)
Conds:RS_27._col2=RS_28._col0(Left Semi),Output:["_col0","_col1","_col2"]
<-Reducer 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_27]
@@ -2069,7 +2069,7 @@ Stage-0
PartitionCols:_col0, _col1
Group By Operator [GBY_12] (rows=65 width=186)
Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0, _col1
- Merge Join Operator [MERGEJOIN_43] (rows=131 width=178)
+ Merge Join Operator [MERGEJOIN_53] (rows=131 width=178)
Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col0","_col1"]
<-Map 5 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
@@ -2138,7 +2138,7 @@ Stage-0
Stage-1
Reducer 3 llap
File Output Operator [FS_21]
- Merge Join Operator [MERGEJOIN_26] (rows=6 width=227)
+ Merge Join Operator [MERGEJOIN_31] (rows=6 width=227)
Conds:RS_17._col1=RS_18._col0(Left Semi),Output:["_col0","_col1","_col2"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_17]
@@ -2212,12 +2212,12 @@ Stage-0
Output:["_col0","_col1"]
Filter Operator [FIL_22] (rows=500 width=195)
predicate:((_col2 = 0L) or (_col5 is null and _col0 is not null and (_col3 >= _col2)))
- Merge Join Operator [MERGEJOIN_31] (rows=500 width=195)
+ Merge Join Operator [MERGEJOIN_36] (rows=500 width=195)
Conds:RS_19._col0=RS_20._col0(Left Outer),Output:["_col0","_col1","_col2","_col3","_col5"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_19]
PartitionCols:_col0
- Merge Join Operator [MERGEJOIN_30] (rows=500 width=194)
+ Merge Join Operator [MERGEJOIN_35] (rows=500 width=194)
Conds:(Inner),Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [CUSTOM_SIMPLE_EDGE] llap
PARTITION_ONLY_SHUFFLE [RS_16]
@@ -2249,7 +2249,9 @@ Stage-0
PartitionCols:_col0
Group By Operator [GBY_12] (rows=83 width=87)
Output:["_col0"],keys:key
- Please refer to the previous Filter Operator [FIL_28]
+ Filter Operator [FIL_29] (rows=166 width=87)
+ predicate:(key > '2')
+ Please refer to the previous TableScan [TS_2]
PREHOOK: query: explain select p_mfgr, b.p_name, p_size
from part b
@@ -2285,12 +2287,12 @@ Stage-0
Output:["_col0","_col1","_col2"]
Filter Operator [FIL_22] (rows=13 width=231)
predicate:CASE WHEN ((_col4 = 0L)) THEN (true) WHEN (_col4 is null) THEN (true) WHEN (_col8 is not null) THEN (false) WHEN (_col0 is null) THEN (null) WHEN ((_col5 < _col4)) THEN (false) ELSE (true) END
- Merge Join Operator [MERGEJOIN_30] (rows=26 width=230)
+ Merge Join Operator [MERGEJOIN_45] (rows=26 width=230)
Conds:RS_19._col0, _col1=RS_20._col0, _col1(Left Outer),Output:["_col0","_col1","_col2","_col4","_col5","_col8"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_19]
PartitionCols:_col0, _col1
- Merge Join Operator [MERGEJOIN_29] (rows=26 width=229)
+ Merge Join Operator [MERGEJOIN_44] (rows=26 width=229)
Conds:RS_16._col1=RS_17._col0(Left Outer),Output:["_col0","_col1","_col2","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_16]
@@ -2451,12 +2453,12 @@ Stage-0
Output:["_col0","_col1"]
Filter Operator [FIL_32] (rows=2 width=116)
predicate:CASE WHEN ((_col3 = 0L)) THEN (true) WHEN (_col3 is null) THEN (true) WHEN (_col7 is not null) THEN (false) WHEN (_col0 is null) THEN (null) WHEN ((_col4 < _col3)) THEN (false) ELSE (true) END
- Merge Join Operator [MERGEJOIN_43] (rows=5 width=114)
+ Merge Join Operator [MERGEJOIN_48] (rows=5 width=114)
Conds:RS_29._col0, _col1=RS_30._col0, _col1(Left Outer),Output:["_col0","_col1","_col3","_col4","_col7"]
<-Reducer 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_29]
PartitionCols:_col0, _col1
- Merge Join Operator [MERGEJOIN_42] (rows=5 width=112)
+ Merge Join Operator [MERGEJOIN_47] (rows=5 width=112)
Conds:RS_26._col1=RS_27._col0(Left Outer),Output:["_col0","_col1","_col3","_col4"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_26]
@@ -2660,7 +2662,7 @@ Stage-0
PartitionCols:_col0
Group By Operator [GBY_10] (rows=16 width=94)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Merge Join Operator [MERGEJOIN_24] (rows=39 width=86)
+ Merge Join Operator [MERGEJOIN_34] (rows=39 width=86)
Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_6]
@@ -2721,7 +2723,7 @@ Stage-0
PartitionCols:_col0
Group By Operator [GBY_10] (rows=16 width=94)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Merge Join Operator [MERGEJOIN_24] (rows=39 width=86)
+ Merge Join Operator [MERGEJOIN_34] (rows=39 width=86)
Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_6]
@@ -2782,7 +2784,7 @@ Stage-0
PartitionCols:_col0
Group By Operator [GBY_10] (rows=16 width=94)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Map Join Operator [MAPJOIN_24] (rows=39 width=86)
+ Map Join Operator [MAPJOIN_34] (rows=39 width=86)
Conds:RS_6._col0=SEL_5._col0(Inner),Output:["_col0"]
<-Map 1 [BROADCAST_EDGE] llap
BROADCAST [RS_6]
@@ -2840,7 +2842,7 @@ Stage-0
PartitionCols:_col0
Group By Operator [GBY_12] (rows=9 width=94)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Merge Join Operator [MERGEJOIN_26] (rows=19 width=86)
+ Merge Join Operator [MERGEJOIN_36] (rows=19 width=86)
Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
@@ -3431,7 +3433,7 @@ Stage-0
File Output Operator [FS_11]
Select Operator [SEL_10] (rows=2 width=8)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- Merge Join Operator [MERGEJOIN_21] (rows=2 width=8)
+ Merge Join Operator [MERGEJOIN_39] (rows=2 width=8)
Conds:RS_4.key=RS_6.value(Inner),RS_4.key=RS_8.key(Inner),Output:["_col0","_col1","_col5","_col6","_col10","_col11"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_4]
@@ -3935,7 +3937,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=1 width=206)
+ Merge Join Operator [MERGEJOIN_27] (rows=1 width=206)
Conds:RS_8._col1=RS_9._col0(Left Semi),Output:["_col0","_col1"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
@@ -3989,8 +3991,8 @@ Stage-0
Stage-1
Map 1 llap
File Output Operator [FS_16]
- Map Join Operator [MAPJOIN_26] (rows=805 width=10)
- Conds:MAPJOIN_25._col1=RS_13._col0(Inner),Output:["_col0"]
+ Map Join Operator [MAPJOIN_46] (rows=805 width=10)
+ Conds:MAPJOIN_45._col1=RS_13._col0(Inner),Output:["_col0"]
<-Map 3 [BROADCAST_EDGE] llap
BROADCAST [RS_13]
PartitionCols:_col0
@@ -4000,7 +4002,7 @@ Stage-0
predicate:(value > 'val_450')
TableScan [TS_6] (rows=500 width=10)
default@src,src,Tbl:COMPLETE,Col:NONE,Output:["value"]
- <-Map Join Operator [MAPJOIN_25] (rows=732 width=10)
+ <-Map Join Operator [MAPJOIN_45] (rows=732 width=10)
Conds:SEL_2._col0=RS_10._col0(Inner),Output:["_col0","_col1"]
<-Map 2 [BROADCAST_EDGE] llap
BROADCAST [RS_10]
@@ -4033,8 +4035,8 @@ Stage-0
Stage-1
Map 1 llap
File Output Operator [FS_16]
- Map Join Operator [MAPJOIN_26] (rows=805 width=10)
- Conds:MAPJOIN_25._col1=RS_13._col0(Inner),Output:["_col0"]
+ Map Join Operator [MAPJOIN_46] (rows=805 width=10)
+ Conds:MAPJOIN_45._col1=RS_13._col0(Inner),Output:["_col0"]
<-Map 3 [BROADCAST_EDGE] llap
BROADCAST [RS_13]
PartitionCols:_col0
@@ -4044,7 +4046,7 @@ Stage-0
predicate:(value > 'val_450')
TableScan [TS_6] (rows=500 width=10)
default@src,src,Tbl:COMPLETE,Col:NONE,Output:["value"]
- <-Map Join Operator [MAPJOIN_25] (rows=732 width=10)
+ <-Map Join Operator [MAPJOIN_45] (rows=732 width=10)
Conds:SEL_2._col0=RS_10._col0(Inner),Output:["_col0","_col1"]
<-Map 2 [BROADCAST_EDGE] llap
BROADCAST [RS_10]
@@ -4156,7 +4158,7 @@ Stage-0
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:_col2
- Map Join Operator [MAPJOIN_21] (rows=27 width=223)
+ Map Join Operator [MAPJOIN_31] (rows=27 width=223)
Conds:FIL_19.p_partkey=RS_5.p_partkey(Inner),Output:["_col1","_col2","_col5"]
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_5]
@@ -4358,7 +4360,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_11]
- Map Join Operator [MAPJOIN_16] (rows=27 width=619)
+ Map Join Operator [MAPJOIN_21] (rows=27 width=619)
Conds:FIL_14._col0=RS_8.p_partkey(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
<-Map 3 [BROADCAST_EDGE] llap
BROADCAST [RS_8]
@@ -4689,7 +4691,7 @@ Stage-0
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_10]
PartitionCols:_col2
- Map Join Operator [MAPJOIN_20] (rows=27 width=231)
+ Map Join Operator [MAPJOIN_25] (rows=27 width=231)
Conds:FIL_18._col0=RS_8.p_partkey(Inner),Output:["_col1","_col2","_col5","_col7"]
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_8]
@@ -5284,7 +5286,7 @@ Stage-3
table:{"name:":"default.dest_j1_n16"}
Select Operator [SEL_9] (rows=791 width=95)
Output:["_col0","_col1"]
- Merge Join Operator [MERGEJOIN_24] (rows=791 width=178)
+ Merge Join Operator [MERGEJOIN_34] (rows=791 width=178)
Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_6]
@@ -5345,8 +5347,8 @@ Stage-0
Stage-1
Map 3 llap
File Output Operator [FS_21]
- Map Join Operator [MAPJOIN_37] (rows=2 width=404)
- Conds:RS_16._col0=RS_17._col0(Inner),RS_17._col0=MAPJOIN_36._col0(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
+ Map Join Operator [MAPJOIN_67] (rows=2 width=404)
+ Conds:RS_16._col0=RS_17._col0(Inner),RS_17._col0=MAPJOIN_66._col0(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
<-Map 1 [BROADCAST_EDGE] llap
BROADCAST [RS_16]
PartitionCols:_col0
@@ -5365,7 +5367,7 @@ Stage-0
predicate:key is not null
TableScan [TS_3] (rows=1 width=368)
default@t2_n70,b,Tbl:COMPLETE,Col:NONE,Output:["key","val"]
- <-Map Join Operator [MAPJOIN_36] (rows=1 width=404)
+ <-Map Join Operator [MAPJOIN_66] (rows=1 width=404)
Conds:SEL_8._col0=RS_13._col0(Inner),Output:["_col0","_col1","_col2","_col3"]
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_13]
@@ -5406,8 +5408,8 @@ Stage-0
Stage-1
Map 3 llap
File Output Operator [FS_21]
- Map Join Operator [MAPJOIN_37] (rows=2 width=404)
- Conds:RS_16._col0=RS_17._col0(Inner),RS_17._col0=MAPJOIN_36._col0(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
+ Map Join Operator [MAPJOIN_67] (rows=2 width=404)
+ Conds:RS_16._col0=RS_17._col0(Inner),RS_17._col0=MAPJOIN_66._col0(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
<-Map 1 [BROADCAST_EDGE] llap
BROADCAST [RS_16]
PartitionCols:_col0
@@ -5426,7 +5428,7 @@ Stage-0
predicate:key is not null
TableScan [TS_3] (rows=1 width=368)
default@t2_n70,b,Tbl:COMPLETE,Col:NONE,Output:["key","val"]
- <-Map Join Operator [MAPJOIN_36] (rows=1 width=404)
+ <-Map Join Operator [MAPJOIN_66] (rows=1 width=404)
Conds:SEL_8._col0=RS_13._col0(Inner),Output:["_col0","_col1","_col2","_col3"]
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_13]
@@ -5472,7 +5474,7 @@ Stage-0
PartitionCols:rand()
Select Operator [SEL_9] (rows=550 width=87)
Output:["_col0","_col1","_col2"]
- Map Join Operator [MAPJOIN_21] (rows=550 width=87)
+ Map Join Operator [MAPJOIN_26] (rows=550 width=87)
Conds:RS_6.UDFToDouble(_col0)=SEL_5.(UDFToDouble(_col0) + 1.0D)(Inner),Output:["_col0","_col1","_col2"]
<-Map 1 [BROADCAST_EDGE] llap
BROADCAST [RS_6]
@@ -5526,7 +5528,7 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_10]
- Merge Join Operator [MERGEJOIN_15] (rows=791 width=356)
+ Merge Join Operator [MERGEJOIN_25] (rows=791 width=356)
Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_6]
@@ -5575,7 +5577,7 @@ Stage-0
PartitionCols:rand()
Select Operator [SEL_9] (rows=1 width=202)
Output:["_col0","_col1"]
- Map Join Operator [MAPJOIN_21] (rows=1 width=202)
+ Map Join Operator [MAPJOIN_31] (rows=1 width=202)
Conds:SEL_2._col0=RS_7._col0(Inner),Output:["_col0","_col1"]
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_7]
@@ -5621,7 +5623,7 @@ Stage-0
PartitionCols:rand()
Select Operator [SEL_9] (rows=1 width=202)
Output:["_col0","_col1"]
- Map Join Operator [MAPJOIN_21] (rows=1 width=202)
+ Map Join Operator [MAPJOIN_31] (rows=1 width=202)
Conds:RS_6._col0=SEL_5._col0(Inner),Output:["_col0","_col2"]
<-Map 1 [BROADCAST_EDGE] llap
BROADCAST [RS_6]
@@ -5665,7 +5667,7 @@ Stage-0
<-Map 1 [CUSTOM_SIMPLE_EDGE] llap
PARTITION_ONLY_SHUFFLE [RS_10]
PartitionCols:rand()
- Map Join Operator [MAPJOIN_20] (rows=1 width=202)
+ Map Join Operator [MAPJOIN_30] (rows=1 width=202)
Conds:SEL_2._col0=RS_7._col0(Inner)
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_7]
@@ -5711,7 +5713,7 @@ Stage-0
PartitionCols:rand()
Select Operator [SEL_7] (rows=1 width=404)
Output:["_col0","_col1","_col2"]
- Map Join Operator [MAPJOIN_17] (rows=1 width=404)
+ Map Join Operator [MAPJOIN_22] (rows=1 width=404)
Conds:SEL_1.UDFToDouble(_col0)=RS_5.(UDFToDouble(_col0) + 1.0D)(Left Outer),Output:["_col0","_col1","_col2"]
<-Map 4 [BROADCAST_EDGE] llap
BROADCAST [RS_5]