http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/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 3647acf..79199b8 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/b356aae0/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/b356aae0/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/b356aae0/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/b356aae0/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out b/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out index f770fe4..1811f23 100644 --- a/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out +++ b/ql/src/test/results/clientpositive/llap/metadata_only_queries.q.out @@ -179,9 +179,13 @@ POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k_n12)ove PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -243,9 +247,19 @@ STAGE PLANS: PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +PREHOOK: Input: default@stats_tbl_part@dt=2010 +PREHOOK: Input: default@stats_tbl_part@dt=2011 +PREHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +POSTHOOK: Input: default@stats_tbl_part@dt=2010 +POSTHOOK: Input: default@stats_tbl_part@dt=2011 +POSTHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -307,9 +321,13 @@ STAGE PLANS: PREHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -371,9 +389,19 @@ STAGE PLANS: PREHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +PREHOOK: Input: default@stats_tbl_part@dt=2010 +PREHOOK: Input: default@stats_tbl_part@dt=2011 +PREHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), '1' as one, sum(1), sum(0.2), 2 as two, count(1), count(s), 3+4.0 as three, count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +POSTHOOK: Input: default@stats_tbl_part@dt=2010 +POSTHOOK: Input: default@stats_tbl_part@dt=2011 +POSTHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -487,9 +515,13 @@ POSTHOOK: Output: default@stats_tbl_part@dt=2012 PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -512,9 +544,13 @@ POSTHOOK: Input: default@stats_tbl PREHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -537,9 +573,13 @@ POSTHOOK: Input: default@stats_tbl PREHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -562,9 +602,13 @@ POSTHOOK: Input: default@stats_tbl PREHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -587,9 +631,13 @@ POSTHOOK: Input: default@stats_tbl_part PREHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), max(i), min(b), max(b), min(f), max(f), min(d), max(d) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -612,9 +660,13 @@ POSTHOOK: Input: default@stats_tbl_part PREHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select min(i), '1' as one, max(i), min(b), max(b), min(f), max(f), 3+4.0 as three, min(d), max(d) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -636,8 +688,18 @@ POSTHOOK: Input: default@stats_tbl_part 65536 1 65791 4294967296 4294967551 0.01 99.98 7 0.01 50.0 PREHOOK: query: explain select count(ts) from stats_tbl_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +PREHOOK: Input: default@stats_tbl_part@dt=2010 +PREHOOK: Input: default@stats_tbl_part@dt=2011 +PREHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### POSTHOOK: query: explain select count(ts) from stats_tbl_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +POSTHOOK: Input: default@stats_tbl_part@dt=2010 +POSTHOOK: Input: default@stats_tbl_part@dt=2011 +POSTHOOK: Input: default@stats_tbl_part@dt=2012 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -694,8 +756,12 @@ STAGE PLANS: PREHOOK: query: explain select count('1') from stats_tbl group by '1' PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl +#### A masked pattern was here #### POSTHOOK: query: explain select count('1') from stats_tbl group by '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -717,8 +783,12 @@ POSTHOOK: Input: default@stats_tbl 9999 PREHOOK: query: explain select count('1') from stats_tbl_part group by '1' PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### POSTHOOK: query: explain select count('1') from stats_tbl_part group by '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out index 6be0911..6383d0a 100644 --- a/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out +++ b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out @@ -153,9 +153,13 @@ POSTHOOK: Output: default@stats_tbl_part_n0@dt=2014 PREHOOK: query: explain select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt = 2010 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt = 2010 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -178,9 +182,13 @@ POSTHOOK: Input: default@stats_tbl_part_n0 PREHOOK: query: explain select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt > 2010 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt > 2010 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/metadataonly1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out index 0cf0693..11634d5 100644 --- a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out +++ b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out @@ -8,8 +8,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@TEST1_n12 PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT MAX(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -104,8 +108,14 @@ POSTHOOK: Output: default@test1_n12 POSTHOOK: Output: default@test1_n12@ds=1 PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT MAX(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -247,8 +257,14 @@ POSTHOOK: Input: default@test1_n12@ds=1 NULL PREHOOK: query: explain extended select count(distinct ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(distinct ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(DISTINCT `ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -391,8 +407,14 @@ POSTHOOK: Input: default@test1_n12@ds=1 0 PREHOOK: query: explain extended select count(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -543,9 +565,17 @@ POSTHOOK: Output: default@test1_n12@ds=2 PREHOOK: query: explain extended select count(*) from TEST1_n12 a2 join (select max(ds) m from TEST1_n12) b on a2.ds=b.m PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +PREHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from TEST1_n12 a2 join (select max(ds) m from TEST1_n12) b on a2.ds=b.m POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +POSTHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM (SELECT `ds` FROM `default`.`test1_n12` @@ -958,8 +988,18 @@ POSTHOOK: Output: default@test2_n8 POSTHOOK: Output: default@test2_n8@ds=1/hr=3 PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `ds`, COUNT(DISTINCT `hr`) AS `$f1` FROM `default`.`test2_n8` GROUP BY `ds` @@ -1209,8 +1249,18 @@ POSTHOOK: Input: default@test2_n8@ds=1/hr=3 #### A masked pattern was here #### PREHOOK: query: explain extended select ds, count(hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `ds`, COUNT(`hr`) AS `$f1` FROM `default`.`test2_n8` GROUP BY `ds` @@ -1462,8 +1512,16 @@ POSTHOOK: Input: default@test2_n8@ds=1/hr=3 #### A masked pattern was here #### PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +PREHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +POSTHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT MAX(`ds`) AS `$f0` FROM `default`.`test1_n12` STAGE DEPENDENCIES: @@ -1705,8 +1763,22 @@ POSTHOOK: Output: default@test2_n8 POSTHOOK: Output: default@test2_n8@ds=01%3A10%3A20/hr=02 PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=01%3A10%3A10/hr=01 +PREHOOK: Input: default@test2_n8@ds=01%3A10%3A20/hr=02 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=01%3A10%3A10/hr=01 +POSTHOOK: Input: default@test2_n8@ds=01%3A10%3A20/hr=02 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `ds`, COUNT(DISTINCT `hr`) AS `$f1` FROM `default`.`test2_n8` GROUP BY `ds` http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/mm_all.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mm_all.q.out b/ql/src/test/results/clientpositive/llap/mm_all.q.out index 95734b6..98fac89 100644 --- a/ql/src/test/results/clientpositive/llap/mm_all.q.out +++ b/ql/src/test/results/clientpositive/llap/mm_all.q.out @@ -51,8 +51,18 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm_n0 PREHOOK: query: explain insert into table part_mm_n0 partition(key_mm=455) select key from intermediate_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@intermediate_n0 +PREHOOK: Input: default@intermediate_n0@p=455 +PREHOOK: Input: default@intermediate_n0@p=456 +PREHOOK: Input: default@intermediate_n0@p=457 +PREHOOK: Output: default@part_mm_n0@key_mm=455 POSTHOOK: query: explain insert into table part_mm_n0 partition(key_mm=455) select key from intermediate_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@intermediate_n0 +POSTHOOK: Input: default@intermediate_n0@p=455 +POSTHOOK: Input: default@intermediate_n0@p=456 +POSTHOOK: Input: default@intermediate_n0@p=457 +POSTHOOK: Output: default@part_mm_n0@key_mm=455 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/mm_bhif.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mm_bhif.q.out b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out index f6a7ed3..953b433 100644 --- a/ql/src/test/results/clientpositive/llap/mm_bhif.q.out +++ b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out @@ -48,9 +48,15 @@ POSTHOOK: Input: default@t1_mm@ds=1 PREHOOK: query: explain select count(distinct key) from T1_mm PREHOOK: type: QUERY +PREHOOK: Input: default@t1_mm +PREHOOK: Input: default@t1_mm@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(distinct key) from T1_mm POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_mm +POSTHOOK: Input: default@t1_mm@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/mrr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mrr.q.out b/ql/src/test/results/clientpositive/llap/mrr.q.out index 2a8a2fc..8ce190d 100644 --- a/ql/src/test/results/clientpositive/llap/mrr.q.out +++ b/ql/src/test/results/clientpositive/llap/mrr.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -392,8 +396,12 @@ POSTHOOK: Input: default@src 98 2 PREHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -826,8 +834,12 @@ POSTHOOK: Input: default@src 98 1 PREHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1267,6 +1279,8 @@ WHERE s1.cnt > 1 ORDER BY s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM @@ -1283,6 +1297,8 @@ WHERE s1.cnt > 1 ORDER BY s1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1604,12 +1620,16 @@ FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src ON (s1.key = src.key) order by s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src ON (s1.key = src.key) order by s1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out index f8adcd4..b29f0dd 100644 --- a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out @@ -166,6 +166,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM (select bigTbl.key as key, bigTbl.value as value1, @@ -175,6 +179,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -329,6 +337,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM (select bigTbl.key as key, bigTbl.value as value1, @@ -338,6 +350,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -493,6 +509,10 @@ JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) group by smallTbl2.key PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM (select bigTbl.key as key, bigTbl.value as value1, @@ -503,6 +523,10 @@ JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) group by smallTbl2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -775,6 +799,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -808,6 +838,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1110,6 +1146,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -1143,6 +1185,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1445,6 +1493,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -1478,6 +1532,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1811,6 +1871,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -1844,6 +1910,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### 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/multiMapJoin2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out index 61b7c4e..7252811 100644 --- a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out +++ b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out @@ -5,6 +5,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp.key FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) @@ -12,6 +15,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -243,6 +249,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp.key FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) @@ -250,6 +259,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -493,6 +505,9 @@ FROM (SELECT x1.key AS key FROM src1 x1 GROUP BY x1.key SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp.key FROM (SELECT x1.key AS key FROM src1 x1 GROUP BY x1.key @@ -500,6 +515,9 @@ FROM (SELECT x1.key AS key FROM src1 x1 GROUP BY x1.key SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -701,6 +719,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -713,6 +734,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -941,6 +965,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -953,6 +980,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1181,6 +1211,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -1193,6 +1226,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1405,6 +1441,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -1417,6 +1456,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1662,10 +1704,20 @@ PREHOOK: query: EXPLAIN SELECT count(*) FROM part_table_n0 x JOIN src1 y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@part_table_n0 +PREHOOK: Input: default@part_table_n0@partitionid=1 +PREHOOK: Input: default@part_table_n0@partitionid=2 +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(*) FROM part_table_n0 x JOIN src1 y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part_table_n0 +POSTHOOK: Input: default@part_table_n0@partitionid=1 +POSTHOOK: Input: default@part_table_n0@partitionid=2 +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1781,6 +1833,8 @@ SELECT x.key FROM ( JOIN src c ON tmp.key=c.key ) x order by x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key FROM ( SELECT c.key FROM @@ -1792,6 +1846,8 @@ SELECT x.key FROM ( JOIN src c ON tmp.key=c.key ) x order by x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/multi_column_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out index f6b6fec..141cc16 100644 --- a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out @@ -104,9 +104,13 @@ POSTHOOK: Input: default@emps_n1 PREHOOK: query: explain select * from emps_n1 where (empno+1,deptno) in ((1,2),(3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n1 where (empno+1,deptno) in ((1,2),(3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -127,9 +131,13 @@ STAGE PLANS: PREHOOK: query: explain select * from emps_n1 where (empno+1,deptno) not in ((1,2),(3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n1 where (empno+1,deptno) not in ((1,2),(3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -195,8 +203,12 @@ POSTHOOK: Input: default@emps_n1 2 5 22 PREHOOK: query: explain select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n1 +#### 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/multi_column_in_single.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out index 81fdb13..72f532a 100644 --- a/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out @@ -114,9 +114,13 @@ POSTHOOK: Input: default@emps_n7 PREHOOK: query: explain select * from emps_n7 where (empno+1,deptno) in ((3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n7 where (empno+1,deptno) in ((3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -137,9 +141,13 @@ STAGE PLANS: PREHOOK: query: explain select * from emps_n7 where (empno+1,deptno) not in ((3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n7 where (empno+1,deptno) not in ((3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -159,8 +167,12 @@ STAGE PLANS: PREHOOK: query: explain select * from emps_n7 where ((empno*2)|1,deptno) in ((empno+2,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n7 where ((empno*2)|1,deptno) in ((empno+2,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n7 +#### 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/multi_count_distinct_null.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out index 9633ae0..a049b02 100644 --- a/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out @@ -23,8 +23,12 @@ POSTHOOK: Lineage: employee.education_level SCRIPT [] POSTHOOK: Lineage: employee.gender SCRIPT [] PREHOOK: query: explain select count(distinct department_id), count(distinct gender), count(distinct education_level) from employee PREHOOK: type: QUERY +PREHOOK: Input: default@employee +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select count(distinct department_id), count(distinct gender), count(distinct education_level) from employee POSTHOOK: type: QUERY +POSTHOOK: Input: default@employee +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -163,9 +167,13 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select count(distinct gender), count(distinct department_id), count(distinct gender), count(distinct education_level), count(distinct education_level, department_id), count(distinct department_id, education_level), count(distinct department_id, education_level, gender) from employee PREHOOK: type: QUERY +PREHOOK: Input: default@employee +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select count(distinct gender), count(distinct department_id), count(distinct gender), count(distinct education_level), count(distinct education_level, department_id), count(distinct department_id, education_level), count(distinct department_id, education_level, gender) from employee POSTHOOK: type: QUERY +POSTHOOK: Input: default@employee +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/multi_insert.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_insert.q.out b/ql/src/test/results/clientpositive/llap/multi_insert.q.out index 53ae291..11462f8 100644 --- a/ql/src/test/results/clientpositive/llap/multi_insert.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_insert.q.out @@ -19,11 +19,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -232,11 +238,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -445,11 +457,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -658,11 +676,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -871,11 +895,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1093,11 +1123,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1315,11 +1351,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1537,11 +1579,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1759,11 +1807,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2050,11 +2104,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2341,11 +2401,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2632,11 +2698,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2923,10 +2995,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -3026,10 +3102,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -3129,10 +3209,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -3232,10 +3316,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out b/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out index 74a6945..ecca6ea 100644 --- a/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out @@ -39,11 +39,17 @@ from src_10_n0 insert overwrite table src_lv1 select key, C lateral view explode(array(key+1, key+2)) A as C insert overwrite table src_lv2 select key, C lateral view explode(array(key+3, key+4)) A as C PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, C lateral view explode(array(key+1, key+2)) A as C insert overwrite table src_lv2 select key, C lateral view explode(array(key+3, key+4)) A as C POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -355,11 +361,17 @@ from src_10_n0 insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key insert overwrite table src_lv2 select key, sum(C) lateral view explode(array(key+3, key+4)) A as C group by key PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key insert overwrite table src_lv2 select key, sum(C) lateral view explode(array(key+3, key+4)) A as C group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -670,12 +682,20 @@ insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key insert overwrite table src_lv2 select key, count(value) where key > 200 group by key insert overwrite table src_lv3 select key, count(value) where key < 200 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 +PREHOOK: Output: default@src_lv3 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key insert overwrite table src_lv2 select key, count(value) where key > 200 group by key insert overwrite table src_lv3 select key, count(value) where key < 200 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 +POSTHOOK: Output: default@src_lv3 STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -1041,12 +1061,20 @@ insert overwrite table src_lv1 select C, sum(distinct key) lateral view explode( insert overwrite table src_lv2 select C, sum(distinct key) lateral view explode(array(key+3, key+4)) A as C group by C insert overwrite table src_lv3 select value, sum(distinct key) group by value PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 +PREHOOK: Output: default@src_lv3 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select C, sum(distinct key) lateral view explode(array(key+1, key+2)) A as C group by C insert overwrite table src_lv2 select C, sum(distinct key) lateral view explode(array(key+3, key+4)) A as C group by C insert overwrite table src_lv3 select value, sum(distinct key) group by value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 +POSTHOOK: Output: default@src_lv3 STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -1492,6 +1520,11 @@ insert overwrite table src_lv2 select key, sum(distinct C) lateral view explode( insert overwrite table src_lv3 select value, sum(distinct key) where key > 200 group by value insert overwrite table src_lv4 select value, sum(distinct key) where key < 200 group by value PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 +PREHOOK: Output: default@src_lv3 +PREHOOK: Output: default@src_lv4 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, sum(distinct C) lateral view explode(array(key+1, key+2)) A as C group by key @@ -1499,6 +1532,11 @@ insert overwrite table src_lv2 select key, sum(distinct C) lateral view explode( insert overwrite table src_lv3 select value, sum(distinct key) where key > 200 group by value insert overwrite table src_lv4 select value, sum(distinct key) where key < 200 group by value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 +POSTHOOK: Output: default@src_lv3 +POSTHOOK: Output: default@src_lv4 STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/murmur_hash_migration.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/murmur_hash_migration.q.out b/ql/src/test/results/clientpositive/llap/murmur_hash_migration.q.out index cb2169f..b211694 100644 --- a/ql/src/test/results/clientpositive/llap/murmur_hash_migration.q.out +++ b/ql/src/test/results/clientpositive/llap/murmur_hash_migration.q.out @@ -148,10 +148,16 @@ PREHOOK: query: explain insert overwrite table tab_part_n11 partition (ds='2008-04-08') select key,value from srcbucket_mapjoin_part_n20 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_part_n20 +PREHOOK: Input: default@srcbucket_mapjoin_part_n20@ds=2008-04-08 +PREHOOK: Output: default@tab_part_n11@ds=2008-04-08 POSTHOOK: query: explain insert overwrite table tab_part_n11 partition (ds='2008-04-08') select key,value from srcbucket_mapjoin_part_n20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_part_n20 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n20@ds=2008-04-08 +POSTHOOK: Output: default@tab_part_n11@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -243,10 +249,16 @@ PREHOOK: query: explain insert overwrite table tab_n10 partition (ds='2008-04-08') select key,value from srcbucket_mapjoin_n18 PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n18 +PREHOOK: Input: default@srcbucket_mapjoin_n18@ds=2008-04-08 +PREHOOK: Output: default@tab_n10@ds=2008-04-08 POSTHOOK: query: explain insert overwrite table tab_n10 partition (ds='2008-04-08') select key,value from srcbucket_mapjoin_n18 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n18 +POSTHOOK: Input: default@srcbucket_mapjoin_n18@ds=2008-04-08 +POSTHOOK: Output: default@tab_n10@ds=2008-04-08 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -357,9 +369,19 @@ POSTHOOK: Output: default@tab_n10@ds=2008-04-08 PREHOOK: query: explain select t1.key, t1.value, t2.key, t2.value from srcbucket_mapjoin_n18 t1, srcbucket_mapjoin_part_n20 t2 where t1.key = t2.key order by t1.key, t1.value, t2.key, t2.value PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n18 +PREHOOK: Input: default@srcbucket_mapjoin_n18@ds=2008-04-08 +PREHOOK: Input: default@srcbucket_mapjoin_part_n20 +PREHOOK: Input: default@srcbucket_mapjoin_part_n20@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select t1.key, t1.value, t2.key, t2.value from srcbucket_mapjoin_n18 t1, srcbucket_mapjoin_part_n20 t2 where t1.key = t2.key order by t1.key, t1.value, t2.key, t2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n18 +POSTHOOK: Input: default@srcbucket_mapjoin_n18@ds=2008-04-08 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n20 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n20@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -486,9 +508,19 @@ POSTHOOK: Input: default@srcbucket_mapjoin_part_n20@ds=2008-04-08 PREHOOK: query: explain select t1.key, t1.value, t2.key, t2.value from tab_part_n11 t1, tab_n10 t2 where t1.key = t2.key order by t1.key, t1.value, t2.key, t2.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n10 +PREHOOK: Input: default@tab_n10@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n11 +PREHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select t1.key, t1.value, t2.key, t2.value from tab_part_n11 t1, tab_n10 t2 where t1.key = t2.key order by t1.key, t1.value, t2.key, t2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n10 +POSTHOOK: Input: default@tab_n10@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n11 +POSTHOOK: Input: default@tab_part_n11@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
