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:39 UTC
[36/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_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out b/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
index 95098b9..c7a7153 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
@@ -25,28 +25,28 @@ Stage-0
limit:-1
Stage-1
Reducer 3 vectorized, llap
- File Output Operator [FS_25]
- Select Operator [SEL_24] (rows=2048 width=552)
+ File Output Operator [FS_35]
+ Select Operator [SEL_34] (rows=2048 width=552)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_10]
- Merge Join Operator [MERGEJOIN_17] (rows=2048 width=552)
- Conds:RS_20._col2=RS_23._col2(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
+ Merge Join Operator [MERGEJOIN_27] (rows=2048 width=552)
+ Conds:RS_30._col2=RS_33._col2(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
<-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_20]
+ SHUFFLE [RS_30]
PartitionCols:_col2
- Select Operator [SEL_19] (rows=1365 width=251)
+ Select Operator [SEL_29] (rows=1365 width=251)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
- Filter Operator [FIL_18] (rows=1365 width=251)
+ Filter Operator [FIL_28] (rows=1365 width=251)
predicate:cint BETWEEN 1000000 AND 3000000
TableScan [TS_0] (rows=12288 width=251)
default@alltypesorc,a,Tbl:COMPLETE,Col:COMPLETE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
<-Map 4 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_23]
+ SHUFFLE [RS_33]
PartitionCols:_col2
- Select Operator [SEL_22] (rows=1019 width=251)
+ Select Operator [SEL_32] (rows=1019 width=251)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
- Filter Operator [FIL_21] (rows=1019 width=251)
+ Filter Operator [FIL_31] (rows=1019 width=251)
predicate:(cbigint is not null and cint BETWEEN 1000000 AND 3000000)
TableScan [TS_3] (rows=12288 width=251)
default@alltypesorc,b,Tbl:COMPLETE,Col:COMPLETE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
@@ -104,30 +104,30 @@ Stage-0
limit:-1
Stage-1
Reducer 3 vectorized, llap
- File Output Operator [FS_27]
- Group By Operator [GBY_26] (rows=1 width=8)
+ File Output Operator [FS_37]
+ Group By Operator [GBY_36] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Reducer 2 [CUSTOM_SIMPLE_EDGE] llap
PARTITION_ONLY_SHUFFLE [RS_11]
Group By Operator [GBY_10] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Merge Join Operator [MERGEJOIN_19] (rows=2048 width=8)
- Conds:RS_22._col0=RS_25._col0(Inner)
+ Merge Join Operator [MERGEJOIN_29] (rows=2048 width=8)
+ Conds:RS_32._col0=RS_35._col0(Inner)
<-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_22]
+ SHUFFLE [RS_32]
PartitionCols:_col0
- Select Operator [SEL_21] (rows=1365 width=2)
+ Select Operator [SEL_31] (rows=1365 width=2)
Output:["_col0"]
- Filter Operator [FIL_20] (rows=1365 width=2)
+ Filter Operator [FIL_30] (rows=1365 width=2)
predicate:cint BETWEEN 1000000 AND 3000000
TableScan [TS_0] (rows=12288 width=2)
default@alltypesorc,a,Tbl:COMPLETE,Col:COMPLETE,Output:["cint"]
<-Map 4 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_25]
+ SHUFFLE [RS_35]
PartitionCols:_col0
- Select Operator [SEL_24] (rows=1019 width=8)
+ Select Operator [SEL_34] (rows=1019 width=8)
Output:["_col0"]
- Filter Operator [FIL_23] (rows=1019 width=8)
+ Filter Operator [FIL_33] (rows=1019 width=8)
predicate:(cbigint is not null and cint BETWEEN 1000000 AND 3000000)
TableScan [TS_3] (rows=12288 width=8)
default@alltypesorc,b,Tbl:COMPLETE,Col:COMPLETE,Output:["cint","cbigint"]
@@ -179,35 +179,35 @@ Stage-0
limit:-1
Stage-1
Reducer 4 vectorized, llap
- File Output Operator [FS_31]
- Select Operator [SEL_30] (rows=631 width=11)
+ File Output Operator [FS_41]
+ Select Operator [SEL_40] (rows=631 width=11)
Output:["_col0","_col1"]
<-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_29]
- Group By Operator [GBY_28] (rows=631 width=11)
+ SHUFFLE [RS_39]
+ Group By Operator [GBY_38] (rows=631 width=11)
Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_11]
PartitionCols:_col0
Group By Operator [GBY_10] (rows=631 width=11)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Merge Join Operator [MERGEJOIN_21] (rows=2048 width=3)
- Conds:RS_24._col1=RS_27._col0(Inner),Output:["_col0"]
+ Merge Join Operator [MERGEJOIN_31] (rows=2048 width=3)
+ Conds:RS_34._col1=RS_37._col0(Inner),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_24]
+ SHUFFLE [RS_34]
PartitionCols:_col1
- Select Operator [SEL_23] (rows=1365 width=5)
+ Select Operator [SEL_33] (rows=1365 width=5)
Output:["_col0","_col1"]
- Filter Operator [FIL_22] (rows=1365 width=5)
+ Filter Operator [FIL_32] (rows=1365 width=5)
predicate:cint BETWEEN 1000000 AND 3000000
TableScan [TS_0] (rows=12288 width=5)
default@alltypesorc,a,Tbl:COMPLETE,Col:COMPLETE,Output:["csmallint","cint"]
<-Map 5 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_27]
+ SHUFFLE [RS_37]
PartitionCols:_col0
- Select Operator [SEL_26] (rows=1019 width=8)
+ Select Operator [SEL_36] (rows=1019 width=8)
Output:["_col0"]
- Filter Operator [FIL_25] (rows=1019 width=8)
+ Filter Operator [FIL_35] (rows=1019 width=8)
predicate:(cbigint is not null and cint BETWEEN 1000000 AND 3000000)
TableScan [TS_3] (rows=12288 width=8)
default@alltypesorc,b,Tbl:COMPLETE,Col:COMPLETE,Output:["cint","cbigint"]
@@ -264,28 +264,28 @@ Stage-0
limit:-1
Stage-1
Reducer 3 vectorized, llap
- File Output Operator [FS_28]
- Select Operator [SEL_27] (rows=1501 width=236)
+ File Output Operator [FS_38]
+ Select Operator [SEL_37] (rows=1501 width=236)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
<-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_26]
- Map Join Operator [MAPJOIN_25] (rows=1501 width=236)
- Conds:RS_21.KEY.reducesinkkey0=RS_24.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true,Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
+ SHUFFLE [RS_36]
+ Map Join Operator [MAPJOIN_35] (rows=1501 width=236)
+ Conds:RS_31.KEY.reducesinkkey0=RS_34.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true,Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
<-Map 4 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_24]
+ PARTITION_ONLY_SHUFFLE [RS_34]
PartitionCols:_col2
- Select Operator [SEL_23] (rows=1365 width=236)
+ Select Operator [SEL_33] (rows=1365 width=236)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
- Filter Operator [FIL_22] (rows=1365 width=236)
+ Filter Operator [FIL_32] (rows=1365 width=236)
predicate:(cbigint is not null and cint BETWEEN 1000000 AND 3000000)
TableScan [TS_3] (rows=12288 width=236)
default@alltypesorc,b,Tbl:COMPLETE,Col:NONE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
<-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_21]
+ PARTITION_ONLY_SHUFFLE [RS_31]
PartitionCols:_col2
- Select Operator [SEL_20] (rows=1365 width=236)
+ Select Operator [SEL_30] (rows=1365 width=236)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
- Filter Operator [FIL_19] (rows=1365 width=236)
+ Filter Operator [FIL_29] (rows=1365 width=236)
predicate:cint BETWEEN 1000000 AND 3000000
TableScan [TS_0] (rows=12288 width=236)
default@alltypesorc,a,Tbl:COMPLETE,Col:NONE,Output:["ctinyint","csmallint","cint","cbigint","cfloat","cdouble","cstring1","cstring2","ctimestamp1","ctimestamp2","cboolean1","cboolean2"]
@@ -343,30 +343,30 @@ Stage-0
limit:-1
Stage-1
Reducer 3 vectorized, llap
- File Output Operator [FS_31]
- Group By Operator [GBY_30] (rows=1 width=8)
+ File Output Operator [FS_41]
+ Group By Operator [GBY_40] (rows=1 width=8)
Output:["_col0"],aggregations:["count(VALUE._col0)"]
<-Reducer 2 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_29]
- Group By Operator [GBY_28] (rows=1 width=8)
+ PARTITION_ONLY_SHUFFLE [RS_39]
+ Group By Operator [GBY_38] (rows=1 width=8)
Output:["_col0"],aggregations:["count()"]
- Map Join Operator [MAPJOIN_27] (rows=1501 width=236)
- Conds:RS_23.KEY.reducesinkkey0=RS_26.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true
+ Map Join Operator [MAPJOIN_37] (rows=1501 width=236)
+ Conds:RS_33.KEY.reducesinkkey0=RS_36.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true
<-Map 4 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_26]
+ PARTITION_ONLY_SHUFFLE [RS_36]
PartitionCols:_col0
- Select Operator [SEL_25] (rows=1365 width=236)
+ Select Operator [SEL_35] (rows=1365 width=236)
Output:["_col0"]
- Filter Operator [FIL_24] (rows=1365 width=236)
+ Filter Operator [FIL_34] (rows=1365 width=236)
predicate:(cbigint is not null and cint BETWEEN 1000000 AND 3000000)
TableScan [TS_3] (rows=12288 width=236)
default@alltypesorc,b,Tbl:COMPLETE,Col:NONE,Output:["cint","cbigint"]
<-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_23]
+ PARTITION_ONLY_SHUFFLE [RS_33]
PartitionCols:_col0
- Select Operator [SEL_22] (rows=1365 width=236)
+ Select Operator [SEL_32] (rows=1365 width=236)
Output:["_col0"]
- Filter Operator [FIL_21] (rows=1365 width=236)
+ Filter Operator [FIL_31] (rows=1365 width=236)
predicate:cint BETWEEN 1000000 AND 3000000
TableScan [TS_0] (rows=12288 width=236)
default@alltypesorc,a,Tbl:COMPLETE,Col:NONE,Output:["cint"]
@@ -418,35 +418,35 @@ Stage-0
limit:-1
Stage-1
Reducer 4 vectorized, llap
- File Output Operator [FS_35]
- Select Operator [SEL_34] (rows=750 width=236)
+ File Output Operator [FS_45]
+ Select Operator [SEL_44] (rows=750 width=236)
Output:["_col0","_col1"]
<-Reducer 3 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_33]
- Group By Operator [GBY_32] (rows=750 width=236)
+ SHUFFLE [RS_43]
+ Group By Operator [GBY_42] (rows=750 width=236)
Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0
<-Reducer 2 [SIMPLE_EDGE] vectorized, llap
- SHUFFLE [RS_31]
+ SHUFFLE [RS_41]
PartitionCols:_col0
- Group By Operator [GBY_30] (rows=1501 width=236)
+ Group By Operator [GBY_40] (rows=1501 width=236)
Output:["_col0","_col1"],aggregations:["count()"],keys:_col0
- Map Join Operator [MAPJOIN_29] (rows=1501 width=236)
- Conds:RS_25.KEY.reducesinkkey0=RS_28.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true,Output:["_col0"]
+ Map Join Operator [MAPJOIN_39] (rows=1501 width=236)
+ Conds:RS_35.KEY.reducesinkkey0=RS_38.KEY.reducesinkkey0(Inner),HybridGraceHashJoin:true,Output:["_col0"]
<-Map 5 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_28]
+ PARTITION_ONLY_SHUFFLE [RS_38]
PartitionCols:_col0
- Select Operator [SEL_27] (rows=1365 width=236)
+ Select Operator [SEL_37] (rows=1365 width=236)
Output:["_col0"]
- Filter Operator [FIL_26] (rows=1365 width=236)
+ Filter Operator [FIL_36] (rows=1365 width=236)
predicate:(cbigint is not null and cint BETWEEN 1000000 AND 3000000)
TableScan [TS_3] (rows=12288 width=236)
default@alltypesorc,b,Tbl:COMPLETE,Col:NONE,Output:["cint","cbigint"]
<-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap
- PARTITION_ONLY_SHUFFLE [RS_25]
+ PARTITION_ONLY_SHUFFLE [RS_35]
PartitionCols:_col1
- Select Operator [SEL_24] (rows=1365 width=236)
+ Select Operator [SEL_34] (rows=1365 width=236)
Output:["_col0","_col1"]
- Filter Operator [FIL_23] (rows=1365 width=236)
+ Filter Operator [FIL_33] (rows=1365 width=236)
predicate:cint BETWEEN 1000000 AND 3000000
TableScan [TS_0] (rows=12288 width=236)
default@alltypesorc,a,Tbl:COMPLETE,Col:NONE,Output:["csmallint","cint"]
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/filter_join_breaktask.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/filter_join_breaktask.q.out b/ql/src/test/results/clientpositive/llap/filter_join_breaktask.q.out
index c473183..4b15ce0 100644
--- a/ql/src/test/results/clientpositive/llap/filter_join_breaktask.q.out
+++ b/ql/src/test/results/clientpositive/llap/filter_join_breaktask.q.out
@@ -45,6 +45,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: f
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -122,6 +123,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: m
+ filterExpr: ((value <> '') and key is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 2289 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -200,6 +202,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: g
+ filterExpr: (value <> '') (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/groupby_resolution.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/groupby_resolution.q.out b/ql/src/test/results/clientpositive/llap/groupby_resolution.q.out
index 39dd4d5..11bb452 100644
--- a/ql/src/test/results/clientpositive/llap/groupby_resolution.q.out
+++ b/ql/src/test/results/clientpositive/llap/groupby_resolution.q.out
@@ -647,6 +647,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (key < '12') (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < '12') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out b/ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out
index a47df59..421250f 100644
--- a/ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out
+++ b/ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out
@@ -165,6 +165,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tx2_n1
+ filterExpr: (a < 0) (type: boolean)
Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (a < 0) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/having.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/having.q.out b/ql/src/test/results/clientpositive/llap/having.q.out
index 3964a31..742fc02 100644
--- a/ql/src/test/results/clientpositive/llap/having.q.out
+++ b/ql/src/test/results/clientpositive/llap/having.q.out
@@ -109,6 +109,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToDouble(key) <> 302.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) <> 302.0D) (type: boolean)
@@ -762,6 +763,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToDouble(key) > 300.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToDouble(key) > 300.0D) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out
index e98f3ba..333b103 100644
--- a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out
@@ -40,6 +40,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cint < 2000000000) (type: boolean)
@@ -72,6 +73,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cd
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cint < 2000000000) (type: boolean)
@@ -161,6 +163,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cint < 2000000000) (type: boolean)
@@ -193,6 +196,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cd
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cint < 2000000000) (type: boolean)
@@ -280,6 +284,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: cint is not null (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint is not null (type: boolean)
@@ -312,6 +317,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cd
+ filterExpr: cint is not null (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint is not null (type: boolean)
@@ -397,6 +403,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: cint is not null (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint is not null (type: boolean)
@@ -429,6 +436,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cd
+ filterExpr: cint is not null (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint is not null (type: boolean)
@@ -768,6 +776,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -800,6 +809,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -889,6 +899,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -922,6 +933,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1011,6 +1023,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1030,6 +1043,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1138,6 +1152,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1157,6 +1172,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 525 Data size: 104474 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1291,6 +1307,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
+ filterExpr: (cint = 6981) (type: boolean)
Statistics: Num rows: 12288 Data size: 1354300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cint = 6981) (type: boolean)
@@ -1309,6 +1326,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: r
+ filterExpr: (cint = 6981) (type: boolean)
Statistics: Num rows: 12288 Data size: 1354300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cint = 6981) (type: boolean)
@@ -1494,6 +1512,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: l
+ filterExpr: (cint = 6981) (type: boolean)
Statistics: Num rows: 12288 Data size: 1354300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cint = 6981) (type: boolean)
@@ -1512,6 +1531,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: r
+ filterExpr: (cint = 6981) (type: boolean)
Statistics: Num rows: 12288 Data size: 1354300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cint = 6981) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
index ed7d8c9..5996e07 100644
--- a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
@@ -43,6 +43,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -58,6 +59,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -89,6 +91,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -174,6 +177,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -189,6 +193,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -220,6 +225,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -316,6 +322,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -331,6 +338,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -365,6 +373,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: w
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -380,6 +389,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -469,6 +479,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -484,6 +495,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -518,6 +530,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: w
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -533,6 +546,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -640,6 +654,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -655,6 +670,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -670,6 +686,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -701,6 +718,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -716,6 +734,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -731,6 +750,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 182000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -890,6 +910,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -905,6 +926,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -920,6 +942,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -951,6 +974,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -966,6 +990,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -981,6 +1006,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 182000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1148,6 +1174,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: ((value < 'zzzzzzzzzz') and (key < 'zzzzzzzz')) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 'zzzzzzzz') and (value < 'zzzzzzzzzz')) (type: boolean)
@@ -1164,6 +1191,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z1
+ filterExpr: (key < 'zzzzzzzz') (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 'zzzzzzzz') (type: boolean)
@@ -1208,6 +1236,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y1
+ filterExpr: ((value < 'zzzzzzzz') and (key < 'zzzzzzzz')) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 'zzzzzzzz') and (value < 'zzzzzzzz')) (type: boolean)
@@ -1223,6 +1252,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z2
+ filterExpr: ((key < 'zzzzzzzzzz') and (value < 'zzzzzzzzzz')) (type: boolean)
Statistics: Num rows: 2000 Data size: 356000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 'zzzzzzzzzz') and (value < 'zzzzzzzzzz')) (type: boolean)
@@ -1238,6 +1268,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: (value < 'zzzzzzzzzz') (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (value < 'zzzzzzzzzz') (type: boolean)
@@ -1343,6 +1374,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: ((value < 'zzzzzzzzzz') and (key < 'zzzzzzzz')) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 'zzzzzzzz') and (value < 'zzzzzzzzzz')) (type: boolean)
@@ -1359,6 +1391,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z1
+ filterExpr: (key < 'zzzzzzzz') (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 'zzzzzzzz') (type: boolean)
@@ -1403,6 +1436,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y1
+ filterExpr: ((value < 'zzzzzzzz') and (key < 'zzzzzzzz')) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 'zzzzzzzz') and (value < 'zzzzzzzz')) (type: boolean)
@@ -1418,6 +1452,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z2
+ filterExpr: ((key < 'zzzzzzzzzz') and (value < 'zzzzzzzzzz')) (type: boolean)
Statistics: Num rows: 2000 Data size: 356000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 'zzzzzzzzzz') and (value < 'zzzzzzzzzz')) (type: boolean)
@@ -1433,6 +1468,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: (value < 'zzzzzzzzzz') (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (value < 'zzzzzzzzzz') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/identity_project_remove_skip.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/identity_project_remove_skip.q.out b/ql/src/test/results/clientpositive/llap/identity_project_remove_skip.q.out
index b29d277..aacbd96 100644
--- a/ql/src/test/results/clientpositive/llap/identity_project_remove_skip.q.out
+++ b/ql/src/test/results/clientpositive/llap/identity_project_remove_skip.q.out
@@ -32,6 +32,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((value = 'val_105') and (key = '105')) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key = '105') and (value = 'val_105')) (type: boolean)
@@ -49,6 +50,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '105') (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key = '105') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/insert1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert1.q.out b/ql/src/test/results/clientpositive/llap/insert1.q.out
index 33ad150..94cef86 100644
--- a/ql/src/test/results/clientpositive/llap/insert1.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert1.q.out
@@ -46,6 +46,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key = -1) (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = -1) (type: boolean)
@@ -136,6 +137,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key = -1) (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = -1) (type: boolean)
@@ -240,6 +242,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key = -1) (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = -1) (type: boolean)
@@ -330,6 +333,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key = -1) (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = -1) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/insert1_overwrite_partitions.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert1_overwrite_partitions.q.out b/ql/src/test/results/clientpositive/llap/insert1_overwrite_partitions.q.out
index 7f830e9..228cb6a 100644
--- a/ql/src/test/results/clientpositive/llap/insert1_overwrite_partitions.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert1_overwrite_partitions.q.out
@@ -57,6 +57,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: sourcetable
+ filterExpr: ((ds = '2011-11-11') and (hr = '11')) (type: boolean)
Statistics: Num rows: 99 Data size: 93448 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: one (type: string), two (type: string)
@@ -245,6 +246,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: sourcetable
+ filterExpr: ((ds = '2011-11-11') and (hr = '11')) (type: boolean)
Statistics: Num rows: 99 Data size: 93448 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: one (type: string), two (type: string)
@@ -402,6 +404,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: sourcetable
+ filterExpr: ((ds = '2011-11-11') and (hr = '11')) (type: boolean)
Statistics: Num rows: 99 Data size: 93448 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: one (type: string), two (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/insert_into2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert_into2.q.out b/ql/src/test/results/clientpositive/llap/insert_into2.q.out
index 0303f56..47927d5 100644
--- a/ql/src/test/results/clientpositive/llap/insert_into2.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert_into2.q.out
@@ -594,6 +594,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: insert_into2
+ filterExpr: (ds = '2') (type: boolean)
Statistics: Num rows: 50 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
Statistics: Num rows: 50 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out b/ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out
index febcddb..cd38c51 100644
--- a/ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert_into_default_keyword.q.out
@@ -1704,6 +1704,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: insert_into1_n0
+ filterExpr: (value = 1) (type: boolean)
Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (value = 1) (type: boolean)
@@ -1811,6 +1812,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: insert_into1_n0
+ filterExpr: (value = 1) (type: boolean)
Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (value = 1) (type: boolean)
@@ -2368,6 +2370,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t
+ filterExpr: enforce_constraint(key is not null) (type: boolean)
Statistics: Num rows: 20 Data size: 80 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: enforce_constraint(key is not null) (type: boolean)
@@ -2383,6 +2386,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
+ filterExpr: enforce_constraint(key is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: enforce_constraint(key is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
index 1c0841c..8bd95b1 100644
--- a/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert_values_orig_table_use_metadata.q.out
@@ -906,6 +906,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: sp
+ filterExpr: ((ds = '2008-04-08') and (hr = '11')) (type: boolean)
Statistics: Num rows: 99 Data size: 58912 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
Statistics: Num rows: 99 Data size: 58912 Basic stats: COMPLETE Column stats: COMPLETE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/is_distinct_from.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/is_distinct_from.q.out b/ql/src/test/results/clientpositive/llap/is_distinct_from.q.out
index 1938a76..5ec8867 100644
--- a/ql/src/test/results/clientpositive/llap/is_distinct_from.q.out
+++ b/ql/src/test/results/clientpositive/llap/is_distinct_from.q.out
@@ -194,6 +194,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: test_n5
+ filterExpr: (y <> null) (type: boolean)
Filter Operator
predicate: (y <> null) (type: boolean)
Select Operator
@@ -226,6 +227,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: test_n5
+ filterExpr: (y = null) (type: boolean)
Filter Operator
predicate: (y = null) (type: boolean)
Select Operator
@@ -265,6 +267,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: part
+ filterExpr: (p_size <> 2) (type: boolean)
Filter Operator
predicate: (p_size <> 2) (type: boolean)
Select Operator
@@ -316,6 +319,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: part
+ filterExpr: (p_size = 2) (type: boolean)
Filter Operator
predicate: (p_size = 2) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out b/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
index e7e3bc3..f55bda5 100644
--- a/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
+++ b/ql/src/test/results/clientpositive/llap/jdbc_handler.q.out
@@ -243,6 +243,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((UDFToDouble(key) - 1.0D) = 1.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) - 1.0D) = 1.0D) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join0.q.out b/ql/src/test/results/clientpositive/llap/join0.q.out
index c2c6515..a6baa0f 100644
--- a/ql/src/test/results/clientpositive/llap/join0.q.out
+++ b/ql/src/test/results/clientpositive/llap/join0.q.out
@@ -32,6 +32,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -50,6 +51,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 10) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join1.q.out b/ql/src/test/results/clientpositive/llap/join1.q.out
index cf14327..9bdec85 100644
--- a/ql/src/test/results/clientpositive/llap/join1.q.out
+++ b/ql/src/test/results/clientpositive/llap/join1.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -52,6 +53,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out b/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
index e4b5673..48efb80 100644
--- a/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
+++ b/ql/src/test/results/clientpositive/llap/join32_lessSize.q.out
@@ -46,6 +46,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -136,6 +137,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -214,6 +216,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -578,6 +581,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (value is not null and key is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -656,6 +660,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -734,6 +739,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -812,6 +818,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: w
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -1195,6 +1202,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -1273,6 +1281,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -1367,6 +1376,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -1729,6 +1739,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -1880,6 +1891,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
@@ -1965,7 +1977,7 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col1 (type: string)
outputColumnNames: _col0, _col3, _col4
- Position of Big Table: 0
+ Position of Big Table: 1
Statistics: Num rows: 63 Data size: 16758 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col3 (type: string), _col0 (type: string), _col4 (type: string)
@@ -2280,6 +2292,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -2299,6 +2312,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -2333,6 +2347,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -2570,6 +2585,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -2589,6 +2605,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -2623,6 +2640,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join46.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join46.q.out b/ql/src/test/results/clientpositive/llap/join46.q.out
index 1f637d4..b6ef9b1 100644
--- a/ql/src/test/results/clientpositive/llap/join46.q.out
+++ b/ql/src/test/results/clientpositive/llap/join46.q.out
@@ -190,6 +190,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2_n0
+ filterExpr: key BETWEEN 100 AND 102 (type: boolean)
Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
@@ -302,6 +303,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2_n0
+ filterExpr: key BETWEEN 100 AND 102 (type: boolean)
Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
@@ -2016,7 +2018,7 @@ NULL NULL None NULL NULL NULL
101 2 Car 102 2 Del
101 2 Car 103 2 Ema
NULL NULL NULL 104 3 Fli
-Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: EXPLAIN
SELECT *
FROM (
@@ -2086,6 +2088,10 @@ STAGE PLANS:
Map-reduce partition columns: _col1 (type: int)
Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
+ Select Operator
+ expressions: key (type: int), value (type: int), col_1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
@@ -2109,6 +2115,10 @@ STAGE PLANS:
Map-reduce partition columns: _col1 (type: int)
Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
+ Select Operator
+ expressions: key (type: int), value (type: int), col_2 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
@@ -2175,7 +2185,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: SELECT *
FROM (
SELECT test1_n2.key AS key1, test1_n2.value AS value1, test1_n2.col_1 AS col_1,
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join_is_not_distinct_from.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join_is_not_distinct_from.q.out b/ql/src/test/results/clientpositive/llap/join_is_not_distinct_from.q.out
index f29700f..acb3381 100644
--- a/ql/src/test/results/clientpositive/llap/join_is_not_distinct_from.q.out
+++ b/ql/src/test/results/clientpositive/llap/join_is_not_distinct_from.q.out
@@ -125,6 +125,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -141,6 +142,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -157,6 +159,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -354,6 +357,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -369,6 +373,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -384,6 +389,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1596,6 +1602,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is null (type: boolean)
@@ -1612,6 +1619,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join_max_hashtable.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join_max_hashtable.q.out b/ql/src/test/results/clientpositive/llap/join_max_hashtable.q.out
index 996b789..c0c9f95 100644
--- a/ql/src/test/results/clientpositive/llap/join_max_hashtable.q.out
+++ b/ql/src/test/results/clientpositive/llap/join_max_hashtable.q.out
@@ -22,6 +22,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -53,6 +54,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -99,6 +101,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -130,6 +133,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -176,6 +180,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -196,6 +201,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -263,6 +269,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -282,6 +289,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -349,6 +357,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -369,6 +378,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -436,6 +446,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -455,6 +466,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -522,6 +534,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -553,6 +566,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -599,6 +613,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -630,6 +645,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join_nullsafe.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join_nullsafe.q.out b/ql/src/test/results/clientpositive/llap/join_nullsafe.q.out
index d64c8b8..4e923c6 100644
--- a/ql/src/test/results/clientpositive/llap/join_nullsafe.q.out
+++ b/ql/src/test/results/clientpositive/llap/join_nullsafe.q.out
@@ -125,6 +125,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -141,6 +142,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -157,6 +159,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -354,6 +357,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -369,6 +373,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -384,6 +389,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1596,6 +1602,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is null (type: boolean)
@@ -1612,6 +1619,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is null (type: boolean)