http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/explainuser_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out index 2b69d01..a51b1ad 100644 --- a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out +++ b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out @@ -1,7 +1,11 @@ PREHOOK: query: explain create table src_orc_merge_test_part_n1(key int, value string) partitioned by (ds string, ts string) stored as orc PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@src_orc_merge_test_part_n1 POSTHOOK: query: explain create table src_orc_merge_test_part_n1(key int, value string) partitioned by (ds string, ts string) stored as orc POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_orc_merge_test_part_n1 Stage-0 Create Table Operator: name:default.src_orc_merge_test_part_n1 @@ -40,8 +44,12 @@ ts string #### A masked pattern was here #### PREHOOK: query: explain insert overwrite table src_orc_merge_test_part_n1 partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 POSTHOOK: query: explain insert overwrite table src_orc_merge_test_part_n1 partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 Plan optimized by CBO. Vertex dependency in root stage @@ -88,8 +96,12 @@ POSTHOOK: Lineage: src_orc_merge_test_part_n1 PARTITION(ds=2012-01-03,ts=2012-01 POSTHOOK: Lineage: src_orc_merge_test_part_n1 PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain insert into table src_orc_merge_test_part_n1 partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 POSTHOOK: query: explain insert into table src_orc_merge_test_part_n1 partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 Plan optimized by CBO. Vertex dependency in root stage @@ -137,8 +149,12 @@ Stage-3 PREHOOK: query: explain select count(1) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part_n1 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -147,8 +163,14 @@ Stage-0 PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part_n1 +PREHOOK: Input: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part_n1 +POSTHOOK: Input: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -181,8 +203,14 @@ POSTHOOK: Input: default@src_orc_merge_test_part_n1 POSTHOOK: Output: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 PREHOOK: query: explain select count(1) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part_n1 +PREHOOK: Input: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part_n1 +POSTHOOK: Input: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -206,8 +234,14 @@ Stage-0 PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part_n1 +PREHOOK: Input: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part_n1 where ds='2012-01-03' and ts='2012-01-03+14:46:31' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part_n1 +POSTHOOK: Input: default@src_orc_merge_test_part_n1@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -249,6 +283,8 @@ select src1.key as k1, src1.value as v1, SORT BY k1, v1, k2, v2 ) a PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(a.k1,a.v1,a.k2, a.v2)) from ( select src1.key as k1, src1.value as v1, @@ -259,6 +295,8 @@ select src1.key as k1, src1.value as v1, SORT BY k1, v1, k2, v2 ) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -298,8 +336,14 @@ Stage-0 PREHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1 group by c_float, cbo_t1.c_int, key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1 group by c_float, cbo_t1.c_int, key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -327,8 +371,14 @@ Stage-0 PREHOOK: query: explain select x, y, count(*) from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float, cbo_t1.c_int, key) R group by y, x PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select x, y, count(*) from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float, cbo_t1.c_int, key) R group by y, x POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -366,8 +416,20 @@ Stage-0 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key order by a) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key order by a) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -444,8 +506,20 @@ Stage-0 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b % c asc, b desc) cbo_t1 left outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p left outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by cbo_t3.c_int % c asc, cbo_t3.c_int desc PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b % c asc, b desc) cbo_t1 left outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p left outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by cbo_t3.c_int % c asc, cbo_t3.c_int desc POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -522,8 +596,20 @@ Stage-0 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b+c, a desc) cbo_t1 right outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 2) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b+c, a desc) cbo_t1 right outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 2) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -593,8 +679,20 @@ Stage-0 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by c+a desc) cbo_t1 full outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by p+q desc, r asc) cbo_t2 on cbo_t1.a=p full outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by cbo_t3.c_int PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by c+a desc) cbo_t1 full outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by p+q desc, r asc) cbo_t2 on cbo_t1.a=p full outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by cbo_t3.c_int POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -669,8 +767,20 @@ Stage-0 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -740,8 +850,12 @@ Stage-0 PREHOOK: query: explain select unionsrc.key FROM (select 'tst1' as key, count(1) as value from src) unionsrc PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select unionsrc.key FROM (select 'tst1' as key, count(1) as value from src) unionsrc POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -754,12 +868,16 @@ PREHOOK: query: explain select unionsrc.key FROM (select 'max' as key, max(c_int UNION ALL select 'avg' as key, avg(c_int) as value from cbo_t3 s3) unionsrc order by unionsrc.key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select unionsrc.key FROM (select 'max' as key, max(c_int) as value from cbo_t3 s1 UNION ALL select 'min' as key, min(c_int) as value from cbo_t3 s2 UNION ALL select 'avg' as key, avg(c_int) as value from cbo_t3 s3) unionsrc order by unionsrc.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -826,12 +944,16 @@ PREHOOK: query: explain select unionsrc.key, count(1) FROM (select 'max' as key, UNION ALL select 'avg' as key, avg(c_int) as value from cbo_t3 s3) unionsrc group by unionsrc.key order by unionsrc.key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select unionsrc.key, count(1) FROM (select 'max' as key, max(c_int) as value from cbo_t3 s1 UNION ALL select 'min' as key, min(c_int) as value from cbo_t3 s2 UNION ALL select 'avg' as key, avg(c_int) as value from cbo_t3 s3) unionsrc group by unionsrc.key order by unionsrc.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -908,8 +1030,16 @@ Stage-0 PREHOOK: query: explain select cbo_t1.key from cbo_t1 join cbo_t3 where cbo_t1.key=cbo_t3.key and cbo_t1.key >= 1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t1.key from cbo_t1 join cbo_t3 where cbo_t1.key=cbo_t3.key and cbo_t1.key >= 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -944,8 +1074,18 @@ Stage-0 PREHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left outer join cbo_t2 on cbo_t1.key=cbo_t2.key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left outer join cbo_t2 on cbo_t1.key=cbo_t2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -978,8 +1118,18 @@ Stage-0 PREHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join cbo_t2 on cbo_t1.key=cbo_t2.key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join cbo_t2 on cbo_t1.key=cbo_t2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1012,8 +1162,20 @@ Stage-0 PREHOOK: query: explain select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1059,8 +1221,20 @@ Stage-0 PREHOOK: query: explain select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c from cbo_t3)cbo_t3 on cbo_t1.key=a PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c from cbo_t3)cbo_t3 on cbo_t1.key=a POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1106,8 +1280,20 @@ Stage-0 PREHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 full outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 full outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1153,8 +1339,20 @@ Stage-0 PREHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 right outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 right outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0 or c_int >= 0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1200,8 +1398,14 @@ Stage-0 PREHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1 group by c_float, cbo_t1.c_int, key order by x limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1 group by c_float, cbo_t1.c_int, key order by x limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1236,8 +1440,14 @@ Stage-0 PREHOOK: query: explain select x, y, count(*) from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float, cbo_t1.c_int, key) R group by y, x order by x,y limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select x, y, count(*) from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float, cbo_t1.c_int, key) R group by y, x order by x,y limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1282,8 +1492,14 @@ Stage-0 PREHOOK: query: explain select key from(select key from (select key from cbo_t1 limit 5)cbo_t2 limit 5)cbo_t3 limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select key from(select key from (select key from cbo_t1 limit 5)cbo_t2 limit 5)cbo_t3 limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -1298,8 +1514,14 @@ Stage-0 PREHOOK: query: explain select key, c_int from(select key, c_int from (select key, c_int from cbo_t1 order by c_int limit 5)cbo_t1 order by c_int limit 5)cbo_t2 order by c_int limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select key, c_int from(select key, c_int from (select key, c_int from cbo_t1 order by c_int limit 5)cbo_t1 order by c_int limit 5)cbo_t2 order by c_int limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1338,8 +1560,20 @@ Stage-0 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key order by a limit 5) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc limit 5) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c limit 5 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key order by a limit 5) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc limit 5) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c limit 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1436,8 +1670,18 @@ Stage-0 PREHOOK: query: explain select cbo_t1.c_int from cbo_t1 left semi join cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t1.c_int from cbo_t1 left semi join cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1476,8 +1720,20 @@ Stage-0 PREHOOK: query: explain select * from (select c, b, a from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 left semi join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 == 2) and (b > 0 or c >= 0)) R where (b + 1 = 2) and (R.b > 0 or c >= 0) PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select c, b, a from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 left semi join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 == 2) and (b > 0 or c >= 0)) R where (b + 1 = 2) and (R.b > 0 or c >= 0) POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1527,8 +1783,20 @@ Stage-0 PREHOOK: query: explain select a, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by a+b desc, c asc) cbo_t1 left semi join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by q+r/10 desc, p) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a > 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, a PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +PREHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: explain select a, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by a+b desc, c asc) cbo_t1 left semi join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by q+r/10 desc, p) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a > 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, a POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +POSTHOOK: Input: default@cbo_t3 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1611,8 +1879,14 @@ Stage-0 PREHOOK: query: explain select cbo_t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select cbo_t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -1625,8 +1899,14 @@ Stage-0 PREHOOK: query: explain select null from cbo_t1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select null from cbo_t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -1638,8 +1918,14 @@ Stage-0 PREHOOK: query: explain select key from cbo_t1 where c_int = -6 or c_int = +6 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select key from cbo_t1 where c_int = -6 or c_int = +6 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -1654,8 +1940,18 @@ Stage-0 PREHOOK: query: explain select count(cbo_t1.dt) from cbo_t1 join cbo_t2 on cbo_t1.dt = cbo_t2.dt where cbo_t1.dt = '2014' PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +PREHOOK: Input: default@cbo_t2 +PREHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select count(cbo_t1.dt) from cbo_t1 join cbo_t2 on cbo_t1.dt = cbo_t2.dt where cbo_t1.dt = '2014' POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +POSTHOOK: Input: default@cbo_t2 +POSTHOOK: Input: default@cbo_t2@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1695,6 +1991,8 @@ where not exists where b.value = a.value and a.value > 'val_2' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select * from src_cbo b where not exists @@ -1703,6 +2001,8 @@ where not exists where b.value = a.value and a.value > 'val_2' ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1757,6 +2057,8 @@ having not exists where b.value = a.value and a.key = b.key and a.value > 'val_12' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select * from src_cbo b group by key, value @@ -1766,6 +2068,8 @@ having not exists where b.value = a.value and a.key = b.key and a.value > 'val_12' ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1834,8 +2138,14 @@ POSTHOOK: Lineage: cv1_n5.key SIMPLE [(src_cbo)b.FieldSchema(name:key, type:stri POSTHOOK: Lineage: cv1_n5.value SIMPLE [(src_cbo)b.FieldSchema(name:value, type:string, comment:null), ] PREHOOK: query: explain select * from cv1_n5 PREHOOK: type: QUERY +PREHOOK: Input: default@cv1_n5 +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select * from cv1_n5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cv1_n5 +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1879,6 +2189,8 @@ from (select * where b.value = a.value and a.key = b.key and a.value > 'val_9') ) a PREHOOK: type: QUERY +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select * from src_cbo b @@ -1888,6 +2200,8 @@ from (select * where b.value = a.value and a.key = b.key and a.value > 'val_9') ) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1926,10 +2240,14 @@ PREHOOK: query: explain select * from src_cbo where src_cbo.key in (select key from src_cbo s1 where s1.key > '9') PREHOOK: type: QUERY +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select * from src_cbo where src_cbo.key in (select key from src_cbo s1 where s1.key > '9') POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1969,11 +2287,15 @@ from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li o where li.l_linenumber = 1 and li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select p.p_partkey, li.l_suppkey from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey where li.l_linenumber = 1 and li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2037,12 +2359,16 @@ where b.key in (select key from src_cbo where src_cbo.key > '8') group by key, value having count(*) in (select count(*) from src_cbo s1 where s1.key > '9' group by s1.key ) PREHOOK: type: QUERY +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, count(*) from src_cbo b where b.key in (select key from src_cbo where src_cbo.key > '8') group by key, value having count(*) in (select count(*) from src_cbo s1 where s1.key > '9' group by s1.key ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2121,12 +2447,16 @@ group by p_mfgr, p_name having p_name in (select first_value(p_name) over(partition by p_mfgr order by p_size) from part) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, avg(p_size) from part group by p_mfgr, p_name having p_name in (select first_value(p_name) over(partition by p_mfgr order by p_size) from part) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2184,6 +2514,8 @@ where src_cbo.key not in where s1.key > '2' ) order by key PREHOOK: type: QUERY +PREHOOK: Input: default@src_cbo +#### A masked pattern was here #### POSTHOOK: query: explain select * from src_cbo where src_cbo.key not in @@ -2191,6 +2523,8 @@ where src_cbo.key not in where s1.key > '2' ) order by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_cbo +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2261,6 +2595,8 @@ where b.p_name not in where r < 10 and b.p_mfgr = a.p_mfgr ) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, b.p_name, p_size from part b where b.p_name not in @@ -2269,6 +2605,8 @@ where b.p_name not in where r < 10 and b.p_mfgr = a.p_mfgr ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2342,6 +2680,8 @@ part where part.p_size not in where p_size < 10 ) order by p_name PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_name, p_size from part where part.p_size not in @@ -2350,6 +2690,8 @@ part where part.p_size not in where p_size < 10 ) order by p_name POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2418,6 +2760,8 @@ having b.p_mfgr not in ) order by b.p_mfgr PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select b.p_mfgr, min(p_retailprice) from part b group by b.p_mfgr @@ -2428,6 +2772,8 @@ having b.p_mfgr not in ) order by b.p_mfgr POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2516,8 +2862,14 @@ Stage-0 PREHOOK: query: explain select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over(), rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(), lag(c_float, 2, c_float) over() from cbo_t1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over(), rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(), lag(c_float, 2, c_float) over() from cbo_t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2543,8 +2895,14 @@ Stage-0 PREHOOK: query: explain select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over(), rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(), lag(c_float, 2, c_float) over() from cbo_t1) cbo_t1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select count(c_int) over(), sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over(), rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(), lag(c_float, 2, c_float) over() from cbo_t1) cbo_t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2570,8 +2928,14 @@ Stage-0 PREHOOK: query: explain select i, a, h, b, c, d, e, f, g, a as x, a +1 as y from (select max(c_int) over (partition by key order by value range UNBOUNDED PRECEDING) a, min(c_int) over (partition by key order by value range current row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c, avg(value) over (partition by key order by value range between unbounded preceding and unbounded following) d, sum(value) over (partition by key order by value range between unbounded preceding and current row) e, avg(c_float) over (partition by key order by value range between 1 preceding and unbounded following) f, sum(c_float) over (partition by key order by value range between 1 preceding and current row) g, max(c_float) over (partition by key order by value range between 1 preceding and unbounded following) h, min(c_float) over (partition by key order by value range between 1 preceding and 1 following) i from cbo_t1) cbo_t1 PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: explain select i, a, h, b, c, d, e, f, g, a as x, a +1 as y from (select max(c_int) over (partition by key order by value range UNBOUNDED PRECEDING) a, min(c_int) over (partition by key order by value range current row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c, avg(value) over (partition by key order by value range between unbounded preceding and unbounded following) d, sum(value) over (partition by key order by value range between unbounded preceding and current row) e, avg(c_float) over (partition by key order by value range between 1 preceding and unbounded following) f, sum(c_float) over (partition by key order by value range between 1 preceding and current row) g, max(c_float) over (partition by key order by value range between 1 preceding and unbounded following) h, min(c_float) over (partition by key order by value range between 1 preceding and 1 following) i from cbo_t1) cbo_t1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2597,8 +2961,12 @@ Stage-0 PREHOOK: query: explain select *, rank() over(partition by key order by value) as rr from src1 PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select *, rank() over(partition by key order by value) as rr from src1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2628,12 +2996,18 @@ FROM (select x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (select x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2689,12 +3063,18 @@ FROM (select x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (select x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2750,12 +3130,18 @@ FROM (select x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (select x.key AS key, count(1) AS cnt FROM src1 x JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2808,12 +3194,18 @@ FROM (select x.key AS key, count(1) AS cnt FROM src1 x LEFT SEMI JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt)) FROM (select x.key AS key, count(1) AS cnt FROM src1 x LEFT SEMI JOIN src y ON (x.key = y.key) GROUP BY x.key) tmp POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2867,8 +3259,12 @@ Stage-0 PREHOOK: query: explain create table abcd_n1 (a int, b int, c int, d int) PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@abcd_n1 POSTHOOK: query: explain create table abcd_n1 (a int, b int, c int, d int) POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@abcd_n1 Stage-0 Create Table Operator: name:default.abcd_n1 @@ -2891,8 +3287,12 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@abcd_n1 PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd_n1 group by a PREHOOK: type: QUERY +PREHOOK: Input: default@abcd_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd_n1 group by a POSTHOOK: type: QUERY +POSTHOOK: Input: default@abcd_n1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2918,8 +3318,12 @@ Stage-0 PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd_n1 group by a PREHOOK: type: QUERY +PREHOOK: Input: default@abcd_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd_n1 group by a POSTHOOK: type: QUERY +POSTHOOK: Input: default@abcd_n1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -2943,8 +3347,12 @@ Stage-0 PREHOOK: query: explain create table src_rc_merge_test_n0(key int, value string) stored as rcfile PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@src_rc_merge_test_n0 POSTHOOK: query: explain create table src_rc_merge_test_n0(key int, value string) stored as rcfile POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_rc_merge_test_n0 Stage-0 Create Table Operator: name:default.src_rc_merge_test_n0 @@ -2967,8 +3375,12 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@src_rc_merge_test_n0 PREHOOK: query: explain create table tgt_rc_merge_test_n0(key int, value string) stored as rcfile PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tgt_rc_merge_test_n0 POSTHOOK: query: explain create table tgt_rc_merge_test_n0(key int, value string) stored as rcfile POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tgt_rc_merge_test_n0 Stage-0 Create Table Operator: name:default.tgt_rc_merge_test_n0 @@ -3010,8 +3422,12 @@ minFileSize:171 PREHOOK: query: explain select count(1) from tgt_rc_merge_test_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from tgt_rc_merge_test_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -3033,8 +3449,12 @@ Stage-0 PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from tgt_rc_merge_test_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from tgt_rc_merge_test_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -3082,8 +3502,12 @@ minFileSize:171 PREHOOK: query: explain select count(1) from tgt_rc_merge_test_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from tgt_rc_merge_test_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -3105,8 +3529,12 @@ Stage-0 PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from tgt_rc_merge_test_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from tgt_rc_merge_test_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tgt_rc_merge_test_n0 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -3145,8 +3573,12 @@ POSTHOOK: Input: default@tgt_rc_merge_test_n0 POSTHOOK: Output: default@tgt_rc_merge_test_n0 PREHOOK: query: explain select src.key from src cross join src src2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src.key from src cross join src src2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -3174,8 +3606,12 @@ Stage-0 PREHOOK: query: explain create table nzhang_Tmp_n1(a int, b string) PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_Tmp_n1 POSTHOOK: query: explain create table nzhang_Tmp_n1(a int, b string) POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_Tmp_n1 Stage-0 Create Table Operator: name:default.nzhang_Tmp_n1 @@ -3190,8 +3626,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_Tmp_n1 PREHOOK: query: explain create table nzhang_CTAS1_n1 as select key k, value from src sort by k, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_CTAS1_n1 POSTHOOK: query: explain create table nzhang_CTAS1_n1 as select key k, value from src sort by k, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_CTAS1_n1 Plan not optimized by CBO. Vertex dependency in root stage @@ -3243,8 +3685,14 @@ POSTHOOK: Lineage: nzhang_ctas1_n1.k SIMPLE [(src)src.FieldSchema(name:key, type POSTHOOK: Lineage: nzhang_ctas1_n1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain create table nzhang_ctas3_n1 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10 PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas3_n1 POSTHOOK: query: explain create table nzhang_ctas3_n1 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@nzhang_ctas3_n1 Plan not optimized by CBO. Vertex dependency in root stage @@ -3305,8 +3753,12 @@ POSTHOOK: query: create table if not exists nzhang_ctas3_n1 as select key, value POSTHOOK: type: CREATETABLE_AS_SELECT PREHOOK: query: explain create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@acid_dtt POSTHOOK: query: explain create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@acid_dtt Stage-0 Create Table Operator: name:default.acid_dtt @@ -3327,6 +3779,8 @@ select src1.key as k1, src1.value as v1, (select * FROM src WHERE src.key < 10) src2 SORT BY k1, v1, k2, v2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key as k1, src1.value as v1, src2.key as k2, src2.value as v2 FROM @@ -3335,6 +3789,8 @@ select src1.key as k1, src1.value as v1, (select * FROM src WHERE src.key < 10) src2 SORT BY k1, v1, k2, v2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -3388,8 +3844,12 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@myinput1_n7 PREHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3418,8 +3878,12 @@ Stage-0 PREHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value join myinput1_n7 c on a.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value join myinput1_n7 c on a.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3459,8 +3923,12 @@ Stage-0 PREHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value join myinput1_n7 c on a.key<=>c.key PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value join myinput1_n7 c on a.key<=>c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3494,8 +3962,12 @@ Stage-0 PREHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value AND a.value=b.key join myinput1_n7 c on a.key<=>c.key AND a.value=c.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value AND a.value=b.key join myinput1_n7 c on a.key<=>c.key AND a.value=c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3535,8 +4007,12 @@ Stage-0 PREHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value AND a.value<=>b.key join myinput1_n7 c on a.key<=>c.key AND a.value<=>c.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from myinput1_n7 a join myinput1_n7 b on a.key<=>b.value AND a.value<=>b.key join myinput1_n7 c on a.key<=>c.key AND a.value<=>c.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3570,8 +4046,12 @@ Stage-0 PREHOOK: query: explain select * FROM myinput1_n7 a LEFT OUTER JOIN myinput1_n7 b ON a.key<=>b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * FROM myinput1_n7 a LEFT OUTER JOIN myinput1_n7 b ON a.key<=>b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3600,8 +4080,12 @@ Stage-0 PREHOOK: query: explain select * FROM myinput1_n7 a RIGHT OUTER JOIN myinput1_n7 b ON a.key<=>b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * FROM myinput1_n7 a RIGHT OUTER JOIN myinput1_n7 b ON a.key<=>b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3630,8 +4114,12 @@ Stage-0 PREHOOK: query: explain select * FROM myinput1_n7 a FULL OUTER JOIN myinput1_n7 b ON a.key<=>b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * FROM myinput1_n7 a FULL OUTER JOIN myinput1_n7 b ON a.key<=>b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3660,8 +4148,12 @@ Stage-0 PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM myinput1_n7 a JOIN myinput1_n7 b ON a.key<=>b.value PREHOOK: type: QUERY +PREHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM myinput1_n7 a JOIN myinput1_n7 b ON a.key<=>b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@myinput1_n7 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3756,8 +4248,12 @@ POSTHOOK: Input: default@smb_input1_n2 POSTHOOK: Output: default@smb_input1_n2 PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1_n2 a JOIN smb_input1_n2 b ON a.key <=> b.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1_n2 a JOIN smb_input1_n2 b ON a.key <=> b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Stage-0 @@ -3777,8 +4273,12 @@ Stage-0 PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1_n2 a JOIN smb_input1_n2 b ON a.key <=> b.key AND a.value <=> b.value PREHOOK: type: QUERY +PREHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1_n2 a JOIN smb_input1_n2 b ON a.key <=> b.key AND a.value <=> b.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Vertex dependency in root stage @@ -3807,8 +4307,12 @@ Stage-0 PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1_n2 a RIGHT OUTER JOIN smb_input1_n2 b ON a.key <=> b.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1_n2 a RIGHT OUTER JOIN smb_input1_n2 b ON a.key <=> b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Stage-0 @@ -3828,8 +4332,12 @@ Stage-0 PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1_n2 a JOIN smb_input1_n2 b ON a.key <=> b.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1_n2 a JOIN smb_input1_n2 b ON a.key <=> b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Stage-0 @@ -3849,8 +4357,12 @@ Stage-0 PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1_n2 a LEFT OUTER JOIN smb_input1_n2 b ON a.key <=> b.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1_n2 a LEFT OUTER JOIN smb_input1_n2 b ON a.key <=> b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_input1_n2 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Less_than_equal_greater_than]. Stage-0 @@ -3924,8 +4436,18 @@ POSTHOOK: Output: default@things_n0 POSTHOOK: Output: default@things_n0@ds=2011-10-24 PREHOOK: query: explain select name,id FROM sales_n0 LEFT SEMI JOIN things_n0 ON (sales_n0.id = things_n0.id) PREHOOK: type: QUERY +PREHOOK: Input: default@sales_n0 +PREHOOK: Input: default@things_n0 +PREHOOK: Input: default@things_n0@ds=2011-10-23 +PREHOOK: Input: default@things_n0@ds=2011-10-24 +#### A masked pattern was here #### POSTHOOK: query: explain select name,id FROM sales_n0 LEFT SEMI JOIN things_n0 ON (sales_n0.id = things_n0.id) POSTHOOK: type: QUERY +POSTHOOK: Input: default@sales_n0 +POSTHOOK: Input: default@things_n0 +POSTHOOK: Input: default@things_n0@ds=2011-10-23 +POSTHOOK: Input: default@things_n0@ds=2011-10-24 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -3978,8 +4500,24 @@ POSTHOOK: Input: default@things_n0 POSTHOOK: Output: default@things_n0 PREHOOK: query: explain select srcpart.key from srcpart join src on (srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where srcpart.value > 'val_450' PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +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 +#### A masked pattern was here #### POSTHOOK: query: explain select srcpart.key from srcpart join src on (srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where srcpart.value > 'val_450' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +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 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -4022,8 +4560,24 @@ Stage-0 PREHOOK: query: explain select srcpart.key from srcpart join src on (srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where srcpart.value > 'val_450' PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +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 +#### A masked pattern was here #### POSTHOOK: query: explain select srcpart.key from srcpart join src on (srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where srcpart.value > 'val_450' POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +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 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -4074,6 +4628,8 @@ from noop(on part order by p_name ) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4084,6 +4640,8 @@ from noop(on part order by p_name ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4122,6 +4680,8 @@ from noop (on (select p1.* from part p1 join part p2 on p1.p_partkey = p2.p_part distribute by j.p_mfgr sort by j.p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, p_size - lag(p_size,1,p_size) over (partition by p_mfgr order by p_name) as deltaSz @@ -4129,6 +4689,8 @@ from noop (on (select p1.* from part p1 join part p2 on p1.p_partkey = p2.p_part distribute by j.p_mfgr sort by j.p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4182,6 +4744,8 @@ from noop(on part order by p_name ) abc PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4192,6 +4756,8 @@ from noop(on part order by p_name ) abc POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4233,6 +4799,8 @@ from noop(on part order by p_name ) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4243,6 +4811,8 @@ from noop(on part order by p_name ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4285,6 +4855,8 @@ from noop(on part ) group by p_mfgr, p_name, p_size PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4296,6 +4868,8 @@ from noop(on part ) group by p_mfgr, p_name, p_size POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4342,6 +4916,8 @@ partition by p_mfgr order by p_name ) abc join part p1 on abc.p_partkey = p1.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select abc.* from noop(on part @@ -4349,6 +4925,8 @@ partition by p_mfgr order by p_name ) abc join part p1 on abc.p_partkey = p1.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4388,6 +4966,8 @@ from noopwithmap(on part partition by p_mfgr order by p_name, p_size desc) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name, p_size desc) as r @@ -4395,6 +4975,8 @@ from noopwithmap(on part partition by p_mfgr order by p_name, p_size desc) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4437,6 +5019,8 @@ from noopwithmap(on part partition by p_mfgr order by p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4446,6 +5030,8 @@ from noopwithmap(on part partition by p_mfgr order by p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4488,6 +5074,8 @@ from noop(on part partition by p_mfgr order by p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4497,6 +5085,8 @@ from noop(on part partition by p_mfgr order by p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4538,6 +5128,8 @@ partition by p_mfgr order by p_mfgr DESC, p_name ))) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, p_size, rank() over (partition by p_mfgr order by p_name) as r, @@ -4548,6 +5140,8 @@ partition by p_mfgr order by p_mfgr DESC, p_name ))) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4602,6 +5196,8 @@ order by p_name) window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) ) sub1 PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, sub1.cd, sub1.s1 @@ -4615,6 +5211,8 @@ order by p_name) window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) ) sub1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4658,6 +5256,8 @@ partition by p_mfgr order by p_name ) abc join part p1 on abc.p_partkey = p1.p_partkey PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select abc.p_mfgr, abc.p_name, rank() over (distribute by abc.p_mfgr sort by abc.p_name) as r, @@ -4670,6 +5270,8 @@ partition by p_mfgr order by p_name ) abc join part p1 on abc.p_partkey = p1.p_partkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4718,12 +5320,18 @@ sum(p_retailprice) as s from part group by p_mfgr, p_brand PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@part +PREHOOK: Output: database:default +PREHOOK: Output: default@mfgr_price_view_n3 POSTHOOK: query: explain create view IF NOT EXISTS mfgr_price_view_n3 as select p_mfgr, p_brand, sum(p_retailprice) as s from part group by p_mfgr, p_brand POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@part +POSTHOOK: Output: database:default +POSTHOOK: Output: default@mfgr_price_view_n3 Plan optimized by CBO. Stage-1 @@ -4793,6 +5401,9 @@ cume_dist() over (distribute by p_mfgr sort by p_mfgr, p_name) as cud, first_value(p_size, true) over w1 as fv1 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) PREHOOK: type: QUERY +PREHOOK: Input: default@part +PREHOOK: Output: default@part_4_n1 +PREHOOK: Output: default@part_5_n1 POSTHOOK: query: explain from noop(on part partition by p_mfgr @@ -4809,6 +5420,9 @@ cume_dist() over (distribute by p_mfgr sort by p_mfgr, p_name) as cud, first_value(p_size, true) over w1 as fv1 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +POSTHOOK: Output: default@part_4_n1 +POSTHOOK: Output: default@part_5_n1 Plan not optimized by CBO. Vertex dependency in root stage @@ -4922,6 +5536,8 @@ from noop(on partition by p_mfgr,p_name order by p_mfgr,p_name) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, rank() over (partition by p_mfgr,p_name) as r, @@ -4939,6 +5555,8 @@ from noop(on partition by p_mfgr,p_name order by p_mfgr,p_name) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -4997,6 +5615,8 @@ from noop(on partition by p_mfgr order by p_mfgr ) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, rank() over (partition by p_mfgr order by p_name) as r, @@ -5014,6 +5634,8 @@ from noop(on partition by p_mfgr order by p_mfgr ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -5076,6 +5698,8 @@ from noop(on partition by p_mfgr order by p_mfgr)) PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### POSTHOOK: query: explain select p_mfgr, p_name, rank() over (partition by p_mfgr order by p_name) as r, @@ -5091,6 +5715,8 @@ from noop(on partition by p_mfgr order by p_mfgr)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### Plan not optimized by CBO. Vertex dependency in root stage @@ -5132,8 +5758,12 @@ Stage-0 PREHOOK: query: explain select distinct src.* from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select distinct src.* from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5163,8 +5793,12 @@ Stage-0 PREHOOK: query: explain select explode(array('a', 'b')) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### POSTHOOK: query: explain select explode(array('a', 'b')) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -5254,10 +5888,14 @@ PREHOOK: query: explain FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest_j1_n16 select src1.key, src2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest_j1_n16 POSTHOOK: query: explain FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest_j1_n16 select src1.key, src2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest_j1_n16 Plan optimized by CBO. Vertex dependency in root stage @@ -5330,12 +5968,22 @@ FROM T1_n119 a JOIN T2_n70 b ON a.key = b.key JOIN T3_n26 c ON b.key = c.key JOIN T4_n15 d ON c.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +PREHOOK: Input: default@t2_n70 +PREHOOK: Input: default@t3_n26 +PREHOOK: Input: default@t4_n15 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ STREAMTABLE(a) */ * FROM T1_n119 a JOIN T2_n70 b ON a.key = b.key JOIN T3_n26 c ON b.key = c.key JOIN T4_n15 d ON c.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n119 +POSTHOOK: Input: default@t2_n70 +POSTHOOK: Input: default@t3_n26 +POSTHOOK: Input: default@t4_n15 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5391,12 +6039,22 @@ FROM T1_n119 a JOIN T2_n70 b ON a.key = b.key JOIN T3_n26 c ON b.key = c.key JOIN T4_n15 d ON c.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +PREHOOK: Input: default@t2_n70 +PREHOOK: Input: default@t3_n26 +PREHOOK: Input: default@t4_n15 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ STREAMTABLE(a,c) */ * FROM T1_n119 a JOIN T2_n70 b ON a.key = b.key JOIN T3_n26 c ON b.key = c.key JOIN T4_n15 d ON c.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n119 +POSTHOOK: Input: default@t2_n70 +POSTHOOK: Input: default@t3_n26 +POSTHOOK: Input: default@t4_n15 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5448,8 +6106,14 @@ Stage-0 PREHOOK: query: explain FROM T1_n119 a JOIN src c ON c.key+1=a.key select /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@t1_n119 +#### A masked pattern was here #### POSTHOOK: query: explain FROM T1_n119 a JOIN src c ON c.key+1=a.key select /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@t1_n119 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5510,6 +6174,8 @@ JOIN (select src.* FROM src) Y ON (x.key = Y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * FROM (select src.* FROM src) x @@ -5517,6 +6183,8 @@ JOIN (select src.* FROM src) Y ON (x.key = Y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5551,8 +6219,12 @@ Stage-0 PREHOOK: query: explain select /*+ mapjoin(k)*/ sum(hash(k.key)), sum(hash(v.val)) from T1_n119 k join T1_n119 v on k.key=v.val PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+ mapjoin(k)*/ sum(hash(k.key)), sum(hash(v.val)) from T1_n119 k join T1_n119 v on k.key=v.val POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n119 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5597,8 +6269,12 @@ Stage-0 PREHOOK: query: explain select sum(hash(k.key)), sum(hash(v.val)) from T1_n119 k join T1_n119 v on k.key=v.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(k.key)), sum(hash(v.val)) from T1_n119 k join T1_n119 v on k.key=v.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n119 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5643,8 +6319,12 @@ Stage-0 PREHOOK: query: explain select count(1) from T1_n119 a join T1_n119 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from T1_n119 a join T1_n119 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n119 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5687,8 +6367,14 @@ Stage-0 PREHOOK: query: explain FROM T1_n119 a LEFT OUTER JOIN T2_n70 c ON c.key+1=a.key select sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key)) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +PREHOOK: Input: default@t2_n70 +#### A masked pattern was here #### POSTHOOK: query: explain FROM T1_n119 a LEFT OUTER JOIN T2_n70 c ON c.key+1=a.key select sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n119 +POSTHOOK: Input: default@t2_n70 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -5729,8 +6415,14 @@ Stage-0 PREHOOK: query: explain FROM T1_n119 a RIGHT OUTER JOIN T2_n70 c ON c.key+1=a.key select /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key)) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n119 +PREHOOK: Input: default@t2_n70 +#### A masked pattern was here #### POSTHOOK: query: explain FROM T1_n119 a RIGHT OUTER JOIN T2_n70 c ON c.key+1=a.key select /*+ STREAMTABLE(
<TRUNCATED>
