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:52 UTC
[49/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/auto_join28.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join28.q.out b/ql/src/test/results/clientpositive/auto_join28.q.out
index d93f397..c6233e7 100644
--- a/ql/src/test/results/clientpositive/auto_join28.q.out
+++ b/ql/src/test/results/clientpositive/auto_join28.q.out
@@ -36,6 +36,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key > 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key > 10) (type: boolean)
@@ -125,6 +126,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key > 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key > 10) (type: boolean)
@@ -141,6 +143,7 @@ STAGE PLANS:
src3
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -230,6 +233,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -246,6 +250,7 @@ STAGE PLANS:
src3
TableScan
alias: src3
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -335,6 +340,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join29.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join29.q.out b/ql/src/test/results/clientpositive/auto_join29.q.out
index a784add..ab1047e 100644
--- a/ql/src/test/results/clientpositive/auto_join29.q.out
+++ b/ql/src/test/results/clientpositive/auto_join29.q.out
@@ -36,6 +36,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key > 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key > 10) (type: boolean)
@@ -633,6 +634,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key > 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key > 10) (type: boolean)
@@ -649,6 +651,7 @@ STAGE PLANS:
src3
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -1246,6 +1249,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -1262,6 +1266,7 @@ STAGE PLANS:
src3
TableScan
alias: src3
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -1871,6 +1876,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -2493,6 +2499,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2505,6 +2512,7 @@ STAGE PLANS:
src3
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2520,6 +2528,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2597,6 +2606,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -2613,6 +2623,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3210,6 +3221,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3226,6 +3238,7 @@ STAGE PLANS:
src3
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3323,6 +3336,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -3339,6 +3353,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -3358,6 +3373,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: (key < 10) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -3461,6 +3477,7 @@ STAGE PLANS:
src1
TableScan
alias: src1
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3473,6 +3490,7 @@ STAGE PLANS:
src2
TableScan
alias: src2
+ filterExpr: ((key < 10) and (key > 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key < 10) and (key > 10)) (type: boolean)
@@ -3488,6 +3506,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ filterExpr: ((key > 10) and (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
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/auto_join3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join3.q.out b/ql/src/test/results/clientpositive/auto_join3.q.out
index 68aa4c2..2bffe6e 100644
--- a/ql/src/test/results/clientpositive/auto_join3.q.out
+++ b/ql/src/test/results/clientpositive/auto_join3.q.out
@@ -35,6 +35,7 @@ STAGE PLANS:
$hdt$_0: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)
@@ -51,6 +52,7 @@ STAGE PLANS:
$hdt$_1:src2
TableScan
alias: src2
+ 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)
@@ -70,6 +72,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src3
+ 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/auto_join32.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join32.q.out b/ql/src/test/results/clientpositive/auto_join32.q.out
index 0e1d3c6..09fcd7d 100644
--- a/ql/src/test/results/clientpositive/auto_join32.q.out
+++ b/ql/src/test/results/clientpositive/auto_join32.q.out
@@ -40,6 +40,7 @@ STAGE PLANS:
$hdt$_0:s
TableScan
alias: s
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
@@ -58,6 +59,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: v
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
@@ -160,6 +162,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
@@ -271,6 +274,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
@@ -404,6 +408,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
+ filterExpr: ((p = 'bar') and name is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Filter Operator
predicate: ((p = 'bar') and name is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join33.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join33.q.out b/ql/src/test/results/clientpositive/auto_join33.q.out
index ec6018d..9c9c898 100644
--- a/ql/src/test/results/clientpositive/auto_join33.q.out
+++ b/ql/src/test/results/clientpositive/auto_join33.q.out
@@ -28,6 +28,7 @@ STAGE PLANS:
$hdt$_0:src
TableScan
alias: src
+ filterExpr: (((UDFToDouble(key) + 1.0D) < 10.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(key) + 1.0D) < 10.0D) and key is not null) (type: boolean)
@@ -46,6 +47,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((UDFToDouble(key) + 2.0D) < 10.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(key) + 2.0D) < 10.0D) and key is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join4.q.out b/ql/src/test/results/clientpositive/auto_join4.q.out
index c8b778c..0d92656 100644
--- a/ql/src/test/results/clientpositive/auto_join4.q.out
+++ b/ql/src/test/results/clientpositive/auto_join4.q.out
@@ -54,6 +54,7 @@ STAGE PLANS:
$hdt$_1:src2
TableScan
alias: src2
+ filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
@@ -72,6 +73,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((UDFToDouble(key) > 10.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 10.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join5.q.out b/ql/src/test/results/clientpositive/auto_join5.q.out
index 79b4dec..b3c1c25 100644
--- a/ql/src/test/results/clientpositive/auto_join5.q.out
+++ b/ql/src/test/results/clientpositive/auto_join5.q.out
@@ -54,6 +54,7 @@ STAGE PLANS:
$hdt$_0:src1
TableScan
alias: src1
+ filterExpr: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
@@ -72,6 +73,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join6.q.out b/ql/src/test/results/clientpositive/auto_join6.q.out
index 1f652fc..a3e829f 100644
--- a/ql/src/test/results/clientpositive/auto_join6.q.out
+++ b/ql/src/test/results/clientpositive/auto_join6.q.out
@@ -48,6 +48,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((UDFToDouble(key) > 10.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 10.0D)) (type: boolean)
@@ -64,6 +65,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: src2
+ filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join7.q.out b/ql/src/test/results/clientpositive/auto_join7.q.out
index 7ca170a..1f2616e 100644
--- a/ql/src/test/results/clientpositive/auto_join7.q.out
+++ b/ql/src/test/results/clientpositive/auto_join7.q.out
@@ -58,6 +58,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((UDFToDouble(key) > 10.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 10.0D)) (type: boolean)
@@ -74,6 +75,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: src2
+ filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
@@ -90,6 +92,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: src3
+ filterExpr: ((UDFToDouble(key) > 20.0D) and (UDFToDouble(key) < 25.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 25.0D) and (UDFToDouble(key) > 20.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join8.q.out b/ql/src/test/results/clientpositive/auto_join8.q.out
index b959822..e550810 100644
--- a/ql/src/test/results/clientpositive/auto_join8.q.out
+++ b/ql/src/test/results/clientpositive/auto_join8.q.out
@@ -54,6 +54,7 @@ STAGE PLANS:
$hdt$_1:src2
TableScan
alias: src2
+ filterExpr: ((UDFToDouble(key) > 15.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 15.0D)) (type: boolean)
@@ -72,6 +73,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src1
+ filterExpr: ((UDFToDouble(key) > 10.0D) and (UDFToDouble(key) < 20.0D)) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) < 20.0D) and (UDFToDouble(key) > 10.0D)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/auto_join9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join9.q.out b/ql/src/test/results/clientpositive/auto_join9.q.out
index 80c1649..fb09841 100644
--- a/ql/src/test/results/clientpositive/auto_join9.q.out
+++ b/ql/src/test/results/clientpositive/auto_join9.q.out
@@ -32,6 +32,7 @@ STAGE PLANS:
$hdt$_0:src1
TableScan
alias: src1
+ filterExpr: ((ds = '2008-04-08') and (hr = '12') 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)
@@ -50,6 +51,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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/auto_join_reordering_values.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out b/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
index e66e402..259142d 100644
--- a/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
+++ b/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
@@ -93,6 +93,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orderpayment
+ filterExpr: (date is not null and dealid is not null and cityid is not null and userid is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -114,6 +115,7 @@ STAGE PLANS:
auto parallelism: false
TableScan
alias: dim_pay_date
+ filterExpr: date is not null (type: boolean)
Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -230,6 +232,7 @@ STAGE PLANS:
auto parallelism: false
TableScan
alias: deal
+ filterExpr: dealid is not null (type: boolean)
Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -369,6 +372,7 @@ STAGE PLANS:
auto parallelism: false
TableScan
alias: order_city
+ filterExpr: cityid is not null (type: boolean)
Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -508,6 +512,7 @@ STAGE PLANS:
auto parallelism: false
TableScan
alias: user
+ filterExpr: userid is not null (type: boolean)
Statistics: Num rows: 100 Data size: 288 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/auto_join_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join_stats.q.out b/ql/src/test/results/clientpositive/auto_join_stats.q.out
index 321c977..346c9c2 100644
--- a/ql/src/test/results/clientpositive/auto_join_stats.q.out
+++ b/ql/src/test/results/clientpositive/auto_join_stats.q.out
@@ -51,6 +51,7 @@ STAGE PLANS:
$hdt$_1:src2
TableScan
alias: src2
+ 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)
@@ -69,6 +70,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -105,6 +107,7 @@ STAGE PLANS:
$hdt$_2:smalltable_n0
TableScan
alias: smalltable_n0
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -151,6 +154,7 @@ STAGE PLANS:
$hdt$_0: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)
@@ -169,6 +173,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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)
@@ -200,6 +205,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -215,6 +221,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: src2
+ 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)
@@ -315,6 +322,7 @@ STAGE PLANS:
$hdt$_2:src2
TableScan
alias: src2
+ 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)
@@ -333,6 +341,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -372,6 +381,7 @@ STAGE PLANS:
$hdt$_0:smalltable_n0
TableScan
alias: smalltable_n0
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -388,6 +398,7 @@ STAGE PLANS:
$hdt$_3:smalltable2_n0
TableScan
alias: smalltable2_n0
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -441,6 +452,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)
@@ -459,6 +471,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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)
@@ -490,6 +503,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -505,6 +519,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: src2
+ 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/auto_join_stats2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join_stats2.q.out b/ql/src/test/results/clientpositive/auto_join_stats2.q.out
index 1b274a1..6eab581 100644
--- a/ql/src/test/results/clientpositive/auto_join_stats2.q.out
+++ b/ql/src/test/results/clientpositive/auto_join_stats2.q.out
@@ -38,6 +38,7 @@ STAGE PLANS:
$hdt$_0: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)
@@ -53,6 +54,7 @@ STAGE PLANS:
$hdt$_2:smalltable
TableScan
alias: smalltable
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -71,6 +73,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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)
@@ -182,6 +185,7 @@ STAGE PLANS:
$hdt$_0:smalltable
TableScan
alias: smalltable
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -198,6 +202,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)
@@ -213,6 +218,7 @@ STAGE PLANS:
$hdt$_3:smalltable2
TableScan
alias: smalltable2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -232,6 +238,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src2
+ 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/auto_join_without_localtask.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out b/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out
index ad5e187..2f32cf2 100644
--- a/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out
+++ b/ql/src/test/results/clientpositive/auto_join_without_localtask.q.out
@@ -28,6 +28,7 @@ STAGE PLANS:
$hdt$_1:b
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)
@@ -46,6 +47,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)
@@ -106,6 +108,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)
@@ -124,6 +127,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -154,6 +158,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)
@@ -170,6 +175,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)
@@ -292,6 +298,7 @@ STAGE PLANS:
$hdt$_1:b
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)
@@ -310,6 +317,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ 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)
@@ -348,6 +356,7 @@ STAGE PLANS:
$hdt$_2:c
TableScan
alias: c
+ 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)
@@ -412,6 +421,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ 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)
@@ -456,6 +466,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
TableScan
alias: c
+ 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)
@@ -495,6 +506,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ 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)
@@ -513,6 +525,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -543,6 +556,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ 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)
@@ -559,6 +573,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)
@@ -684,6 +699,7 @@ STAGE PLANS:
$hdt$_2:b
TableScan
alias: b
+ 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)
@@ -702,6 +718,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean)
@@ -740,6 +757,7 @@ STAGE PLANS:
$hdt$_0:c
TableScan
alias: c
+ 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)
@@ -804,6 +822,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ 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)
@@ -848,6 +867,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
TableScan
alias: c
+ 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)
@@ -887,6 +907,7 @@ STAGE PLANS:
$hdt$_1:a
TableScan
alias: a
+ filterExpr: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean)
@@ -905,6 +926,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ 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)
@@ -935,6 +957,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) > 100.0D) and value is not null) (type: boolean)
@@ -951,6 +974,7 @@ STAGE PLANS:
value expressions: _col1 (type: string)
TableScan
alias: b
+ 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/avro_schema_evolution_native.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out b/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out
index 6860b47..6b3920c 100644
--- a/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out
+++ b/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out
@@ -250,6 +250,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: episodes_partitioned_n0
+ filterExpr: (doctor_pt > 6) (type: boolean)
Statistics: Num rows: 3 Data size: 8950 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: title (type: string), air_date (type: string), doctor (type: int), value (type: int), doctor_pt (type: int)
@@ -339,6 +340,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: episodes_partitioned_n0
+ filterExpr: (doctor_pt > 6) (type: boolean)
Statistics: Num rows: 3 Data size: 8950 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: title (type: string), air_date (type: string), doctor (type: int), value (type: int), doctor_pt (type: int)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out b/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out
index 1837756..1d4c7ad 100644
--- a/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out
+++ b/ql/src/test/results/clientpositive/beeline/explain_outputs.q.out
@@ -49,6 +49,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n22
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -64,6 +65,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t2_n14
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 5 Data size: 5 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -148,6 +150,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n22
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2/2 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -163,6 +166,7 @@ STAGE PLANS:
Statistics: Num rows: 2/2 Data size: 3 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t2_n14
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 5/5 Data size: 5 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -255,6 +259,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n22
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -270,6 +275,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 3 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t2_n14
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 5 Data size: 5 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/beeline/materialized_view_create_rewrite.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out
index a0f916b..ff02643 100644
--- a/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out
+++ b/ql/src/test/results/clientpositive/beeline/materialized_view_create_rewrite.q.out
@@ -172,6 +172,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: (a = 3) (type: boolean)
Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (a = 3) (type: boolean)
@@ -186,6 +187,7 @@ STAGE PLANS:
value expressions: _col0 (type: decimal(10,2))
TableScan
alias: cmv_basetable_n10
+ filterExpr: ((d = 3) and (a = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
@@ -293,6 +295,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: ((a = 3) and (d = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
@@ -393,6 +396,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: (a = 3) (type: boolean)
Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (a = 3) (type: boolean)
@@ -407,6 +411,7 @@ STAGE PLANS:
value expressions: _col0 (type: decimal(10,2))
TableScan
alias: cmv_basetable_n10
+ filterExpr: ((d = 3) and (a = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 1205 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
index fa834ac..733a3f5 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_1.q.out
@@ -108,6 +108,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -329,6 +330,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2080 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/beeline/smb_mapjoin_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out
index 25e5eac..6938b0e 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_10.q.out
@@ -78,6 +78,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (userid is not null and pageid is not null and postid is not null and type is not null) (type: boolean)
Statistics: Num rows: 13 Data size: 4140 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (pageid is not null and postid is not null and type is not null and userid is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
index afc7e95..9f946e0 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
@@ -58,6 +58,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((ds = '1') and key is not null) (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/beeline/smb_mapjoin_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out
index c635658..c626c7e 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_12.q.out
@@ -69,6 +69,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((ds = '1') and key is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -271,6 +272,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((ds = '1') and key is not null) (type: boolean)
Statistics: Num rows: 3084 Data size: 32904 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/beeline/smb_mapjoin_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out
index 2dd921f..123e844 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_13.q.out
@@ -76,6 +76,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
GatherStats: false
Filter Operator
@@ -237,6 +238,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: UDFToDouble(value) is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -254,6 +256,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: UDFToDouble(key) is not null (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/beeline/smb_mapjoin_16.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out
index 4f6406b..3fb1769 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_16.q.out
@@ -48,6 +48,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)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
index 3353eb5..e39edcc 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_2.q.out
@@ -62,6 +62,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -287,6 +288,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2080 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/beeline/smb_mapjoin_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
index e116fa7..fa7968d 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_3.q.out
@@ -62,6 +62,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -285,6 +286,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 2060 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/bucket3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket3.q.out b/ql/src/test/results/clientpositive/bucket3.q.out
index 0ad6d04..d9ee0dc 100644
--- a/ql/src/test/results/clientpositive/bucket3.q.out
+++ b/ql/src/test/results/clientpositive/bucket3.q.out
@@ -317,6 +317,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
+ filterExpr: (ds = '1') (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_1.q.out b/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
index 6d837a3..fb99ead 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
@@ -64,6 +64,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -81,6 +82,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 200 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/bucket_map_join_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_2.q.out b/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
index 0761f2f..3377621 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
@@ -64,6 +64,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 210 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -81,6 +82,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 200 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/bucket_map_join_spark1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out
index e4c7c64..4650034 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out
@@ -183,6 +183,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -204,6 +205,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -625,6 +627,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -646,6 +649,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 149 Data size: 58120 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/bucket_map_join_spark2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out
index eed3365..64c5bf4 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out
@@ -167,6 +167,7 @@ STAGE PLANS:
$hdt$_1:b
TableScan
alias: b
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -188,6 +189,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -609,6 +611,7 @@ STAGE PLANS:
$hdt$_1:b
TableScan
alias: b
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -630,6 +633,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 149 Data size: 58120 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/bucket_map_join_spark3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out
index 4841f6d..e7a9263 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out
@@ -167,6 +167,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -188,6 +189,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 149 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -609,6 +611,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 78 Data size: 30620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -630,6 +633,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((ds = '2008-04-08') and key is not null) (type: boolean)
Statistics: Num rows: 149 Data size: 58120 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/bucket_map_join_spark4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out b/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out
index 96a0593..31d7870 100644
--- a/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out
+++ b/ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out
@@ -85,6 +85,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -103,6 +104,7 @@ STAGE PLANS:
$hdt$_2:c
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -124,6 +126,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -447,6 +450,7 @@ STAGE PLANS:
$hdt$_0:a
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -465,6 +469,7 @@ STAGE PLANS:
$hdt$_2:c
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -486,6 +491,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 70 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/bucketcontext_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_1.q.out b/ql/src/test/results/clientpositive/bucketcontext_1.q.out
index 6060fe7..42c6301 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_1.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_1.q.out
@@ -166,6 +166,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 56 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -190,6 +191,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -393,6 +395,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 116240 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/bucketcontext_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_2.q.out b/ql/src/test/results/clientpositive/bucketcontext_2.q.out
index f998650..f9b0201 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_2.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_2.q.out
@@ -150,6 +150,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 120 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -174,6 +175,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -377,6 +379,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 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/bucketcontext_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_3.q.out b/ql/src/test/results/clientpositive/bucketcontext_3.q.out
index 15b3d14..520dad8 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_3.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_3.q.out
@@ -198,6 +198,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -222,6 +223,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 120 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -374,6 +376,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 120 Data size: 58120 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/bucketcontext_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_4.q.out b/ql/src/test/results/clientpositive/bucketcontext_4.q.out
index f448796..486a8e7 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_4.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_4.q.out
@@ -214,6 +214,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -238,6 +239,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 56 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -390,6 +392,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 56 Data size: 27500 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/bucketcontext_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_5.q.out b/ql/src/test/results/clientpositive/bucketcontext_5.q.out
index 629c364..e14c61b 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_5.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_5.q.out
@@ -82,6 +82,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -106,6 +107,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -252,6 +254,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 27500 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/bucketcontext_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_6.q.out b/ql/src/test/results/clientpositive/bucketcontext_6.q.out
index c6e940c..548a34d 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_6.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_6.q.out
@@ -100,6 +100,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -124,6 +125,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -325,6 +327,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 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/bucketcontext_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_7.q.out b/ql/src/test/results/clientpositive/bucketcontext_7.q.out
index ec8806f..970917e 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_7.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_7.q.out
@@ -231,6 +231,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -255,6 +256,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -460,6 +462,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 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/bucketcontext_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketcontext_8.q.out b/ql/src/test/results/clientpositive/bucketcontext_8.q.out
index 2eda939..d46d623 100644
--- a/ql/src/test/results/clientpositive/bucketcontext_8.q.out
+++ b/ql/src/test/results/clientpositive/bucketcontext_8.q.out
@@ -231,6 +231,7 @@ STAGE PLANS:
a
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 112 Data size: 55000 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -255,6 +256,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 116240 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -460,6 +462,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 240 Data size: 116240 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/bucketmapjoin10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin10.q.out b/ql/src/test/results/clientpositive/bucketmapjoin10.q.out
index a8951d1..d9a8414 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin10.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin10.q.out
@@ -247,6 +247,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: (part is not null and key is not null) (type: boolean)
Statistics: Num rows: 178 Data size: 69500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -264,6 +265,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (part is not null and key is not null) (type: boolean)
Statistics: Num rows: 178 Data size: 69500 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/bucketmapjoin11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin11.q.out b/ql/src/test/results/clientpositive/bucketmapjoin11.q.out
index e54a8c3..7fbde83 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin11.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin11.q.out
@@ -255,6 +255,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: (part is not null and key is not null) (type: boolean)
Statistics: Num rows: 219 Data size: 85620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -279,6 +280,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (part is not null and key is not null) (type: boolean)
Statistics: Num rows: 219 Data size: 85620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -592,6 +594,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: (part is not null and key is not null) (type: boolean)
Statistics: Num rows: 219 Data size: 85620 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -616,6 +619,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (part is not null and key is not null) (type: boolean)
Statistics: Num rows: 219 Data size: 85620 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/bucketmapjoin12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin12.q.out b/ql/src/test/results/clientpositive/bucketmapjoin12.q.out
index f892b8e..ede40f0 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin12.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin12.q.out
@@ -168,6 +168,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: ((part = '1') and key is not null) (type: boolean)
Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -192,6 +193,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((part = '1') and key is not null) (type: boolean)
Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -403,6 +405,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: ((part = '1') and key is not null) (type: boolean)
Statistics: Num rows: 95 Data size: 27500 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -420,6 +423,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((part = '1') and key is not null) (type: boolean)
Statistics: Num rows: 95 Data size: 27500 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/bucketmapjoin13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketmapjoin13.q.out b/ql/src/test/results/clientpositive/bucketmapjoin13.q.out
index 2f9b3ca..8aa75e7 100644
--- a/ql/src/test/results/clientpositive/bucketmapjoin13.q.out
+++ b/ql/src/test/results/clientpositive/bucketmapjoin13.q.out
@@ -137,6 +137,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -154,6 +155,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -420,6 +422,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -444,6 +447,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: ((part = '2') and key is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -666,6 +670,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -690,6 +695,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
GatherStats: false
Filter Operator
@@ -912,6 +918,7 @@ STAGE PLANS:
b
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -936,6 +943,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
GatherStats: false
Filter Operator