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:29 UTC
[26/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/mapjoin47.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin47.q.out b/ql/src/test/results/clientpositive/mapjoin47.q.out
index cd61cee..cf29fa0 100644
--- a/ql/src/test/results/clientpositive/mapjoin47.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin47.q.out
@@ -30,6 +30,7 @@ STAGE PLANS:
$hdt$_0:src1
TableScan
alias: src1
+ filterExpr: (UDFToDouble(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToDouble(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean)
@@ -48,6 +49,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToDouble(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToDouble(value) BETWEEN 100.0D AND 102.0D and key is not null) (type: boolean)
@@ -132,6 +134,7 @@ STAGE PLANS:
$hdt$_0:src1
TableScan
alias: src1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -150,6 +153,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
@@ -245,6 +249,7 @@ STAGE PLANS:
$hdt$_0:src1
TableScan
alias: src1
+ filterExpr: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean)
@@ -263,6 +268,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(value) BETWEEN 100.0D AND 102.0D (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mapjoin_distinct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin_distinct.q.out b/ql/src/test/results/clientpositive/mapjoin_distinct.q.out
index 0436e4a..19ab4e5 100644
--- a/ql/src/test/results/clientpositive/mapjoin_distinct.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin_distinct.q.out
@@ -27,6 +27,7 @@ STAGE PLANS:
$hdt$_0:c
TableScan
alias: c
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -45,6 +46,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -173,6 +175,7 @@ STAGE PLANS:
$hdt$_0:c
TableScan
alias: c
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -191,6 +194,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -297,6 +301,7 @@ STAGE PLANS:
$hdt$_0:c
TableScan
alias: c
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -315,6 +320,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -438,6 +444,7 @@ STAGE PLANS:
$hdt$_0:c
TableScan
alias: c
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -456,6 +463,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: d
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 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/mapjoin_filter_on_outerjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out b/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out
index 89d8c86..9472b85 100644
--- a/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out
@@ -67,6 +67,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: ((key < 300) and (key < 10)) (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key < 300)) (type: boolean)
@@ -83,6 +84,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key < 300) (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 300) (type: boolean)
@@ -102,6 +104,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: (key < 300) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 300) (type: boolean)
@@ -220,6 +223,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: ((key < 300) and (key < 10)) (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key < 300)) (type: boolean)
@@ -236,6 +240,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key < 300) (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 300) (type: boolean)
@@ -255,6 +260,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: (key < 300) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 300) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out b/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
index ed92c17..a62c798 100644
--- a/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
@@ -21,6 +21,7 @@ STAGE PLANS:
$hdt$_0:src
TableScan
alias: src
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -39,6 +40,7 @@ STAGE PLANS:
$hdt$_2:src1
TableScan
alias: src1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -60,6 +62,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (value is not null and key is not null) (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -445,6 +448,7 @@ STAGE PLANS:
$hdt$_0:src
TableScan
alias: src
+ filterExpr: (value > 'val_450') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (value > 'val_450') (type: boolean)
@@ -460,6 +464,7 @@ STAGE PLANS:
$hdt$_2:src1
TableScan
alias: src1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -478,6 +483,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: ((value > 'val_450') and key is not null) (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((value > 'val_450') and key is not null) (type: boolean)
@@ -544,6 +550,7 @@ STAGE PLANS:
$hdt$_1:src1
TableScan
alias: src1
+ 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)
@@ -559,6 +566,7 @@ STAGE PLANS:
$hdt$_2:src
TableScan
alias: src
+ 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)
@@ -577,6 +585,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (value is not null and key is not null) (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
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/mapjoin_memcheck.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out b/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out
index 19a00e0..a805566 100644
--- a/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out
@@ -40,6 +40,7 @@ STAGE PLANS:
$hdt$_0:src1
TableScan
alias: src1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -58,6 +59,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 70 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/mapjoin_subquery.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin_subquery.q.out b/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
index 1f3f1bb..6116d38 100644
--- a/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
@@ -31,6 +31,7 @@ STAGE PLANS:
$hdt$_0:z
TableScan
alias: z
+ filterExpr: ((ds = '2008-04-08') and (11.0D = 11.0D) and 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:
$hdt$_1:$hdt$_2:x
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -64,6 +66,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ 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)
@@ -275,6 +278,7 @@ STAGE PLANS:
$hdt$_0:z
TableScan
alias: z
+ filterExpr: ((ds = '2008-04-08') and (11.0D = 11.0D) and 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)
@@ -290,6 +294,7 @@ STAGE PLANS:
$hdt$_1:$hdt$_2:x
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -308,6 +313,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ 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/mapjoin_subquery2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out b/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out
index 89f367c..50e7ce0 100644
--- a/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out
+++ b/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out
@@ -97,6 +97,7 @@ STAGE PLANS:
$hdt$_0:$hdt$_0:y
TableScan
alias: y
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 60 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -112,6 +113,7 @@ STAGE PLANS:
$hdt$_1:z
TableScan
alias: z
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 60 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -130,6 +132,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 130 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_1.q.out b/ql/src/test/results/clientpositive/masking_1.q.out
index bc0a42a..19d1fcc 100644
--- a/ql/src/test/results/clientpositive/masking_1.q.out
+++ b/ql/src/test/results/clientpositive/masking_1.q.out
@@ -553,6 +553,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n8
+ 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)
@@ -1095,6 +1096,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n8
+ 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)
@@ -1637,6 +1639,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n8
+ 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)
@@ -2179,6 +2182,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n8
+ 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)
@@ -2195,6 +2199,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col1 (type: string)
TableScan
alias: srcpart
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -6376,6 +6381,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n8
+ 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)
@@ -6918,6 +6924,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n8
+ 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)
@@ -7460,6 +7467,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((UDFToDouble(key) > 0.0D) and (UDFToDouble(key) < 10.0D) and ((UDFToDouble(key) % 2.0D) = 0.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((UDFToDouble(key) % 2.0D) = 0.0D) and (UDFToDouble(key) < 10.0D) and (UDFToDouble(key) > 0.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_10.q.out b/ql/src/test/results/clientpositive/masking_10.q.out
index 712f07b..5d5e1fe 100644
--- a/ql/src/test/results/clientpositive/masking_10.q.out
+++ b/ql/src/test/results/clientpositive/masking_10.q.out
@@ -26,6 +26,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test
+ filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
@@ -117,6 +118,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test
+ filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
@@ -171,6 +173,7 @@ STAGE PLANS:
value expressions: _col1 (type: string), _col2 (type: int), _col3 (type: string)
TableScan
alias: masking_test
+ filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_12.q.out b/ql/src/test/results/clientpositive/masking_12.q.out
index 32c420c..bd9e596 100644
--- a/ql/src/test/results/clientpositive/masking_12.q.out
+++ b/ql/src/test/results/clientpositive/masking_12.q.out
@@ -672,6 +672,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n5
+ filterExpr: (key > 6) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1217,6 +1218,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n5
+ filterExpr: key is not null (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1235,6 +1237,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: masking_test_n5
+ filterExpr: (key > 6) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_1_newdb.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_1_newdb.q.out b/ql/src/test/results/clientpositive/masking_1_newdb.q.out
index fa32212..4beefd9 100644
--- a/ql/src/test/results/clientpositive/masking_1_newdb.q.out
+++ b/ql/src/test/results/clientpositive/masking_1_newdb.q.out
@@ -571,6 +571,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n12
+ 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/masking_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_2.q.out b/ql/src/test/results/clientpositive/masking_2.q.out
index 2d2e696..9a42211 100644
--- a/ql/src/test/results/clientpositive/masking_2.q.out
+++ b/ql/src/test/results/clientpositive/masking_2.q.out
@@ -570,6 +570,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToInteger(key) > 0) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1116,6 +1117,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)
@@ -1132,6 +1134,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: src
+ filterExpr: ((UDFToInteger(key) > 0) and value is not null) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1185,6 +1188,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1203,6 +1207,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col1 (type: string)
TableScan
alias: src
+ filterExpr: ((UDFToInteger(key) > 0) and value is not null) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1277,6 +1282,7 @@ STAGE PLANS:
Statistics: Num rows: 666 Data size: 7075 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: src
+ filterExpr: (UDFToInteger(key) > 0) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_3.q.out b/ql/src/test/results/clientpositive/masking_3.q.out
index 8553b08..20d9231 100644
--- a/ql/src/test/results/clientpositive/masking_3.q.out
+++ b/ql/src/test/results/clientpositive/masking_3.q.out
@@ -553,6 +553,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq_n3
+ 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)
@@ -1095,6 +1096,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq_n3
+ 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)
@@ -1637,6 +1639,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq_n3
+ 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)
@@ -2179,6 +2182,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq_n3
+ 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)
@@ -2195,6 +2199,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col1 (type: string)
TableScan
alias: srcpart
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -6376,6 +6381,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq_n3
+ 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)
@@ -6918,6 +6924,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq_n3
+ 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)
@@ -7460,6 +7467,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((UDFToDouble(key) > 0.0D) and (UDFToDouble(key) < 10.0D) and ((UDFToDouble(key) % 2.0D) = 0.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((UDFToDouble(key) % 2.0D) = 0.0D) and (UDFToDouble(key) < 10.0D) and (UDFToDouble(key) > 0.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_4.q.out b/ql/src/test/results/clientpositive/masking_4.q.out
index 068c484..5f90f3e 100644
--- a/ql/src/test/results/clientpositive/masking_4.q.out
+++ b/ql/src/test/results/clientpositive/masking_4.q.out
@@ -42,6 +42,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '5') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '5') (type: boolean)
@@ -83,6 +84,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n11
+ filterExpr: (key = 5) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
@@ -124,6 +126,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n11
+ filterExpr: (key = 5) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_6.q.out b/ql/src/test/results/clientpositive/masking_6.q.out
index bee347f..a8fab44 100644
--- a/ql/src/test/results/clientpositive/masking_6.q.out
+++ b/ql/src/test/results/clientpositive/masking_6.q.out
@@ -575,6 +575,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToInteger(key) > 0) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1701,6 +1702,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToInteger(key) > 0) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_7.q.out b/ql/src/test/results/clientpositive/masking_7.q.out
index 9fa62f9..9727f5e 100644
--- a/ql/src/test/results/clientpositive/masking_7.q.out
+++ b/ql/src/test/results/clientpositive/masking_7.q.out
@@ -576,6 +576,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToInteger(key) > 0) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1703,6 +1704,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (UDFToInteger(key) > 0) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_9.q.out b/ql/src/test/results/clientpositive/masking_9.q.out
index ae1a82b..c9c0ad7 100644
--- a/ql/src/test/results/clientpositive/masking_9.q.out
+++ b/ql/src/test/results/clientpositive/masking_9.q.out
@@ -26,6 +26,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test
+ filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out
index 0967fde..fa92660 100644
--- a/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out
+++ b/ql/src/test/results/clientpositive/masking_disablecbo_1.q.out
@@ -553,6 +553,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n10
+ 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)
@@ -1095,6 +1096,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n10
+ 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)
@@ -1637,6 +1639,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n10
+ 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)
@@ -2179,6 +2182,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n10
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -2191,6 +2195,7 @@ STAGE PLANS:
value expressions: key (type: int), value (type: string)
TableScan
alias: srcpart
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -6372,6 +6377,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n10
+ 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)
@@ -6914,6 +6920,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n10
+ 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)
@@ -7456,6 +7463,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((key > 0) and (key < 10) and ((key % 2) = 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key % 2) = 0) and (key < 10) and (key > 0)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out
index bb58b08..dc53112 100644
--- a/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out
+++ b/ql/src/test/results/clientpositive/masking_disablecbo_2.q.out
@@ -1099,6 +1099,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ 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)
@@ -1118,6 +1119,7 @@ STAGE PLANS:
value expressions: _col0 (type: int)
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)
@@ -1185,6 +1187,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col1 (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(value) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(value) is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
index 9f4b149..df96b3d 100644
--- a/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
+++ b/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
@@ -24,6 +24,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -36,6 +37,7 @@ STAGE PLANS:
value expressions: key (type: int), value (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -601,6 +603,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
@@ -613,6 +616,7 @@ STAGE PLANS:
value expressions: key (type: int), value (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -1175,6 +1179,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
@@ -1187,6 +1192,7 @@ STAGE PLANS:
value expressions: key (type: int)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -1749,6 +1755,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
@@ -1761,6 +1768,7 @@ STAGE PLANS:
value expressions: value (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -2328,6 +2336,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -2340,6 +2349,7 @@ STAGE PLANS:
value expressions: key (type: int), value (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -2386,6 +2396,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col1 (type: string)
TableScan
alias: srcpart
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -6569,6 +6580,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
@@ -6581,6 +6593,7 @@ STAGE PLANS:
value expressions: key (type: int), value (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -7143,6 +7156,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_subq
+ filterExpr: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
@@ -7155,6 +7169,7 @@ STAGE PLANS:
value expressions: key (type: int), value (type: string)
TableScan
alias: src
+ filterExpr: UDFToDouble(key) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: UDFToDouble(key) is not null (type: boolean)
@@ -7717,6 +7732,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((key > 0) and (key < 10) and ((key % 2) = 0)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key % 2) = 0) and (key < 10) and (key > 0)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out
index 087d093..55e2915 100644
--- a/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out
+++ b/ql/src/test/results/clientpositive/masking_disablecbo_4.q.out
@@ -42,6 +42,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (key = '5') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '5') (type: boolean)
@@ -83,6 +84,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n3
+ filterExpr: (key = 5) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
@@ -124,6 +126,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: masking_test_n3
+ filterExpr: (key = 5) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 5) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge3.q.out b/ql/src/test/results/clientpositive/merge3.q.out
index aaa7702..961fae3 100644
--- a/ql/src/test/results/clientpositive/merge3.q.out
+++ b/ql/src/test/results/clientpositive/merge3.q.out
@@ -2390,6 +2390,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: merge_src_part
+ filterExpr: ds is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
@@ -4872,6 +4873,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: merge_src_part
+ filterExpr: ds is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge4.q.out b/ql/src/test/results/clientpositive/merge4.q.out
index edaf416..1bbfd86 100644
--- a/ql/src/test/results/clientpositive/merge4.q.out
+++ b/ql/src/test/results/clientpositive/merge4.q.out
@@ -28,6 +28,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
Select Operator
expressions: key (type: string), value (type: string), hr (type: string)
@@ -1187,6 +1188,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
Select Operator
expressions: key (type: string), value (type: string)
@@ -2852,6 +2854,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
Select Operator
expressions: key (type: string), value (type: string), hr (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out
index 45c3a93..068d589 100644
--- a/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out
+++ b/ql/src/test/results/clientpositive/merge_dynamic_partition.q.out
@@ -64,6 +64,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_n1
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), hr (type: string)
@@ -694,6 +695,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_n1
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -1363,6 +1365,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_n1
+ filterExpr: ((ds = '2008-04-08') and (11.0D = 11.0D)) (type: boolean)
Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), '2008-04-08' (type: string), hr (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out
index aa87e3b..551581b 100644
--- a/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out
+++ b/ql/src/test/results/clientpositive/merge_dynamic_partition2.q.out
@@ -86,6 +86,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_n0
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 297 Data size: 174150 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), hr (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out
index 6ffcf4c..bd9beb8 100644
--- a/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out
+++ b/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out
@@ -146,6 +146,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_n2
+ filterExpr: (ds >= '2008-04-08') (type: boolean)
Statistics: Num rows: 594 Data size: 348300 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out
index 4ede977..f5740cf 100644
--- a/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out
+++ b/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out
@@ -147,6 +147,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_rc_n1
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), if(((UDFToDouble(key) % 2.0D) = 0.0D), 'a1', 'b1') (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out b/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out
index bd151da..c3319b8 100644
--- a/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out
+++ b/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out
@@ -123,6 +123,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart_merge_dp_rc
+ filterExpr: (ds = '2008-04-08') (type: boolean)
Statistics: Num rows: 618 Data size: 5934 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), if(((UDFToDouble(key) % 100.0D) = 0.0D), 'a1', 'b1') (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/merge_join_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/merge_join_1.q.out b/ql/src/test/results/clientpositive/merge_join_1.q.out
index 8a2dd1d..ccbae94 100644
--- a/ql/src/test/results/clientpositive/merge_join_1.q.out
+++ b/ql/src/test/results/clientpositive/merge_join_1.q.out
@@ -77,6 +77,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_join_1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: a is not null (type: boolean)
@@ -93,6 +94,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: test_join_2
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: a is not null (type: boolean)
@@ -134,6 +136,7 @@ STAGE PLANS:
value expressions: _col1 (type: string), _col2 (type: string)
TableScan
alias: test_join_1
+ filterExpr: (a is not null and b is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: (a is not null and b is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/mergejoins.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mergejoins.q.out b/ql/src/test/results/clientpositive/mergejoins.q.out
index b34b388..58d1c1d 100644
--- a/ql/src/test/results/clientpositive/mergejoins.q.out
+++ b/ql/src/test/results/clientpositive/mergejoins.q.out
@@ -53,6 +53,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n0
+ filterExpr: (val1 is not null and val2 is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: (val1 is not null and val2 is not null) (type: boolean)
@@ -69,6 +70,7 @@ STAGE PLANS:
value expressions: _col1 (type: int)
TableScan
alias: b_n0
+ filterExpr: val1 is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: val1 is not null (type: boolean)
@@ -85,6 +87,7 @@ STAGE PLANS:
value expressions: _col1 (type: int)
TableScan
alias: c_n0
+ filterExpr: val1 is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: val1 is not null (type: boolean)
@@ -101,6 +104,7 @@ STAGE PLANS:
value expressions: _col1 (type: int)
TableScan
alias: d_n0
+ filterExpr: val1 is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: val1 is not null (type: boolean)
@@ -147,6 +151,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int)
TableScan
alias: e_n0
+ filterExpr: val2 is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: val2 is not null (type: boolean)
@@ -198,6 +203,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n0
+ 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)
@@ -214,6 +220,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b_n0
+ 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)
@@ -230,6 +237,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: c_n0
+ 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/mergejoins_mixed.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mergejoins_mixed.q.out b/ql/src/test/results/clientpositive/mergejoins_mixed.q.out
index ee3fa11..9ac6d59 100644
--- a/ql/src/test/results/clientpositive/mergejoins_mixed.q.out
+++ b/ql/src/test/results/clientpositive/mergejoins_mixed.q.out
@@ -22,6 +22,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -38,6 +39,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -54,6 +56,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -70,6 +73,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: d
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -127,6 +131,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -143,6 +148,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -159,6 +165,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -229,6 +236,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -245,6 +253,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -328,6 +337,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -344,6 +354,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -429,6 +440,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -445,6 +457,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -526,6 +539,7 @@ STAGE PLANS:
value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
TableScan
alias: d
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -581,6 +595,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -597,6 +612,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -730,6 +746,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -746,6 +763,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -879,6 +897,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -895,6 +914,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1028,6 +1048,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1044,6 +1065,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1177,6 +1199,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1193,6 +1216,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1326,6 +1350,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1342,6 +1367,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1474,6 +1500,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a_n5
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1490,6 +1517,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 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/multi_insert_gby.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_gby.q.out b/ql/src/test/results/clientpositive/multi_insert_gby.q.out
index 514e4538..9c7b61e 100644
--- a/ql/src/test/results/clientpositive/multi_insert_gby.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_gby.q.out
@@ -41,6 +41,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((key > 500) or (key > 450)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key > 450) or (key > 500)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out b/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
index fa32ee4..7e720b6 100644
--- a/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
@@ -1068,6 +1068,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -1311,6 +1312,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -1622,6 +1624,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -1865,6 +1868,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -3900,6 +3904,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -4015,6 +4020,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -4130,6 +4136,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -4245,6 +4252,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/multi_insert_union_src.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_union_src.q.out b/ql/src/test/results/clientpositive/multi_insert_union_src.q.out
index e8dabfd..a35c1e4 100644
--- a/ql/src/test/results/clientpositive/multi_insert_union_src.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_union_src.q.out
@@ -62,6 +62,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: (UDFToDouble(key) < 10.0D) (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
@@ -91,6 +92,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
TableScan
alias: src2_n4
+ 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/multi_insert_with_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out b/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
index 34b1d08..0e75384 100644
--- a/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
@@ -79,6 +79,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (id = 'Id_1') (type: boolean)
Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (id = 'Id_1') (type: boolean)
@@ -93,6 +94,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: ((id = 'Id_1') and (val = 'val_103')) (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((id = 'Id_1') and (val = 'val_103')) (type: boolean)
@@ -205,6 +207,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((id = 'Id_2') and (val <> 'val_104')) (type: boolean)
Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((id = 'Id_2') and (val <> 'val_104')) (type: boolean)
@@ -219,6 +222,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: ((val = 'val_104') and (id = 'Id_2')) (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((id = 'Id_2') and (val = 'val_104')) (type: boolean)
@@ -741,6 +745,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -753,6 +758,7 @@ STAGE PLANS:
value expressions: val (type: string)
TableScan
alias: b
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -948,6 +954,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -960,6 +967,7 @@ STAGE PLANS:
value expressions: val (type: string)
TableScan
alias: b
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -1155,6 +1163,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -1171,6 +1180,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -1374,6 +1384,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -1390,6 +1401,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/multi_join_union.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_join_union.q.out b/ql/src/test/results/clientpositive/multi_join_union.q.out
index 5030103..991ffd5 100644
--- a/ql/src/test/results/clientpositive/multi_join_union.q.out
+++ b/ql/src/test/results/clientpositive/multi_join_union.q.out
@@ -78,6 +78,7 @@ STAGE PLANS:
$hdt$_0:a
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)
@@ -93,6 +94,7 @@ STAGE PLANS:
$hdt$_2:$hdt$_2-subquery1:src13
TableScan
alias: src13
+ 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)
@@ -110,6 +112,7 @@ STAGE PLANS:
$hdt$_2:$hdt$_2-subquery2:src14
TableScan
alias: src14
+ 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)
@@ -130,6 +133,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ 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)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/named_column_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/named_column_join.q.out b/ql/src/test/results/clientpositive/named_column_join.q.out
index b67b74a..362a6cb 100644
--- a/ql/src/test/results/clientpositive/named_column_join.q.out
+++ b/ql/src/test/results/clientpositive/named_column_join.q.out
@@ -30,6 +30,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: a is not null (type: boolean)
@@ -46,6 +47,7 @@ STAGE PLANS:
value expressions: _col1 (type: int)
TableScan
alias: t2
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: a is not null (type: boolean)