http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out index 2d5764b..a17d721 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out @@ -205,11 +205,19 @@ select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -284,11 +292,19 @@ select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -363,11 +379,19 @@ select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n0 join depts_n0 using (deptno) where depts_n0.deptno > 20 group by empid, depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -442,11 +466,19 @@ select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno, emps_n0.empid PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno, emps_n0.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -526,11 +558,19 @@ select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n0.deptno from depts_n0 join emps_n0 using (deptno) where emps_n0.empid > 15 group by depts_n0.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -656,6 +696,11 @@ join emps_n0 on (emps_n0.deptno = depts_n0.deptno) where depts_n0.deptno > 10 group by dependents_n0.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n0 +PREHOOK: Input: default@depts_n0 +PREHOOK: Input: default@emps_n0 +PREHOOK: Input: default@mv1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n0.empid from depts_n0 @@ -664,6 +709,11 @@ join emps_n0 on (emps_n0.deptno = depts_n0.deptno) where depts_n0.deptno > 10 group by dependents_n0.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n0 +POSTHOOK: Input: default@depts_n0 +POSTHOOK: Input: default@emps_n0 +POSTHOOK: Input: default@mv1_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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out index 5965d31..7986f40 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out @@ -202,10 +202,18 @@ PREHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -275,10 +283,18 @@ PREHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -352,10 +368,18 @@ PREHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select empid deptno from emps_n9 join depts_n7 using (deptno) where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -429,12 +453,22 @@ from depts_n7 join dependents_n5 on (depts_n7.name = dependents_n5.name) join emps_n9 on (emps_n9.deptno = depts_n7.deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n5 +PREHOOK: Input: default@depts_n7 +PREHOOK: Input: default@emps_n9 +PREHOOK: Input: default@mv1_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n5.empid from depts_n7 join dependents_n5 on (depts_n7.name = dependents_n5.name) join emps_n9 on (emps_n9.deptno = depts_n7.deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n5 +POSTHOOK: Input: default@depts_n7 +POSTHOOK: Input: default@emps_n9 +POSTHOOK: Input: default@mv1_n5 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out index a0a22bf..e8f370a 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out @@ -200,10 +200,16 @@ PREHOOK: query: explain select name, count(*) as c, sum(empid) as s from emps_n5 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select name, count(*) as c, sum(empid) as s from emps_n5 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -314,10 +320,16 @@ PREHOOK: query: explain select salary, name, sum(empid) as s, count(*) as c from emps_n5 group by name, salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select salary, name, sum(empid) as s, count(*) as c from emps_n5 group by name, salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -390,11 +402,19 @@ select depts_n4.deptno, count(*) as c, sum(empid) as s from emps_n5 join depts_n4 using (deptno) group by depts_n4.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n4.deptno, count(*) as c, sum(empid) as s from emps_n5 join depts_n4 using (deptno) group by depts_n4.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -512,11 +532,19 @@ select depts_n4.deptno, sum(empid) as s from emps_n5 join depts_n4 using (deptno) where emps_n5.deptno > 10 group by depts_n4.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n4.deptno, sum(empid) as s from emps_n5 join depts_n4 using (deptno) where emps_n5.deptno > 10 group by depts_n4.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -632,11 +660,19 @@ select depts_n4.deptno, sum(empid) + 1 as s from emps_n5 join depts_n4 using (deptno) where depts_n4.deptno > 10 group by depts_n4.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n4.deptno, sum(empid) + 1 as s from emps_n5 join depts_n4 using (deptno) where depts_n4.deptno > 10 group by depts_n4.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -764,6 +800,11 @@ join depts_n4 on (emps_n5.deptno = depts_n4.deptno) join dependents_n3 on (depts_n4.name = dependents_n3.name) group by dependents_n3.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n3 +PREHOOK: Input: default@depts_n4 +PREHOOK: Input: default@emps_n5 +PREHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n3.empid, sum(salary) as s from emps_n5 @@ -771,6 +812,11 @@ join depts_n4 on (emps_n5.deptno = depts_n4.deptno) join dependents_n3 on (depts_n4.name = dependents_n3.name) group by dependents_n3.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n3 +POSTHOOK: Input: default@depts_n4 +POSTHOOK: Input: default@emps_n5 +POSTHOOK: Input: default@mv1_n3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -936,12 +982,18 @@ from emps_n5 join dependents_n3 on (emps_n5.empid = dependents_n3.empid) group by dependents_n3.empid, emps_n5.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n3 +PREHOOK: Input: default@emps_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n5.deptno, count(distinct salary) as s from emps_n5 join dependents_n3 on (emps_n5.empid = dependents_n3.empid) group by dependents_n3.empid, emps_n5.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n3 +POSTHOOK: Input: default@emps_n5 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out index 6718e3f..561e558 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out @@ -213,9 +213,15 @@ POSTHOOK: Output: default@mv1_n1 PREHOOK: query: explain select name from emps_n2 where deptno >= 20 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select name from emps_n2 where deptno >= 20 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -321,10 +327,16 @@ PREHOOK: query: explain select name, sum(empid) as s from emps_n2 where deptno > 15 group by name PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select name, sum(empid) as s from emps_n2 where deptno > 15 group by name POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -456,6 +468,12 @@ join emps_n2 on (emps_n2.deptno = depts_n1.deptno) where depts_n1.deptno > 11 and depts_n1.deptno < 19 group by dependents_n1.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@depts_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@locations_n1 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n1.empid from depts_n1 @@ -465,6 +483,12 @@ join emps_n2 on (emps_n2.deptno = depts_n1.deptno) where depts_n1.deptno > 11 and depts_n1.deptno < 19 group by dependents_n1.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@depts_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@locations_n1 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -590,9 +614,15 @@ POSTHOOK: Output: default@mv1_n1 PREHOOK: query: explain select deptno from emps_n2 group by deptno PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select deptno from emps_n2 group by deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -700,10 +730,16 @@ PREHOOK: query: explain select deptno, empid, sum(empid) as s, count(*) as c from emps_n2 group by empid, deptno PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select deptno, empid, sum(empid) as s, count(*) as c from emps_n2 group by empid, deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -780,6 +816,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by dependents_n1.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@depts_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n1.empid, sum(salary) as s from emps_n2 @@ -787,6 +828,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by dependents_n1.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@depts_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -946,6 +992,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by depts_n1.name PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@depts_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select depts_n1.name, sum(salary) as s from emps_n2 @@ -953,6 +1004,11 @@ join depts_n1 on (emps_n2.deptno = depts_n1.deptno) join dependents_n1 on (emps_n2.empid = dependents_n1.empid) group by depts_n1.name POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@depts_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1114,11 +1170,19 @@ select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1196,11 +1260,19 @@ select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select a.empid from (select * from emps_n2 where empid = 1) a join dependents_n1 on (a.empid = dependents_n1.empid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1271,9 +1343,15 @@ POSTHOOK: Output: default@mv1_n1 PREHOOK: query: explain select empid from emps_n2 where empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select empid from emps_n2 where empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1345,11 +1423,19 @@ select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1429,11 +1515,19 @@ select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.empid = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1512,11 +1606,19 @@ select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.name = 'Sebastian' PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n1 +PREHOOK: Input: default@emps_n2 +PREHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps_n2.empid from emps_n2 join dependents_n1 on (emps_n2.empid = dependents_n1.empid) where emps_n2.name = 'Sebastian' POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n1 +POSTHOOK: Input: default@emps_n2 +POSTHOOK: Input: default@mv1_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out index 77887e0..f83e547 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out @@ -216,10 +216,16 @@ PREHOOK: query: explain select salary, sum(empid) + 1 as s from emps where deptno > 10 group by salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select salary, sum(empid) + 1 as s from emps where deptno > 10 group by salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -334,10 +340,16 @@ PREHOOK: query: explain select salary + 1, sum(empid) + 1 as s from emps where deptno > 15 group by salary PREHOOK: type: QUERY +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select salary + 1, sum(empid) + 1 as s from emps where deptno > 15 group by salary POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -458,12 +470,22 @@ from emps join depts on (emps.deptno = depts.deptno) join dependents on (depts.name = dependents.name) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents +PREHOOK: Input: default@depts +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents.empid from emps join depts on (emps.deptno = depts.deptno) join dependents on (depts.name = dependents.name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents +POSTHOOK: Input: default@depts +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -607,6 +629,12 @@ join dependents on (depts.name = dependents.name) join locations on (locations.name = dependents.name) join emps on (emps.deptno = depts.deptno) PREHOOK: type: QUERY +PREHOOK: Input: default@dependents +PREHOOK: Input: default@depts +PREHOOK: Input: default@emps +PREHOOK: Input: default@locations +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents.empid from depts @@ -614,6 +642,12 @@ join dependents on (depts.name = dependents.name) join locations on (locations.name = dependents.name) join emps on (emps.deptno = depts.deptno) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents +POSTHOOK: Input: default@depts +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@locations +POSTHOOK: Input: default@mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -780,6 +814,11 @@ join dependents on (emps.empid = dependents.empid) join depts a on (emps.deptno=a.deptno) where emps.name = 'Bill' PREHOOK: type: QUERY +PREHOOK: Input: default@dependents +PREHOOK: Input: default@depts +PREHOOK: Input: default@emps +PREHOOK: Input: default@mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select emps.empid, dependents.empid, emps.deptno from emps @@ -787,6 +826,11 @@ join dependents on (emps.empid = dependents.empid) join depts a on (emps.deptno=a.deptno) where emps.name = 'Bill' POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents +POSTHOOK: Input: default@depts +POSTHOOK: Input: default@emps +POSTHOOK: Input: default@mv1 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out index f677a6c..4ada4e1 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out @@ -237,6 +237,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 group by dependents_n4.empid, depts_n6.deptno PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n4 +PREHOOK: Input: default@depts_n6 +PREHOOK: Input: default@emps_n8 +PREHOOK: Input: default@locations_n4 +PREHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n4.empid, depts_n6.deptno from depts_n6 @@ -246,6 +252,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 group by dependents_n4.empid, depts_n6.deptno POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n4 +POSTHOOK: Input: default@depts_n6 +POSTHOOK: Input: default@emps_n8 +POSTHOOK: Input: default@locations_n4 +POSTHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -528,6 +540,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 and depts_n6.deptno < 20 group by dependents_n4.empid PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n4 +PREHOOK: Input: default@depts_n6 +PREHOOK: Input: default@emps_n8 +PREHOOK: Input: default@locations_n4 +PREHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n4.empid, count(emps_n8.salary) + 1 from depts_n6 @@ -537,6 +555,12 @@ join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 10 and depts_n6.deptno < 20 group by dependents_n4.empid POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n4 +POSTHOOK: Input: default@depts_n6 +POSTHOOK: Input: default@emps_n8 +POSTHOOK: Input: default@locations_n4 +POSTHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -845,6 +869,11 @@ join dependents_n4 on (depts_n6.name = dependents_n4.name) join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@dependents_n4 +PREHOOK: Input: default@depts_n6 +PREHOOK: Input: default@emps_n8 +PREHOOK: Input: default@mv1_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select dependents_n4.empid from depts_n6 @@ -852,6 +881,11 @@ join dependents_n4 on (depts_n6.name = dependents_n4.name) join emps_n8 on (emps_n8.deptno = depts_n6.deptno) where depts_n6.deptno > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependents_n4 +POSTHOOK: Input: default@depts_n6 +POSTHOOK: Input: default@emps_n8 +POSTHOOK: Input: default@mv1_n4 +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out index 72f327e..0103b72 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_8.q.out @@ -89,6 +89,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -96,6 +99,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -119,6 +125,9 @@ FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE LIMIT 100 PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -127,6 +136,9 @@ FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE LIMIT 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -152,6 +164,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select 1, @@ -160,6 +175,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -182,6 +200,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) + 0 AS DOWNLOAD_VOLUME_BYTES, @@ -189,6 +210,9 @@ A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -213,6 +237,9 @@ group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE ORDER BY A.MY_ID2 LIMIT 100 PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -222,6 +249,9 @@ group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE ORDER BY A.MY_ID2 LIMIT 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -280,11 +310,17 @@ select distinct A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select distinct A.MY_DATE,A.MY_ID2,A.ENVIRONMENT FROM source_table_001 AS A POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -348,6 +384,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -356,6 +395,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -381,6 +423,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) + SUM(A.UP_VOLUME) AS TOTAL_VOLUME_BYTES, @@ -389,6 +434,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -412,12 +460,18 @@ SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -482,6 +536,9 @@ TO_DATE('2010-01-10') FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -489,6 +546,9 @@ TO_DATE('2010-01-10') FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -558,6 +618,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_DATE PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001 +PREHOOK: Input: default@source_table_001_mv +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -566,6 +629,9 @@ FROM source_table_001 AS A where A.MY_DATE=TO_DATE('2010-01-10') group by A.MY_DATE POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001 +POSTHOOK: Input: default@source_table_001_mv +#### 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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out index e889ebd..5be06f1 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_9.q.out @@ -89,6 +89,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_mv_n0 +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -96,6 +99,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_mv_n0 +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -205,6 +211,9 @@ FLOOR(A.MY_DATE to day),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to day) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_mv_n0 +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -212,6 +221,9 @@ FLOOR(A.MY_DATE to day),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to day) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_mv_n0 +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -281,6 +293,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_mv_n0 +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -288,6 +303,9 @@ FLOOR(A.MY_DATE to hour),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to hour) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_mv_n0 +POSTHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -310,6 +328,8 @@ FLOOR(A.MY_DATE to second),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to second) PREHOOK: type: QUERY +PREHOOK: Input: default@source_table_001_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(A.DOWN_VOLUME) AS DOWNLOAD_VOLUME_BYTES, @@ -317,6 +337,8 @@ FLOOR(A.MY_DATE to second),A.MY_ID2,A.ENVIRONMENT FROM source_table_001_n0 AS A group by A.MY_ID,A.MY_ID2,A.ENVIRONMENT,FLOOR(A.MY_DATE to second) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_table_001_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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out index e988ea4..d4097dc 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_empty.q.out @@ -43,9 +43,15 @@ POSTHOOK: Output: default@emps_mv_rewrite_empty_mv1 PREHOOK: query: explain select * from emps_mv_rewrite_empty where empid < 120 PREHOOK: type: QUERY +PREHOOK: Input: default@emps_mv_rewrite_empty +PREHOOK: Input: default@emps_mv_rewrite_empty_mv1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_mv_rewrite_empty where empid < 120 POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_mv_rewrite_empty +POSTHOOK: Input: default@emps_mv_rewrite_empty_mv1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb.q.out index ab28253..cea5037 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 @@ -740,6 +748,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 @@ -751,6 +763,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 @@ -820,6 +836,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 @@ -832,6 +852,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 @@ -905,6 +929,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 @@ -921,6 +951,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 @@ -1015,6 +1051,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 @@ -1031,6 +1073,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 @@ -1125,6 +1173,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 @@ -1141,6 +1195,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 @@ -1237,6 +1297,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, @@ -1255,6 +1321,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 @@ -1350,6 +1422,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 @@ -1367,6 +1445,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 @@ -1462,6 +1546,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 @@ -1479,6 +1569,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 @@ -1570,6 +1666,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 @@ -1587,6 +1689,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 @@ -1684,6 +1792,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, @@ -1703,6 +1818,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 @@ -1797,6 +1919,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, @@ -1817,6 +1946,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 @@ -1911,6 +2047,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, @@ -1931,6 +2074,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/c39b5d1b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_ssb_2.q.out index 994c9c1..7f7aa38 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 @@ -742,6 +750,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 @@ -753,6 +765,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 @@ -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 +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 @@ -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 +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 @@ -907,6 +931,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 @@ -923,6 +953,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 @@ -1017,6 +1053,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 @@ -1033,6 +1075,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 @@ -1127,6 +1175,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 @@ -1143,6 +1197,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 @@ -1239,6 +1299,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, @@ -1257,6 +1323,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 @@ -1352,6 +1424,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 @@ -1369,6 +1447,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 @@ -1464,6 +1548,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 @@ -1481,6 +1571,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 @@ -1576,6 +1672,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 @@ -1593,6 +1695,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 @@ -1690,6 +1798,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, @@ -1709,6 +1824,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 @@ -1803,6 +1925,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, @@ -1823,6 +1952,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 @@ -1917,6 +2053,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, @@ -1937,6 +2080,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/c39b5d1b/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/c39b5d1b/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/c39b5d1b/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 1e4f632..cff2d9c 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] @@ -382,10 +388,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] @@ -1481,10 +1497,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] @@ -1601,10 +1627,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] @@ -1721,10 +1757,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] @@ -1916,9 +1962,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] @@ -2319,9 +2377,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] @@ -2530,12 +2598,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] @@ -2769,9 +2847,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] @@ -2977,9 +3065,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] @@ -3383,12 +3483,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] @@ -3628,6 +3738,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 @@ -3637,6 +3752,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/c39b5d1b/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
