http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out b/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out index feadbcd..64b1067 100644 --- a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out +++ b/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out @@ -82,8 +82,14 @@ POSTHOOK: Lineage: part_null_n0.p_type SCRIPT [] Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where p_size > (select avg(p_size) from part_null_n0) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size > (select avg(p_size) from part_null_n0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -214,8 +220,14 @@ POSTHOOK: Input: default@tempty_n0 Warning: Shuffle Join MERGEJOIN[18][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where p_size > (select * from tempty_n0) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@tempty_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size > (select * from tempty_n0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@tempty_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -328,8 +340,14 @@ STAGE PLANS: Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where p_name = (select p_name from part_null_n0 where p_name is null) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_name = (select p_name from part_null_n0 where p_name is null) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -449,8 +467,14 @@ Warning: Shuffle Join MERGEJOIN[33][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select * from part where (select i from tnull_n0 limit 1) is null PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@tnull_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where (select i from tnull_n0 limit 1) is null POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@tnull_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -653,8 +677,14 @@ POSTHOOK: Input: default@tnull_n0 Warning: Shuffle Join MERGEJOIN[15][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where (select max(p_name) from part_null_n0) is not null PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where (select max(p_name) from part_null_n0) is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -785,8 +815,12 @@ Warning: Shuffle Join MERGEJOIN[23][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select * from part where p_size between (select min(p_size) from part) and (select avg(p_size) from part) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size between (select min(p_size) from part) and (select avg(p_size) from part) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -951,10 +985,14 @@ PREHOOK: query: explain select p_mfgr, p_name, p_size from part where part.p_size > (select first_value(p_size) over(partition by p_mfgr order by p_size) as fv from part order by fv limit 1) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size from part where part.p_size > (select first_value(p_size) over(partition by p_mfgr order by p_size) as fv from part order by fv limit 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1182,8 +1220,12 @@ Manufacturer#5 almond azure blanched chiffon midnight 23 Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where (p_partkey*p_size) <> (select min(p_partkey) from part) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where (p_partkey*p_size) <> (select min(p_partkey) from part) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1311,8 +1353,12 @@ POSTHOOK: Input: default@part 90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl PREHOOK: query: explain select count(*) as c from part as e where p_size + 100 < (select max(p_partkey) from part where p_name = e.p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) as c from part as e where p_size + 100 < (select max(p_partkey) from part where p_name = e.p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1446,8 +1492,12 @@ POSTHOOK: Input: default@part 26 PREHOOK: query: explain select count(*) as c from part as e where 100 < (select max(p_partkey) from part where p_name = e.p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) as c from part as e where 100 < (select max(p_partkey) from part where p_name = e.p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1578,8 +1628,14 @@ POSTHOOK: Input: default@part 26 PREHOOK: query: explain select * from part where p_size > (select avg(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size > (select avg(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1700,8 +1756,14 @@ POSTHOOK: Input: default@part_null_n0 Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select * from part where p_size BETWEEN (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND (select max(p_size) from part_null_n0) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size BETWEEN (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND (select max(p_size) from part_null_n0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1895,8 +1957,14 @@ POSTHOOK: Input: default@part_null_n0 Warning: Shuffle Join MERGEJOIN[39][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select * from part where p_size >= (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND p_retailprice <= (select max(p_retailprice) from part_null_n0) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size >= (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND p_retailprice <= (select max(p_retailprice) from part_null_n0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2093,8 +2161,12 @@ POSTHOOK: Input: default@part_null_n0 Warning: Shuffle Join MERGEJOIN[47][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where p_brand <> (select min(p_brand) from part ) AND p_size IN (select (p_size) from part p where p.p_type = part.p_type ) AND p_size <> 340 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_brand <> (select min(p_brand) from part ) AND p_size IN (select (p_size) from part p where p.p_type = part.p_type ) AND p_size <> 340 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2262,8 +2334,12 @@ POSTHOOK: Input: default@part 90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl PREHOOK: query: explain select * from part where p_size <> (select count(p_name) from part p where p.p_size = part.p_size AND part.p_partkey= p.p_partkey ) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size <> (select count(p_name) from part p where p.p_size = part.p_size AND part.p_partkey= p.p_partkey ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2403,8 +2479,12 @@ Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 4' is a cross product PREHOOK: query: explain select key, count(*) from src where value <> (select max(value) from src) group by key having count(*) > (select count(*) from src s1 where s1.key = '90' group by s1.key ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from src where value <> (select max(value) from src) group by key having count(*) > (select count(*) from src s1 where s1.key = '90' group by s1.key ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2604,8 +2684,12 @@ POSTHOOK: Input: default@src Warning: Shuffle Join MERGEJOIN[17][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select sum(p_retailprice) from part group by p_type having sum(p_retailprice) > (select max(pp.p_retailprice) from part pp) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select sum(p_retailprice) from part group by p_type having sum(p_retailprice) > (select max(pp.p_retailprice) from part pp) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2736,8 +2820,12 @@ POSTHOOK: Input: default@part Warning: Shuffle Join MERGEJOIN[76][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where p_size > (select count(p_name) from part INTERSECT select count(p_brand) from part) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size > (select count(p_name) from part INTERSECT select count(p_brand) from part) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3069,8 +3157,12 @@ POSTHOOK: Input: default@part 86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully PREHOOK: query: explain select p_partkey from part where p_name like (select max(p.p_name) from part p left outer join part pp on p.p_type = pp.p_type where pp.p_size = part.p_size) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_partkey from part where p_name like (select max(p.p_name) from part p left outer join part pp on p.p_type = pp.p_type where pp.p_size = part.p_size) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3251,8 +3343,14 @@ POSTHOOK: Input: default@part Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part_null_n0 where p_name NOT LIKE (select min(p_name) from part_null_n0) AND p_brand NOT IN (select p_name from part) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part_null_n0 where p_name NOT LIKE (select min(p_name) from part_null_n0) AND p_brand NOT IN (select p_name from part) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3467,8 +3565,14 @@ POSTHOOK: Input: default@part_null_n0 Warning: Shuffle Join MERGEJOIN[58][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part_null_n0 where p_brand NOT IN (select p_name from part) AND p_name NOT LIKE (select min(p_name) from part_null_n0 pp where part_null_n0.p_type = pp.p_type) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part_null_n0 where p_brand NOT IN (select p_name from part) AND p_name NOT LIKE (select min(p_name) from part_null_n0 pp where part_null_n0.p_type = pp.p_type) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3696,11 +3800,15 @@ from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li o where li.l_linenumber = 1 and li.l_orderkey <> (select min(l_orderkey) from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select p.p_partkey, li.l_suppkey from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey where li.l_linenumber = 1 and li.l_orderkey <> (select min(l_orderkey) from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3906,11 +4014,15 @@ from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li o where li.l_linenumber = 1 and li.l_orderkey <> (select min(l_orderkey) from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select p.p_partkey, li.l_suppkey from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey where li.l_linenumber = 1 and li.l_orderkey <> (select min(l_orderkey) from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4112,8 +4224,14 @@ POSTHOOK: Input: default@lineitem 88362 871 PREHOOK: query: explain select sum(l_extendedprice) from lineitem, part where p_partkey = l_partkey and l_quantity > (select avg(l_quantity) from lineitem where l_partkey = p_partkey) PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select sum(l_extendedprice) from lineitem, part where p_partkey = l_partkey and l_quantity > (select avg(l_quantity) from lineitem where l_partkey = p_partkey) POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4273,8 +4391,14 @@ POSTHOOK: Input: default@part NULL PREHOOK: query: explain select * from part_null_n0 where p_name IN (select p_name from part where part.p_type = part_null_n0.p_type AND p_brand NOT LIKE (select min(p_brand) from part pp where part.p_type = pp.p_type)) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from part_null_n0 where p_name IN (select p_name from part where part.p_type = part_null_n0.p_type AND p_brand NOT LIKE (select min(p_brand) from part pp where part.p_type = pp.p_type)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@part_null_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4597,8 +4721,14 @@ POSTHOOK: Lineage: depts_n3.deptno SCRIPT [] POSTHOOK: Lineage: depts_n3.name SCRIPT [] PREHOOK: query: explain select * from emps_n4 where deptno <> (select count(deptno) from depts_n3 where depts_n3.name = emps_n4.name) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n3 +PREHOOK: Input: default@emps_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n4 where deptno <> (select count(deptno) from depts_n3 where depts_n3.name = emps_n4.name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n3 +POSTHOOK: Input: default@emps_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4720,8 +4850,14 @@ POSTHOOK: Input: default@emps_n4 130 Alice 40 F Vancouver 2 NULL false true 2007-01-01 PREHOOK: query: explain select * from emps_n4 where name > (select min(name) from depts_n3 where depts_n3.deptno=emps_n4.deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n3 +PREHOOK: Input: default@emps_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n4 where name > (select min(name) from depts_n3 where depts_n3.deptno=emps_n4.deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n3 +POSTHOOK: Input: default@emps_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4841,8 +4977,14 @@ POSTHOOK: Input: default@emps_n4 120 Wilma 20 F NULL 1 5 NULL true 2005-09-07 PREHOOK: query: explain select * from emps_n4 where deptno <> (select count(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3 where depts_n3.deptno = emps_n4.deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n3 +PREHOOK: Input: default@emps_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n4 where deptno <> (select count(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3 where depts_n3.deptno = emps_n4.deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n3 +POSTHOOK: Input: default@emps_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5025,8 +5167,14 @@ POSTHOOK: Input: default@emps_n4 Warning: Shuffle Join MERGEJOIN[39][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select * from emps_n4 where deptno <> (select sum(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n3 +PREHOOK: Input: default@emps_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n4 where deptno <> (select sum(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n3 +POSTHOOK: Input: default@emps_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5222,12 +5370,16 @@ from src group by key having count(*) > (select count(*) from src s1 where s1.key > '9' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from src group by key having count(*) > (select count(*) from src s1 where s1.key > '9' ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5367,6 +5519,8 @@ where b.key in (select key from src where src.key > '8') group by key, value having count(*) > (select count(*) from src s1 where s1.key > '9' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, count(*) from src b @@ -5374,6 +5528,8 @@ where b.key in (select key from src where src.key > '8') group by key, value having count(*) > (select count(*) from src s1 where s1.key > '9' ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5547,8 +5703,12 @@ POSTHOOK: Input: default@src Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from part where p_size > (select max(p_size) from part group by p_type) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size > (select max(p_size) from part group by p_type) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5709,8 +5869,12 @@ STAGE PLANS: PREHOOK: query: explain select * from part where p_size > (select max(p_size) from part p where p.p_type = part.p_type group by p_type) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size > (select max(p_size) from part p where p.p_type = part.p_type group by p_type) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5871,9 +6035,13 @@ Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reduc PREHOOK: query: explain select * from part where p_size <> (select count(p_size) from part pp where part.p_type <> pp.p_type) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select * from part where p_size <> (select count(p_size) from part pp where part.p_type <> pp.p_type) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6086,8 +6254,12 @@ POSTHOOK: Lineage: t_n11.j SCRIPT [] Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product PREHOOK: query: explain select * from t_n11 where 0 = (select count(*) from t_n11 tt_n11 where tt_n11.j <> t_n11.i) PREHOOK: type: QUERY +PREHOOK: Input: default@t_n11 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t_n11 where 0 = (select count(*) from t_n11 tt_n11 where tt_n11.j <> t_n11.i) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t_n11 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6256,8 +6428,12 @@ POSTHOOK: Input: default@t_n11 Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select * from t_n11 where 0 = (select avg(tt_n11.i) from t_n11 tt_n11 where tt_n11.j <> t_n11.i) PREHOOK: type: QUERY +PREHOOK: Input: default@t_n11 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t_n11 where 0 = (select avg(tt_n11.i) from t_n11 tt_n11 where tt_n11.j <> t_n11.i) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t_n11 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6428,8 +6604,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tempty_n0 PREHOOK: query: explain select * from t_n11 where 0 = (select count(*) from tempty_n0 tt_n11 where t_n11.i=tt_n11.i) PREHOOK: type: QUERY +PREHOOK: Input: default@t_n11 +PREHOOK: Input: default@tempty_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t_n11 where 0 = (select count(*) from tempty_n0 tt_n11 where t_n11.i=tt_n11.i) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t_n11 +POSTHOOK: Input: default@tempty_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6548,8 +6730,14 @@ POSTHOOK: Input: default@tempty_n0 3 1 PREHOOK: query: explain select * from t_n11 where 0 = (select min(tt_n11.j) from tempty_n0 tt_n11 where t_n11.i=tt_n11.i) PREHOOK: type: QUERY +PREHOOK: Input: default@t_n11 +PREHOOK: Input: default@tempty_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t_n11 where 0 = (select min(tt_n11.j) from tempty_n0 tt_n11 where t_n11.i=tt_n11.i) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t_n11 +POSTHOOK: Input: default@tempty_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6683,9 +6871,13 @@ Warning: Shuffle Join MERGEJOIN[18][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc PREHOOK: query: explain select key, count(*) from src group by key having count(*) > (select count(*) from src s1 group by 4) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from src group by key having count(*) > (select count(*) from src s1 group by 4) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -6808,9 +7000,13 @@ Warning: Shuffle Join MERGEJOIN[20][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc PREHOOK: query: explain select key, count(*) from src group by key having count(*) > (select count(*) from src s1 where s1.key = '90' group by s1.key ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from src group by key having count(*) > (select count(*) from src s1 where s1.key = '90' group by s1.key ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 e035219..30c6d13 100644 --- a/ql/src/test/results/clientpositive/llap/subquery_select.q.out +++ b/ql/src/test/results/clientpositive/llap/subquery_select.q.out @@ -3,10 +3,14 @@ PREHOOK: query: explain SELECT p_size, p_size IN ( SELECT MAX(p_size) FROM part) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, p_size IN ( SELECT MAX(p_size) FROM part) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -187,10 +191,14 @@ PREHOOK: query: EXPLAIN SELECT p_size, p_size IN ( SELECT MAX(p_size) FROM part p where p.p_type = part.p_type) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT p_size, p_size IN ( SELECT MAX(p_size) FROM part p where p.p_type = part.p_type) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -385,10 +393,14 @@ PREHOOK: query: explain SELECT p_size, p_size NOT IN ( SELECT MAX(p_size) FROM part) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, p_size NOT IN ( SELECT MAX(p_size) FROM part) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -569,10 +581,14 @@ PREHOOK: query: EXPLAIN SELECT p_size, p_size NOT IN ( SELECT MAX(p_size) FROM part p where p.p_type = part.p_type) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT p_size, p_size NOT IN ( SELECT MAX(p_size) FROM part p where p.p_type = part.p_type) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -833,9 +849,13 @@ Warning: Shuffle Join MERGEJOIN[14][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc PREHOOK: query: explain SELECT p_size, EXISTS(SELECT p_size FROM part) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, EXISTS(SELECT p_size FROM part) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -964,9 +984,13 @@ POSTHOOK: Input: default@part PREHOOK: query: explain SELECT p_size, EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1105,9 +1129,13 @@ Warning: Shuffle Join MERGEJOIN[14][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc PREHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1236,9 +1264,13 @@ POSTHOOK: Input: default@part PREHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1375,8 +1407,12 @@ POSTHOOK: Input: default@part 45 false PREHOOK: query: explain select p_size, (select count(p_name) from part p where p.p_type = part.p_name) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_size, (select count(p_name) from part p where p.p_type = part.p_name) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1514,8 +1550,12 @@ POSTHOOK: Input: default@part 23 0 PREHOOK: query: explain select p_size, (select max(p_name) from part p where p.p_type = part.p_name) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_size, (select max(p_name) from part p where p.p_type = part.p_name) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1655,9 +1695,13 @@ Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc PREHOOK: query: explain SELECT p_size, (SELECT max(p_size) FROM part) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, (SELECT max(p_size) FROM part) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1783,6 +1827,8 @@ where b.key in where b.value = a.value and a.key > '9' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b @@ -1792,6 +1838,8 @@ where b.key in where b.value = a.value and a.key > '9' ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1954,6 +2002,8 @@ where b.key in where b.value = a.value and a.key > '9' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b @@ -1963,6 +2013,8 @@ where b.key in where b.value = a.value and a.key > '9' ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2145,8 +2197,14 @@ POSTHOOK: Lineage: tnull_n3.i EXPRESSION [] 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 +PREHOOK: Input: default@part +PREHOOK: Input: default@tnull_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select p_size, p_size IN (select i from tnull_n3) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@tnull_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2331,8 +2389,14 @@ POSTHOOK: Output: default@tempty_n3 Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select p_size, (select count(*) from tempty_n3) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@tempty_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select p_size, (select count(*) from tempty_n3) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@tempty_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2456,8 +2520,14 @@ POSTHOOK: Input: default@tempty_n3 Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select p_size, (select max(i) from tempty_n3) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Input: default@tempty_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select p_size, (select max(i) from tempty_n3) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Input: default@tempty_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2599,9 +2669,13 @@ POSTHOOK: Output: default@tnull_n3 PREHOOK: query: explain SELECT p_size, 1+(SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, 1+(SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2734,9 +2808,13 @@ POSTHOOK: Input: default@part PREHOOK: query: explain SELECT p_size, (SELECT count(p_size) FROM part p WHERE p.p_type = part.p_type) IS NULL from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, (SELECT count(p_size) FROM part p WHERE p.p_type = part.p_type) IS NULL from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2870,8 +2948,12 @@ Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select p_type, (select p_size from part order by p_size limit 1) = 1 from part order by p_type PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_type, (select p_size from part order by p_size limit 1) = 1 from part order by p_type POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3069,11 +3151,15 @@ PREHOOK: query: EXPLAIN SELECT p_size, p_size IN ( p_name IN (SELECT min(p_name) from part) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: 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) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3350,9 +3436,13 @@ POSTHOOK: Input: default@part PREHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type) FROM part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, NOT EXISTS(SELECT p_size FROM part pp where pp.p_type = part.p_type) FROM part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3493,10 +3583,14 @@ PREHOOK: query: explain select p_size, (p_size IN (select (select max(p_size) from part) as sb from part order by sb limit 1)) = true from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_size, (p_size IN (select (select max(p_size) from part) as sb from part order by sb limit 1)) = true from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -3742,6 +3836,8 @@ PREHOOK: query: explain select case when (select count(*) where p_partkey between 10000 and 20000) end sq from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select case when (select count(*) from part where p_size between 1 and 20) > 409437 @@ -3753,6 +3849,8 @@ POSTHOOK: query: explain select case when (select count(*) where p_partkey between 10000 and 20000) end sq from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4005,8 +4103,12 @@ POSTHOOK: Input: default@part Warning: Shuffle Join MERGEJOIN[17][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product PREHOOK: query: explain select max(p_size) > ( select count(*)-1 from part) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select max(p_size) > ( select count(*)-1 from part) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4130,9 +4232,13 @@ Warning: Shuffle Join MERGEJOIN[48][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reduc 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 +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: 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 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4336,10 +4442,14 @@ PREHOOK: query: explain select (select max(p_size) from part), (select min(p_siz (select avg(p_size) from part), (select sum(p_size) from part) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select (select max(p_size) from part), (select min(p_size) from part), (select avg(p_size) from part), (select sum(p_size) from part) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4591,10 +4701,14 @@ 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 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: 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 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -4766,12 +4880,16 @@ PREHOOK: query: explain select t1.p_size, group by a1.p_partkey) > 0) from part t1 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: 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 group by a1.p_partkey) > 0) from part t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5065,6 +5183,8 @@ PREHOOK: query: explain select t1.p_size, group by a1.p_partkey) > 0) from part t1 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: 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 @@ -5072,6 +5192,8 @@ POSTHOOK: query: explain select t1.p_size, group by a1.p_partkey) > 0) from part t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -5446,8 +5568,12 @@ POSTHOOK: Input: default@part 18 1 28 PREHOOK: query: explain SELECT p_size, exp((SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type)) from part PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain SELECT p_size, exp((SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type)) from part POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 4a58149..a0bc64e 100644 --- a/ql/src/test/results/clientpositive/llap/subquery_views.q.out +++ b/ql/src/test/results/clientpositive/llap/subquery_views.q.out @@ -89,10 +89,16 @@ PREHOOK: query: explain select * from cv2 where cv2.key in (select key from cv2 c where c.key < '11') PREHOOK: type: QUERY +PREHOOK: Input: default@cv2 +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from cv2 where cv2.key in (select key from cv2 c where c.key < '11') POSTHOOK: type: QUERY +POSTHOOK: Input: default@cv2 +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/sysdb.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/sysdb.q.out b/ql/src/test/results/clientpositive/llap/sysdb.q.out index 172be1c..b3be3f7 100644 --- a/ql/src/test/results/clientpositive/llap/sysdb.q.out +++ b/ql/src/test/results/clientpositive/llap/sysdb.q.out @@ -3842,9 +3842,13 @@ POSTHOOK: Input: sys@role_map PREHOOK: query: explain vectorization detail select count(*) from sds PREHOOK: type: QUERY +PREHOOK: Input: sys@sds +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from sds POSTHOOK: type: QUERY +POSTHOOK: Input: sys@sds +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -4227,8 +4231,12 @@ num_falses bigint from deserializer last_analyzed bigint from deserializer PREHOOK: query: explain select max(num_distincts) from sys.tab_col_stats PREHOOK: type: QUERY +PREHOOK: Input: sys@tab_col_stats +#### A masked pattern was here #### POSTHOOK: query: explain select max(num_distincts) from sys.tab_col_stats POSTHOOK: type: QUERY +POSTHOOK: Input: sys@tab_col_stats +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 80972b4..45be750 100644 --- a/ql/src/test/results/clientpositive/llap/temp_table.q.out +++ b/ql/src/test/results/clientpositive/llap/temp_table.q.out @@ -1,7 +1,13 @@ PREHOOK: query: EXPLAIN CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@foo POSTHOOK: query: EXPLAIN CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@foo STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -74,8 +80,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@foo PREHOOK: query: EXPLAIN CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@bar POSTHOOK: query: EXPLAIN CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@bar STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -190,8 +202,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from foo order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: explain select * from foo order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@foo +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -265,8 +281,14 @@ POSTHOOK: Input: default@foo 116 val_116 PREHOOK: query: explain select * from (select * from foo union all select * from bar) u order by key limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@bar +PREHOOK: Input: default@foo +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from foo union all select * from bar) u order by key limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@bar +POSTHOOK: Input: default@foo +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 5766ba2..089d226 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 @@ -67,8 +67,18 @@ p int p int PREHOOK: query: explain select test_n1.key, test_n1.value from test_n1 join test1 on (test_n1.key = test1.key) order by test_n1.key PREHOOK: type: QUERY +PREHOOK: Input: default@test1 +PREHOOK: Input: default@test_n1 +PREHOOK: Input: default@test_n1@p=1 +PREHOOK: Input: default@test_n1@p=2 +#### A masked pattern was here #### POSTHOOK: query: explain select test_n1.key, test_n1.value from test_n1 join test1 on (test_n1.key = test1.key) order by test_n1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1 +POSTHOOK: Input: default@test_n1 +POSTHOOK: Input: default@test_n1@p=1 +POSTHOOK: Input: default@test_n1@p=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_dml.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_dml.q.out b/ql/src/test/results/clientpositive/llap/tez_dml.q.out index 993d57b..67d4bf3 100644 --- a/ql/src/test/results/clientpositive/llap/tez_dml.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_dml.q.out @@ -1,7 +1,13 @@ PREHOOK: query: EXPLAIN CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_src POSTHOOK: query: EXPLAIN CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tmp_src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -432,8 +438,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tmp_src_part PREHOOK: query: EXPLAIN INSERT INTO TABLE tmp_src_part PARTITION (d) SELECT * FROM tmp_src PREHOOK: type: QUERY +PREHOOK: Input: default@tmp_src +PREHOOK: Output: default@tmp_src_part POSTHOOK: query: EXPLAIN INSERT INTO TABLE tmp_src_part PARTITION (d) SELECT * FROM tmp_src POSTHOOK: type: QUERY +POSTHOOK: Input: default@tmp_src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -892,11 +901,17 @@ FROM src INSERT INTO TABLE even SELECT key, value WHERE key % 2 = 0 INSERT INTO TABLE odd SELECT key, value WHERE key % 2 = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@even +PREHOOK: Output: default@odd POSTHOOK: query: EXPLAIN FROM src INSERT INTO TABLE even SELECT key, value WHERE key % 2 = 0 INSERT INTO TABLE odd SELECT key, value WHERE key % 2 = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@even +POSTHOOK: Output: default@odd STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 2bc1d3e..828d25d 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 @@ -6,6 +6,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select * @@ -14,6 +16,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -141,6 +145,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) @@ -148,6 +154,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -268,6 +276,8 @@ where group by a.csmallint order by a.csmallint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select a.csmallint, count(*) c1 @@ -277,6 +287,8 @@ where group by a.csmallint order by a.csmallint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -422,6 +434,8 @@ where a.cint between 1000000 and 3000000 order by a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select * from alltypesorc a left outer join alltypesorc b on a.cint = b.cint and a.csmallint != a.cint @@ -429,6 +443,8 @@ where a.cint between 1000000 and 3000000 order by a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -564,6 +580,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select * @@ -572,6 +590,8 @@ where a.cint between 1000000 and 3000000 and b.cbigint is not null order by a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -703,6 +723,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) @@ -710,6 +732,8 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -834,6 +858,8 @@ where group by a.csmallint order by cs PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select a.csmallint cs, count(*) c1 @@ -843,6 +869,8 @@ where group by a.csmallint order by cs POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 3f74be1..37970ab 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 @@ -10,6 +10,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* @@ -22,6 +25,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -204,6 +210,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* @@ -216,6 +225,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -398,6 +410,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* @@ -410,6 +425,9 @@ where and (a.csmallint < 100) order by a.csmallint, a.ctinyint, a.cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_3.q.out b/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_3.q.out index 07f13bc..6b801fb 100644 --- a/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_3.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_3.q.out @@ -4,12 +4,18 @@ from alltypesorc a left outer join src b on a.cint = cast(b.key as int) and (a.cint < 100) limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* from alltypesorc a left outer join src b on a.cint = cast(b.key as int) and (a.cint < 100) limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -111,12 +117,18 @@ from alltypesorc a left outer join src b on a.cint = cast(b.key as int) and (a.cint < 100) limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* from alltypesorc a left outer join src b on a.cint = cast(b.key as int) and (a.cint < 100) limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -222,12 +234,18 @@ from alltypesorc a left outer join src b on a.cint = cast(b.key as int) limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select a.* from alltypesorc a left outer join src b on a.cint = cast(b.key as int) limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/tez_fixed_bucket_pruning.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_fixed_bucket_pruning.q.out b/ql/src/test/results/clientpositive/llap/tez_fixed_bucket_pruning.q.out index 0aed74e..9d16a8d 100644 --- a/ql/src/test/results/clientpositive/llap/tez_fixed_bucket_pruning.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_fixed_bucket_pruning.q.out @@ -439,6 +439,11 @@ where DW.PROJECT_OBJECT_ID =7147200 order by DW.PROJECT_OBJECT_ID, PLAN_KEY, PROJECT_KEY limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_datajoin_1_s2_2018022300104_1 +PREHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_dw_stg_2018022300104_1 +PREHOOK: Input: default@l3_clarity__l3_snap_number_2018022300104 +PREHOOK: Input: default@l3_monthly_dw_dimplan +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT DW.PROJECT_OBJECT_ID, S1.PLAN_KEY as PLAN_KEY, S2.PROJECT_KEY AS PROJECT_KEY FROM l3_clarity__L3_SNAP_NUMBER_2018022300104 snap inner join @@ -453,6 +458,11 @@ where DW.PROJECT_OBJECT_ID =7147200 order by DW.PROJECT_OBJECT_ID, PLAN_KEY, PROJECT_KEY limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_datajoin_1_s2_2018022300104_1 +POSTHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_dw_stg_2018022300104_1 +POSTHOOK: Input: default@l3_clarity__l3_snap_number_2018022300104 +POSTHOOK: Input: default@l3_monthly_dw_dimplan +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(7147200 AS BIGINT) AS `project_object_id`, `t9`.`plan_key`, `t9`.`project_key` FROM (SELECT `t4`.`plan_key`, `t6`.`project_key` FROM (SELECT `t3`.`l3_snapshot_number`, `t2`.`plan_detail_object_id`, `t2`.`project_object_id`, `t0`.`idp_data_date`, `t0`.`l3_snapshot_number` AS `l3_snapshot_number0`, `t0`.`plan_key`, `t0`.`finplan_detail_object_id` @@ -938,6 +948,11 @@ where DW.PROJECT_OBJECT_ID =7147200 order by DW.PROJECT_OBJECT_ID, PLAN_KEY, PROJECT_KEY limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_datajoin_1_s2_2018022300104_1 +PREHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_dw_stg_2018022300104_1 +PREHOOK: Input: default@l3_clarity__l3_snap_number_2018022300104 +PREHOOK: Input: default@l3_monthly_dw_dimplan +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT DW.PROJECT_OBJECT_ID, S1.PLAN_KEY as PLAN_KEY, S2.PROJECT_KEY AS PROJECT_KEY FROM l3_clarity__L3_SNAP_NUMBER_2018022300104 snap inner join @@ -952,6 +967,11 @@ where DW.PROJECT_OBJECT_ID =7147200 order by DW.PROJECT_OBJECT_ID, PLAN_KEY, PROJECT_KEY limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_datajoin_1_s2_2018022300104_1 +POSTHOOK: Input: default@l3_clarity__l3_monthly_dw_factplan_dw_stg_2018022300104_1 +POSTHOOK: Input: default@l3_clarity__l3_snap_number_2018022300104 +POSTHOOK: Input: default@l3_monthly_dw_dimplan +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(7147200 AS BIGINT) AS `project_object_id`, `t9`.`plan_key`, `t9`.`project_key` FROM (SELECT `t4`.`plan_key`, `t6`.`project_key` FROM (SELECT `t3`.`l3_snapshot_number`, `t2`.`plan_detail_object_id`, `t2`.`project_object_id`, `t0`.`idp_data_date`, `t0`.`l3_snapshot_number` AS `l3_snapshot_number0`, `t0`.`plan_key`, `t0`.`finplan_detail_object_id` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 d346f04..8f4f055 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 @@ -1842,6 +1842,392 @@ Stage-1 INPUT COUNTERS: RAW_INPUT_SPLITS_Map_1: 148 PREHOOK: query: explain select sum(hash(*)) from testpart t1 join testpart1 t2 on t1.v = t2.v PREHOOK: type: QUERY +PREHOOK: Input: default@testpart +PREHOOK: Input: default@testpart1 +PREHOOK: Input: default@testpart1@v=val_0 +PREHOOK: Input: default@testpart1@v=val_10 +PREHOOK: Input: default@testpart1@v=val_100 +PREHOOK: Input: default@testpart1@v=val_103 +PREHOOK: Input: default@testpart1@v=val_104 +PREHOOK: Input: default@testpart1@v=val_105 +PREHOOK: Input: default@testpart1@v=val_11 +PREHOOK: Input: default@testpart1@v=val_111 +PREHOOK: Input: default@testpart1@v=val_113 +PREHOOK: Input: default@testpart1@v=val_114 +PREHOOK: Input: default@testpart1@v=val_116 +PREHOOK: Input: default@testpart1@v=val_118 +PREHOOK: Input: default@testpart1@v=val_119 +PREHOOK: Input: default@testpart1@v=val_12 +PREHOOK: Input: default@testpart1@v=val_120 +PREHOOK: Input: default@testpart1@v=val_125 +PREHOOK: Input: default@testpart1@v=val_126 +PREHOOK: Input: default@testpart1@v=val_128 +PREHOOK: Input: default@testpart1@v=val_129 +PREHOOK: Input: default@testpart1@v=val_131 +PREHOOK: Input: default@testpart1@v=val_133 +PREHOOK: Input: default@testpart1@v=val_134 +PREHOOK: Input: default@testpart1@v=val_136 +PREHOOK: Input: default@testpart1@v=val_137 +PREHOOK: Input: default@testpart1@v=val_138 +PREHOOK: Input: default@testpart1@v=val_143 +PREHOOK: Input: default@testpart1@v=val_145 +PREHOOK: Input: default@testpart1@v=val_146 +PREHOOK: Input: default@testpart1@v=val_149 +PREHOOK: Input: default@testpart1@v=val_15 +PREHOOK: Input: default@testpart1@v=val_150 +PREHOOK: Input: default@testpart1@v=val_152 +PREHOOK: Input: default@testpart1@v=val_153 +PREHOOK: Input: default@testpart1@v=val_155 +PREHOOK: Input: default@testpart1@v=val_156 +PREHOOK: Input: default@testpart1@v=val_157 +PREHOOK: Input: default@testpart1@v=val_158 +PREHOOK: Input: default@testpart1@v=val_160 +PREHOOK: Input: default@testpart1@v=val_162 +PREHOOK: Input: default@testpart1@v=val_163 +PREHOOK: Input: default@testpart1@v=val_164 +PREHOOK: Input: default@testpart1@v=val_165 +PREHOOK: Input: default@testpart1@v=val_166 +PREHOOK: Input: default@testpart1@v=val_167 +PREHOOK: Input: default@testpart1@v=val_168 +PREHOOK: Input: default@testpart1@v=val_169 +PREHOOK: Input: default@testpart1@v=val_17 +PREHOOK: Input: default@testpart1@v=val_170 +PREHOOK: Input: default@testpart1@v=val_172 +PREHOOK: Input: default@testpart1@v=val_174 +PREHOOK: Input: default@testpart1@v=val_175 +PREHOOK: Input: default@testpart1@v=val_176 +PREHOOK: Input: default@testpart1@v=val_177 +PREHOOK: Input: default@testpart1@v=val_178 +PREHOOK: Input: default@testpart1@v=val_179 +PREHOOK: Input: default@testpart1@v=val_18 +PREHOOK: Input: default@testpart1@v=val_180 +PREHOOK: Input: default@testpart1@v=val_181 +PREHOOK: Input: default@testpart1@v=val_183 +PREHOOK: Input: default@testpart1@v=val_186 +PREHOOK: Input: default@testpart1@v=val_187 +PREHOOK: Input: default@testpart1@v=val_189 +PREHOOK: Input: default@testpart1@v=val_19 +PREHOOK: Input: default@testpart1@v=val_190 +PREHOOK: Input: default@testpart1@v=val_191 +PREHOOK: Input: default@testpart1@v=val_192 +PREHOOK: Input: default@testpart1@v=val_193 +PREHOOK: Input: default@testpart1@v=val_194 +PREHOOK: Input: default@testpart1@v=val_195 +PREHOOK: Input: default@testpart1@v=val_196 +PREHOOK: Input: default@testpart1@v=val_197 +PREHOOK: Input: default@testpart1@v=val_199 +PREHOOK: Input: default@testpart1@v=val_2 +PREHOOK: Input: default@testpart1@v=val_20 +PREHOOK: Input: default@testpart@v=val_0 +PREHOOK: Input: default@testpart@v=val_10 +PREHOOK: Input: default@testpart@v=val_100 +PREHOOK: Input: default@testpart@v=val_103 +PREHOOK: Input: default@testpart@v=val_104 +PREHOOK: Input: default@testpart@v=val_105 +PREHOOK: Input: default@testpart@v=val_11 +PREHOOK: Input: default@testpart@v=val_111 +PREHOOK: Input: default@testpart@v=val_113 +PREHOOK: Input: default@testpart@v=val_114 +PREHOOK: Input: default@testpart@v=val_116 +PREHOOK: Input: default@testpart@v=val_118 +PREHOOK: Input: default@testpart@v=val_119 +PREHOOK: Input: default@testpart@v=val_12 +PREHOOK: Input: default@testpart@v=val_120 +PREHOOK: Input: default@testpart@v=val_125 +PREHOOK: Input: default@testpart@v=val_126 +PREHOOK: Input: default@testpart@v=val_128 +PREHOOK: Input: default@testpart@v=val_129 +PREHOOK: Input: default@testpart@v=val_131 +PREHOOK: Input: default@testpart@v=val_133 +PREHOOK: Input: default@testpart@v=val_134 +PREHOOK: Input: default@testpart@v=val_136 +PREHOOK: Input: default@testpart@v=val_137 +PREHOOK: Input: default@testpart@v=val_138 +PREHOOK: Input: default@testpart@v=val_143 +PREHOOK: Input: default@testpart@v=val_145 +PREHOOK: Input: default@testpart@v=val_146 +PREHOOK: Input: default@testpart@v=val_149 +PREHOOK: Input: default@testpart@v=val_15 +PREHOOK: Input: default@testpart@v=val_150 +PREHOOK: Input: default@testpart@v=val_152 +PREHOOK: Input: default@testpart@v=val_153 +PREHOOK: Input: default@testpart@v=val_155 +PREHOOK: Input: default@testpart@v=val_156 +PREHOOK: Input: default@testpart@v=val_157 +PREHOOK: Input: default@testpart@v=val_158 +PREHOOK: Input: default@testpart@v=val_160 +PREHOOK: Input: default@testpart@v=val_162 +PREHOOK: Input: default@testpart@v=val_163 +PREHOOK: Input: default@testpart@v=val_164 +PREHOOK: Input: default@testpart@v=val_165 +PREHOOK: Input: default@testpart@v=val_166 +PREHOOK: Input: default@testpart@v=val_167 +PREHOOK: Input: default@testpart@v=val_168 +PREHOOK: Input: default@testpart@v=val_169 +PREHOOK: Input: default@testpart@v=val_17 +PREHOOK: Input: default@testpart@v=val_170 +PREHOOK: Input: default@testpart@v=val_172 +PREHOOK: Input: default@testpart@v=val_174 +PREHOOK: Input: default@testpart@v=val_175 +PREHOOK: Input: default@testpart@v=val_176 +PREHOOK: Input: default@testpart@v=val_177 +PREHOOK: Input: default@testpart@v=val_178 +PREHOOK: Input: default@testpart@v=val_179 +PREHOOK: Input: default@testpart@v=val_18 +PREHOOK: Input: default@testpart@v=val_180 +PREHOOK: Input: default@testpart@v=val_181 +PREHOOK: Input: default@testpart@v=val_183 +PREHOOK: Input: default@testpart@v=val_186 +PREHOOK: Input: default@testpart@v=val_187 +PREHOOK: Input: default@testpart@v=val_189 +PREHOOK: Input: default@testpart@v=val_19 +PREHOOK: Input: default@testpart@v=val_190 +PREHOOK: Input: default@testpart@v=val_191 +PREHOOK: Input: default@testpart@v=val_192 +PREHOOK: Input: default@testpart@v=val_193 +PREHOOK: Input: default@testpart@v=val_194 +PREHOOK: Input: default@testpart@v=val_195 +PREHOOK: Input: default@testpart@v=val_196 +PREHOOK: Input: default@testpart@v=val_197 +PREHOOK: Input: default@testpart@v=val_199 +PREHOOK: Input: default@testpart@v=val_2 +PREHOOK: Input: default@testpart@v=val_20 +PREHOOK: Input: default@testpart@v=val_200 +PREHOOK: Input: default@testpart@v=val_201 +PREHOOK: Input: default@testpart@v=val_202 +PREHOOK: Input: default@testpart@v=val_203 +PREHOOK: Input: default@testpart@v=val_205 +PREHOOK: Input: default@testpart@v=val_207 +PREHOOK: Input: default@testpart@v=val_208 +PREHOOK: Input: default@testpart@v=val_209 +PREHOOK: Input: default@testpart@v=val_213 +PREHOOK: Input: default@testpart@v=val_214 +PREHOOK: Input: default@testpart@v=val_216 +PREHOOK: Input: default@testpart@v=val_217 +PREHOOK: Input: default@testpart@v=val_218 +PREHOOK: Input: default@testpart@v=val_219 +PREHOOK: Input: default@testpart@v=val_221 +PREHOOK: Input: default@testpart@v=val_222 +PREHOOK: Input: default@testpart@v=val_223 +PREHOOK: Input: default@testpart@v=val_224 +PREHOOK: Input: default@testpart@v=val_226 +PREHOOK: Input: default@testpart@v=val_228 +PREHOOK: Input: default@testpart@v=val_229 +PREHOOK: Input: default@testpart@v=val_230 +PREHOOK: Input: default@testpart@v=val_233 +PREHOOK: Input: default@testpart@v=val_235 +PREHOOK: Input: default@testpart@v=val_237 +PREHOOK: Input: default@testpart@v=val_238 +PREHOOK: Input: default@testpart@v=val_239 +PREHOOK: Input: default@testpart@v=val_24 +PREHOOK: Input: default@testpart@v=val_241 +PREHOOK: Input: default@testpart@v=val_242 +PREHOOK: Input: default@testpart@v=val_244 +PREHOOK: Input: default@testpart@v=val_247 +PREHOOK: Input: default@testpart@v=val_248 +PREHOOK: Input: default@testpart@v=val_249 +PREHOOK: Input: default@testpart@v=val_252 +PREHOOK: Input: default@testpart@v=val_255 +PREHOOK: Input: default@testpart@v=val_256 +PREHOOK: Input: default@testpart@v=val_257 +PREHOOK: Input: default@testpart@v=val_258 +PREHOOK: Input: default@testpart@v=val_26 +PREHOOK: Input: default@testpart@v=val_260 +PREHOOK: Input: default@testpart@v=val_262 +PREHOOK: Input: default@testpart@v=val_263 +PREHOOK: Input: default@testpart@v=val_265 +PREHOOK: Input: default@testpart@v=val_266 +PREHOOK: Input: default@testpart@v=val_27 +PREHOOK: Input: default@testpart@v=val_272 +PREHOOK: Input: default@testpart@v=val_273 +PREHOOK: Input: default@testpart@v=val_274 +PREHOOK: Input: default@testpart@v=val_275 +PREHOOK: Input: default@testpart@v=val_277 +PREHOOK: Input: default@testpart@v=val_278 +PREHOOK: Input: default@testpart@v=val_28 +PREHOOK: Input: default@testpart@v=val_280 +PREHOOK: Input: default@testpart@v=val_281 +PREHOOK: Input: default@testpart@v=val_282 +PREHOOK: Input: default@testpart@v=val_283 +PREHOOK: Input: default@testpart@v=val_284 +PREHOOK: Input: default@testpart@v=val_285 +PREHOOK: Input: default@testpart@v=val_286 +PREHOOK: Input: default@testpart@v=val_287 +PREHOOK: Input: default@testpart@v=val_288 +PREHOOK: Input: default@testpart@v=val_289 +PREHOOK: Input: default@testpart@v=val_291 +PREHOOK: Input: default@testpart@v=val_292 +PREHOOK: Input: default@testpart@v=val_296 +PREHOOK: Input: default@testpart@v=val_298 +PREHOOK: Input: default@testpart@v=val_30 +PREHOOK: Input: default@testpart@v=val_302 +PREHOOK: Input: default@testpart@v=val_305 +PREHOOK: Input: default@testpart@v=val_306 +PREHOOK: Input: default@testpart@v=val_307 +PREHOOK: Input: default@testpart@v=val_308 +PREHOOK: Input: default@testpart@v=val_309 +PREHOOK: Input: default@testpart@v=val_310 +PREHOOK: Input: default@testpart@v=val_311 +PREHOOK: Input: default@testpart@v=val_315 +PREHOOK: Input: default@testpart@v=val_316 +PREHOOK: Input: default@testpart@v=val_317 +PREHOOK: Input: default@testpart@v=val_318 +PREHOOK: Input: default@testpart@v=val_321 +PREHOOK: Input: default@testpart@v=val_322 +PREHOOK: Input: default@testpart@v=val_323 +PREHOOK: Input: default@testpart@v=val_325 +PREHOOK: Input: default@testpart@v=val_327 +PREHOOK: Input: default@testpart@v=val_33 +PREHOOK: Input: default@testpart@v=val_331 +PREHOOK: Input: default@testpart@v=val_332 +PREHOOK: Input: default@testpart@v=val_333 +PREHOOK: Input: default@testpart@v=val_335 +PREHOOK: Input: default@testpart@v=val_336 +PREHOOK: Input: default@testpart@v=val_338 +PREHOOK: Input: default@testpart@v=val_339 +PREHOOK: Input: default@testpart@v=val_34 +PREHOOK: Input: default@testpart@v=val_341 +PREHOOK: Input: default@testpart@v=val_342 +PREHOOK: Input: default@testpart@v=val_344 +PREHOOK: Input: default@testpart@v=val_345 +PREHOOK: Input: default@testpart@v=val_348 +PREHOOK: Input: default@testpart@v=val_35 +PREHOOK: Input: default@testpart@v=val_351 +PREHOOK: Input: default@testpart@v=val_353 +PREHOOK: Input: default@testpart@v=val_356 +PREHOOK: Input: default@testpart@v=val_360 +PREHOOK: Input: default@testpart@v=val_362 +PREHOOK: Input: default@testpart@v=val_364 +PREHOOK: Input: default@testpart@v=val_365 +PREHOOK: Input: default@testpart@v=val_366 +PREHOOK: Input: default@testpart@v=val_367 +PREHOOK: Input: default@testpart@v=val_368 +PREHOOK: Input: default@testpart@v=val_369 +PREHOOK: Input: default@testpart@v=val_37 +PREHOOK: Input: default@testpart@v=val_373 +PREHOOK: Input: default@testpart@v=val_374 +PREHOOK: Input: default@testpart@v=val_375 +PREHOOK: Input: default@testpart@v=val_377 +PREHOOK: Input: default@testpart@v=val_378 +PREHOOK: Input: default@testpart@v=val_379 +PREHOOK: Input: default@testpart@v=val_382 +PREHOOK: Input: default@testpart@v=val_384 +PREHOOK: Input: default@testpart@v=val_386 +PREHOOK: Input: default@testpart@v=val_389 +PREHOOK: Input: default@testpart@v=val_392 +PREHOOK: Input: default@testpart@v=val_393 +PREHOOK: Input: default@testpart@v=val_394 +PREHOOK: Input: default@testpart@v=val_395 +PREHOOK: Input: default@testpart@v=val_396 +PREHOOK: Input: default@testpart@v=val_397 +PREHOOK: Input: default@testpart@v=val_399 +PREHOOK: Input: default@testpart@v=val_4 +PREHOOK: Input: default@testpart@v=val_400 +PREHOOK: Input: default@testpart@v=val_401 +PREHOOK: Input: default@testpart@v=val_402 +PREHOOK: Input: default@testpart@v=val_403 +PREHOOK: Input: default@testpart@v=val_404 +PREHOOK: Input: default@testpart@v=val_406 +PREHOOK: Input: default@testpart@v=val_407 +PREHOOK: Input: default@testpart@v=val_409 +PREHOOK: Input: default@testpart@v=val_41 +PREHOOK: Input: default@testpart@v=val_411 +PREHOOK: Input: default@testpart@v=val_413 +PREHOOK: Input: default@testpart@v=val_414 +PREHOOK: Input: default@testpart@v=val_417 +PREHOOK: Input: default@testpart@v=val_418 +PREHOOK: Input: default@testpart@v=val_419 +PREHOOK: Input: default@testpart@v=val_42 +PREHOOK: Input: default@testpart@v=val_421 +PREHOOK: Input: default@testpart@v=val_424 +PREHOOK: Input: default@testpart@v=val_427 +PREHOOK: Input: default@testpart@v=val_429 +PREHOOK: Input: default@testpart@v=val_43 +PREHOOK: Input: default@testpart@v=val_430 +PREHOOK: Input: default@testpart@v=val_431 +PREHOOK: Input: default@testpart@v=val_432 +PREHOOK: Input: default@testpart@v=val_435 +PREHOOK: Input: default@testpart@v=val_436 +PREHOOK: Input: default@testpart@v=val_437 +PREHOOK: Input: default@testpart@v=val_438 +PREHOOK: Input: default@testpart@v=val_439 +PREHOOK: Input: default@testpart@v=val_44 +PREHOOK: Input: default@testpart@v=val_443 +PREHOOK: Input: default@testpart@v=val_444 +PREHOOK: Input: default@testpart@v=val_446 +PREHOOK: Input: default@testpart@v=val_448 +PREHOOK: Input: default@testpart@v=val_449 +PREHOOK: Input: default@testpart@v=val_452 +PREHOOK: Input: default@testpart@v=val_453 +PREHOOK: Input: default@testpart@v=val_454 +PREHOOK: Input: default@testpart@v=val_455 +PREHOOK: Input: default@testpart@v=val_457 +PREHOOK: Input: default@testpart@v=val_458 +PREHOOK: Input: default@testpart@v=val_459 +PREHOOK: Input: default@testpart@v=val_460 +PREHOOK: Input: default@testpart@v=val_462 +PREHOOK: Input: default@testpart@v=val_463 +PREHOOK: Input: default@testpart@v=val_466 +PREHOOK: Input: default@testpart@v=val_467 +PREHOOK: Input: default@testpart@v=val_468 +PREHOOK: Input: default@testpart@v=val_469 +PREHOOK: Input: default@testpart@v=val_47 +PREHOOK: Input: default@testpart@v=val_470 +PREHOOK: Input: default@testpart@v=val_472 +PREHOOK: Input: default@testpart@v=val_475 +PREHOOK: Input: default@testpart@v=val_477 +PREHOOK: Input: default@testpart@v=val_478 +PREHOOK: Input: default@testpart@v=val_479 +PREHOOK: Input: default@testpart@v=val_480 +PREHOOK: Input: default@testpart@v=val_481 +PREHOOK: Input: default@testpart@v=val_482 +PREHOOK: Input: default@testpart@v=val_483 +PREHOOK: Input: default@testpart@v=val_484 +PREHOOK: Input: default@testpart@v=val_485 +PREHOOK: Input: default@testpart@v=val_487 +PREHOOK: Input: default@testpart@v=val_489 +PREHOOK: Input: default@testpart@v=val_490 +PREHOOK: Input: default@testpart@v=val_491 +PREHOOK: Input: default@testpart@v=val_492 +PREHOOK: Input: default@testpart@v=val_493 +PREHOOK: Input: default@testpart@v=val_494 +PREHOOK: Input: default@testpart@v=val_495 +PREHOOK: Input: default@testpart@v=val_496 +PREHOOK: Input: default@testpart@v=val_497 +PREHOOK: Input: default@testpart@v=val_498 +PREHOOK: Input: default@testpart@v=val_5 +PREHOOK: Input: default@testpart@v=val_51 +PREHOOK: Input: default@testpart@v=val_53 +PREHOOK: Input: default@testpart@v=val_54 +PREHOOK: Input: default@testpart@v=val_57 +PREHOOK: Input: default@testpart@v=val_58 +PREHOOK: Input: default@testpart@v=val_64 +PREHOOK: Input: default@testpart@v=val_65 +PREHOOK: Input: default@testpart@v=val_66 +PREHOOK: Input: default@testpart@v=val_67 +PREHOOK: Input: default@testpart@v=val_69 +PREHOOK: Input: default@testpart@v=val_70 +PREHOOK: Input: default@testpart@v=val_72 +PREHOOK: Input: default@testpart@v=val_74 +PREHOOK: Input: default@testpart@v=val_76 +PREHOOK: Input: default@testpart@v=val_77 +PREHOOK: Input: default@testpart@v=val_78 +PREHOOK: Input: default@testpart@v=val_8 +PREHOOK: Input: default@testpart@v=val_80 +PREHOOK: Input: default@testpart@v=val_82 +PREHOOK: Input: default@testpart@v=val_83 +PREHOOK: Input: default@testpart@v=val_84 +PREHOOK: Input: default@testpart@v=val_85 +PREHOOK: Input: default@testpart@v=val_86 +PREHOOK: Input: default@testpart@v=val_87 +PREHOOK: Input: default@testpart@v=val_9 +PREHOOK: Input: default@testpart@v=val_90 +PREHOOK: Input: default@testpart@v=val_92 +PREHOOK: Input: default@testpart@v=val_95 +PREHOOK: Input: default@testpart@v=val_96 +PREHOOK: Input: default@testpart@v=val_97 +PREHOOK: Input: default@testpart@v=val_98 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/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 ecf9299..2afcbef 100644 --- a/ql/src/test/results/clientpositive/llap/tez_join.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_join.q.out @@ -31,6 +31,9 @@ join (select t2_n26.id, t2_n26.od from t2_n26 order by t2_n26.id, t2_n26.od) rt2_n26) vt2_n26 where vt1_n42.id=vt2_n26.id PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n42 +PREHOOK: Input: default@t2_n26 +#### A masked pattern was here #### POSTHOOK: query: explain select vt1_n42.id from (select rt1_n42.id from @@ -40,6 +43,9 @@ join (select t2_n26.id, t2_n26.od from t2_n26 order by t2_n26.id, t2_n26.od) rt2_n26) vt2_n26 where vt1_n42.id=vt2_n26.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n42 +POSTHOOK: Input: default@t2_n26 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1