http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out index 43fc1c4..108471d 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out @@ -201,11 +201,19 @@ select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -346,11 +354,19 @@ select depts_n20.deptno, count(*) as c, sum(empid) as s from emps_n30 join depts_n20 using (deptno) group by depts_n20.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n20.deptno, count(*) as c, sum(empid) as s from emps_n30 join depts_n20 using (deptno) group by depts_n20.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -472,6 +488,11 @@ join depts_n20 on (emps_n30.deptno = depts_n20.deptno) join dependents_n20 on (emps_n30.empid = dependents_n20.empid) group by dependents_n20.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n20 +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n20.empid, sum(salary) as s from emps_n30 @@ -479,6 +500,11 @@ join depts_n20 on (emps_n30.deptno = depts_n20.deptno) join dependents_n20 on (emps_n30.empid = dependents_n20.empid) group by dependents_n20.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n20 +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -638,6 +664,11 @@ join dependents_n20 on (emps_n30.empid = dependents_n20.empid) join depts_n20 a on (emps_n30.deptno=a.deptno) where emps_n30.name = 'Bill' PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n20 +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_n20 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n30.empid, dependents_n20.empid, emps_n30.deptno from emps_n30 @@ -645,6 +676,11 @@ join dependents_n20 on (emps_n30.empid = dependents_n20.empid) join depts_n20 a on (emps_n30.deptno=a.deptno) where emps_n30.name = 'Bill' POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n20 +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_n20 +#### 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/materialized_view_rewrite_no_join_opt_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt_2.q.out index 283e55d..61b0efc 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt_2.q.out @@ -209,11 +209,21 @@ select * from (select * from emps_n30 where empid < 120) t join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from emps_n30 where empid < 120) t join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -382,11 +392,23 @@ select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +PREHOOK: Input: default@mv1_part_n2@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +POSTHOOK: Input: default@mv1_part_n2@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -542,10 +564,18 @@ PREHOOK: query: explain select * from emps_n30 where empid > 120 union all select * from emps_n30 where empid < 150 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n30 where empid > 120 union all select * from emps_n30 where empid < 150 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -689,9 +719,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name, salary from emps_n30 group by name, salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name, salary from emps_n30 group by name, salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -787,9 +831,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -919,9 +977,21 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 where deptno = 10 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 where deptno = 10 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1064,9 +1134,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### 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/materialized_view_rewrite_part_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out index 9782cb7..68f4947 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_1.q.out @@ -209,11 +209,21 @@ select * from (select * from emps_n30 where empid < 120) t join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from emps_n30 where empid < 120) t join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -382,11 +392,23 @@ select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n20 +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +PREHOOK: Input: default@mv1_part_n2@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n30.name, emps_n30.salary, emps_n30.commission from emps_n30 join depts_n20 using (deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n20 +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +POSTHOOK: Input: default@mv1_part_n2@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -472,10 +494,18 @@ PREHOOK: query: explain select * from emps_n30 where empid > 120 union all select * from emps_n30 where empid < 150 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n30 where empid > 120 union all select * from emps_n30 where empid < 150 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@deptno=10 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -619,9 +649,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name, salary from emps_n30 group by name, salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name, salary from emps_n30 group by name, salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -717,9 +761,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -849,9 +907,21 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 where deptno = 10 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 where deptno = 10 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -994,9 +1064,23 @@ POSTHOOK: Output: default@mv1_part_n2@name=Theodore PREHOOK: query: explain select name from emps_n30 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n30 +PREHOOK: Input: default@mv1_part_n2 +PREHOOK: Input: default@mv1_part_n2@name=Bill +PREHOOK: Input: default@mv1_part_n2@name=Eric +PREHOOK: Input: default@mv1_part_n2@name=Sebastian +PREHOOK: Input: default@mv1_part_n2@name=Theodore +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n30 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n30 +POSTHOOK: Input: default@mv1_part_n2 +POSTHOOK: Input: default@mv1_part_n2@name=Bill +POSTHOOK: Input: default@mv1_part_n2@name=Eric +POSTHOOK: Input: default@mv1_part_n2@name=Sebastian +POSTHOOK: Input: default@mv1_part_n2@name=Theodore +#### 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/materialized_view_rewrite_part_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out index b3c7e1f..67a11c0 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_part_2.q.out @@ -212,11 +212,21 @@ select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -300,11 +310,21 @@ select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -388,11 +408,21 @@ select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n00 join depts_n00 using (deptno) where depts_n00.deptno >= 20 group by empid, depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -482,11 +512,23 @@ select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno, emps_n00.empid PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=10 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno, emps_n00.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=10 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -584,11 +626,23 @@ select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno=10 +PREHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n00.deptno from depts_n00 join emps_n00 using (deptno) where emps_n00.empid > 15 group by depts_n00.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno=10 +POSTHOOK: Input: default@mv1_part_n0@deptno=20 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -786,6 +840,13 @@ join emps_n00 on (emps_n00.deptno = depts_n00.deptno) where depts_n00.deptno > 10 group by dependents_n00.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n00 +PREHOOK: Input: default@depts_n00 +PREHOOK: Input: default@emps_n00 +PREHOOK: Input: default@mv1_part_n0 +PREHOOK: Input: default@mv1_part_n0@deptno2=20 +PREHOOK: Input: default@mv1_part_n0@deptno2=30 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n00.empid from depts_n00 @@ -794,6 +855,13 @@ join emps_n00 on (emps_n00.deptno = depts_n00.deptno) where depts_n00.deptno > 10 group by dependents_n00.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n00 +POSTHOOK: Input: default@depts_n00 +POSTHOOK: Input: default@emps_n00 +POSTHOOK: Input: default@mv1_part_n0 +POSTHOOK: Input: default@mv1_part_n0@deptno2=20 +POSTHOOK: Input: default@mv1_part_n0@deptno2=30 +#### 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/materialized_view_rewrite_ssb.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out index 63b6e54..f6aadd5 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out @@ -661,6 +661,10 @@ where and lo_discount between 1 and 3 and lo_quantity < 25 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -672,6 +676,10 @@ where and lo_discount between 1 and 3 and lo_quantity < 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -741,6 +749,10 @@ where and lo_discount between 4 and 6 and lo_quantity between 26 and 35 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -752,6 +764,10 @@ where and lo_discount between 4 and 6 and lo_quantity between 26 and 35 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -822,6 +838,10 @@ where and lo_discount between 5 and 7 and lo_quantity between 26 and 35 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -834,6 +854,10 @@ where and lo_discount between 5 and 7 and lo_quantity between 26 and 35 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -908,6 +932,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -924,6 +954,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1019,6 +1055,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -1035,6 +1077,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1130,6 +1178,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -1146,6 +1200,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1243,6 +1303,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_nation, s_nation, d_year, @@ -1261,6 +1327,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1357,6 +1429,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1374,6 +1452,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1470,6 +1554,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1487,6 +1577,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1579,6 +1675,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1596,6 +1698,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1694,6 +1802,13 @@ group by order by d_year, c_nation PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, c_nation, @@ -1713,6 +1828,13 @@ group by order by d_year, c_nation POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1808,6 +1930,13 @@ group by order by d_year, s_nation, p_category PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, s_nation, p_category, @@ -1828,6 +1957,13 @@ group by order by d_year, s_nation, p_category POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1923,6 +2059,13 @@ group by order by d_year, s_city, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n1 +PREHOOK: Input: default@dates_n0 +PREHOOK: Input: default@lineorder_n0 +PREHOOK: Input: default@ssb_mv_n0 +PREHOOK: Input: default@ssb_part_n0 +PREHOOK: Input: default@supplier_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, s_city, p_brand1, @@ -1943,6 +2086,13 @@ group by order by d_year, s_city, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n1 +POSTHOOK: Input: default@dates_n0 +POSTHOOK: Input: default@lineorder_n0 +POSTHOOK: Input: default@ssb_mv_n0 +POSTHOOK: Input: default@ssb_part_n0 +POSTHOOK: Input: default@supplier_n0 +#### 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/materialized_view_rewrite_ssb_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out index 8d14b3e..6f7dcdb 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out @@ -663,6 +663,10 @@ where and lo_discount between 1 and 3 and lo_quantity < 25 PREHOOK: type: QUERY +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -674,6 +678,10 @@ where and lo_discount between 1 and 3 and lo_quantity < 25 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -743,6 +751,10 @@ where and lo_discount between 4 and 6 and lo_quantity between 26 and 35 PREHOOK: type: QUERY +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -754,6 +766,10 @@ where and lo_discount between 4 and 6 and lo_quantity between 26 and 35 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -824,6 +840,10 @@ where and lo_discount between 5 and 7 and lo_quantity between 26 and 35 PREHOOK: type: QUERY +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_extendedprice*lo_discount) as revenue @@ -836,6 +856,10 @@ where and lo_discount between 5 and 7 and lo_quantity between 26 and 35 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -910,6 +934,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@ssb_part +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -926,6 +956,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@ssb_part +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1021,6 +1057,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@ssb_part +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -1037,6 +1079,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@ssb_part +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1132,6 +1180,12 @@ group by order by d_year, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@ssb_part +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select sum(lo_revenue) as lo_revenue, d_year, p_brand1 @@ -1148,6 +1202,12 @@ group by order by d_year, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@ssb_part +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1245,6 +1305,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select c_nation, s_nation, d_year, @@ -1263,6 +1329,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1359,6 +1431,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1376,6 +1454,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1472,6 +1556,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1489,6 +1579,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1585,6 +1681,12 @@ group by order by d_year asc, lo_revenue desc PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select c_city, s_city, d_year, sum(lo_revenue) as lo_revenue @@ -1602,6 +1704,12 @@ group by order by d_year asc, lo_revenue desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1700,6 +1808,13 @@ group by order by d_year, c_nation PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@ssb_part +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, c_nation, @@ -1719,6 +1834,13 @@ group by order by d_year, c_nation POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@ssb_part +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1814,6 +1936,13 @@ group by order by d_year, s_nation, p_category PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@ssb_part +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, s_nation, p_category, @@ -1834,6 +1963,13 @@ group by order by d_year, s_nation, p_category POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@ssb_part +POSTHOOK: Input: default@supplier +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1929,6 +2065,13 @@ group by order by d_year, s_city, p_brand1 PREHOOK: type: QUERY +PREHOOK: Input: default@customer_n0 +PREHOOK: Input: default@dates +PREHOOK: Input: default@lineorder +PREHOOK: Input: default@ssb_mv +PREHOOK: Input: default@ssb_part +PREHOOK: Input: default@supplier +#### A masked pattern was here #### POSTHOOK: query: explain select d_year, s_city, p_brand1, @@ -1949,6 +2092,13 @@ group by order by d_year, s_city, p_brand1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_n0 +POSTHOOK: Input: default@dates +POSTHOOK: Input: default@lineorder +POSTHOOK: Input: default@ssb_mv +POSTHOOK: Input: default@ssb_part +POSTHOOK: Input: default@supplier +#### 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/merge1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/merge1.q.out b/ql/src/test/results/clientpositive/llap/merge1.q.out index d79726c..ffe9164 100644 --- a/ql/src/test/results/clientpositive/llap/merge1.q.out +++ b/ql/src/test/results/clientpositive/llap/merge1.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain insert overwrite table dest1_n145 select key, count(1) from src group by key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n145 POSTHOOK: query: explain insert overwrite table dest1_n145 select key, count(1) from src group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n145 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -499,9 +503,17 @@ POSTHOOK: Lineage: test_src_n2 PARTITION(ds=102).value SIMPLE [(src)src.FieldSch PREHOOK: query: explain insert overwrite table dest1_n145 select key from test_src_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_src_n2 +PREHOOK: Input: default@test_src_n2@ds=101 +PREHOOK: Input: default@test_src_n2@ds=102 +PREHOOK: Output: default@dest1_n145 POSTHOOK: query: explain insert overwrite table dest1_n145 select key from test_src_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_src_n2 +POSTHOOK: Input: default@test_src_n2@ds=101 +POSTHOOK: Input: default@test_src_n2@ds=102 +POSTHOOK: Output: default@dest1_n145 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -601,9 +613,17 @@ POSTHOOK: Lineage: dest1_n145.key SIMPLE [(test_src_n2)test_src_n2.FieldSchema(n PREHOOK: query: explain insert overwrite table dest1_n145 select key from test_src_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@test_src_n2 +PREHOOK: Input: default@test_src_n2@ds=101 +PREHOOK: Input: default@test_src_n2@ds=102 +PREHOOK: Output: default@dest1_n145 POSTHOOK: query: explain insert overwrite table dest1_n145 select key from test_src_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_src_n2 +POSTHOOK: Input: default@test_src_n2@ds=101 +POSTHOOK: Input: default@test_src_n2@ds=102 +POSTHOOK: Output: default@dest1_n145 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/merge2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/merge2.q.out b/ql/src/test/results/clientpositive/llap/merge2.q.out index cf78672..9f9a6d0 100644 --- a/ql/src/test/results/clientpositive/llap/merge2.q.out +++ b/ql/src/test/results/clientpositive/llap/merge2.q.out @@ -10,10 +10,14 @@ PREHOOK: query: explain insert overwrite table test1_n10 select key, count(1) from src group by key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@test1_n10 POSTHOOK: query: explain insert overwrite table test1_n10 select key, count(1) from src group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@test1_n10 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -499,9 +503,17 @@ POSTHOOK: Lineage: test_src_n0 PARTITION(ds=102).value SIMPLE [(src)src.FieldSch PREHOOK: query: explain insert overwrite table test1_n10 select key from test_src_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@test_src_n0 +PREHOOK: Input: default@test_src_n0@ds=101 +PREHOOK: Input: default@test_src_n0@ds=102 +PREHOOK: Output: default@test1_n10 POSTHOOK: query: explain insert overwrite table test1_n10 select key from test_src_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_src_n0 +POSTHOOK: Input: default@test_src_n0@ds=101 +POSTHOOK: Input: default@test_src_n0@ds=102 +POSTHOOK: Output: default@test1_n10 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -601,9 +613,17 @@ POSTHOOK: Lineage: test1_n10.key SIMPLE [(test_src_n0)test_src_n0.FieldSchema(na PREHOOK: query: explain insert overwrite table test1_n10 select key from test_src_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@test_src_n0 +PREHOOK: Input: default@test_src_n0@ds=101 +PREHOOK: Input: default@test_src_n0@ds=102 +PREHOOK: Output: default@test1_n10 POSTHOOK: query: explain insert overwrite table test1_n10 select key from test_src_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_src_n0 +POSTHOOK: Input: default@test_src_n0@ds=101 +POSTHOOK: Input: default@test_src_n0@ds=102 +POSTHOOK: Output: default@test1_n10 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/mergejoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mergejoin.q.out b/ql/src/test/results/clientpositive/llap/mergejoin.q.out index b86d822..ea94b3b 100644 --- a/ql/src/test/results/clientpositive/llap/mergejoin.q.out +++ b/ql/src/test/results/clientpositive/llap/mergejoin.q.out @@ -1,9 +1,15 @@ PREHOOK: query: explain vectorization detail select * from src a join src1 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select * from src a join src1 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -383,10 +389,20 @@ PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1485,10 +1501,20 @@ PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a left outer join tab_part_n10 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a left outer join tab_part_n10 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1608,10 +1634,20 @@ PREHOOK: query: explain vectorization detail select count (*) from tab_n9 a right outer join tab_part_n10 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count (*) from tab_n9 a right outer join tab_part_n10 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1731,10 +1767,20 @@ PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a full outer join tab_part_n10 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a full outer join tab_part_n10 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -1927,9 +1973,21 @@ POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.key = b.key join src1 c on a.value = c.value PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.key = b.key join src1 c on a.value = c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2331,9 +2389,19 @@ POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2543,12 +2611,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n9 s2 ) a join tab_part_n10 b on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from (select s1.key as key, s1.value as value from tab_n9 s1 join tab_n9 s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from tab_n9 s2 ) a join tab_part_n10 b on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2786,9 +2864,19 @@ STAGE PLANS: PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.value = b.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.value = b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2995,9 +3083,21 @@ POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 PREHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.key = b.key join src1 c on a.value = c.value PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from tab_n9 a join tab_part_n10 b on a.key = b.key join src1 c on a.value = c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3402,12 +3502,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n9 s2 ) a join tab_part_n10 b on (a.key = b.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from (select s1.key as key, s1.value as value from tab_n9 s1 join tab_n9 s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from tab_n9 s2 ) a join tab_part_n10 b on (a.key = b.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -3651,6 +3761,11 @@ join (select t2.key as id, t2.value as od from tab_part_n10 t2 order by id, od) rt2) vt2 where vt1.id=vt2.id PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n9 +PREHOOK: Input: default@tab_n9@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n10 +PREHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select count(*) from (select rt1.id from @@ -3660,6 +3775,11 @@ join (select t2.key as id, t2.value as od from tab_part_n10 t2 order by id, od) rt2) vt2 where vt1.id=vt2.id POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n9 +POSTHOOK: Input: default@tab_n9@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n10 +POSTHOOK: Input: default@tab_part_n10@ds=2008-04-08 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out b/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out index f770fe4..1811f23 100644 --- a/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out +++ b/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out @@ -179,9 +179,13 @@ POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k_n12)ove PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -243,9 +247,19 @@ STAGE PLANS: PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +PREHOOK: Input: default@stats_tbl_part@dt=2010 +PREHOOK: Input: default@stats_tbl_part@dt=2011 +PREHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +POSTHOOK: Input: default@stats_tbl_part@dt=2010 +POSTHOOK: Input: default@stats_tbl_part@dt=2011 +POSTHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -307,9 +321,13 @@ STAGE PLANS: PREHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -371,9 +389,19 @@ STAGE PLANS: PREHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +PREHOOK: Input: default@stats_tbl_part@dt=2010 +PREHOOK: Input: default@stats_tbl_part@dt=2011 +PREHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +POSTHOOK: Input: default@stats_tbl_part@dt=2010 +POSTHOOK: Input: default@stats_tbl_part@dt=2011 +POSTHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -487,9 +515,13 @@ POSTHOOK: Output: default@stats_tbl_part@dt=2012 PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -512,9 +544,13 @@ POSTHOOK: Input: default@stats_tbl PREHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -537,9 +573,13 @@ POSTHOOK: Input: default@stats_tbl PREHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -562,9 +602,13 @@ POSTHOOK: Input: default@stats_tbl PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -587,9 +631,13 @@ POSTHOOK: Input: default@stats_tbl_part PREHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -612,9 +660,13 @@ POSTHOOK: Input: default@stats_tbl_part PREHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -636,8 +688,18 @@ POSTHOOK: Input: default@stats_tbl_part 65536 1 65791 4294967296 4294967551 0.01 99.98 7 0.01 50.0 PREHOOK: query: explain select count(ts) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +PREHOOK: Input: default@stats_tbl_part@dt=2010 +PREHOOK: Input: default@stats_tbl_part@dt=2011 +PREHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### POSTHOOK: query: explain select count(ts) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +POSTHOOK: Input: default@stats_tbl_part@dt=2010 +POSTHOOK: Input: default@stats_tbl_part@dt=2011 +POSTHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -694,8 +756,12 @@ STAGE PLANS: PREHOOK: query: explain select count('1') from stats_tbl group by '1' PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count('1') from stats_tbl group by '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -717,8 +783,12 @@ POSTHOOK: Input: default@stats_tbl 9999 PREHOOK: query: explain select count('1') from stats_tbl_part group by '1' PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select count('1') from stats_tbl_part group by '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out index 6be0911..6383d0a 100644 --- a/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out +++ b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out @@ -153,9 +153,13 @@ POSTHOOK: Output: default@stats_tbl_part_n0@dt=2014 PREHOOK: query: explain select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt = 2010 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt = 2010 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -178,9 +182,13 @@ POSTHOOK: Input: default@stats_tbl_part_n0 PREHOOK: query: explain select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt > 2010 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt > 2010 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/metadataonly1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out index 061d454..76ade73 100644 --- a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out +++ b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out @@ -8,8 +8,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@TEST1_n12 PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT MAX(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -104,8 +108,14 @@ POSTHOOK: Output: default@test1_n12 POSTHOOK: Output: default@test1_n12@ds=1 PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT MAX(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -247,8 +257,14 @@ POSTHOOK: Input: default@test1_n12@ds=1 NULL PREHOOK: query: explain extended select count(distinct ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(distinct ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(DISTINCT `ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -391,8 +407,14 @@ POSTHOOK: Input: default@test1_n12@ds=1 0 PREHOOK: query: explain extended select count(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -543,9 +565,17 @@ POSTHOOK: Output: default@test1_n12@ds=2 PREHOOK: query: explain extended select count(*) from TEST1_n12 a2 join (select max(ds) m from TEST1_n12) b on a2.ds=b.m PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +PREHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from TEST1_n12 a2 join (select max(ds) m from TEST1_n12) b on a2.ds=b.m POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +POSTHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `ds` FROM `default`.`test1_n12` @@ -959,8 +989,18 @@ POSTHOOK: Output: default@test2_n8 POSTHOOK: Output: default@test2_n8@ds=1/hr=3 PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `ds`, COUNT(DISTINCT `hr`) AS `$f1` FROM `default`.`test2_n8` GROUP BY `ds` @@ -1210,8 +1250,18 @@ POSTHOOK: Input: default@test2_n8@ds=1/hr=3 #### A masked pattern was here #### PREHOOK: query: explain extended select ds, count(hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `ds`, COUNT(`hr`) AS `$f1` FROM `default`.`test2_n8` GROUP BY `ds` @@ -1463,8 +1513,16 @@ POSTHOOK: Input: default@test2_n8@ds=1/hr=3 #### A masked pattern was here #### PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +PREHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +POSTHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT MAX(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -1706,8 +1764,22 @@ POSTHOOK: Output: default@test2_n8 POSTHOOK: Output: default@test2_n8@ds=01%3A10%3A20/hr=02 PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=01%3A10%3A10/hr=01 +PREHOOK: Input: default@test2_n8@ds=01%3A10%3A20/hr=02 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=01%3A10%3A10/hr=01 +POSTHOOK: Input: default@test2_n8@ds=01%3A10%3A20/hr=02 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `ds`, COUNT(DISTINCT `hr`) AS `$f1` FROM `default`.`test2_n8` GROUP BY `ds` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/mm_all.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mm_all.q.out b/ql/src/test/results/clientpositive/llap/mm_all.q.out index 500c7fa..58624c3 100644 --- a/ql/src/test/results/clientpositive/llap/mm_all.q.out +++ b/ql/src/test/results/clientpositive/llap/mm_all.q.out @@ -51,8 +51,18 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm_n0 PREHOOK: query: explain insert into table part_mm_n0 partition(key_mm=455) select key from intermediate_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@intermediate_n0 +PREHOOK: Input: default@intermediate_n0@p=455 +PREHOOK: Input: default@intermediate_n0@p=456 +PREHOOK: Input: default@intermediate_n0@p=457 +PREHOOK: Output: default@part_mm_n0@key_mm=455 POSTHOOK: query: explain insert into table part_mm_n0 partition(key_mm=455) select key from intermediate_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@intermediate_n0 +POSTHOOK: Input: default@intermediate_n0@p=455 +POSTHOOK: Input: default@intermediate_n0@p=456 +POSTHOOK: Input: default@intermediate_n0@p=457 +POSTHOOK: Output: default@part_mm_n0@key_mm=455 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/mm_bhif.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mm_bhif.q.out b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out index f6a7ed3..953b433 100644 --- a/ql/src/test/results/clientpositive/llap/mm_bhif.q.out +++ b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out @@ -48,9 +48,15 @@ POSTHOOK: Input: default@t1_mm@ds=1 PREHOOK: query: explain select count(distinct key) from T1_mm PREHOOK: type: QUERY +PREHOOK: Input: default@t1_mm +PREHOOK: Input: default@t1_mm@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(distinct key) from T1_mm POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_mm +POSTHOOK: Input: default@t1_mm@ds=1 +#### 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/mrr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mrr.q.out b/ql/src/test/results/clientpositive/llap/mrr.q.out index 39ff946..a8aceea 100644 --- a/ql/src/test/results/clientpositive/llap/mrr.q.out +++ b/ql/src/test/results/clientpositive/llap/mrr.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt 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 @@ -392,8 +396,12 @@ POSTHOOK: Input: default@src 98 2 PREHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.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 @@ -828,8 +836,12 @@ POSTHOOK: Input: default@src 98 1 PREHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.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 @@ -1271,6 +1283,8 @@ WHERE s1.cnt > 1 ORDER BY s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM @@ -1287,6 +1301,8 @@ WHERE s1.cnt > 1 ORDER 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 @@ -1611,12 +1627,16 @@ FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src ON (s1.key = src.key) order by s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src ON (s1.key = src.key) order 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
