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:33 UTC
[30/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/subquery_select.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_select.q.out b/ql/src/test/results/clientpositive/llap/subquery_select.q.out
index f21fd39..bd569b3 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_select.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_select.q.out
@@ -641,6 +641,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2704 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1000,6 +1001,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2704 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1271,6 +1273,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2704 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1408,6 +1411,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5850 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1546,6 +1550,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5850 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1768,7 +1773,7 @@ POSTHOOK: Input: default@part
2 46
46 46
23 46
-Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[46][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain
select *
from src b
@@ -1805,6 +1810,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((value is not null and key is not null) or ((key > '9') and value 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 and value is not null) (type: boolean)
@@ -1916,7 +1922,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[46][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select *
from src b
where b.key in
@@ -1975,6 +1981,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((value is not null and key is not null) or ((key > '9') and value is not null) or value 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 and value is not null) (type: boolean)
@@ -2135,7 +2142,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@tnull_n3
POSTHOOK: Lineage: tnull_n3.i EXPRESSION []
-Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[29][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select p_size, p_size IN (select i from tnull_n3) from part
PREHOOK: type: QUERY
POSTHOOK: query: explain select p_size, p_size IN (select i from tnull_n3) from part
@@ -2276,7 +2283,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[29][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select p_size, p_size IN (select i from tnull_n3) from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -3056,7 +3063,7 @@ STANDARD ANODIZED TIN true
STANDARD BURNISHED TIN true
STANDARD PLATED TIN true
STANDARD POLISHED STEEL true
-Warning: Shuffle Join MERGEJOIN[62][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[72][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: EXPLAIN SELECT p_size, p_size IN (
SELECT MAX(p_size) FROM part p where p.p_type = part.p_type) AND
p_name IN (SELECT min(p_name) from part)
@@ -3106,6 +3113,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -3298,7 +3306,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[62][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[72][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: SELECT p_size, p_size IN (
SELECT MAX(p_size) FROM part p where p.p_type = part.p_type) AND
p_name IN (SELECT min(p_name) from part)
@@ -3379,6 +3387,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2704 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -3777,6 +3786,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_size BETWEEN 1 AND 20 (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size BETWEEN 1 AND 20 (type: boolean)
@@ -3798,6 +3808,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_partkey BETWEEN 1 AND 20 (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey BETWEEN 1 AND 20 (type: boolean)
@@ -3817,6 +3828,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_partkey BETWEEN 10000 AND 20000 (type: boolean)
Statistics: Num rows: 26 Data size: 208 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey BETWEEN 10000 AND 20000 (type: boolean)
@@ -4114,7 +4126,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
true
-Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[48][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select o.p_size, (select count(distinct p_type) from part p where p.p_partkey = o.p_partkey) tmp
FROM part o right join (select * from part where p_size > (select avg(p_size) from part)) t on t.p_partkey = o.p_partkey
PREHOOK: type: QUERY
@@ -4151,6 +4163,10 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 26 Data size: 208 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: int)
+ Select Operator
+ expressions: p_partkey (type: int), p_size (type: int)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 26 Data size: 208 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
Statistics: Num rows: 26 Data size: 208 Basic stats: COMPLETE Column stats: COMPLETE
@@ -4181,6 +4197,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -4289,7 +4306,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[48][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select o.p_size, (select count(distinct p_type) from part p where p.p_partkey = o.p_partkey) tmp
FROM part o right join (select * from part where p_size > (select avg(p_size) from part)) t on t.p_partkey = o.p_partkey
PREHOOK: type: QUERY
@@ -4569,7 +4586,7 @@ POSTHOOK: Input: default@part
46 1 19.692307692307693 512
46 1 19.692307692307693 512
46 1 19.692307692307693 512
-Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[46][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select t1.p_size,
(select count(*) from part p, part pp where p.p_size = pp.p_size and p.p_type = pp.p_type)
from part t1
@@ -4611,6 +4628,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: (p_size is not null and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_size is not null and p_type is not null) (type: boolean)
@@ -4630,6 +4648,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_size is not null and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_size is not null and p_type is not null) (type: boolean)
@@ -4701,7 +4720,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[46][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select t1.p_size,
(select count(*) from part p, part pp where p.p_size = pp.p_size and p.p_type = pp.p_type)
from part t1
@@ -4740,7 +4759,7 @@ POSTHOOK: Input: default@part
2 28
46 28
23 28
-Warning: Shuffle Join MERGEJOIN[60][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[92][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select t1.p_size,
(select count(*) from part p, part pp where p.p_size = pp.p_size and p.p_type = pp.p_type
and (select sum(p_size) from part a1 where a1.p_partkey = p.p_partkey
@@ -4789,6 +4808,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a1
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 208 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -4811,6 +4831,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: (p_size is not null and p_type is not null and p_partkey is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2912 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_partkey is not null and p_size is not null and p_type is not null) (type: boolean)
@@ -4831,6 +4852,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_size is not null and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_size is not null and p_type is not null) (type: boolean)
@@ -4850,6 +4872,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a1
+ 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)
@@ -4991,7 +5014,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[60][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[92][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select t1.p_size,
(select count(*) from part p, part pp where p.p_size = pp.p_size and p.p_type = pp.p_type
and (select sum(p_size) from part a1 where a1.p_partkey = p.p_partkey
@@ -5034,7 +5057,7 @@ POSTHOOK: Input: default@part
2 28
46 28
23 28
-Warning: Shuffle Join MERGEJOIN[89][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[127][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select t1.p_size,
(select count(*) from part t2 where t2.p_partkey = t1.p_partkey group by t2.p_partkey),
(select count(*) from part p, part pp where p.p_size = pp.p_size and p.p_type = pp.p_type
@@ -5105,6 +5128,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: (p_size is not null and p_type is not null and p_partkey is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2912 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_partkey is not null and p_size is not null and p_type is not null) (type: boolean)
@@ -5125,6 +5149,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_size is not null and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_size is not null and p_type is not null) (type: boolean)
@@ -5144,6 +5169,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
+ 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)
@@ -5373,7 +5399,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[89][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[127][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select t1.p_size,
(select count(*) from part t2 where t2.p_partkey = t1.p_partkey group by t2.p_partkey),
(select count(*) from part p, part pp where p.p_size = pp.p_size and p.p_type = pp.p_type
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/subquery_views.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_views.q.out b/ql/src/test/results/clientpositive/llap/subquery_views.q.out
index cde0413..05c91cd 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_views.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_views.q.out
@@ -116,6 +116,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((key < '11') or ((value > 'val_11') and (key < '11')) or ((value > 'val_11') and (key < '11'))) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
@@ -192,6 +193,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (key < '11') (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/table_access_keys_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/table_access_keys_stats.q.out b/ql/src/test/results/clientpositive/llap/table_access_keys_stats.q.out
index bb823d4..1b6fdbd 100644
--- a/ql/src/test/results/clientpositive/llap/table_access_keys_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/table_access_keys_stats.q.out
@@ -496,7 +496,7 @@ Keys:val
13.0 1
17.0 1
46.0 1
-Warning: Shuffle Join MERGEJOIN[29][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[39][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: SELECT *
FROM
(
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/temp_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/temp_table.q.out b/ql/src/test/results/clientpositive/llap/temp_table.q.out
index 7abb8e6..2965d54 100644
--- a/ql/src/test/results/clientpositive/llap/temp_table.q.out
+++ b/ql/src/test/results/clientpositive/llap/temp_table.q.out
@@ -18,6 +18,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((UDFToDouble(key) % 2.0D) = 0.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) % 2.0D) = 0.0D) (type: boolean)
@@ -91,6 +92,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((UDFToDouble(key) % 2.0D) = 1.0D) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) % 2.0D) = 1.0D) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_bmj_schema_evolution.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_bmj_schema_evolution.q.out b/ql/src/test/results/clientpositive/llap/tez_bmj_schema_evolution.q.out
index 5107fbe..5766ba2 100644
--- a/ql/src/test/results/clientpositive/llap/tez_bmj_schema_evolution.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_bmj_schema_evolution.q.out
@@ -86,6 +86,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test_n1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1000 Data size: 95000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -115,6 +116,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: test1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 2000 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/tez_dynpart_hashjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out
index fd6541e..cfa87a7 100644
--- a/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out
@@ -31,6 +31,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -51,6 +52,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -163,6 +165,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -182,6 +185,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -291,6 +295,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -311,6 +316,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -442,6 +448,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -462,6 +469,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -577,6 +585,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -596,6 +605,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -708,6 +718,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -728,6 +739,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out b/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out
index 3373fc25..55c581f 100644
--- a/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out
@@ -39,6 +39,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (csmallint < 100S) (type: boolean)
Statistics: Num rows: 12288 Data size: 3093170 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (csmallint < 100S) (type: boolean)
@@ -59,6 +60,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)
@@ -78,6 +80,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)
@@ -230,6 +233,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (csmallint < 100S) (type: boolean)
Statistics: Num rows: 12288 Data size: 3093170 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (csmallint < 100S) (type: boolean)
@@ -250,6 +254,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)
@@ -269,6 +274,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)
@@ -421,6 +427,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (csmallint < 100S) (type: boolean)
Statistics: Num rows: 12288 Data size: 3093170 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (csmallint < 100S) (type: boolean)
@@ -441,6 +448,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)
@@ -460,6 +468,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)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_input_counters.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_input_counters.q.out b/ql/src/test/results/clientpositive/llap/tez_input_counters.q.out
index 5a9fb30..f24906f 100644
--- a/ql/src/test/results/clientpositive/llap/tez_input_counters.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_input_counters.q.out
@@ -1859,6 +1859,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
+ filterExpr: v is not null (type: boolean)
Statistics: Num rows: 1000 Data size: 188000 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: k (type: int), v (type: string)
@@ -1891,6 +1892,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
+ filterExpr: v is not null (type: boolean)
Statistics: Num rows: 240 Data size: 45120 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: k (type: int), v (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_join.q.out b/ql/src/test/results/clientpositive/llap/tez_join.q.out
index 8253333..53f8895 100644
--- a/ql/src/test/results/clientpositive/llap/tez_join.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_join.q.out
@@ -56,6 +56,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n42
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
@@ -74,6 +75,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2_n26
+ filterExpr: id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: id is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out b/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out
index 122eb5c..0da6c05 100644
--- a/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_join_hash.q.out
@@ -39,6 +39,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -58,6 +59,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -156,6 +158,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 2000 Data size: 356000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -176,6 +179,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 174000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -195,6 +199,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 2000 Data size: 356000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -215,6 +220,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 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/tez_join_result_complex.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out b/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out
index 8b5f73f..606c384 100644
--- a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out
@@ -167,6 +167,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: contact_event_id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 3212 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -251,6 +252,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: cnctevn_id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4944 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -1156,6 +1158,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: contact_event_id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 3212 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
@@ -1240,6 +1243,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: cnctevn_id is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4944 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out b/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out
index ff74455..bf2f5a8 100644
--- a/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_join_tests.q.out
@@ -33,6 +33,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: _col1 (type: string)
sort order: +
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out b/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out
index 012b934..72b84a0 100644
--- a/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_joins_explain.q.out
@@ -33,6 +33,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: _col1 (type: string)
sort order: +
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out b/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out
index 2dac1d2..fab8b52 100644
--- a/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_nway_join.q.out
@@ -53,6 +53,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -88,6 +89,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -107,6 +109,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -165,6 +168,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -207,6 +211,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -226,6 +231,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 2 Data size: 8 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/tez_self_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_self_join.q.out b/ql/src/test/results/clientpositive/llap/tez_self_join.q.out
index fe602a5..a362411 100644
--- a/ql/src/test/results/clientpositive/llap/tez_self_join.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_self_join.q.out
@@ -42,7 +42,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@tez_self_join2
POSTHOOK: Lineage: tez_self_join2.id1 SCRIPT []
-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 s.id2, s.id3
from
@@ -82,6 +82,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tez_self_join2
+ filterExpr: id1 is not null (type: boolean)
Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: id1 is not null (type: boolean)
@@ -101,6 +102,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: self1
+ filterExpr: ((id2 = 'ab') and id1 is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 528 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((id2 = 'ab') and id1 is not null) (type: boolean)
@@ -119,6 +121,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: self2
+ filterExpr: (id3 = 'ab') (type: boolean)
Statistics: Num rows: 3 Data size: 258 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (id3 = 'ab') (type: boolean)
@@ -180,7 +183,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 s.id2, s.id3
from
(
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out b/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out
index c8d1d90..dfc4d30 100644
--- a/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_smb_empty.q.out
@@ -138,6 +138,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -149,6 +150,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -540,6 +542,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -551,6 +554,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -562,6 +566,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -646,6 +651,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -657,6 +663,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -668,6 +675,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -752,6 +760,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -763,6 +772,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -841,6 +851,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 968 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -852,6 +863,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 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/tez_smb_main.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out b/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out
index 468f45c..9929989 100644
--- a/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_smb_main.q.out
@@ -20,6 +20,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ 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)
@@ -40,6 +41,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 25 Data size: 4375 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -263,6 +265,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -282,6 +285,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 7216 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -374,6 +378,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -393,6 +398,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 7216 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -485,6 +491,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -504,6 +511,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -593,6 +601,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -622,6 +631,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -641,6 +651,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -719,6 +730,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -748,6 +760,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -767,6 +780,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -861,6 +875,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -880,6 +895,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ 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)
@@ -957,6 +973,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -976,6 +993,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ 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)
@@ -1078,6 +1096,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1089,6 +1108,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1115,6 +1135,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1134,6 +1155,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1213,6 +1235,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1232,6 +1255,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ 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)
@@ -1303,6 +1327,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1322,6 +1347,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ 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)
@@ -1409,6 +1435,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -1438,6 +1465,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1457,6 +1485,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1529,6 +1558,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (key is not null and value is not null) (type: boolean)
Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -1558,6 +1588,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: c
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: value is not null (type: boolean)
@@ -1577,6 +1608,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1674,6 +1706,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 924 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1716,6 +1749,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 924 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1735,6 +1769,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 924 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1767,6 +1802,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 1904 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1846,6 +1882,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 242 Data size: 45994 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1864,6 +1901,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 94800 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/tez_union.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_union.q.out b/ql/src/test/results/clientpositive/llap/tez_union.q.out
index 5e5e9a8..914ed47 100644
--- a/ql/src/test/results/clientpositive/llap/tez_union.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_union.q.out
@@ -25,6 +25,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)
@@ -56,6 +57,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ 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)
@@ -183,6 +185,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -202,6 +205,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -221,6 +225,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -240,6 +245,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -359,6 +365,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)
@@ -383,6 +390,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -414,6 +422,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: key is not null (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: key is not null (type: boolean)
@@ -539,6 +548,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ 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)
@@ -585,6 +595,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s8
+ 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)
@@ -614,6 +625,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ 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)
@@ -633,6 +645,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s4
+ 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)
@@ -679,6 +692,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s5
+ 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)
@@ -698,6 +712,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s6
+ 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)
@@ -744,6 +759,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s7
+ 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)
@@ -763,6 +779,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)
@@ -979,6 +996,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ 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)
@@ -1010,6 +1028,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s3
+ 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)
@@ -1029,6 +1048,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s4
+ 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)
@@ -1060,6 +1080,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s5
+ 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/tez_union_group_by.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out b/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out
index 9d7430d..2c79549 100644
--- a/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_union_group_by.q.out
@@ -160,6 +160,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x_n3
+ filterExpr: ((date < '2014-09-02') and (u <> 0L)) (type: boolean)
Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: ((date < '2014-09-02') and (u <> 0L)) (type: boolean)
@@ -186,6 +187,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: v_n15
+ filterExpr: t is not null (type: boolean)
Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: t is not null (type: boolean)
@@ -201,6 +203,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: y_n1
+ filterExpr: ((date < '2014-09-02') and (u <> 0L)) (type: boolean)
Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: ((date < '2014-09-02') and (u <> 0L)) (type: boolean)
@@ -227,6 +230,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: z_n0
+ filterExpr: ((date < '2014-09-02') and (u <> 0L)) (type: boolean)
Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: ((date < '2014-09-02') and (u <> 0L)) (type: boolean)
@@ -253,6 +257,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: x_n3
+ filterExpr: (t is not null and (date >= '2014-03-04') and (date < '2014-09-03') and (u <> 0L)) (type: boolean)
Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: PARTIAL
Filter Operator
predicate: ((date < '2014-09-03') and (date >= '2014-03-04') and (u <> 0L) and t is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out
index 5c12e9a..dcc7e9d 100644
--- a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out
@@ -31,6 +31,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -51,6 +52,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -163,6 +165,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -182,6 +185,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -291,6 +295,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -311,6 +316,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -442,6 +448,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -462,6 +469,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -577,6 +585,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -596,6 +605,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
@@ -708,6 +718,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: cint BETWEEN 1000000 AND 3000000 (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: cint BETWEEN 1000000 AND 3000000 (type: boolean)
@@ -728,6 +739,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (cint BETWEEN 1000000 AND 3000000 and cbigint is not null) (type: boolean)
Statistics: Num rows: ###Masked### Data size: ###Masked### Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cbigint is not null and cint BETWEEN 1000000 AND 3000000) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
index 3373fc25..55c581f 100644
--- a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
@@ -39,6 +39,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (csmallint < 100S) (type: boolean)
Statistics: Num rows: 12288 Data size: 3093170 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (csmallint < 100S) (type: boolean)
@@ -59,6 +60,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)
@@ -78,6 +80,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)
@@ -230,6 +233,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (csmallint < 100S) (type: boolean)
Statistics: Num rows: 12288 Data size: 3093170 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (csmallint < 100S) (type: boolean)
@@ -250,6 +254,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)
@@ -269,6 +274,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)
@@ -421,6 +427,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: a
+ filterExpr: (csmallint < 100S) (type: boolean)
Statistics: Num rows: 12288 Data size: 3093170 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (csmallint < 100S) (type: boolean)
@@ -441,6 +448,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)
@@ -460,6 +468,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)