You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2018/06/26 04:16:54 UTC
[35/58] [abbrv] [partial] hive git commit: HIVE-12342 : Set default
value of hive.optimize.index.filter to true (Igor Kryvenko via Ashutosh
Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out b/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out
index 7fc508b..6c06662 100644
--- a/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out
@@ -100,6 +100,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem_nostats
+ filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean)
@@ -120,6 +121,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_nostats
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -139,6 +141,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: supplier_nostats
+ filterExpr: s_suppkey is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: s_suppkey is not null (type: boolean)
@@ -233,6 +236,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem_nostats
+ filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean)
@@ -253,6 +257,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_nostats
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -272,6 +277,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: supplier_nostats
+ filterExpr: s_suppkey is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: s_suppkey is not null (type: boolean)
@@ -430,6 +436,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem_nostats
+ filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean)
@@ -450,6 +457,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: supplier_nostats
+ filterExpr: s_suppkey is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: s_suppkey is not null (type: boolean)
@@ -469,6 +477,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: employee_part_n1
+ filterExpr: employeeid is not null (type: boolean)
Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: employeeid is not null (type: boolean)
@@ -563,6 +572,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem_nostats
+ filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean)
@@ -583,6 +593,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: supplier_nostats
+ filterExpr: s_suppkey is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: s_suppkey is not null (type: boolean)
@@ -602,6 +613,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: employee_part_n1
+ filterExpr: employeeid is not null (type: boolean)
Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: employeeid is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/kryo.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/kryo.q.out b/ql/src/test/results/clientpositive/llap/kryo.q.out
index 1463dfb..234bae8 100644
--- a/ql/src/test/results/clientpositive/llap/kryo.q.out
+++ b/ql/src/test/results/clientpositive/llap/kryo.q.out
@@ -44,6 +44,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: datetime_
+ filterExpr: ((id = 1) or (id = 2) or (id = 3) or (id = 4) or (id = 5) or (id = 6)) (type: boolean)
Statistics: Num rows: 1 Data size: 372 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((id = 1) or (id = 2) or (id = 3) or (id = 4) or (id = 5) or (id = 6)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out b/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out
index 363f2de..d8de3e7 100644
--- a/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out
@@ -108,7 +108,7 @@ POSTHOOK: query: drop table things_n1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@things_n1
POSTHOOK: Output: default@things_n1
-Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name
PREHOOK: type: QUERY
POSTHOOK: query: explain select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name
@@ -130,6 +130,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5850 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -150,6 +151,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3146 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -226,7 +228,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name
PREHOOK: type: QUERY
PREHOOK: Input: default@part
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out b/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out
index 76a8bf6..ebaac18 100644
--- a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out
+++ b/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out
@@ -242,6 +242,10 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: string), _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -356,6 +360,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Limit
Number of rows: 1
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
@@ -364,6 +372,10 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: string), _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
@@ -506,6 +518,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Limit
Number of rows: 1
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
@@ -514,6 +530,10 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: string), _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
@@ -673,6 +693,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -1109,6 +1133,10 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: string), _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
@@ -1224,6 +1252,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Limit
Number of rows: 1
Offset of rows: 1
@@ -1233,6 +1265,10 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: string), _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
@@ -1376,6 +1412,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Limit
Number of rows: 1
Offset of rows: 1
@@ -1385,6 +1425,10 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: string), _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
@@ -1547,6 +1591,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out b/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out
index b3b2dcc..b16b8d0 100644
--- a/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out
@@ -35,6 +35,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
TableScan Vectorization:
native: true
@@ -101,6 +102,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cd
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
TableScan Vectorization:
native: true
@@ -214,6 +216,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
TableScan Vectorization:
native: true
@@ -280,6 +283,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cd
+ filterExpr: (cint < 2000000000) (type: boolean)
Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
TableScan Vectorization:
native: true
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/llapdecider.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llapdecider.q.out b/ql/src/test/results/clientpositive/llap/llapdecider.q.out
index 64ed44d..5785b70 100644
--- a/ql/src/test/results/clientpositive/llap/llapdecider.q.out
+++ b/ql/src/test/results/clientpositive/llap/llapdecider.q.out
@@ -339,6 +339,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -359,6 +360,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -431,6 +433,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -451,6 +454,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -525,6 +529,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -545,6 +550,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -618,6 +624,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -637,6 +644,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -709,6 +717,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -728,6 +737,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -800,6 +810,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -820,6 +831,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -893,6 +905,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -912,6 +925,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -984,6 +998,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1004,6 +1019,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1083,6 +1099,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
+ filterExpr: (UDFToInteger(key) > 1) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToInteger(key) > 1) (type: boolean)
@@ -1144,6 +1161,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
+ filterExpr: (UDFToInteger(key) > 1) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToInteger(key) > 1) (type: boolean)
@@ -1204,6 +1222,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
+ filterExpr: (UDFToInteger(GenericUDFTestGetJavaString(key)) > 1) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToInteger(GenericUDFTestGetJavaString(key)) > 1) (type: boolean)
@@ -1264,6 +1283,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
+ filterExpr: (UDFToInteger(key) > 1) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToInteger(key) > 1) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out
index d0293eb..9f54bbc 100644
--- a/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out
+++ b/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out
@@ -52,6 +52,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds is not null and hr is not null) (type: boolean)
Statistics: Num rows: 2000 Data size: 724000 Basic stats: COMPLETE Column stats: COMPLETE
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/llap/load_dyn_part3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out
index c9823ce..f00343e 100644
--- a/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out
+++ b/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out
@@ -57,6 +57,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: srcpart
+ filterExpr: (ds is not null and hr is not null) (type: boolean)
Statistics: Num rows: 2000 Data size: 1092000 Basic stats: COMPLETE Column stats: COMPLETE
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/llap/lvj_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out
index 56aff94..7548400 100644
--- a/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out
@@ -114,6 +114,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: expod1
+ filterExpr: aid is not null (type: boolean)
Statistics: Num rows: 3 Data size: 5772 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: aid is not null (type: boolean)
@@ -199,6 +200,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: expod2
+ filterExpr: bid is not null (type: boolean)
Statistics: Num rows: 3 Data size: 5772 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: bid is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
index 60128da..204e775 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out
@@ -197,6 +197,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2_n2
+ filterExpr: key BETWEEN 100 AND 102 (type: boolean)
Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
@@ -304,6 +305,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test2_n2
+ filterExpr: key BETWEEN 100 AND 102 (type: boolean)
Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key BETWEEN 100 AND 102 (type: boolean)
@@ -1831,7 +1833,7 @@ NULL NULL None NULL NULL NULL
101 2 Car 102 2 Del
101 2 Car 103 2 Ema
NULL NULL NULL 104 3 Fli
-Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: EXPLAIN
SELECT *
FROM (
@@ -1901,6 +1903,10 @@ STAGE PLANS:
Map-reduce partition columns: _col1 (type: int)
Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col2 (type: string)
+ Select Operator
+ expressions: key (type: int), value (type: int), col_1 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Left Outer Join 0 to 1
@@ -1987,7 +1993,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: SELECT *
FROM (
SELECT test1_n4.key AS key1, test1_n4.value AS value1, test1_n4.col_1 AS col_1,
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
index 795ecfe..e7bafc9 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out
@@ -95,6 +95,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n95
+ filterExpr: dec is not null (type: boolean)
Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: dec is not null (type: boolean)
@@ -124,6 +125,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2_n59
+ filterExpr: dec is not null (type: boolean)
Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: dec is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
index 0ef6bbb..d289536 100644
--- a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out
@@ -18,6 +18,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
@@ -284,6 +285,7 @@ STAGE PLANS:
Map Operator Tree:
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
@@ -361,6 +363,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
GatherStats: false
Filter Operator
@@ -463,6 +466,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)
@@ -504,6 +508,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -523,6 +528,7 @@ STAGE PLANS:
Map Operator Tree:
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)
@@ -568,6 +574,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)
@@ -614,6 +621,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)
@@ -633,6 +641,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)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
index b949618..c3cd893 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
@@ -176,6 +176,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: (a = 3) (type: boolean)
Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (a = 3) (type: boolean)
@@ -194,6 +195,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: ((d = 3) and (a = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
@@ -311,6 +313,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: 600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
@@ -425,6 +428,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: (a = 3) (type: boolean)
Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (a = 3) (type: boolean)
@@ -443,6 +447,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n10
+ filterExpr: ((d = 3) and (a = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE
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/llap/materialized_view_create_rewrite_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
index d311f36..fdfdee5 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out
@@ -72,6 +72,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n9
+ filterExpr: (c > 20) (type: boolean)
Statistics: Num rows: 5 Data size: 1030 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (c > 20) (type: boolean)
@@ -162,6 +163,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n9
+ filterExpr: (c > 20) (type: boolean)
Statistics: Num rows: 5 Data size: 1030 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (c > 20) (type: boolean)
@@ -252,6 +254,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.cmv_mat_view_3
+ filterExpr: (c > 20) (type: boolean)
Statistics: Num rows: 3 Data size: 1368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (c > 20) (type: boolean)
@@ -474,6 +477,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_5
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -529,6 +533,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.cmv_mat_view_5
+ filterExpr: (c > 10.1) (type: boolean)
Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (c > 10.1) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
index 237ff00..6027804 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
@@ -107,6 +107,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -126,6 +127,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -253,6 +255,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -333,6 +336,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -352,6 +356,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -463,6 +468,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -482,6 +488,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean)
@@ -665,6 +672,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -730,6 +738,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -749,6 +758,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -863,6 +873,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -945,6 +956,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -1008,6 +1020,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -1027,6 +1040,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
index 8aa6c72..b3fd29a 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
@@ -107,6 +107,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -126,6 +127,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 240 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -321,6 +323,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -340,6 +343,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 240 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -548,6 +552,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -567,6 +572,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -683,6 +689,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.cmv_mat_view_n5
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 248 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -703,6 +710,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -722,6 +730,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean)
@@ -984,6 +993,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n5
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -1046,6 +1056,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -1065,6 +1076,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 61 Data size: 7320 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -1203,6 +1215,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n5
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -1265,6 +1278,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -1284,6 +1298,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 75 Data size: 9000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -1422,6 +1437,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n5
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -1494,6 +1510,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.cmv_mat_view_n5
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 248 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -1514,6 +1531,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n5
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -1533,6 +1551,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n2
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 4) and a is not null) (type: boolean)
Statistics: Num rows: 91 Data size: 10920 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 4) and (c > 10) and a is not null) (type: boolean)
@@ -1751,6 +1770,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n5
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
index 20146f8..9abdcbb 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
@@ -152,6 +152,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n6
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -171,6 +172,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n3
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -256,6 +258,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n6
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -275,6 +278,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n3
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean)
@@ -442,6 +446,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n6
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -504,6 +509,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n6
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -523,6 +529,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n3
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 61 Data size: 7076 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -649,6 +656,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n6
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -712,6 +720,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n6
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -731,6 +740,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n3
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 75 Data size: 8700 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -857,6 +867,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n6
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -924,6 +935,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n6
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -943,6 +955,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n3
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 4) and a is not null) (type: boolean)
Statistics: Num rows: 91 Data size: 10556 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 4) and (c > 10) and a is not null) (type: boolean)
@@ -1069,6 +1082,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n6
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
index cff7f70..e2972f3 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out
@@ -176,6 +176,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n0
+ filterExpr: (a = 3) (type: boolean)
Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (a = 3) (type: boolean)
@@ -194,6 +195,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n0
+ filterExpr: ((d = 3) and (a = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
@@ -311,6 +313,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n0
+ filterExpr: ((a = 3) and (d = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((a = 3) and (d = 3)) (type: boolean)
@@ -425,6 +428,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n0
+ filterExpr: (a = 3) (type: boolean)
Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (a = 3) (type: boolean)
@@ -443,6 +447,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n0
+ filterExpr: ((d = 3) and (a = 3)) (type: boolean)
Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE
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/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
index 3b7fb57..210db2c 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
@@ -107,6 +107,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -126,6 +127,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n0
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -253,6 +255,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n1
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -333,6 +336,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -352,6 +356,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n0
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -463,6 +468,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -482,6 +488,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n0
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean)
@@ -665,6 +672,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n1
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -730,6 +738,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -749,6 +758,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n0
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -863,6 +873,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n1
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -945,6 +956,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n1
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -1008,6 +1020,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n1
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -1027,6 +1040,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n0
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
index cfff416..44a866d 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
@@ -107,6 +107,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n3
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -126,6 +127,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n1
+ filterExpr: ((c > 10) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10) and a is not null) (type: boolean)
@@ -306,6 +308,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n3
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -325,6 +328,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n1
+ filterExpr: ((c > 10.1) and a is not null) (type: boolean)
Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((c > 10.1) and a is not null) (type: boolean)
@@ -521,6 +525,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n3
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
@@ -577,6 +582,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_n3
+ filterExpr: a is not null (type: boolean)
Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: a is not null (type: boolean)
@@ -596,6 +602,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: cmv_basetable_2_n1
+ filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean)
@@ -824,6 +831,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.cmv_mat_view_n3
+ filterExpr: (c > 10.1) (type: boolean)
Filter Operator
predicate: (c > 10.1) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
index 16b199b..50f62d9 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
@@ -220,6 +220,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n2
+ filterExpr: ((empid < 120) and deptno is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 315 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((empid < 120) and deptno is not null) (type: boolean)
@@ -359,6 +360,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n2
+ filterExpr: deptno is not null (type: boolean)
Statistics: Num rows: 5 Data size: 510 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: deptno is not null (type: boolean)
@@ -493,6 +495,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n2
+ filterExpr: (deptno = 1) (type: boolean)
Filter Operator
predicate: (deptno = 1) (type: boolean)
Select Operator
@@ -569,6 +572,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps_n3
+ filterExpr: (empid > 120) (type: boolean)
Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (empid > 120) (type: boolean)
@@ -590,6 +594,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n2
+ filterExpr: (empid < 150) (type: boolean)
Statistics: Num rows: 4 Data size: 424 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (empid < 150) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
index 2d5764b..feef487 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
@@ -220,6 +220,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n0
+ filterExpr: (deptno > 20) (type: boolean)
Filter Operator
predicate: (deptno > 20) (type: boolean)
Select Operator
@@ -299,6 +300,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n0
+ filterExpr: (deptno > 20) (type: boolean)
Filter Operator
predicate: (deptno > 20) (type: boolean)
Select Operator
@@ -378,6 +380,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n0
+ filterExpr: (deptno > 20) (type: boolean)
Filter Operator
predicate: (deptno > 20) (type: boolean)
Select Operator
@@ -457,6 +460,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n0
+ filterExpr: (empid > 15) (type: boolean)
Filter Operator
predicate: (empid > 15) (type: boolean)
Select Operator
@@ -547,6 +551,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n0
+ filterExpr: (empid > 15) (type: boolean)
Statistics: Num rows: 5 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (empid > 15) (type: boolean)
@@ -680,6 +685,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n0
+ filterExpr: ((name = name2) and (deptno = deptno2)) (type: boolean)
Statistics: Num rows: 8 Data size: 1536 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((deptno = deptno2) and (name = name2)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
index 5965d31..27fdee4 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
@@ -216,6 +216,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n5
+ filterExpr: (deptno = 1) (type: boolean)
Filter Operator
predicate: (deptno = 1) (type: boolean)
Select Operator
@@ -289,6 +290,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n5
+ filterExpr: (UDFToInteger(_c0) > 1) (type: boolean)
Filter Operator
predicate: (UDFToInteger(_c0) > 1) (type: boolean)
Select Operator
@@ -366,6 +368,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.mv1_n5
+ filterExpr: (UDFToInteger(_c0) = 1) (type: boolean)
Filter Operator
predicate: (UDFToInteger(_c0) = 1) (type: boolean)
Select Operator
@@ -451,6 +454,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n5
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 4 Data size: 352 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -470,6 +474,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents_n5
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
index a0a22bf..7688d1a 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
@@ -533,6 +533,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n3
+ filterExpr: (deptno > 10) (type: boolean)
Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (deptno > 10) (type: boolean)
@@ -653,6 +654,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n3
+ filterExpr: (deptno > 10) (type: boolean)
Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (deptno > 10) (type: boolean)
@@ -788,6 +790,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n3
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -808,6 +811,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents_n3
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)