http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out b/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out index 363f2de..f059c75 100644 --- a/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out +++ b/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out @@ -111,8 +111,12 @@ POSTHOOK: Output: default@things_n1 Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product PREHOOK: query: explain select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -263,8 +267,12 @@ STANDARD PLATED TIN STANDARD POLISHED STEEL PREHOOK: query: explain select part.p_type from part left join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select part.p_type from part left join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage
http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out b/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out index 76a8bf6..4a9db25 100644 --- a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out +++ b/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out @@ -4,12 +4,16 @@ from src src1 left outer join src src2 on src1.key = src2.key limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 left outer join src src2 on src1.key = src2.key limit 1 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 @@ -105,12 +109,16 @@ from src src1 left outer join src src2 on src1.key = src2.key limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 left outer join src src2 on src1.key = src2.key limit 1 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 @@ -206,12 +214,16 @@ from src src1 left outer join src src2 on src1.key = src2.key limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 left outer join src src2 on src1.key = src2.key limit 1 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 @@ -318,6 +330,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -327,6 +341,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 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 @@ -467,6 +483,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -476,6 +494,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 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 @@ -632,6 +652,8 @@ on src1.key = src2.key order by src2.key limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -642,6 +664,8 @@ on src1.key = src2.key order by src2.key limit 1 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 @@ -823,6 +847,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 0 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -832,6 +858,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -868,12 +896,16 @@ from src src1 left outer join src src2 on src1.key = src2.key limit 1 offset 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 left outer join src src2 on src1.key = src2.key limit 1 offset 1 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 @@ -970,12 +1002,16 @@ from src src1 left outer join src src2 on src1.key = src2.key limit 1 offset 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 left outer join src src2 on src1.key = src2.key limit 1 offset 1 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 @@ -1072,12 +1108,16 @@ from src src1 left outer join src src2 on src1.key = src2.key limit 1 offset 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 left outer join src src2 on src1.key = src2.key limit 1 offset 1 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 @@ -1186,6 +1226,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 offset 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -1195,6 +1237,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 offset 1 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 @@ -1337,6 +1381,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 offset 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -1346,6 +1392,8 @@ from src src1 right outer join ( on src1.key = src2.key limit 1 offset 1 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 @@ -1506,6 +1554,8 @@ on src1.key = src2.key order by src2.key limit 1 offset 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src src1 right outer join ( @@ -1516,6 +1566,8 @@ on src1.key = src2.key order by src2.key limit 1 offset 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/limit_pushdown.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/limit_pushdown.q.out b/ql/src/test/results/clientpositive/llap/limit_pushdown.q.out index 3d6300d..3f0c2ae 100644 --- a/ql/src/test/results/clientpositive/llap/limit_pushdown.q.out +++ b/ql/src/test/results/clientpositive/llap/limit_pushdown.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select key,value from src order by key limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key limit 20 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 @@ -88,9 +92,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select key,value from src order by key desc limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key desc limit 20 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 @@ -175,9 +183,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select value, sum(key + 1) as sum from src group by value order by value limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key + 1) as sum from src group by value order by value limit 20 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 @@ -276,9 +288,13 @@ val_131 132.0 PREHOOK: query: explain select value,avg(key + 1) from src group by value order by value limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value,avg(key + 1) from src group by value order by value limit 20 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 @@ -381,9 +397,13 @@ val_131 132.0 PREHOOK: query: explain select distinct(cdouble) as dis from alltypesorc order by dis limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select distinct(cdouble) as dis from alltypesorc order by dis limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -479,9 +499,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint order by ctinyint limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint order by ctinyint limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -577,9 +601,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(cdouble) from (select ctinyint, cdouble from alltypesorc group by ctinyint, cdouble) t1 group by ctinyint order by ctinyint limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(cdouble) from (select ctinyint, cdouble from alltypesorc group by ctinyint, cdouble) t1 group by ctinyint order by ctinyint limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -675,9 +703,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint order by ctinyint limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint order by ctinyint limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -770,9 +802,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select key,value from src order by key limit 0 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key limit 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -794,9 +830,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select value, sum(key) as sum from src group by value order by sum limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key) as sum from src group by value order by sum limit 20 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 @@ -907,6 +947,8 @@ join (select key, count(1) from src group by key limit 3) subq2 on subq.key=subq2.key limit 4 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select key, count(1) from src group by key order by key limit 2) subq @@ -914,6 +956,8 @@ join (select key, count(1) from src group by key limit 3) subq2 on subq.key=subq2.key limit 4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1064,9 +1108,13 @@ STAGE PLANS: PREHOOK: query: explain select value, sum(key) as sum from src group by value order by value limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key) as sum from src group by value order by value limit 20 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 @@ -1154,9 +1202,13 @@ val_131 131.0 PREHOOK: query: explain select key,value,value,value,value,value,value,value,value from src order by key limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value,value,value,value,value,value,value,value from src order by key limit 100 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 @@ -1321,9 +1373,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/limit_pushdown3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/limit_pushdown3.q.out b/ql/src/test/results/clientpositive/llap/limit_pushdown3.q.out index 1f9d692..8d5848b 100644 --- a/ql/src/test/results/clientpositive/llap/limit_pushdown3.q.out +++ b/ql/src/test/results/clientpositive/llap/limit_pushdown3.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select key,value from src order by key limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key limit 20 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 @@ -88,9 +92,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select key,value from src order by key desc limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key desc limit 20 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 @@ -175,9 +183,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select value, sum(key + 1) as sum from src group by value order by value limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key + 1) as sum from src group by value order by value limit 20 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 @@ -290,9 +302,13 @@ val_131 132.0 PREHOOK: query: explain select value,avg(key + 1) from src group by value order by value limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value,avg(key + 1) from src group by value order by value limit 20 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 @@ -409,9 +425,13 @@ val_131 132.0 PREHOOK: query: explain select distinct(cdouble) as dis from alltypesorc order by dis limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select distinct(cdouble) as dis from alltypesorc order by dis limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -520,9 +540,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint order by ctinyint limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint order by ctinyint limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -632,9 +656,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(cdouble) from (select ctinyint, cdouble from alltypesorc group by ctinyint, cdouble) t1 group by ctinyint order by ctinyint limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(cdouble) from (select ctinyint, cdouble from alltypesorc group by ctinyint, cdouble) t1 group by ctinyint order by ctinyint limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -744,9 +772,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint order by ctinyint limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint order by ctinyint limit 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -853,9 +885,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select key,value from src order by key limit 0 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key limit 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -877,9 +913,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select value, sum(key) as sum from src group by value order by sum limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key) as sum from src group by value order by sum limit 20 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 @@ -986,9 +1026,13 @@ val_41 41.0 PREHOOK: query: explain select value, sum(key) as sum from src group by value order by value limit 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key) as sum from src group by value order by value limit 20 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 @@ -1090,9 +1134,13 @@ val_131 131.0 PREHOOK: query: explain select key,value,value,value,value,value,value,value,value from src order by key limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value,value,value,value,value,value,value,value from src order by key limit 100 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 @@ -1257,9 +1305,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out b/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out index 2693367..05c874f 100644 --- a/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out +++ b/ql/src/test/results/clientpositive/llap/list_bucket_dml_10.q.out @@ -18,10 +18,14 @@ PREHOOK: query: explain extended insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11') select key, value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@list_bucketing_static_part@ds=2008-04-08/hr=11 POSTHOOK: query: explain extended insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11') select key, value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@list_bucketing_static_part@ds=2008-04-08/hr=11 OPTIMIZED SQL: SELECT `key`, `value` FROM `default`.`src` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/llap_acid.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_acid.q.out b/ql/src/test/results/clientpositive/llap/llap_acid.q.out index 0d1a331..f6d573e 100644 --- a/ql/src/test/results/clientpositive/llap/llap_acid.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_acid.q.out @@ -82,10 +82,20 @@ PREHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order by csmallint, cint PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n1 +PREHOOK: Input: default@orc_llap_n1@csmallint=1 +PREHOOK: Input: default@orc_llap_n1@csmallint=2 +PREHOOK: Input: default@orc_llap_n1@csmallint=3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order by csmallint, cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n1 +POSTHOOK: Input: default@orc_llap_n1@csmallint=1 +POSTHOOK: Input: default@orc_llap_n1@csmallint=2 +POSTHOOK: Input: default@orc_llap_n1@csmallint=3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -225,9 +235,23 @@ POSTHOOK: Lineage: orc_llap_n1 PARTITION(csmallint=1).cint SCRIPT [] PREHOOK: query: explain vectorization only detail update orc_llap_n1 set cbigint = 2 where cint = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n1 +PREHOOK: Input: default@orc_llap_n1@csmallint=1 +PREHOOK: Input: default@orc_llap_n1@csmallint=2 +PREHOOK: Input: default@orc_llap_n1@csmallint=3 +PREHOOK: Output: default@orc_llap_n1@csmallint=1 +PREHOOK: Output: default@orc_llap_n1@csmallint=2 +PREHOOK: Output: default@orc_llap_n1@csmallint=3 POSTHOOK: query: explain vectorization only detail update orc_llap_n1 set cbigint = 2 where cint = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n1 +POSTHOOK: Input: default@orc_llap_n1@csmallint=1 +POSTHOOK: Input: default@orc_llap_n1@csmallint=2 +POSTHOOK: Input: default@orc_llap_n1@csmallint=3 +POSTHOOK: Output: default@orc_llap_n1@csmallint=1 +POSTHOOK: Output: default@orc_llap_n1@csmallint=2 +POSTHOOK: Output: default@orc_llap_n1@csmallint=3 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -336,10 +360,20 @@ PREHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order by csmallint, cint PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n1 +PREHOOK: Input: default@orc_llap_n1@csmallint=1 +PREHOOK: Input: default@orc_llap_n1@csmallint=2 +PREHOOK: Input: default@orc_llap_n1@csmallint=3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_n1 where cint is not null order by csmallint, cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n1 +POSTHOOK: Input: default@orc_llap_n1@csmallint=1 +POSTHOOK: Input: default@orc_llap_n1@csmallint=2 +POSTHOOK: Input: default@orc_llap_n1@csmallint=3 +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_acid_fast.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_acid_fast.q.out b/ql/src/test/results/clientpositive/llap/llap_acid_fast.q.out index 18a2ae9..8198ea1 100644 --- a/ql/src/test/results/clientpositive/llap/llap_acid_fast.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_acid_fast.q.out @@ -76,10 +76,20 @@ PREHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order by csmallint, cint PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_acid_fast +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order by csmallint, cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_acid_fast +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -219,9 +229,23 @@ POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cint SCRIPT [] PREHOOK: query: explain vectorization only detail update orc_llap_acid_fast set cbigint = 2 where cint = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_acid_fast +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 +PREHOOK: Output: default@orc_llap_acid_fast@csmallint=1 +PREHOOK: Output: default@orc_llap_acid_fast@csmallint=2 +PREHOOK: Output: default@orc_llap_acid_fast@csmallint=3 POSTHOOK: query: explain vectorization only detail update orc_llap_acid_fast set cbigint = 2 where cint = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_acid_fast +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 +POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=1 +POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=2 +POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=3 PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -330,10 +354,20 @@ PREHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order by csmallint, cint PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_acid_fast +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 +PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization only detail select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order by csmallint, cint POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_acid_fast +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 +POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_decimal64_reader.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_decimal64_reader.q.out b/ql/src/test/results/clientpositive/llap/llap_decimal64_reader.q.out index 88ddd9c..f5ada5a 100644 --- a/ql/src/test/results/clientpositive/llap/llap_decimal64_reader.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_decimal64_reader.q.out @@ -103,9 +103,13 @@ POSTHOOK: Lineage: orc_llap_n0.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSc PREHOOK: query: explain vectorization select cdecimal1,cdecimal2 from orc_llap_n0 where cdecimal1 = cast("3.345" as decimal(10,2)) or cdecimal1 = cast("4.456" as decimal(10,2)) group by cdecimal1,cdecimal2 limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select cdecimal1,cdecimal2 from orc_llap_n0 where cdecimal1 = cast("3.345" as decimal(10,2)) or cdecimal1 = cast("4.456" as decimal(10,2)) group by cdecimal1,cdecimal2 limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -204,9 +208,13 @@ POSTHOOK: Input: default@orc_llap_n0 PREHOOK: query: explain vectorization select cdecimal1,cdecimal2 from orc_llap_n0 where cdecimal1 = cast("3.345" as decimal(10,2)) or cdecimal1 = cast("4.456" as decimal(10,2)) group by cdecimal1,cdecimal2 limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization select cdecimal1,cdecimal2 from orc_llap_n0 where cdecimal1 = cast("3.345" as decimal(10,2)) or cdecimal1 = cast("4.456" as decimal(10,2)) group by cdecimal1,cdecimal2 limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n0 +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out b/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out index 7bf003e..515b340 100644 --- a/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out @@ -27,9 +27,13 @@ POSTHOOK: Lineage: src_orc_n1.value SIMPLE [(srcpart)srcpart.FieldSchema(name:va PREHOOK: query: explain extended select * from src_orc_n1 where 1=2 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n1 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain extended select * from src_orc_n1 where 1=2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n1 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -149,9 +153,13 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select * from (select key from src_orc_n1 where false) a left outer join (select key from src_orc_n1 limit 0) b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n1 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from (select key from src_orc_n1 where false) a left outer join (select key from src_orc_n1 limit 0) b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n1 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -246,9 +254,13 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select count(key) from src_orc_n1 where false union all select count(key) from src_orc_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n1 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select count(key) from src_orc_n1 where false union all select count(key) from src_orc_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n1 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -353,9 +365,13 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select * from src_orc_n1 s1, src_orc_n1 s2 where false and s1.value = s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n1 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from src_orc_n1 s1, src_orc_n1 s2 where false and s1.value = s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n1 +POSTHOOK: Output: hdfs://### HDFS PATH ### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out b/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out index e6fa1ac..89e5683 100644 --- a/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out @@ -1610,10 +1610,292 @@ PREHOOK: query: explain vectorization detail SELECT oft.ctinyint, oft.cint, oft.cchar1, oft.cvchar1 FROM orc_llap_part oft INNER JOIN orc_llap_dim_part od ON oft.ctinyint = od.ctinyint PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_dim_part +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=11 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=12 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=13 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=14 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=15 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=16 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=17 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=18 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=19 +PREHOOK: Input: default@orc_llap_dim_part@ctinyint=20 +PREHOOK: Input: default@orc_llap_part +PREHOOK: Input: default@orc_llap_part@ctinyint=-1 +PREHOOK: Input: default@orc_llap_part@ctinyint=-10 +PREHOOK: Input: default@orc_llap_part@ctinyint=-11 +PREHOOK: Input: default@orc_llap_part@ctinyint=-12 +PREHOOK: Input: default@orc_llap_part@ctinyint=-13 +PREHOOK: Input: default@orc_llap_part@ctinyint=-14 +PREHOOK: Input: default@orc_llap_part@ctinyint=-15 +PREHOOK: Input: default@orc_llap_part@ctinyint=-16 +PREHOOK: Input: default@orc_llap_part@ctinyint=-17 +PREHOOK: Input: default@orc_llap_part@ctinyint=-18 +PREHOOK: Input: default@orc_llap_part@ctinyint=-19 +PREHOOK: Input: default@orc_llap_part@ctinyint=-2 +PREHOOK: Input: default@orc_llap_part@ctinyint=-20 +PREHOOK: Input: default@orc_llap_part@ctinyint=-21 +PREHOOK: Input: default@orc_llap_part@ctinyint=-22 +PREHOOK: Input: default@orc_llap_part@ctinyint=-23 +PREHOOK: Input: default@orc_llap_part@ctinyint=-24 +PREHOOK: Input: default@orc_llap_part@ctinyint=-25 +PREHOOK: Input: default@orc_llap_part@ctinyint=-26 +PREHOOK: Input: default@orc_llap_part@ctinyint=-27 +PREHOOK: Input: default@orc_llap_part@ctinyint=-28 +PREHOOK: Input: default@orc_llap_part@ctinyint=-29 +PREHOOK: Input: default@orc_llap_part@ctinyint=-3 +PREHOOK: Input: default@orc_llap_part@ctinyint=-30 +PREHOOK: Input: default@orc_llap_part@ctinyint=-31 +PREHOOK: Input: default@orc_llap_part@ctinyint=-32 +PREHOOK: Input: default@orc_llap_part@ctinyint=-33 +PREHOOK: Input: default@orc_llap_part@ctinyint=-34 +PREHOOK: Input: default@orc_llap_part@ctinyint=-35 +PREHOOK: Input: default@orc_llap_part@ctinyint=-36 +PREHOOK: Input: default@orc_llap_part@ctinyint=-37 +PREHOOK: Input: default@orc_llap_part@ctinyint=-38 +PREHOOK: Input: default@orc_llap_part@ctinyint=-39 +PREHOOK: Input: default@orc_llap_part@ctinyint=-4 +PREHOOK: Input: default@orc_llap_part@ctinyint=-40 +PREHOOK: Input: default@orc_llap_part@ctinyint=-41 +PREHOOK: Input: default@orc_llap_part@ctinyint=-42 +PREHOOK: Input: default@orc_llap_part@ctinyint=-43 +PREHOOK: Input: default@orc_llap_part@ctinyint=-44 +PREHOOK: Input: default@orc_llap_part@ctinyint=-45 +PREHOOK: Input: default@orc_llap_part@ctinyint=-46 +PREHOOK: Input: default@orc_llap_part@ctinyint=-47 +PREHOOK: Input: default@orc_llap_part@ctinyint=-48 +PREHOOK: Input: default@orc_llap_part@ctinyint=-49 +PREHOOK: Input: default@orc_llap_part@ctinyint=-5 +PREHOOK: Input: default@orc_llap_part@ctinyint=-50 +PREHOOK: Input: default@orc_llap_part@ctinyint=-51 +PREHOOK: Input: default@orc_llap_part@ctinyint=-52 +PREHOOK: Input: default@orc_llap_part@ctinyint=-53 +PREHOOK: Input: default@orc_llap_part@ctinyint=-54 +PREHOOK: Input: default@orc_llap_part@ctinyint=-55 +PREHOOK: Input: default@orc_llap_part@ctinyint=-56 +PREHOOK: Input: default@orc_llap_part@ctinyint=-57 +PREHOOK: Input: default@orc_llap_part@ctinyint=-58 +PREHOOK: Input: default@orc_llap_part@ctinyint=-59 +PREHOOK: Input: default@orc_llap_part@ctinyint=-6 +PREHOOK: Input: default@orc_llap_part@ctinyint=-60 +PREHOOK: Input: default@orc_llap_part@ctinyint=-61 +PREHOOK: Input: default@orc_llap_part@ctinyint=-62 +PREHOOK: Input: default@orc_llap_part@ctinyint=-63 +PREHOOK: Input: default@orc_llap_part@ctinyint=-64 +PREHOOK: Input: default@orc_llap_part@ctinyint=-7 +PREHOOK: Input: default@orc_llap_part@ctinyint=-8 +PREHOOK: Input: default@orc_llap_part@ctinyint=-9 +PREHOOK: Input: default@orc_llap_part@ctinyint=0 +PREHOOK: Input: default@orc_llap_part@ctinyint=1 +PREHOOK: Input: default@orc_llap_part@ctinyint=10 +PREHOOK: Input: default@orc_llap_part@ctinyint=11 +PREHOOK: Input: default@orc_llap_part@ctinyint=12 +PREHOOK: Input: default@orc_llap_part@ctinyint=13 +PREHOOK: Input: default@orc_llap_part@ctinyint=14 +PREHOOK: Input: default@orc_llap_part@ctinyint=15 +PREHOOK: Input: default@orc_llap_part@ctinyint=16 +PREHOOK: Input: default@orc_llap_part@ctinyint=17 +PREHOOK: Input: default@orc_llap_part@ctinyint=18 +PREHOOK: Input: default@orc_llap_part@ctinyint=19 +PREHOOK: Input: default@orc_llap_part@ctinyint=2 +PREHOOK: Input: default@orc_llap_part@ctinyint=20 +PREHOOK: Input: default@orc_llap_part@ctinyint=21 +PREHOOK: Input: default@orc_llap_part@ctinyint=22 +PREHOOK: Input: default@orc_llap_part@ctinyint=23 +PREHOOK: Input: default@orc_llap_part@ctinyint=24 +PREHOOK: Input: default@orc_llap_part@ctinyint=25 +PREHOOK: Input: default@orc_llap_part@ctinyint=26 +PREHOOK: Input: default@orc_llap_part@ctinyint=27 +PREHOOK: Input: default@orc_llap_part@ctinyint=28 +PREHOOK: Input: default@orc_llap_part@ctinyint=29 +PREHOOK: Input: default@orc_llap_part@ctinyint=3 +PREHOOK: Input: default@orc_llap_part@ctinyint=30 +PREHOOK: Input: default@orc_llap_part@ctinyint=31 +PREHOOK: Input: default@orc_llap_part@ctinyint=32 +PREHOOK: Input: default@orc_llap_part@ctinyint=33 +PREHOOK: Input: default@orc_llap_part@ctinyint=34 +PREHOOK: Input: default@orc_llap_part@ctinyint=35 +PREHOOK: Input: default@orc_llap_part@ctinyint=36 +PREHOOK: Input: default@orc_llap_part@ctinyint=37 +PREHOOK: Input: default@orc_llap_part@ctinyint=38 +PREHOOK: Input: default@orc_llap_part@ctinyint=39 +PREHOOK: Input: default@orc_llap_part@ctinyint=4 +PREHOOK: Input: default@orc_llap_part@ctinyint=40 +PREHOOK: Input: default@orc_llap_part@ctinyint=41 +PREHOOK: Input: default@orc_llap_part@ctinyint=42 +PREHOOK: Input: default@orc_llap_part@ctinyint=43 +PREHOOK: Input: default@orc_llap_part@ctinyint=44 +PREHOOK: Input: default@orc_llap_part@ctinyint=45 +PREHOOK: Input: default@orc_llap_part@ctinyint=46 +PREHOOK: Input: default@orc_llap_part@ctinyint=47 +PREHOOK: Input: default@orc_llap_part@ctinyint=48 +PREHOOK: Input: default@orc_llap_part@ctinyint=49 +PREHOOK: Input: default@orc_llap_part@ctinyint=5 +PREHOOK: Input: default@orc_llap_part@ctinyint=50 +PREHOOK: Input: default@orc_llap_part@ctinyint=51 +PREHOOK: Input: default@orc_llap_part@ctinyint=52 +PREHOOK: Input: default@orc_llap_part@ctinyint=53 +PREHOOK: Input: default@orc_llap_part@ctinyint=54 +PREHOOK: Input: default@orc_llap_part@ctinyint=55 +PREHOOK: Input: default@orc_llap_part@ctinyint=56 +PREHOOK: Input: default@orc_llap_part@ctinyint=57 +PREHOOK: Input: default@orc_llap_part@ctinyint=58 +PREHOOK: Input: default@orc_llap_part@ctinyint=59 +PREHOOK: Input: default@orc_llap_part@ctinyint=6 +PREHOOK: Input: default@orc_llap_part@ctinyint=60 +PREHOOK: Input: default@orc_llap_part@ctinyint=61 +PREHOOK: Input: default@orc_llap_part@ctinyint=62 +PREHOOK: Input: default@orc_llap_part@ctinyint=7 +PREHOOK: Input: default@orc_llap_part@ctinyint=8 +PREHOOK: Input: default@orc_llap_part@ctinyint=9 +PREHOOK: Input: default@orc_llap_part@ctinyint=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail SELECT oft.ctinyint, oft.cint, oft.cchar1, oft.cvchar1 FROM orc_llap_part oft INNER JOIN orc_llap_dim_part od ON oft.ctinyint = od.ctinyint POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_dim_part +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=11 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=12 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=13 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=14 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=15 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=16 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=17 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=18 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=19 +POSTHOOK: Input: default@orc_llap_dim_part@ctinyint=20 +POSTHOOK: Input: default@orc_llap_part +POSTHOOK: Input: default@orc_llap_part@ctinyint=-1 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-10 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-11 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-12 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-13 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-14 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-15 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-16 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-17 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-18 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-19 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-2 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-20 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-21 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-22 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-23 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-24 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-25 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-26 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-27 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-28 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-29 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-3 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-30 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-31 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-32 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-33 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-34 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-35 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-36 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-37 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-38 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-39 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-4 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-40 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-41 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-42 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-43 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-44 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-45 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-46 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-47 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-48 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-49 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-5 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-50 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-51 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-52 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-53 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-54 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-55 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-56 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-57 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-58 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-59 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-6 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-60 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-61 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-62 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-63 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-64 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-7 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-8 +POSTHOOK: Input: default@orc_llap_part@ctinyint=-9 +POSTHOOK: Input: default@orc_llap_part@ctinyint=0 +POSTHOOK: Input: default@orc_llap_part@ctinyint=1 +POSTHOOK: Input: default@orc_llap_part@ctinyint=10 +POSTHOOK: Input: default@orc_llap_part@ctinyint=11 +POSTHOOK: Input: default@orc_llap_part@ctinyint=12 +POSTHOOK: Input: default@orc_llap_part@ctinyint=13 +POSTHOOK: Input: default@orc_llap_part@ctinyint=14 +POSTHOOK: Input: default@orc_llap_part@ctinyint=15 +POSTHOOK: Input: default@orc_llap_part@ctinyint=16 +POSTHOOK: Input: default@orc_llap_part@ctinyint=17 +POSTHOOK: Input: default@orc_llap_part@ctinyint=18 +POSTHOOK: Input: default@orc_llap_part@ctinyint=19 +POSTHOOK: Input: default@orc_llap_part@ctinyint=2 +POSTHOOK: Input: default@orc_llap_part@ctinyint=20 +POSTHOOK: Input: default@orc_llap_part@ctinyint=21 +POSTHOOK: Input: default@orc_llap_part@ctinyint=22 +POSTHOOK: Input: default@orc_llap_part@ctinyint=23 +POSTHOOK: Input: default@orc_llap_part@ctinyint=24 +POSTHOOK: Input: default@orc_llap_part@ctinyint=25 +POSTHOOK: Input: default@orc_llap_part@ctinyint=26 +POSTHOOK: Input: default@orc_llap_part@ctinyint=27 +POSTHOOK: Input: default@orc_llap_part@ctinyint=28 +POSTHOOK: Input: default@orc_llap_part@ctinyint=29 +POSTHOOK: Input: default@orc_llap_part@ctinyint=3 +POSTHOOK: Input: default@orc_llap_part@ctinyint=30 +POSTHOOK: Input: default@orc_llap_part@ctinyint=31 +POSTHOOK: Input: default@orc_llap_part@ctinyint=32 +POSTHOOK: Input: default@orc_llap_part@ctinyint=33 +POSTHOOK: Input: default@orc_llap_part@ctinyint=34 +POSTHOOK: Input: default@orc_llap_part@ctinyint=35 +POSTHOOK: Input: default@orc_llap_part@ctinyint=36 +POSTHOOK: Input: default@orc_llap_part@ctinyint=37 +POSTHOOK: Input: default@orc_llap_part@ctinyint=38 +POSTHOOK: Input: default@orc_llap_part@ctinyint=39 +POSTHOOK: Input: default@orc_llap_part@ctinyint=4 +POSTHOOK: Input: default@orc_llap_part@ctinyint=40 +POSTHOOK: Input: default@orc_llap_part@ctinyint=41 +POSTHOOK: Input: default@orc_llap_part@ctinyint=42 +POSTHOOK: Input: default@orc_llap_part@ctinyint=43 +POSTHOOK: Input: default@orc_llap_part@ctinyint=44 +POSTHOOK: Input: default@orc_llap_part@ctinyint=45 +POSTHOOK: Input: default@orc_llap_part@ctinyint=46 +POSTHOOK: Input: default@orc_llap_part@ctinyint=47 +POSTHOOK: Input: default@orc_llap_part@ctinyint=48 +POSTHOOK: Input: default@orc_llap_part@ctinyint=49 +POSTHOOK: Input: default@orc_llap_part@ctinyint=5 +POSTHOOK: Input: default@orc_llap_part@ctinyint=50 +POSTHOOK: Input: default@orc_llap_part@ctinyint=51 +POSTHOOK: Input: default@orc_llap_part@ctinyint=52 +POSTHOOK: Input: default@orc_llap_part@ctinyint=53 +POSTHOOK: Input: default@orc_llap_part@ctinyint=54 +POSTHOOK: Input: default@orc_llap_part@ctinyint=55 +POSTHOOK: Input: default@orc_llap_part@ctinyint=56 +POSTHOOK: Input: default@orc_llap_part@ctinyint=57 +POSTHOOK: Input: default@orc_llap_part@ctinyint=58 +POSTHOOK: Input: default@orc_llap_part@ctinyint=59 +POSTHOOK: Input: default@orc_llap_part@ctinyint=6 +POSTHOOK: Input: default@orc_llap_part@ctinyint=60 +POSTHOOK: Input: default@orc_llap_part@ctinyint=61 +POSTHOOK: Input: default@orc_llap_part@ctinyint=62 +POSTHOOK: Input: default@orc_llap_part@ctinyint=7 +POSTHOOK: Input: default@orc_llap_part@ctinyint=8 +POSTHOOK: Input: default@orc_llap_part@ctinyint=9 +POSTHOOK: Input: default@orc_llap_part@ctinyint=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -2064,9 +2346,13 @@ POSTHOOK: Lineage: llap_temp_table_n0.cvchar1 SIMPLE [(orc_llap_part)oft.FieldSc PREHOOK: query: explain vectorization detail select sum(hash(*)) from llap_temp_table_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@llap_temp_table_n0 +#### A masked pattern was here #### POSTHOOK: query: explain vectorization detail select sum(hash(*)) from llap_temp_table_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@llap_temp_table_n0 +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_smb.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_smb.q.out b/ql/src/test/results/clientpositive/llap/llap_smb.q.out index 935e772..ed10999 100644 --- a/ql/src/test/results/clientpositive/llap/llap_smb.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_smb.q.out @@ -195,9 +195,55 @@ POSTHOOK: Input: default@orc_b PREHOOK: query: explain select y,q,count(*) from orc_a a join orc_b b on a.id=b.id group by y,q PREHOOK: type: QUERY +PREHOOK: Input: default@orc_a +PREHOOK: Input: default@orc_a@y=2000/q=0 +PREHOOK: Input: default@orc_a@y=2000/q=1 +PREHOOK: Input: default@orc_a@y=2000/q=2 +PREHOOK: Input: default@orc_a@y=2000/q=3 +PREHOOK: Input: default@orc_a@y=2000/q=4 +PREHOOK: Input: default@orc_a@y=2000/q=5 +PREHOOK: Input: default@orc_a@y=2000/q=6 +PREHOOK: Input: default@orc_a@y=2000/q=7 +PREHOOK: Input: default@orc_a@y=2000/q=8 +PREHOOK: Input: default@orc_a@y=2000/q=9 +PREHOOK: Input: default@orc_a@y=2001/q=0 +PREHOOK: Input: default@orc_a@y=2001/q=1 +PREHOOK: Input: default@orc_a@y=2001/q=2 +PREHOOK: Input: default@orc_a@y=2001/q=3 +PREHOOK: Input: default@orc_a@y=2001/q=4 +PREHOOK: Input: default@orc_a@y=2001/q=5 +PREHOOK: Input: default@orc_a@y=2001/q=6 +PREHOOK: Input: default@orc_a@y=2001/q=7 +PREHOOK: Input: default@orc_a@y=2001/q=8 +PREHOOK: Input: default@orc_a@y=2001/q=9 +PREHOOK: Input: default@orc_b +#### A masked pattern was here #### POSTHOOK: query: explain select y,q,count(*) from orc_a a join orc_b b on a.id=b.id group by y,q POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_a +POSTHOOK: Input: default@orc_a@y=2000/q=0 +POSTHOOK: Input: default@orc_a@y=2000/q=1 +POSTHOOK: Input: default@orc_a@y=2000/q=2 +POSTHOOK: Input: default@orc_a@y=2000/q=3 +POSTHOOK: Input: default@orc_a@y=2000/q=4 +POSTHOOK: Input: default@orc_a@y=2000/q=5 +POSTHOOK: Input: default@orc_a@y=2000/q=6 +POSTHOOK: Input: default@orc_a@y=2000/q=7 +POSTHOOK: Input: default@orc_a@y=2000/q=8 +POSTHOOK: Input: default@orc_a@y=2000/q=9 +POSTHOOK: Input: default@orc_a@y=2001/q=0 +POSTHOOK: Input: default@orc_a@y=2001/q=1 +POSTHOOK: Input: default@orc_a@y=2001/q=2 +POSTHOOK: Input: default@orc_a@y=2001/q=3 +POSTHOOK: Input: default@orc_a@y=2001/q=4 +POSTHOOK: Input: default@orc_a@y=2001/q=5 +POSTHOOK: Input: default@orc_a@y=2001/q=6 +POSTHOOK: Input: default@orc_a@y=2001/q=7 +POSTHOOK: Input: default@orc_a@y=2001/q=8 +POSTHOOK: Input: default@orc_a@y=2001/q=9 +POSTHOOK: Input: default@orc_b +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_smb_ptf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_smb_ptf.q.out b/ql/src/test/results/clientpositive/llap/llap_smb_ptf.q.out index 127cef8..6a8b76a 100644 --- a/ql/src/test/results/clientpositive/llap/llap_smb_ptf.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_smb_ptf.q.out @@ -400,6 +400,11 @@ FROM ( ON ( failed_rqst.cogs_alc_rqst_id = status_rqst.cogs_alc_rqst_id ) WHERE failed_rqst.cogs_alc_rqst_id IS NULL PREHOOK: type: QUERY +PREHOOK: Input: default@cogs_alc_rqst +PREHOOK: Input: default@cogs_alc_rqst_trgt_offs +PREHOOK: Input: default@cogs_alc_stat +PREHOOK: Input: default@int_cogs_alc_post_stg +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT status_rqst.* FROM ( @@ -460,6 +465,11 @@ FROM ( ON ( failed_rqst.cogs_alc_rqst_id = status_rqst.cogs_alc_rqst_id ) WHERE failed_rqst.cogs_alc_rqst_id IS NULL POSTHOOK: type: QUERY +POSTHOOK: Input: default@cogs_alc_rqst +POSTHOOK: Input: default@cogs_alc_rqst_trgt_offs +POSTHOOK: Input: default@cogs_alc_stat +POSTHOOK: Input: default@int_cogs_alc_post_stg +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_stats.q.out b/ql/src/test/results/clientpositive/llap/llap_stats.q.out index 87cf04f..5bba6b0 100644 --- a/ql/src/test/results/clientpositive/llap/llap_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_stats.q.out @@ -89,8 +89,54 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### -17 29 7021 PREHOOK: query: explain analyze table llap_stats partition (cint) compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@llap_stats +PREHOOK: Input: default@llap_stats@cint=-13326 +PREHOOK: Input: default@llap_stats@cint=-15431 +PREHOOK: Input: default@llap_stats@cint=-15549 +PREHOOK: Input: default@llap_stats@cint=-15813 +PREHOOK: Input: default@llap_stats@cint=-4213 +PREHOOK: Input: default@llap_stats@cint=-7824 +PREHOOK: Input: default@llap_stats@cint=-9566 +PREHOOK: Input: default@llap_stats@cint=15007 +PREHOOK: Input: default@llap_stats@cint=4963 +PREHOOK: Input: default@llap_stats@cint=7021 +PREHOOK: Output: default@llap_stats +PREHOOK: Output: default@llap_stats@cint=-13326 +PREHOOK: Output: default@llap_stats@cint=-15431 +PREHOOK: Output: default@llap_stats@cint=-15549 +PREHOOK: Output: default@llap_stats@cint=-15813 +PREHOOK: Output: default@llap_stats@cint=-4213 +PREHOOK: Output: default@llap_stats@cint=-7824 +PREHOOK: Output: default@llap_stats@cint=-9566 +PREHOOK: Output: default@llap_stats@cint=15007 +PREHOOK: Output: default@llap_stats@cint=4963 +PREHOOK: Output: default@llap_stats@cint=7021 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain analyze table llap_stats partition (cint) compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@llap_stats +POSTHOOK: Input: default@llap_stats@cint=-13326 +POSTHOOK: Input: default@llap_stats@cint=-15431 +POSTHOOK: Input: default@llap_stats@cint=-15549 +POSTHOOK: Input: default@llap_stats@cint=-15813 +POSTHOOK: Input: default@llap_stats@cint=-4213 +POSTHOOK: Input: default@llap_stats@cint=-7824 +POSTHOOK: Input: default@llap_stats@cint=-9566 +POSTHOOK: Input: default@llap_stats@cint=15007 +POSTHOOK: Input: default@llap_stats@cint=4963 +POSTHOOK: Input: default@llap_stats@cint=7021 +POSTHOOK: Output: default@llap_stats +POSTHOOK: Output: default@llap_stats@cint=-13326 +POSTHOOK: Output: default@llap_stats@cint=-15431 +POSTHOOK: Output: default@llap_stats@cint=-15549 +POSTHOOK: Output: default@llap_stats@cint=-15813 +POSTHOOK: Output: default@llap_stats@cint=-4213 +POSTHOOK: Output: default@llap_stats@cint=-7824 +POSTHOOK: Output: default@llap_stats@cint=-9566 +POSTHOOK: Output: default@llap_stats@cint=15007 +POSTHOOK: Output: default@llap_stats@cint=4963 +POSTHOOK: Output: default@llap_stats@cint=7021 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-2 depends on stages: Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/llap_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_udf.q.out b/ql/src/test/results/clientpositive/llap/llap_udf.q.out index df3205d..292c0f9 100644 --- a/ql/src/test/results/clientpositive/llap/llap_udf.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_udf.q.out @@ -22,8 +22,12 @@ POSTHOOK: type: CREATEFUNCTION POSTHOOK: Output: test_udf0 PREHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n0 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n0 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -84,9 +88,13 @@ POSTHOOK: Output: default.test_udf4 PREHOOK: query: EXPLAIN SELECT test_udf2(cast(key as string)), test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n0 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT test_udf2(cast(key as string)), test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n0 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -124,9 +132,13 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n0 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n0 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -171,9 +183,13 @@ POSTHOOK: Output: default.test_udf2 PREHOOK: query: EXPLAIN SELECT test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n0 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n0 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -219,9 +235,13 @@ POSTHOOK: Output: default.test_udf4 PREHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n0 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n0 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -258,9 +278,13 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT test_udf3(cast(key as string)) from src_orc_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n0 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT test_udf3(cast(key as string)) from src_orc_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n0 +POSTHOOK: Output: hdfs://### HDFS PATH ### 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/b356aae0/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out b/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out index fb90b60..585384a 100644 --- a/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_uncompressed.q.out @@ -107,9 +107,13 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: explain select * from orc_llap_n0 where cint > 10 and cbigint is not null PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from orc_llap_n0 where cint > 10 and cbigint is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -166,9 +170,13 @@ POSTHOOK: Input: default@llap_temp_table PREHOOK: query: explain select * from orc_llap_n0 where cint > 10 and cint < 5000000 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select * from orc_llap_n0 where cint > 10 and cint < 5000000 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out b/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out index b3b2dcc..5243c26 100644 --- a/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out @@ -6,6 +6,8 @@ select count(*) from on cd.cint = c.cint where c.cint < 2000000000) t1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select count(*) from (select c.ctinyint @@ -14,6 +16,8 @@ select count(*) from on cd.cint = c.cint where c.cint < 2000000000) t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### PLAN VECTORIZATION: enabled: true enabledConditionsMet: [hive.vectorized.execution.enabled IS true] @@ -185,6 +189,8 @@ select count(*) from on cd.cint = c.cint where c.cint < 2000000000) t1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain vectorization expression select count(*) from (select c.ctinyint @@ -193,6 +199,8 @@ select count(*) from on cd.cint = c.cint where c.cint < 2000000000) t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### 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/b356aae0/ql/src/test/results/clientpositive/llap/llapdecider.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llapdecider.q.out b/ql/src/test/results/clientpositive/llap/llapdecider.q.out index 64ed44d..51d841f 100644 --- a/ql/src/test/results/clientpositive/llap/llapdecider.q.out +++ b/ql/src/test/results/clientpositive/llap/llapdecider.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 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -86,8 +90,12 @@ POSTHOOK: Lineage: src_orc_n2.key SIMPLE [(src)src.FieldSchema(name:key, type:st POSTHOOK: Lineage: src_orc_n2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src_orc_n2 GROUP BY key ORDER BY cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src_orc_n2 GROUP BY key ORDER BY cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -160,8 +168,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src_orc_n2 GROUP BY key ORDER BY cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src_orc_n2 GROUP BY key ORDER BY cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -245,8 +257,12 @@ POSTHOOK: Output: default@src_orc_n2 POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src_orc_n2 GROUP BY key ORDER BY cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src_orc_n2 GROUP BY key ORDER BY cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -320,8 +336,14 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 join src on (src_orc_n2.key = src.key) order by src.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 join src on (src_orc_n2.key = src.key) order by src.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -412,8 +434,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -506,8 +532,14 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 join src on (src_orc_n2.key = src.key) order by src.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 join src on (src_orc_n2.key = src.key) order by src.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -599,8 +631,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -690,8 +726,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -781,8 +821,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -874,8 +918,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -965,8 +1013,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT * from src_orc_n2 s1 join src_orc_n2 s2 on (s1.key = s2.key) order by s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1065,8 +1117,12 @@ POSTHOOK: type: CREATEFUNCTION POSTHOOK: Output: test_udf_get_java_string PREHOOK: query: EXPLAIN SELECT sum(cast(key as int) + 1) from src_orc_n2 where cast(key as int) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT sum(cast(key as int) + 1) from src_orc_n2 where cast(key as int) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1126,8 +1182,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT sum(cast(test_udf_get_java_string(cast(key as string)) as int) + 1) from src_orc_n2 where cast(key as int) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT sum(cast(test_udf_get_java_string(cast(key as string)) as int) + 1) from src_orc_n2 where cast(key as int) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1186,8 +1246,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT sum(cast(key as int) + 1) from src_orc_n2 where cast(test_udf_get_java_string(cast(key as string)) as int) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT sum(cast(key as int) + 1) from src_orc_n2 where cast(test_udf_get_java_string(cast(key as string)) as int) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1246,8 +1310,12 @@ STAGE PLANS: PREHOOK: query: EXPLAIN SELECT sum(cast(test_udf_get_java_string(cast(key as string)) as int) + 1) from src_orc_n2 where cast(key as int) > 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_n2 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: EXPLAIN SELECT sum(cast(test_udf_get_java_string(cast(key as string)) as int) + 1) from src_orc_n2 where cast(key as int) > 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_n2 +POSTHOOK: Output: hdfs://### HDFS PATH ### 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/b356aae0/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out b/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out index 21fd933..765ffdf 100644 --- a/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out +++ b/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out @@ -8,8 +8,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_n8 partition(ds='2008-04-08') PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_n8 partition(ds='2008-04-08') POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin_n8 STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 @@ -186,8 +190,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/load_data_1_partition.txt' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/load_data_1_partition.txt' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -394,8 +401,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/load_data_2_partitions.txt' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/load_data_2_partitions.txt' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -608,8 +618,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/subdir' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/subdir' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -940,8 +953,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/bucketing.txt' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/bucketing.txt' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +POSTHOOK: Output: default@srcbucket_mapjoin_n8 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1160,8 +1177,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/load_data_1_partition.txt' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/load_data_1_partition.txt' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1384,8 +1404,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/load_data_2_partitions.txt' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/load_data_2_partitions.txt' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1614,8 +1637,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/subdir' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/subdir' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1962,8 +1988,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2546,8 +2575,11 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@srcbucket_mapjoin_n8 PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/load_data_2_partitions.txt' INTO TABLE srcbucket_mapjoin_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/partitions/load_data_2_partitions.txt' INTO TABLE srcbucket_mapjoin_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2779,10 +2811,13 @@ PREHOOK: query: explain load data local inpath '../../data/files/load_data_job/l INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ +PREHOOK: Output: default@srcbucket_mapjoin_n8 POSTHOOK: query: explain load data local inpath '../../data/files/load_data_job/load_data_1_partition.txt' INTO TABLE srcbucket_mapjoin_n8 INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n8__temp_table_for_load_data__ 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/b356aae0/ql/src/test/results/clientpositive/llap/load_dyn_part1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part1.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part1.q.out index 680f82c..32fef81 100644 --- a/ql/src/test/results/clientpositive/llap/load_dyn_part1.q.out +++ b/ql/src/test/results/clientpositive/llap/load_dyn_part1.q.out @@ -46,11 +46,23 @@ from srcpart insert overwrite table nzhang_part1_n0 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08' insert overwrite table nzhang_part2_n0 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +PREHOOK: Output: default@nzhang_part1_n0 +PREHOOK: Output: default@nzhang_part2_n0@ds=2008-12-31 POSTHOOK: query: explain from srcpart insert overwrite table nzhang_part1_n0 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08' insert overwrite table nzhang_part2_n0 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out index d0293eb..245ca30 100644 --- a/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out +++ b/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out @@ -30,9 +30,20 @@ hr string PREHOOK: query: explain insert overwrite table nzhang_part_bucket partition (ds='2010-03-23', hr) select key, value, hr from srcpart where ds is not null and hr is not null PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +PREHOOK: Output: default@nzhang_part_bucket@ds=2010-03-23 POSTHOOK: query: explain insert overwrite table nzhang_part_bucket partition (ds='2010-03-23', hr) select key, value, hr from srcpart where ds is not null and hr is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1