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:46 UTC
[43/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/join_thrift.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_thrift.q.out b/ql/src/test/results/clientpositive/join_thrift.q.out
index 8748a5b..578aaff 100644
--- a/ql/src/test/results/clientpositive/join_thrift.q.out
+++ b/ql/src/test/results/clientpositive/join_thrift.q.out
@@ -36,6 +36,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: aint is not null (type: boolean)
Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: aint is not null (type: boolean)
@@ -47,6 +48,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: s2
+ filterExpr: aint is not null (type: boolean)
Statistics: Num rows: 11 Data size: 30700 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: aint is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/join_vc.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_vc.q.out b/ql/src/test/results/clientpositive/join_vc.q.out
index 109ac59..7ae3801 100644
--- a/ql/src/test/results/clientpositive/join_vc.q.out
+++ b/ql/src/test/results/clientpositive/join_vc.q.out
@@ -14,6 +14,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -29,6 +30,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t2
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -70,6 +72,7 @@ STAGE PLANS:
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t3
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -166,6 +169,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
+ filterExpr: (UDFToDouble(key) < 100.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToDouble(key) < 100.0D) (type: boolean)
@@ -181,6 +185,7 @@ STAGE PLANS:
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t2
+ filterExpr: (UDFToDouble(key) < 100.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToDouble(key) < 100.0D) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/join_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_view.q.out b/ql/src/test/results/clientpositive/join_view.q.out
index b8bf1ea..5fc5c6f 100644
--- a/ql/src/test/results/clientpositive/join_view.q.out
+++ b/ql/src/test/results/clientpositive/join_view.q.out
@@ -52,6 +52,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: invites
+ filterExpr: (ds = '2011-09-01') (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
@@ -68,6 +69,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
TableScan
alias: invites2
+ filterExpr: (ds = '2011-09-01') (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/lateral_view_cp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/lateral_view_cp.q.out b/ql/src/test/results/clientpositive/lateral_view_cp.q.out
index b58da18..fec8c81 100644
--- a/ql/src/test/results/clientpositive/lateral_view_cp.q.out
+++ b/ql/src/test/results/clientpositive/lateral_view_cp.q.out
@@ -35,6 +35,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -46,6 +47,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
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/lateral_view_onview.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/lateral_view_onview.q.out b/ql/src/test/results/clientpositive/lateral_view_onview.q.out
index 4de4f2e..1ba94da 100644
--- a/ql/src/test/results/clientpositive/lateral_view_onview.q.out
+++ b/ql/src/test/results/clientpositive/lateral_view_onview.q.out
@@ -672,6 +672,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lv_table1_n0
+ filterExpr: c1 is not null (type: boolean)
Statistics: Num rows: 500 Data size: 28000 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: c1 is not null (type: boolean)
@@ -684,6 +685,7 @@ STAGE PLANS:
value expressions: c3 (type: int), c4 (type: char(1)), c5 (type: string), c6 (type: string), c7 (type: string), c8 (type: string), c9 (type: string), c10 (type: string), c11 (type: string), c12 (type: string), c13 (type: string)
TableScan
alias: lv_table2
+ filterExpr: c1 is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5500 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: c1 is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/lateral_view_ppd.q.out b/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
index 2e3adab..25c94e2 100644
--- a/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
+++ b/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
@@ -12,6 +12,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '0') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
@@ -95,6 +96,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '0') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
@@ -175,6 +177,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: ((ds = '2008-04-08') and (hr = '12')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -266,6 +269,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '0') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
@@ -427,6 +431,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '0') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/leftsemijoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/leftsemijoin.q.out b/ql/src/test/results/clientpositive/leftsemijoin.q.out
index 77d50a6..f8ae36b 100644
--- a/ql/src/test/results/clientpositive/leftsemijoin.q.out
+++ b/ql/src/test/results/clientpositive/leftsemijoin.q.out
@@ -124,6 +124,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -170,6 +171,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out b/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
index 054305d..20bcd4b 100644
--- a/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
+++ b/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
@@ -12,6 +12,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -28,6 +29,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
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/list_bucket_dml_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
index d2308bb..6a959a8 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
@@ -29,6 +29,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -459,6 +460,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_dynamic_part_n0
+ filterExpr: ((ds = '2008-04-08') and (hr = '11') and (key = '484')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
index 550d378..c3eccac 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
@@ -342,6 +342,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_static_part_n3
+ filterExpr: ((ds = '2008-04-08') and (hr = '11') and (value = 'val_466')) (type: boolean)
Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
index 07b07fb..2f42296 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
@@ -350,6 +350,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_mul_col_n0
+ filterExpr: ((col2 = '466') and (col4 = 'val_466')) (type: boolean)
Statistics: Num rows: 500 Data size: 6312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -443,6 +444,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_mul_col_n0
+ filterExpr: ((col2 = '382') and (col4 = 'val_382')) (type: boolean)
Statistics: Num rows: 500 Data size: 6312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
index 4d1224b..e067e06 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
@@ -350,6 +350,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_mul_col
+ filterExpr: ((col2 = '466') and (col4 = 'val_466')) (type: boolean)
Statistics: Num rows: 500 Data size: 6312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
index ed23b0d..afe7678 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
@@ -297,6 +297,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: list_bucketing
+ filterExpr: (key = '484') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
index ea621b8..18aa8d5 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -415,6 +416,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_static_part_n4
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
index 3a6b27b..e70cfca 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
@@ -23,6 +23,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -407,6 +408,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_static_part_n1
+ filterExpr: ((ds = '2008-04-08') and (hr = '11') and (key = '484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
index 823e9e1..fb20e69 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -357,6 +358,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -854,6 +856,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_static_part_n2
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
index d71834f..fd5962f 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
@@ -29,6 +29,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -511,6 +512,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_dynamic_part_n1
+ filterExpr: ((key = '103') and (value = 'val_103')) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
index cd3228e..709b40c 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -402,6 +403,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -997,6 +999,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_dynamic_part_n3
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
index a325337..d12c9d9 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -402,6 +403,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -997,6 +999,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_dynamic_part
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
index 3aa3940..9939448 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -560,6 +561,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_dynamic_part_n2
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
index 78f1d8e..11d19fd 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
@@ -33,6 +33,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -357,6 +358,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -854,6 +856,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: list_bucketing_static_part_n0
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out
index 40455b7..b6192a1 100644
--- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out
@@ -138,6 +138,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -223,6 +224,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily
+ filterExpr: ((key = '238') and (value = 'val_238')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -309,6 +311,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily
+ filterExpr: ((ds = '1') and (hr = '4') and (value = '3')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -393,6 +396,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily
+ filterExpr: ((ds = '1') and (hr = '4') and (key = '495')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
index a7cf4e9..8a34b3d 100644
--- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
@@ -138,6 +138,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n2
+ filterExpr: ((ds = '1') and (hr = '4') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -223,6 +224,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n2
+ filterExpr: ((ds = '1') and (hr = '4') and (key = '406')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -311,6 +313,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n2
+ filterExpr: ((ds = '1') and (hr = '4') and (((key = '484') and (value = 'val_484')) or ((key = '238') and (value = 'val_238')))) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
index 273f2d0..93bbf58 100644
--- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
@@ -248,6 +248,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n3
+ filterExpr: ((ds = '1') and (hr = '1') and (key = '145')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -360,6 +361,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n3
+ filterExpr: ((key = '484') and (value = 'val_484')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -447,6 +449,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n3
+ filterExpr: ((key = '327') and (value = 'val_327')) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
index e2db72b..83545be 100644
--- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
@@ -186,6 +186,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n4
+ filterExpr: ((ds = '1') and (x = 484)) (type: boolean)
Statistics: Num rows: 1 Data size: 80 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
@@ -268,6 +269,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n4
+ filterExpr: ((ds = '1') and (x = 495)) (type: boolean)
Statistics: Num rows: 1 Data size: 80 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
@@ -350,6 +352,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n4
+ filterExpr: ((ds = '1') and (x = 1)) (type: boolean)
Statistics: Num rows: 1 Data size: 80 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
index 2537d94..b9407f7 100644
--- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
@@ -189,6 +189,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n5
+ filterExpr: ((ds = '1') and (x = 484)) (type: boolean)
Statistics: Num rows: 1 Data size: 240 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
@@ -271,6 +272,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n5
+ filterExpr: ((ds = '1') and (x = 484)) (type: boolean)
Statistics: Num rows: 1 Data size: 240 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
@@ -308,6 +310,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fact_daily_n5
+ filterExpr: ((ds = '1') and (x = 484)) (type: boolean)
Statistics: Num rows: 1 Data size: 240 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
@@ -447,6 +450,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fact_daily_n5
+ filterExpr: ((ds = '1') and (x = 484)) (type: boolean)
Statistics: Num rows: 1 Data size: 240 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
index 59aeda8..fcb5c4c 100644
--- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
@@ -209,6 +209,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: fact_daily_n0
+ filterExpr: ((ds = '1') and (x <> 86)) (type: boolean)
Statistics: Num rows: 2 Data size: 1170 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out b/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
index f9a17a5..36a6a5d 100644
--- a/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
+++ b/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
@@ -119,6 +119,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_acid
+ filterExpr: ((UDFToInteger(key)) IN (413, 43) and (hr = '11')) (type: boolean)
Statistics: Num rows: 1000 Data size: 362000 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: (UDFToInteger(key)) IN (413, 43) (type: boolean)
@@ -302,6 +303,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_acid
+ filterExpr: (key) IN ('1001', '213', '43') (type: boolean)
Statistics: Num rows: 2015 Data size: 916825 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: (key) IN ('1001', '213', '43') (type: boolean)
@@ -620,6 +622,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_acidb
+ filterExpr: ((UDFToInteger(key)) IN (413, 43) and (hr = '11')) (type: boolean)
Statistics: Num rows: 1000 Data size: 362000 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: (UDFToInteger(key)) IN (413, 43) (type: boolean)
@@ -803,6 +806,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_acidb
+ filterExpr: (key) IN ('1001', '213', '43') (type: boolean)
Statistics: Num rows: 2015 Data size: 916825 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: (key) IN ('1001', '213', '43') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
index a55f5b2..53d27e9 100644
--- a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
@@ -654,6 +654,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: alter5_n0
+ filterExpr: (dt = 'a') (type: boolean)
Select Operator
expressions: col1 (type: string), 'a' (type: string)
outputColumnNames: _col0, _col1
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
index 7f0867a..8e5f2ad 100644
--- a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
@@ -658,6 +658,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: alter5
+ filterExpr: (dt = 'a') (type: boolean)
Select Operator
expressions: col1 (type: string), 'a' (type: string)
outputColumnNames: _col0, _col1
@@ -775,6 +776,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: alter5
+ filterExpr: (dt = 'a') (type: boolean)
Select Operator
expressions: col1 (type: string), 'a' (type: string)
outputColumnNames: _col0, _col1
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_join0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_join0.q.out b/ql/src/test/results/clientpositive/llap/auto_join0.q.out
index a42001e..10aafa5 100644
--- a/ql/src/test/results/clientpositive/llap/auto_join0.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_join0.q.out
@@ -40,6 +40,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/auto_join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_join1.q.out b/ql/src/test/results/clientpositive/llap/auto_join1.q.out
index 17987a7..badc717 100644
--- a/ql/src/test/results/clientpositive/llap/auto_join1.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_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/auto_join21.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_join21.q.out b/ql/src/test/results/clientpositive/llap/auto_join21.q.out
index 5889720..c74fab7 100644
--- a/ql/src/test/results/clientpositive/llap/auto_join21.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_join21.q.out
@@ -34,6 +34,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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/auto_join29.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_join29.q.out b/ql/src/test/results/clientpositive/llap/auto_join29.q.out
index 3891ea0..9db7cb3 100644
--- a/ql/src/test/results/clientpositive/llap/auto_join29.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_join29.q.out
@@ -34,6 +34,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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)
@@ -649,6 +650,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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)
@@ -665,6 +667,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -1254,6 +1257,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ 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)
@@ -1283,6 +1287,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ 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)
@@ -1884,6 +1889,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ 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)
@@ -2511,6 +2517,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2527,6 +2534,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2543,6 +2551,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2628,6 +2637,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2644,6 +2654,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3278,6 +3289,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3294,6 +3306,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3358,6 +3371,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ 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)
@@ -3374,6 +3388,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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)
@@ -3409,6 +3424,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ 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)
@@ -3495,6 +3511,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3526,6 +3543,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3542,6 +3560,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_join30.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_join30.q.out b/ql/src/test/results/clientpositive/llap/auto_join30.q.out
index 1f95237..874511a 100644
--- a/ql/src/test/results/clientpositive/llap/auto_join30.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_join30.q.out
@@ -31,6 +31,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
@@ -50,6 +51,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
@@ -392,6 +394,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
@@ -411,6 +414,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
@@ -447,6 +451,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
index 5489137..21273c1 100644
--- a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
@@ -64,6 +64,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -75,6 +76,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -174,6 +176,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -185,6 +188,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -330,6 +334,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -341,6 +346,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -374,6 +380,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -385,6 +392,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -547,6 +555,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -558,6 +567,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -664,6 +674,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -675,6 +686,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -805,6 +817,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -816,6 +829,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -934,6 +948,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 8) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 8) (type: boolean)
@@ -945,6 +960,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 8) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 8) (type: boolean)
@@ -1042,6 +1058,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1061,6 +1078,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1162,6 +1180,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1173,6 +1192,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1271,6 +1291,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1282,6 +1303,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1293,6 +1315,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1409,6 +1432,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1420,6 +1444,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -1549,6 +1574,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1560,6 +1586,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1834,6 +1861,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1845,6 +1873,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 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/auto_sortmerge_join_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out
index fd6ae5f..14b2cd0 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out
@@ -119,6 +119,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -186,6 +187,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -396,6 +398,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -463,6 +466,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -673,6 +677,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -740,6 +745,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out
index c2a273b..9e07f1c 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_10.q.out
@@ -81,6 +81,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -100,6 +101,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -119,6 +121,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -236,6 +239,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
@@ -247,6 +251,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key < 6) (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key < 6) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out
index b8bd10c..560db39 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_11.q.out
@@ -118,6 +118,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -197,6 +198,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -422,6 +424,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -489,6 +492,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -699,6 +703,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -762,6 +767,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -968,6 +974,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -1031,6 +1038,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -1144,6 +1152,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
index d09b19e..63d52da 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
@@ -134,7 +134,7 @@ POSTHOOK: query: load data local inpath '../../data/files/auto_sortmerge_join/sm
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_medium@ds=2008-04-08
-Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[54][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain extended select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain extended select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
@@ -156,6 +156,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 3 Data size: 552 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -223,6 +224,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -290,6 +292,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 39008 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -554,7 +557,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[54][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select count(*) FROM bucket_small_n15 a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big_n15 c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket_big_n15
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
index 34c9abc..11d72ef 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
@@ -87,6 +87,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -98,6 +99,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -358,6 +360,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -369,6 +372,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -629,6 +633,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -640,6 +645,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 930 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/auto_sortmerge_join_16.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out
index bd51c86..1fe234e 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out
@@ -192,6 +192,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket_big_n17
+ filterExpr: (day = 'day1') (type: boolean)
Statistics: Num rows: 5 Data size: 495 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: bigint), value (type: string)
@@ -209,6 +210,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket_small_n17
+ filterExpr: pri BETWEEN 1 AND 2 (type: boolean)
Statistics: Num rows: 236 Data size: 23364 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: bigint), value (type: string)
@@ -344,6 +346,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket_small_n17
+ filterExpr: pri BETWEEN 1 AND 2 (type: boolean)
Statistics: Num rows: 236 Data size: 23364 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: bigint), value (type: string)
@@ -352,6 +355,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket_big_n17
+ filterExpr: (day = 'day1') (type: boolean)
Statistics: Num rows: 5 Data size: 495 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: bigint), value (type: string)
@@ -586,6 +590,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket_small_n17
+ filterExpr: pri BETWEEN 1 AND 2 (type: boolean)
Statistics: Num rows: 236 Data size: 23364 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: bigint), value (type: string)
@@ -594,6 +599,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bucket_big_n17
+ filterExpr: (day = 'day1') (type: boolean)
Statistics: Num rows: 5 Data size: 495 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: bigint), value (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
index 075cbc1..dd7d321 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_2.q.out
@@ -101,6 +101,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 4 Data size: 2996 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -168,6 +169,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -378,6 +380,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 4 Data size: 2996 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -445,6 +448,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 74872 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
index 4bfc89e..d6a7239 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_3.q.out
@@ -101,6 +101,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -218,6 +219,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 120 Data size: 79280 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -378,6 +380,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -495,6 +498,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 120 Data size: 79280 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -655,6 +659,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 4 Data size: 3016 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -772,6 +777,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 120 Data size: 79280 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator