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:37 UTC
[34/51] [partial] hive git commit: HIVE-12342 : Set default value of
hive.optimize.index.filter to true (Igor Kryvenko via Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
index 6718e3f..3bb93ba 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
@@ -232,6 +232,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n1
+ filterExpr: (deptno >= 20) (type: boolean)
Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (deptno >= 20) (type: boolean)
@@ -341,6 +342,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n1
+ filterExpr: (deptno > 15) (type: boolean)
Statistics: Num rows: 1 Data size: 100 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (deptno > 15) (type: boolean)
@@ -481,6 +483,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1_n1
+ filterExpr: ((deptno > 11) and (deptno < 19)) (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((deptno < 19) and (deptno > 11)) (type: boolean)
@@ -1076,7 +1079,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[22][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select a.empid deptno from
(select * from emps_n2 where empid = 1) a
@@ -1158,7 +1161,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[22][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select a.empid, a.deptno from
(select * from emps_n2 where empid = 1) a
@@ -1307,7 +1310,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[22][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select emps_n2.empid, emps_n2.deptno from emps_n2
join depts_n1 on (emps_n2.deptno = depts_n1.deptno)
@@ -1389,7 +1392,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_2, $hdt$_3, $hdt$_1, $hdt$_0]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[48][tables = [$hdt$_2, $hdt$_3, $hdt$_1, $hdt$_0]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select emps_n2.empid, emps_n2.deptno from emps_n2
join depts_n1 a on (emps_n2.deptno=a.deptno)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
index 77887e0..8a52138 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
@@ -236,6 +236,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1
+ filterExpr: (deptno > 10) (type: boolean)
Statistics: Num rows: 4 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (deptno > 10) (type: boolean)
@@ -354,6 +355,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1
+ filterExpr: (deptno > 15) (type: boolean)
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (deptno > 15) (type: boolean)
@@ -480,6 +482,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -499,6 +502,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents
+ 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)
@@ -630,6 +634,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -649,6 +654,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: locations
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 2 Data size: 190 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -668,6 +674,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents
+ 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)
@@ -819,6 +826,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.mv1
+ filterExpr: (UDFToString(name1) = 'Bill') (type: boolean)
Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (UDFToString(name1) = 'Bill') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out
index f677a6c..423741a 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out
@@ -266,6 +266,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents_n4
+ 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)
@@ -307,6 +308,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: locations_n4
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 2 Data size: 190 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -326,6 +328,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n6
+ filterExpr: ((deptno > 10) and (deptno <= 11) and name is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 279 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((deptno <= 11) and (deptno > 10) and name is not null) (type: boolean)
@@ -346,6 +349,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps_n8
+ filterExpr: ((deptno > 10) and (deptno <= 11)) (type: boolean)
Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((deptno <= 11) and (deptno > 10)) (type: boolean)
@@ -557,6 +561,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents_n4
+ 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)
@@ -600,6 +605,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: locations_n4
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 2 Data size: 190 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -619,6 +625,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps_n8
+ filterExpr: ((deptno > 10) and (deptno < 20) and ((deptno <= 11) or (deptno >= 19))) (type: boolean)
Statistics: Num rows: 4 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((deptno <= 11) or (deptno >= 19)) and (deptno < 20) and (deptno > 10)) (type: boolean)
@@ -639,6 +646,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n6
+ filterExpr: ((deptno > 10) and (deptno < 20) and ((deptno <= 11) or (deptno >= 19)) and name is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 279 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((deptno <= 11) or (deptno >= 19)) and (deptno < 20) and (deptno > 10) and name is not null) (type: boolean)
@@ -870,6 +878,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n6
+ filterExpr: ((deptno > 0) and (deptno < 10) and name is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 279 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((deptno < 10) and (deptno > 0) and name is not null) (type: boolean)
@@ -890,6 +899,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps_n8
+ filterExpr: ((deptno > 0) and (deptno < 10)) (type: boolean)
Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((deptno < 10) and (deptno > 0)) (type: boolean)
@@ -909,6 +919,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: dependents_n4
+ 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_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out
index 72f327e..b8bc011 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out
@@ -366,6 +366,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.source_table_001_mv
+ filterExpr: (my_date = DATE'2010-01-10') (type: boolean)
Filter Operator
predicate: (my_date = DATE'2010-01-10') (type: boolean)
Select Operator
@@ -399,6 +400,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: default.source_table_001_mv
+ filterExpr: (my_date = DATE'2010-01-10') (type: boolean)
Filter Operator
predicate: (my_date = DATE'2010-01-10') (type: boolean)
Select Operator
@@ -434,6 +436,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.source_table_001_mv
+ filterExpr: (my_date = DATE'2010-01-10') (type: boolean)
Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (my_date = DATE'2010-01-10') (type: boolean)
@@ -505,6 +508,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.source_table_001_mv
+ filterExpr: (my_date = DATE'2010-01-10') (type: boolean)
Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (my_date = DATE'2010-01-10') (type: boolean)
@@ -582,6 +586,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.source_table_001_mv
+ filterExpr: (my_date = DATE'2010-01-10') (type: boolean)
Statistics: Num rows: 1 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (my_date = DATE'2010-01-10') (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out
index b33d8c3..2e6f00c 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out
@@ -56,6 +56,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_mv_rewrite_empty
+ filterExpr: (empid < 120) (type: boolean)
Filter Operator
predicate: (empid < 120) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out
index ab28253..1841f1f 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out
@@ -688,6 +688,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_year = 1993) and (lo_quantity < 25.0D) and lo_discount BETWEEN 1.0D AND 3.0D) (type: boolean)
Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((d_year = 1993) and (lo_quantity < 25.0D) and lo_discount BETWEEN 1.0D AND 3.0D) (type: boolean)
@@ -767,6 +768,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_yearmonthnum = 199401) and lo_discount BETWEEN 4.0D AND 6.0D and lo_quantity BETWEEN 26.0D AND 35.0D) (type: boolean)
Statistics: Num rows: 1 Data size: 28 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((d_yearmonthnum = 199401) and lo_discount BETWEEN 4.0D AND 6.0D and lo_quantity BETWEEN 26.0D AND 35.0D) (type: boolean)
@@ -848,6 +850,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_year = 1994) and (d_weeknuminyear = 6) and lo_discount BETWEEN 5.0D AND 7.0D and lo_quantity BETWEEN 26.0D AND 35.0D) (type: boolean)
Statistics: Num rows: 1 Data size: 32 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((d_weeknuminyear = 6) and (d_year = 1994) and lo_discount BETWEEN 5.0D AND 7.0D and lo_quantity BETWEEN 26.0D AND 35.0D) (type: boolean)
@@ -938,6 +941,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((p_category = 'MFGR#12') and (s_region = 'AMERICA')) (type: boolean)
Statistics: Num rows: 1 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((p_category = 'MFGR#12') and (s_region = 'AMERICA')) (type: boolean)
@@ -1048,6 +1052,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((s_region = 'ASIA') and p_brand1 BETWEEN 'MFGR#2221' AND 'MFGR#2228') (type: boolean)
Statistics: Num rows: 1 Data size: 380 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((s_region = 'ASIA') and p_brand1 BETWEEN 'MFGR#2221' AND 'MFGR#2228') (type: boolean)
@@ -1158,6 +1163,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((p_brand1 = 'MFGR#2239') and (s_region = 'EUROPE')) (type: boolean)
Statistics: Num rows: 1 Data size: 380 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((p_brand1 = 'MFGR#2239') and (s_region = 'EUROPE')) (type: boolean)
@@ -1272,6 +1278,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_year >= 1992) and (c_region = 'ASIA') and (s_region = 'ASIA') and (d_year <= 1997)) (type: boolean)
Statistics: Num rows: 1 Data size: 748 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((c_region = 'ASIA') and (d_year <= 1997) and (d_year >= 1992) and (s_region = 'ASIA')) (type: boolean)
@@ -1384,6 +1391,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_year >= 1992) and (c_nation = 'UNITED STATES') and (s_nation = 'UNITED STATES') and (d_year <= 1997)) (type: boolean)
Statistics: Num rows: 1 Data size: 748 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((c_nation = 'UNITED STATES') and (d_year <= 1997) and (d_year >= 1992) and (s_nation = 'UNITED STATES')) (type: boolean)
@@ -1496,6 +1504,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_year >= 1992) and (d_year <= 1997) and ((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5'))) (type: boolean)
Statistics: Num rows: 1 Data size: 380 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5')) and (d_year <= 1997) and (d_year >= 1992)) (type: boolean)
@@ -1604,6 +1613,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((d_yearmonth = 'Dec1997') and ((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5'))) (type: boolean)
Statistics: Num rows: 1 Data size: 564 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5')) and (d_yearmonth = 'Dec1997')) (type: boolean)
@@ -1720,6 +1730,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((c_region = 'AMERICA') and (s_region = 'AMERICA') and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2'))) (type: boolean)
Statistics: Num rows: 1 Data size: 748 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2')) and (c_region = 'AMERICA') and (s_region = 'AMERICA')) (type: boolean)
@@ -1834,6 +1845,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((c_region = 'AMERICA') and (s_region = 'AMERICA') and ((d_year = 1997) or (d_year = 1998)) and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2'))) (type: boolean)
Statistics: Num rows: 1 Data size: 932 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((d_year = 1997) or (d_year = 1998)) and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2')) and (c_region = 'AMERICA') and (s_region = 'AMERICA')) (type: boolean)
@@ -1948,6 +1960,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv_n0
+ filterExpr: ((c_region = 'AMERICA') and (p_category = 'MFGR#14') and (s_nation = 'UNITED STATES') and ((d_year = 1997) or (d_year = 1998))) (type: boolean)
Statistics: Num rows: 1 Data size: 932 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((d_year = 1997) or (d_year = 1998)) and (c_region = 'AMERICA') and (p_category = 'MFGR#14') and (s_nation = 'UNITED STATES')) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out
index 994c9c1..d7c92d8 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out
@@ -690,6 +690,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((UDFToInteger(d_year) = 1993) and (UDFToDouble(lo_quantity) < 25.0D) and UDFToDouble(lo_discount) BETWEEN 1.0D AND 3.0D) (type: boolean)
Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(lo_quantity) < 25.0D) and (UDFToInteger(d_year) = 1993) and UDFToDouble(lo_discount) BETWEEN 1.0D AND 3.0D) (type: boolean)
@@ -769,6 +770,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((UDFToInteger(d_yearmonthnum) = 199401) and UDFToDouble(lo_discount) BETWEEN 4.0D AND 6.0D and UDFToDouble(lo_quantity) BETWEEN 26.0D AND 35.0D) (type: boolean)
Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToInteger(d_yearmonthnum) = 199401) and UDFToDouble(lo_discount) BETWEEN 4.0D AND 6.0D and UDFToDouble(lo_quantity) BETWEEN 26.0D AND 35.0D) (type: boolean)
@@ -850,6 +852,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((UDFToInteger(d_year) = 1994) and (UDFToInteger(d_weeknuminyear) = 6) and UDFToDouble(lo_discount) BETWEEN 5.0D AND 7.0D and UDFToDouble(lo_quantity) BETWEEN 26.0D AND 35.0D) (type: boolean)
Statistics: Num rows: 1 Data size: 744 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToInteger(d_weeknuminyear) = 6) and (UDFToInteger(d_year) = 1994) and UDFToDouble(lo_discount) BETWEEN 5.0D AND 7.0D and UDFToDouble(lo_quantity) BETWEEN 26.0D AND 35.0D) (type: boolean)
@@ -940,6 +943,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((p_category = 'MFGR#12') and (s_region = 'AMERICA')) (type: boolean)
Statistics: Num rows: 1 Data size: 744 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((p_category = 'MFGR#12') and (s_region = 'AMERICA')) (type: boolean)
@@ -1050,6 +1054,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((s_region = 'ASIA') and p_brand1 BETWEEN 'MFGR#2221' AND 'MFGR#2228') (type: boolean)
Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((s_region = 'ASIA') and p_brand1 BETWEEN 'MFGR#2221' AND 'MFGR#2228') (type: boolean)
@@ -1160,6 +1165,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((p_brand1 = 'MFGR#2239') and (s_region = 'EUROPE')) (type: boolean)
Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((p_brand1 = 'MFGR#2239') and (s_region = 'EUROPE')) (type: boolean)
@@ -1274,6 +1280,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((UDFToInteger(d_year) >= 1992) and (c_region = 'ASIA') and (s_region = 'ASIA') and (UDFToInteger(d_year) <= 1997)) (type: boolean)
Statistics: Num rows: 1 Data size: 928 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToInteger(d_year) <= 1997) and (UDFToInteger(d_year) >= 1992) and (c_region = 'ASIA') and (s_region = 'ASIA')) (type: boolean)
@@ -1386,6 +1393,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((UDFToInteger(d_year) >= 1992) and (c_nation = 'UNITED STATES') and (s_nation = 'UNITED STATES') and (UDFToInteger(d_year) <= 1997)) (type: boolean)
Statistics: Num rows: 1 Data size: 928 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToInteger(d_year) <= 1997) and (UDFToInteger(d_year) >= 1992) and (c_nation = 'UNITED STATES') and (s_nation = 'UNITED STATES')) (type: boolean)
@@ -1498,6 +1506,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((UDFToInteger(d_year) >= 1992) and (UDFToInteger(d_year) <= 1997) and ((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5'))) (type: boolean)
Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5')) and (UDFToInteger(d_year) <= 1997) and (UDFToInteger(d_year) >= 1992)) (type: boolean)
@@ -1610,6 +1619,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((d_yearmonth = 'Dec1997') and ((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5'))) (type: boolean)
Statistics: Num rows: 1 Data size: 744 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5')) and (d_yearmonth = 'Dec1997')) (type: boolean)
@@ -1726,6 +1736,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((c_region = 'AMERICA') and (s_region = 'AMERICA') and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2'))) (type: boolean)
Statistics: Num rows: 1 Data size: 928 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2')) and (c_region = 'AMERICA') and (s_region = 'AMERICA')) (type: boolean)
@@ -1840,6 +1851,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((c_region = 'AMERICA') and (s_region = 'AMERICA') and ((UDFToInteger(d_year) = 1997) or (UDFToInteger(d_year) = 1998)) and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2'))) (type: boolean)
Statistics: Num rows: 1 Data size: 1112 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((UDFToInteger(d_year) = 1997) or (UDFToInteger(d_year) = 1998)) and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2')) and (c_region = 'AMERICA') and (s_region = 'AMERICA')) (type: boolean)
@@ -1954,6 +1966,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.ssb_mv
+ filterExpr: ((c_region = 'AMERICA') and (p_category = 'MFGR#14') and (s_nation = 'UNITED STATES') and ((UDFToInteger(d_year) = 1997) or (UDFToInteger(d_year) = 1998))) (type: boolean)
Statistics: Num rows: 1 Data size: 1112 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((UDFToInteger(d_year) = 1997) or (UDFToInteger(d_year) = 1998)) and (c_region = 'AMERICA') and (p_category = 'MFGR#14') and (s_nation = 'UNITED STATES')) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/metadataonly1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out
index 6735c58..7754ce1 100644
--- a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out
+++ b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out
@@ -556,6 +556,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a2
+ filterExpr: ds is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: PARTIAL Column stats: COMPLETE
GatherStats: false
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mrr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/mrr.q.out b/ql/src/test/results/clientpositive/llap/mrr.q.out
index 2a8a2fc..314031f 100644
--- a/ql/src/test/results/clientpositive/llap/mrr.q.out
+++ b/ql/src/test/results/clientpositive/llap/mrr.q.out
@@ -412,6 +412,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -431,6 +432,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)
@@ -846,6 +848,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -865,6 +868,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)
@@ -1300,6 +1304,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)
@@ -1322,6 +1327,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)
@@ -1344,6 +1350,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)
@@ -1627,6 +1634,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1649,6 +1657,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
index f8adcd4..ed1745f 100644
--- a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
+++ b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
@@ -192,6 +192,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -238,6 +239,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -257,6 +259,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -355,6 +358,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -401,6 +405,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -420,6 +425,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -520,6 +526,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -570,6 +577,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -589,6 +597,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 3680 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -825,6 +834,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key1 is not null and value is not null and key2 is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 262752 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key1 is not null and key2 is not null and value is not null) (type: boolean)
@@ -904,6 +914,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -923,6 +934,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 3680 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -943,6 +955,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -962,6 +975,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl4
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1160,6 +1174,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key1 is not null and value is not null and key2 is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 262752 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key1 is not null and key2 is not null and value is not null) (type: boolean)
@@ -1239,6 +1254,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1258,6 +1274,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 3680 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1278,6 +1295,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1297,6 +1315,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl4
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1498,6 +1517,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key1 is not null and value is not null and key2 is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 262752 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key1 is not null and key2 is not null and value is not null) (type: boolean)
@@ -1518,6 +1538,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl4
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1537,6 +1558,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1556,6 +1578,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 3680 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1576,6 +1599,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1864,6 +1888,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: bigtbl
+ filterExpr: (key1 is not null and value is not null and key2 is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 262752 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key1 is not null and key2 is not null and value is not null) (type: boolean)
@@ -1884,6 +1909,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl4
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1903,6 +1929,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1922,6 +1949,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 10 Data size: 3680 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1942,6 +1970,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: smalltbl3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 10 Data size: 1840 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/llap/multiMapJoin2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out
index 61b7c4e..1c6bc94 100644
--- a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out
+++ b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out
@@ -30,6 +30,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -58,6 +59,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -77,6 +79,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -105,6 +108,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -268,6 +272,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -287,6 +292,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -306,6 +312,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -325,6 +332,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -539,6 +547,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -567,6 +576,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -733,6 +743,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -767,6 +778,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -791,6 +803,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -973,6 +986,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1007,6 +1021,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1031,6 +1046,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1213,6 +1229,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1247,6 +1264,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1437,6 +1455,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1471,6 +1490,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1683,6 +1703,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 125 Data size: 10875 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1715,6 +1736,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2150 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1812,6 +1834,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1840,6 +1863,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1874,6 +1898,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1913,6 +1938,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1941,6 +1967,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
index f6b6fec..c06d243 100644
--- a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
+++ b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
@@ -117,6 +117,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_n1
+ filterExpr: (struct((empno + 1),deptno)) IN (const struct(1,2), const struct(3,2)) (type: boolean)
Filter Operator
predicate: (struct((empno + 1),deptno)) IN (const struct(1,2), const struct(3,2)) (type: boolean)
Select Operator
@@ -140,6 +141,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_n1
+ filterExpr: (not (struct((empno + 1),deptno)) IN (const struct(1,2), const struct(3,2))) (type: boolean)
Filter Operator
predicate: (not (struct((empno + 1),deptno)) IN (const struct(1,2), const struct(3,2))) (type: boolean)
Select Operator
@@ -207,6 +209,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_n1
+ filterExpr: (struct(((empno * 2) | 1),deptno)) IN (struct((empno + 1),2), struct((empno + 2),2)) (type: boolean)
Filter Operator
predicate: (struct(((empno * 2) | 1),deptno)) IN (struct((empno + 1),2), struct((empno + 2),2)) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out
index 81fdb13..ce34344 100644
--- a/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out
+++ b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out
@@ -127,6 +127,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_n7
+ filterExpr: (struct((empno + 1),deptno)) IN (const struct(3,2)) (type: boolean)
Filter Operator
predicate: (struct((empno + 1),deptno)) IN (const struct(3,2)) (type: boolean)
Select Operator
@@ -150,6 +151,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_n7
+ filterExpr: (not (struct((empno + 1),deptno)) IN (const struct(3,2))) (type: boolean)
Filter Operator
predicate: (not (struct((empno + 1),deptno)) IN (const struct(3,2))) (type: boolean)
Select Operator
@@ -171,6 +173,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: emps_n7
+ filterExpr: (struct(((empno * 2) | 1),deptno)) IN (struct((empno + 2),2)) (type: boolean)
Filter Operator
predicate: (struct(((empno * 2) | 1),deptno)) IN (struct((empno + 2),2)) (type: boolean)
Select Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/multi_insert.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multi_insert.q.out b/ql/src/test/results/clientpositive/llap/multi_insert.q.out
index 53ae291..d8efef1 100644
--- a/ql/src/test/results/clientpositive/llap/multi_insert.q.out
+++ b/ql/src/test/results/clientpositive/llap/multi_insert.q.out
@@ -898,6 +898,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -1120,6 +1121,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -1342,6 +1344,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
@@ -1564,6 +1567,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((key > 10) and (key < 20)) or (key < 10)) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out b/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out
index e4e3f74..779258b 100644
--- a/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out
+++ b/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out
@@ -56,6 +56,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n97
+ filterExpr: (k < 15) (type: boolean)
Statistics: Num rows: 3 Data size: 285 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (k < 15) (type: boolean)
@@ -76,6 +77,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2_n60
+ filterExpr: ((v = 'people') and k is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 297 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((v = 'people') and k is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/orc_merge_incompat1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_merge_incompat1.q.out b/ql/src/test/results/clientpositive/llap/orc_merge_incompat1.q.out
index 676af08..fd3a8fb 100644
--- a/ql/src/test/results/clientpositive/llap/orc_merge_incompat1.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_merge_incompat1.q.out
@@ -44,6 +44,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_merge5_n3
+ filterExpr: (userid <= 13L) (type: boolean)
Statistics: Num rows: 1 Data size: 352 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (userid <= 13L) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/orc_struct_type_vectorization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_struct_type_vectorization.q.out b/ql/src/test/results/clientpositive/llap/orc_struct_type_vectorization.q.out
index da69c5f..5c6b481 100644
--- a/ql/src/test/results/clientpositive/llap/orc_struct_type_vectorization.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_struct_type_vectorization.q.out
@@ -217,6 +217,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_struct_type
+ filterExpr: (st1.f1 > 500) (type: boolean)
Pruned Column Paths: st1.f1
Statistics: Num rows: 1023 Data size: 229628 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/parquet_complex_types_vectorization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/parquet_complex_types_vectorization.q.out b/ql/src/test/results/clientpositive/llap/parquet_complex_types_vectorization.q.out
index f4d6218..da9dd4e 100644
--- a/ql/src/test/results/clientpositive/llap/parquet_complex_types_vectorization.q.out
+++ b/ql/src/test/results/clientpositive/llap/parquet_complex_types_vectorization.q.out
@@ -194,6 +194,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: parquet_complex_types
+ filterExpr: (l1[0] > 1000) (type: boolean)
Statistics: Num rows: 1023 Data size: 116760 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
@@ -482,6 +483,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: parquet_complex_types
+ filterExpr: (l1[0] > 1000) (type: boolean)
Statistics: Num rows: 1024 Data size: 116880 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
@@ -770,6 +772,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: parquet_complex_types
+ filterExpr: (l1[0] > 1000) (type: boolean)
Statistics: Num rows: 1025 Data size: 117000 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/parquet_map_type_vectorization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/parquet_map_type_vectorization.q.out b/ql/src/test/results/clientpositive/llap/parquet_map_type_vectorization.q.out
index a2bb0f3..6f65061 100644
--- a/ql/src/test/results/clientpositive/llap/parquet_map_type_vectorization.q.out
+++ b/ql/src/test/results/clientpositive/llap/parquet_map_type_vectorization.q.out
@@ -210,6 +210,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: parquet_map_type
+ filterExpr: (stringmap['k1'] like 'v100%') (type: boolean)
Statistics: Num rows: 1023 Data size: 1992704 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
native: true
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/parquet_struct_type_vectorization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/parquet_struct_type_vectorization.q.out b/ql/src/test/results/clientpositive/llap/parquet_struct_type_vectorization.q.out
index 7249363..affb27e 100644
--- a/ql/src/test/results/clientpositive/llap/parquet_struct_type_vectorization.q.out
+++ b/ql/src/test/results/clientpositive/llap/parquet_struct_type_vectorization.q.out
@@ -217,6 +217,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: parquet_struct_type
+ filterExpr: (st1.f1 > 500) (type: boolean)
Pruned Column Paths: st1.f1
Statistics: Num rows: 1023 Data size: 229628 Basic stats: COMPLETE Column stats: NONE
TableScan Vectorization:
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/partialdhj.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/partialdhj.q.out b/ql/src/test/results/clientpositive/llap/partialdhj.q.out
index fde5496..ec0044f 100644
--- a/ql/src/test/results/clientpositive/llap/partialdhj.q.out
+++ b/ql/src/test/results/clientpositive/llap/partialdhj.q.out
@@ -40,6 +40,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -59,6 +60,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -78,6 +80,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -270,6 +273,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -290,6 +294,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -309,6 +314,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 2225 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out b/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
index 3df6e2f..62bab84 100644
--- a/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
@@ -982,6 +982,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: partition_test_multilevel
+ filterExpr: ((level1 = '2222') and level2 BETWEEN '222' AND '333' and level3 BETWEEN '11' AND '33') (type: boolean)
Statistics: Num rows: 108 Data size: 40890 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: level2 (type: string), level3 (type: string)
@@ -1572,6 +1573,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: partition_test_multilevel
+ filterExpr: ((level1 = '2222') and level2 BETWEEN '222' AND '333' and level3 BETWEEN '11' AND '33') (type: boolean)
Statistics: Num rows: 108 Data size: 40890 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: level2 (type: string), level3 (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/partition_pruning.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/partition_pruning.q.out b/ql/src/test/results/clientpositive/llap/partition_pruning.q.out
index 829ab15..ba863a5 100644
--- a/ql/src/test/results/clientpositive/llap/partition_pruning.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_pruning.q.out
@@ -153,6 +153,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: daysales
+ filterExpr: NVL((customer = 1),false) (type: boolean)
GatherStats: false
Filter Operator
isSamplingPred: false
@@ -269,6 +270,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: daysales
+ filterExpr: NVL(((dt = '2001-01-01') or (customer = 3)),false) (type: boolean)
GatherStats: false
Filter Operator
isSamplingPred: false
@@ -385,6 +387,7 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: daysales
+ filterExpr: NVL(((dt = '2001-01-01') or (customer = 3)),false) (type: boolean)
GatherStats: false
Filter Operator
isSamplingPred: false
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/partition_shared_scan.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/partition_shared_scan.q.out b/ql/src/test/results/clientpositive/llap/partition_shared_scan.q.out
index fd33f12..d7d9126 100644
--- a/ql/src/test/results/clientpositive/llap/partition_shared_scan.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_shared_scan.q.out
@@ -59,6 +59,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -79,6 +80,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: f1
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: i is not null (type: boolean)
@@ -98,6 +100,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: f2
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: i is not null (type: boolean)
@@ -190,6 +193,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -210,6 +214,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: f1
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: i is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/ppd_union_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ppd_union_view.q.out b/ql/src/test/results/clientpositive/llap/ppd_union_view.q.out
index 0f20c9b..ca1b58f 100644
--- a/ql/src/test/results/clientpositive/llap/ppd_union_view.q.out
+++ b/ql/src/test/results/clientpositive/llap/ppd_union_view.q.out
@@ -153,6 +153,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_new_n0
+ filterExpr: (ds = '2011-10-13') (type: boolean)
Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: PARTIAL
GatherStats: false
Filter Operator
@@ -195,6 +196,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_old
+ filterExpr: keymap is not null (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 1 Data size: 181 Basic stats: COMPLETE Column stats: COMPLETE
@@ -277,6 +279,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_mapping
+ filterExpr: keymap is not null (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 1 Data size: 179 Basic stats: COMPLETE Column stats: COMPLETE
@@ -468,6 +471,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_new_n0
+ filterExpr: (ds = '2011-10-15') (type: boolean)
Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Select Operator
@@ -561,6 +565,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_old
+ filterExpr: ((ds = '2011-10-15') and keymap is not null) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: PARTIAL
@@ -588,6 +593,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_mapping
+ filterExpr: ((ds = '2011-10-15') and keymap is not null) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: PARTIAL
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ptf.q.out b/ql/src/test/results/clientpositive/llap/ptf.q.out
index 13ea607..808d8c8 100644
--- a/ql/src/test/results/clientpositive/llap/ptf.q.out
+++ b/ql/src/test/results/clientpositive/llap/ptf.q.out
@@ -210,6 +210,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5902 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -226,6 +227,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p2
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -1085,6 +1087,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -1226,6 +1229,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -2370,6 +2374,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out b/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
index c2a80fe..abb05ff 100644
--- a/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
+++ b/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
@@ -318,6 +318,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: flights_tiny_n0
+ filterExpr: (fl_num = -1142) (type: boolean)
Statistics: Num rows: 1 Data size: 384 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (fl_num = -1142) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out b/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
index 3b3b13d..d536945 100644
--- a/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
+++ b/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
@@ -210,6 +210,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5902 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -226,6 +227,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p2
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -415,6 +417,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -1660,6 +1663,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)