http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/sharedworkext.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/sharedworkext.q.out b/ql/src/test/results/clientpositive/llap/sharedworkext.q.out index 5d8dcfc..ca2b4d6 100644 --- a/ql/src/test/results/clientpositive/llap/sharedworkext.q.out +++ b/ql/src/test/results/clientpositive/llap/sharedworkext.q.out @@ -11,6 +11,8 @@ JOIN ) b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT a.key FROM ( @@ -24,6 +26,8 @@ JOIN ) b ON a.key = b.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 @@ -517,6 +521,8 @@ JOIN ) b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT a.key FROM ( @@ -532,6 +538,8 @@ JOIN ) b ON a.key = b.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/163caed7/ql/src/test/results/clientpositive/llap/skewjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/skewjoin.q.out b/ql/src/test/results/clientpositive/llap/skewjoin.q.out index f15f1ef..77cd117 100644 --- a/ql/src/test/results/clientpositive/llap/skewjoin.q.out +++ b/ql/src/test/results/clientpositive/llap/skewjoin.q.out @@ -74,10 +74,14 @@ PREHOOK: query: EXPLAIN FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest_j1_n17 SELECT src1.key, src2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest_j1_n17 POSTHOOK: query: EXPLAIN FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE dest_j1_n17 SELECT src1.key, src2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest_j1_n17 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -234,12 +238,22 @@ FROM T1_n128 a JOIN T2_n76 b ON a.key = b.key JOIN T3_n30 c ON b.key = c.key JOIN T4_n17 d ON c.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n128 +PREHOOK: Input: default@t2_n76 +PREHOOK: Input: default@t3_n30 +PREHOOK: Input: default@t4_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT /*+ STREAMTABLE(a) */ * FROM T1_n128 a JOIN T2_n76 b ON a.key = b.key JOIN T3_n30 c ON b.key = c.key JOIN T4_n17 d ON c.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n128 +POSTHOOK: Input: default@t2_n76 +POSTHOOK: Input: default@t3_n30 +POSTHOOK: Input: default@t4_n17 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -380,12 +394,22 @@ FROM T1_n128 a JOIN T2_n76 b ON a.key = b.key JOIN T3_n30 c ON b.key = c.key JOIN T4_n17 d ON c.key = d.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n128 +PREHOOK: Input: default@t2_n76 +PREHOOK: Input: default@t3_n30 +PREHOOK: Input: default@t4_n17 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT /*+ STREAMTABLE(a,c) */ * FROM T1_n128 a JOIN T2_n76 b ON a.key = b.key JOIN T3_n30 c ON b.key = c.key JOIN T4_n17 d ON c.key = d.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n128 +POSTHOOK: Input: default@t2_n76 +POSTHOOK: Input: default@t3_n30 +POSTHOOK: Input: default@t4_n17 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -522,8 +546,14 @@ POSTHOOK: Input: default@t4_n17 2 12 2 22 2 12 2 12 PREHOOK: query: EXPLAIN FROM T1_n128 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_n128 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN FROM T1_n128 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_n128 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -631,6 +661,8 @@ JOIN ON (x.key = Y.key) SELECT sum(hash(Y.key)), sum(hash(Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN FROM (SELECT src.* FROM src) x JOIN @@ -638,6 +670,8 @@ JOIN ON (x.key = Y.key) SELECT sum(hash(Y.key)), sum(hash(Y.value)) 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 @@ -760,6 +794,8 @@ JOIN ON (x.key = Y.key and substring(x.value, 5)=substring(y.value, 5)+1) SELECT sum(hash(Y.key)), sum(hash(Y.value)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN FROM (SELECT src.* FROM src) x JOIN @@ -767,6 +803,8 @@ JOIN ON (x.key = Y.key and substring(x.value, 5)=substring(y.value, 5)+1) SELECT sum(hash(Y.key)), sum(hash(Y.value)) 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 @@ -893,6 +931,8 @@ JOIN (SELECT src.key as c5, src.value as c6 from src) src3 ON src1.c1 = src3.c5 AND src3.c5 < 80 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT sum(hash(src1.c1)), sum(hash(src2.c4)) FROM @@ -904,6 +944,8 @@ JOIN (SELECT src.key as c5, src.value as c6 from src) src3 ON src1.c1 = src3.c5 AND src3.c5 < 80 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 @@ -1050,9 +1092,13 @@ POSTHOOK: Input: default@src PREHOOK: query: EXPLAIN SELECT /*+ mapjoin(v)*/ sum(hash(k.key)), sum(hash(v.val)) FROM T1_n128 k LEFT OUTER JOIN T1_n128 v ON k.key+1=v.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n128 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT /*+ mapjoin(v)*/ sum(hash(k.key)), sum(hash(v.val)) FROM T1_n128 k LEFT OUTER JOIN T1_n128 v ON k.key+1=v.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n128 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out b/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out index 26e4355..a61d1d6 100644 --- a/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out +++ b/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out @@ -69,9 +69,15 @@ POSTHOOK: Lineage: t2_n66.val SIMPLE [(tmpt2_n66)tmpt2_n66.FieldSchema(name:val, PREHOOK: query: EXPLAIN SELECT a.*, b.* FROM T1_n109 a JOIN T2_n66 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n109 +PREHOOK: Input: default@t2_n66 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT a.*, b.* FROM T1_n109 a JOIN T2_n66 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n109 +POSTHOOK: Input: default@t2_n66 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -172,9 +178,15 @@ POSTHOOK: Input: default@t2_n66 PREHOOK: query: EXPLAIN SELECT a.*, b.* FROM T1_n109 a RIGHT OUTER JOIN T2_n66 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n109 +PREHOOK: Input: default@t2_n66 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT a.*, b.* FROM T1_n109 a RIGHT OUTER JOIN T2_n66 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n109 +POSTHOOK: Input: default@t2_n66 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -269,9 +281,15 @@ NULL NULL 5 15 PREHOOK: query: EXPLAIN SELECT count(1) FROM T1_n109 a JOIN T2_n66 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n109 +PREHOOK: Input: default@t2_n66 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(1) FROM T1_n109 a JOIN T2_n66 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n109 +POSTHOOK: Input: default@t2_n66 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -380,9 +398,15 @@ POSTHOOK: Input: default@t2_n66 PREHOOK: query: EXPLAIN SELECT count(1) FROM T1_n109 a RIGHT OUTER JOIN T2_n66 b ON a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n109 +PREHOOK: Input: default@t2_n66 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(1) FROM T1_n109 a RIGHT OUTER JOIN T2_n66 b ON a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n109 +POSTHOOK: Input: default@t2_n66 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_cache.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_cache.q.out b/ql/src/test/results/clientpositive/llap/smb_cache.q.out index 7db1374..82b0a76 100644 --- a/ql/src/test/results/clientpositive/llap/smb_cache.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_cache.q.out @@ -193,6 +193,9 @@ t1.userid, from bug_201_input_b as t1 join bug_201_input_a as fa on (t1.userid = fa.userid) PREHOOK: type: QUERY +PREHOOK: Input: default@bug_201_input_a +PREHOOK: Input: default@bug_201_input_b +#### A masked pattern was here #### POSTHOOK: query: explain select t1.userid, @@ -200,6 +203,9 @@ t1.userid, from bug_201_input_b as t1 join bug_201_input_a as fa on (t1.userid = fa.userid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bug_201_input_a +POSTHOOK: Input: default@bug_201_input_b +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -297,6 +303,9 @@ t1.userid, from bug_201_input_b as t1 join bug_201_input_a as fa on (t1.userid = fa.userid) PREHOOK: type: QUERY +PREHOOK: Input: default@bug_201_input_a +PREHOOK: Input: default@bug_201_input_b +#### A masked pattern was here #### POSTHOOK: query: explain select t1.userid, @@ -304,6 +313,9 @@ t1.userid, from bug_201_input_b as t1 join bug_201_input_a as fa on (t1.userid = fa.userid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bug_201_input_a +POSTHOOK: Input: default@bug_201_input_b +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_14.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_14.q.out index cbe2dda..07be7f6 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_14.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_14.q.out @@ -43,11 +43,17 @@ select count(*) from ( select /*+mapjoin(a)*/ a.key as key, a.value as val1, b.value as val2 from tbl1_n14 a join tbl2_n13 b on a.key = b.key ) subq1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select /*+mapjoin(a)*/ a.key as key, a.value as val1, b.value as val2 from tbl1_n14 a join tbl2_n13 b on a.key = b.key ) subq1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -147,6 +153,9 @@ select key, count(*) from group by key order by key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select key, count(*) from ( @@ -155,6 +164,9 @@ select key, count(*) from group by key order by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -285,6 +297,9 @@ select count(*) from group by key ) subq2 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( @@ -295,6 +310,9 @@ select count(*) from group by key ) subq2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -425,6 +443,9 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, a.value as value from tbl2_n13 a where key < 6) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, a.value as value from tbl1_n14 a where key < 6) subq1 @@ -432,6 +453,9 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, a.value as value from tbl2_n13 a where key < 6) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -539,6 +563,9 @@ select /*+mapjoin(subq2)*/ count(*) from join tbl2_n13 b on subq2.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq2)*/ count(*) from ( @@ -551,6 +578,9 @@ select /*+mapjoin(subq2)*/ count(*) from join tbl2_n13 b on subq2.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -675,6 +705,8 @@ select /*+mapjoin(subq2)*/ count(*) from ) subq4 on subq2.key = subq4.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq2)*/ count(*) from ( @@ -694,6 +726,8 @@ select /*+mapjoin(subq2)*/ count(*) from ) subq4 on subq2.key = subq4.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -818,6 +852,9 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n13 a where key < 8) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl1_n14 a where key < 8) subq1 @@ -825,6 +862,9 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, concat(a.value, a.value) as value from tbl2_n13 a where key < 8) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -927,6 +967,9 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n13 a) subq2 on subq1.key = subq2.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq1)*/ count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl1_n14 a) subq1 @@ -934,6 +977,9 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key +1 as key, concat(a.value, a.value) as value from tbl2_n13 a) subq2 on subq1.key = subq2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1052,11 +1098,17 @@ select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, a.value as value from tbl1_n14 a where key < 6) subq1 join tbl2_n13 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq1)*/ count(*) from (select a.key as key, a.value as value from tbl1_n14 a where key < 6) subq1 join tbl2_n13 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1153,11 +1205,17 @@ select /*+mapjoin(a)*/ count(*) from (select a.key as key, a.value as value from tbl1_n14 a where key < 6) subq1 join tbl2_n13 a on subq1.key = a.key PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a)*/ count(*) from (select a.key as key, a.value as value from tbl1_n14 a where key < 6) subq1 join tbl2_n13 a on subq1.key = a.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1259,6 +1317,9 @@ select /*+mapjoin(subq1, subq2)*/ count(*) from (select a.key as key, a.value as value from tbl2_n13 a where key < 6) subq3 on (subq1.key = subq3.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(subq1, subq2)*/ count(*) from (select a.key as key, a.value as value from tbl1_n14 a where key < 6) subq1 @@ -1269,6 +1330,9 @@ select /*+mapjoin(subq1, subq2)*/ count(*) from (select a.key as key, a.value as value from tbl2_n13 a where key < 6) subq3 on (subq1.key = subq3.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1397,6 +1461,9 @@ select count(*) from ( join tbl2_n13 b on subq2.key = b.key) a PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n14 +PREHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from ( select /*+mapjoin(subq2)*/ subq2.key as key, subq2.value as value1, b.value as value2 from @@ -1410,6 +1477,9 @@ select count(*) from ( join tbl2_n13 b on subq2.key = b.key) a POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n14 +POSTHOOK: Input: default@tbl2_n13 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_15.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_15.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_15.q.out index e4f2452..4c54cb6 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_15.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_15.q.out @@ -35,9 +35,15 @@ POSTHOOK: Lineage: test_table2_n4.value SIMPLE [(src)src.FieldSchema(name:value, PREHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key = b.key ORDER BY a.key LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n4 +PREHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key = b.key ORDER BY a.key LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n4 +POSTHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT * FROM (SELECT `key`, `value` FROM `default`.`test_table1_n4` @@ -335,9 +341,15 @@ POSTHOOK: Lineage: test_table2_n4.value SIMPLE [(src)src.FieldSchema(name:value, PREHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key = b.key and a.key2 = b.key2 ORDER BY a.key LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n4 +PREHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key = b.key and a.key2 = b.key2 ORDER BY a.key LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n4 +POSTHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT * FROM (SELECT `key`, `key2`, `value` FROM `default`.`test_table1_n4` @@ -612,9 +624,15 @@ POSTHOOK: Input: default@test_table2_n4 PREHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key2 = b.key2 and a.key = b.key ORDER BY a.key LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n4 +PREHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key2 = b.key2 and a.key = b.key ORDER BY a.key LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n4 +POSTHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT * FROM (SELECT `key`, `key2`, `value` FROM `default`.`test_table1_n4` @@ -889,9 +907,15 @@ POSTHOOK: Input: default@test_table2_n4 PREHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key = b.key and a.value = b.value ORDER BY a.key LIMIT 10 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n4 +PREHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT /*+mapjoin(b)*/ * FROM test_table1_n4 a JOIN test_table2_n4 b ON a.key = b.key and a.value = b.value ORDER BY a.key LIMIT 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n4 +POSTHOOK: Input: default@test_table2_n4 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT * FROM (SELECT `key`, `key2`, `value` FROM `default`.`test_table1_n4` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_17.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_17.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_17.q.out index fe491c5..2520dde 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_17.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_17.q.out @@ -167,6 +167,14 @@ JOIN test_table5 e ON a.key = e.key JOIN test_table6 f ON a.key = f.key JOIN test_table7 g ON a.key = g.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n15 +PREHOOK: Input: default@test_table2_n14 +PREHOOK: Input: default@test_table3_n7 +PREHOOK: Input: default@test_table4_n1 +PREHOOK: Input: default@test_table5 +PREHOOK: Input: default@test_table6 +PREHOOK: Input: default@test_table7 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT /*+ mapjoin(b, c, d, e, f, g) */ count(*) FROM test_table1_n15 a JOIN test_table2_n14 b ON a.key = b.key @@ -176,6 +184,14 @@ JOIN test_table5 e ON a.key = e.key JOIN test_table6 f ON a.key = f.key JOIN test_table7 g ON a.key = g.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n15 +POSTHOOK: Input: default@test_table2_n14 +POSTHOOK: Input: default@test_table3_n7 +POSTHOOK: Input: default@test_table4_n1 +POSTHOOK: Input: default@test_table5 +POSTHOOK: Input: default@test_table6 +POSTHOOK: Input: default@test_table7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -422,6 +438,14 @@ LEFT OUTER JOIN test_table5 e ON a.key = e.key LEFT OUTER JOIN test_table6 f ON a.key = f.key LEFT OUTER JOIN test_table7 g ON a.key = g.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n15 +PREHOOK: Input: default@test_table2_n14 +PREHOOK: Input: default@test_table3_n7 +PREHOOK: Input: default@test_table4_n1 +PREHOOK: Input: default@test_table5 +PREHOOK: Input: default@test_table6 +PREHOOK: Input: default@test_table7 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(*) FROM test_table1_n15 a LEFT OUTER JOIN test_table2_n14 b ON a.key = b.key @@ -431,6 +455,14 @@ LEFT OUTER JOIN test_table5 e ON a.key = e.key LEFT OUTER JOIN test_table6 f ON a.key = f.key LEFT OUTER JOIN test_table7 g ON a.key = g.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n15 +POSTHOOK: Input: default@test_table2_n14 +POSTHOOK: Input: default@test_table3_n7 +POSTHOOK: Input: default@test_table4_n1 +POSTHOOK: Input: default@test_table5 +POSTHOOK: Input: default@test_table6 +POSTHOOK: Input: default@test_table7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -592,6 +624,15 @@ LEFT OUTER JOIN test_table6 f ON a.key = f.key LEFT OUTER JOIN test_table7 g ON a.key = g.key LEFT OUTER JOIN test_table8 h ON a.key = h.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n15 +PREHOOK: Input: default@test_table2_n14 +PREHOOK: Input: default@test_table3_n7 +PREHOOK: Input: default@test_table4_n1 +PREHOOK: Input: default@test_table5 +PREHOOK: Input: default@test_table6 +PREHOOK: Input: default@test_table7 +PREHOOK: Input: default@test_table8 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(*) FROM test_table1_n15 a LEFT OUTER JOIN test_table2_n14 b ON a.key = b.key @@ -602,6 +643,15 @@ LEFT OUTER JOIN test_table6 f ON a.key = f.key LEFT OUTER JOIN test_table7 g ON a.key = g.key LEFT OUTER JOIN test_table8 h ON a.key = h.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n15 +POSTHOOK: Input: default@test_table2_n14 +POSTHOOK: Input: default@test_table3_n7 +POSTHOOK: Input: default@test_table4_n1 +POSTHOOK: Input: default@test_table5 +POSTHOOK: Input: default@test_table6 +POSTHOOK: Input: default@test_table7 +POSTHOOK: Input: default@test_table8 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -790,6 +840,15 @@ LEFT OUTER JOIN test_table6 r ON a.key = r.key LEFT OUTER JOIN test_table7 s ON a.key = s.key LEFT OUTER JOIN test_table8 t ON a.key = t.key PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n15 +PREHOOK: Input: default@test_table2_n14 +PREHOOK: Input: default@test_table3_n7 +PREHOOK: Input: default@test_table4_n1 +PREHOOK: Input: default@test_table5 +PREHOOK: Input: default@test_table6 +PREHOOK: Input: default@test_table7 +PREHOOK: Input: default@test_table8 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT a.* FROM test_table1_n15 a @@ -813,6 +872,15 @@ LEFT OUTER JOIN test_table6 r ON a.key = r.key LEFT OUTER JOIN test_table7 s ON a.key = s.key LEFT OUTER JOIN test_table8 t ON a.key = t.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n15 +POSTHOOK: Input: default@test_table2_n14 +POSTHOOK: Input: default@test_table3_n7 +POSTHOOK: Input: default@test_table4_n1 +POSTHOOK: Input: default@test_table5 +POSTHOOK: Input: default@test_table6 +POSTHOOK: Input: default@test_table7 +POSTHOOK: Input: default@test_table8 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_18.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_18.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_18.q.out index 968fa02..8775c2c 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_18.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_18.q.out @@ -34,10 +34,16 @@ PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n7 PARTITION (ds = '1') SELECT a.key, a.value FROM test_table1_n7 a WHERE a.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n7 +PREHOOK: Input: default@test_table1_n7@ds=1 +PREHOOK: Output: default@test_table2_n7@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n7 PARTITION (ds = '1') SELECT a.key, a.value FROM test_table1_n7 a WHERE a.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n7 +POSTHOOK: Input: default@test_table1_n7@ds=1 +POSTHOOK: Output: default@test_table2_n7@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -217,10 +223,16 @@ PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n7 PARTITION (ds = '2') SELECT a.key, a.value FROM test_table1_n7 a WHERE a.ds = '1' and a.key = 238 PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n7 +PREHOOK: Input: default@test_table1_n7@ds=1 +PREHOOK: Output: default@test_table2_n7@ds=2 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n7 PARTITION (ds = '2') SELECT a.key, a.value FROM test_table1_n7 a WHERE a.ds = '1' and a.key = 238 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n7 +POSTHOOK: Input: default@test_table1_n7@ds=1 +POSTHOOK: Output: default@test_table2_n7@ds=2 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -403,10 +415,16 @@ PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n7 PARTITION (ds = '3') SELECT a.key, a.value FROM test_table2_n7 a WHERE a.ds = '2' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table2_n7 +PREHOOK: Input: default@test_table2_n7@ds=2 +PREHOOK: Output: default@test_table2_n7@ds=3 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n7 PARTITION (ds = '3') SELECT a.key, a.value FROM test_table2_n7 a WHERE a.ds = '2' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table2_n7 +POSTHOOK: Input: default@test_table2_n7@ds=2 +POSTHOOK: Output: default@test_table2_n7@ds=3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_19.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_19.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_19.q.out index 847a889..81c6417 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_19.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_19.q.out @@ -34,10 +34,16 @@ PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n11 PARTITION (ds = '1') SELECT a.key, a.value FROM test_table1_n11 a WHERE a.ds = '1' PREHOOK: type: QUERY +PREHOOK: Input: default@test_table1_n11 +PREHOOK: Input: default@test_table1_n11@ds=1 +PREHOOK: Output: default@test_table2_n11@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n11 PARTITION (ds = '1') SELECT a.key, a.value FROM test_table1_n11 a WHERE a.ds = '1' POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table1_n11 +POSTHOOK: Input: default@test_table1_n11@ds=1 +POSTHOOK: Output: default@test_table2_n11@ds=1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_4.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_4.q.out index 0c1ad42..67c10b4 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_4.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_4.q.out @@ -49,9 +49,17 @@ POSTHOOK: Output: default@smb_bucket_3 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -138,9 +146,17 @@ POSTHOOK: Input: default@smb_bucket_3 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -227,9 +243,17 @@ POSTHOOK: Input: default@smb_bucket_3 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -309,9 +333,17 @@ POSTHOOK: Input: default@smb_bucket_3 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -392,9 +424,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -511,9 +551,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -602,9 +650,17 @@ NULL NULL 23 val_23 23 val_23 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -683,9 +739,17 @@ NULL NULL 30 val_30 NULL NULL PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -766,9 +830,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -882,9 +954,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -973,9 +1053,17 @@ NULL NULL 23 val_23 23 val_23 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1090,9 +1178,17 @@ NULL NULL 30 val_30 NULL NULL PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1204,9 +1300,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1 +PREHOOK: Input: default@smb_bucket_2 +PREHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1 +POSTHOOK: Input: default@smb_bucket_2 +POSTHOOK: Input: default@smb_bucket_3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_5.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_5.q.out index 6a63463..d33b3fa 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_5.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_5.q.out @@ -49,9 +49,17 @@ POSTHOOK: Output: default@smb_bucket_3_n2 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -138,9 +146,17 @@ POSTHOOK: Input: default@smb_bucket_3_n2 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -227,9 +243,17 @@ POSTHOOK: Input: default@smb_bucket_3_n2 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key left outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key left outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -309,9 +333,17 @@ POSTHOOK: Input: default@smb_bucket_3_n2 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key right outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key right outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -392,9 +424,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key full outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a left outer join smb_bucket_2_n2 b on a.key = b.key full outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -511,9 +551,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -602,9 +650,17 @@ NULL NULL 23 val_23 23 val_23 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key left outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key left outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -683,9 +739,17 @@ NULL NULL 30 val_30 NULL NULL PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key right outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key right outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -766,9 +830,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key full outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a right outer join smb_bucket_2_n2 b on a.key = b.key full outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -882,9 +954,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -973,9 +1053,17 @@ NULL NULL 23 val_23 23 val_23 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key left outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key left outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1090,9 +1178,17 @@ NULL NULL 30 val_30 NULL NULL PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key right outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key right outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1204,9 +1300,17 @@ NULL NULL NULL NULL 4 val_4 PREHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key full outer join smb_bucket_3_n2 c on b.key=c.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket_1_n2 +PREHOOK: Input: default@smb_bucket_2_n2 +PREHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(a,c)*/ * from smb_bucket_1_n2 a full outer join smb_bucket_2_n2 b on a.key = b.key full outer join smb_bucket_3_n2 c on b.key=c.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket_1_n2 +POSTHOOK: Input: default@smb_bucket_2_n2 +POSTHOOK: Input: default@smb_bucket_3_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/smb_mapjoin_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/smb_mapjoin_6.q.out b/ql/src/test/results/clientpositive/llap/smb_mapjoin_6.q.out index 07dd79c..2c6c493 100644 --- a/ql/src/test/results/clientpositive/llap/smb_mapjoin_6.q.out +++ b/ql/src/test/results/clientpositive/llap/smb_mapjoin_6.q.out @@ -58,10 +58,16 @@ PREHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(a)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1_n0 +PREHOOK: Input: default@smb_bucket4_2_n0 +PREHOOK: Output: default@smb_join_results_n0 POSTHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(a)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1_n0 +POSTHOOK: Input: default@smb_bucket4_2_n0 +POSTHOOK: Output: default@smb_join_results_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1256,10 +1262,16 @@ PREHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(b)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1_n0 +PREHOOK: Input: default@smb_bucket4_2_n0 +PREHOOK: Output: default@smb_join_results_n0 POSTHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(b)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1_n0 +POSTHOOK: Input: default@smb_bucket4_2_n0 +POSTHOOK: Output: default@smb_join_results_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2470,10 +2482,16 @@ PREHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(a)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key where a.key>1000 PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1_n0 +PREHOOK: Input: default@smb_bucket4_2_n0 +PREHOOK: Output: default@smb_join_results_n0 POSTHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(a)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key where a.key>1000 POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1_n0 +POSTHOOK: Input: default@smb_bucket4_2_n0 +POSTHOOK: Output: default@smb_join_results_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2600,10 +2618,16 @@ PREHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(b)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key where a.key>1000 PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1_n0 +PREHOOK: Input: default@smb_bucket4_2_n0 +PREHOOK: Output: default@smb_join_results_n0 POSTHOOK: query: explain insert overwrite table smb_join_results_n0 select /*+mapjoin(b)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key where a.key>1000 POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1_n0 +POSTHOOK: Input: default@smb_bucket4_2_n0 +POSTHOOK: Output: default@smb_join_results_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2729,9 +2753,15 @@ POSTHOOK: Lineage: smb_join_results_n0.v2 SIMPLE [(smb_bucket4_2_n0)b.FieldSchem PREHOOK: query: explain select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key join smb_bucket4_2_n0 c on b.key = c.key where a.key>1000 PREHOOK: type: QUERY +PREHOOK: Input: default@smb_bucket4_1_n0 +PREHOOK: Input: default@smb_bucket4_2_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select /*+mapjoin(b,c)*/ * from smb_bucket4_1_n0 a join smb_bucket4_2_n0 b on a.key = b.key join smb_bucket4_2_n0 c on b.key = c.key where a.key>1000 POSTHOOK: type: QUERY +POSTHOOK: Input: default@smb_bucket4_1_n0 +POSTHOOK: Input: default@smb_bucket4_2_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/sqlmerge.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/sqlmerge.q.out b/ql/src/test/results/clientpositive/llap/sqlmerge.q.out index 8214a24..0994995 100644 --- a/ql/src/test/results/clientpositive/llap/sqlmerge.q.out +++ b/ql/src/test/results/clientpositive/llap/sqlmerge.q.out @@ -19,11 +19,23 @@ WHEN MATCHED AND s.a > 8 THEN DELETE WHEN MATCHED THEN UPDATE SET b = 7 WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) PREHOOK: type: QUERY +PREHOOK: Input: default@acidtbl_n0 +PREHOOK: Input: default@nonacidorctbl_n0 +PREHOOK: Output: default@acidtbl_n0 +PREHOOK: Output: default@acidtbl_n0 +PREHOOK: Output: default@acidtbl_n0 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain merge into acidTbl_n0 as t using nonAcidOrcTbl_n0 s ON t.a = s.a WHEN MATCHED AND s.a > 8 THEN DELETE WHEN MATCHED THEN UPDATE SET b = 7 WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@acidtbl_n0 +POSTHOOK: Input: default@nonacidorctbl_n0 +POSTHOOK: Output: default@acidtbl_n0 +POSTHOOK: Output: default@acidtbl_n0 +POSTHOOK: Output: default@acidtbl_n0 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 @@ -336,9 +348,15 @@ STAGE PLANS: PREHOOK: query: explain merge into acidTbl_n0 as t using nonAcidOrcTbl_n0 s ON t.a = s.a WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) PREHOOK: type: QUERY +PREHOOK: Input: default@acidtbl_n0 +PREHOOK: Input: default@nonacidorctbl_n0 +PREHOOK: Output: default@acidtbl_n0 POSTHOOK: query: explain merge into acidTbl_n0 as t using nonAcidOrcTbl_n0 s ON t.a = s.a WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@acidtbl_n0 +POSTHOOK: Input: default@nonacidorctbl_n0 +POSTHOOK: Output: default@acidtbl_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/sqlmerge_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/sqlmerge_stats.q.out b/ql/src/test/results/clientpositive/llap/sqlmerge_stats.q.out index eba16aa..02aa87a 100644 --- a/ql/src/test/results/clientpositive/llap/sqlmerge_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/sqlmerge_stats.q.out @@ -112,10 +112,20 @@ PREHOOK: query: explain merge into t as t using upd_t as u ON t.a = u.a WHEN MATCHED THEN UPDATE SET b = 99 WHEN NOT MATCHED THEN INSERT VALUES(u.a, u.b) PREHOOK: type: QUERY +PREHOOK: Input: default@t +PREHOOK: Input: default@upd_t +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@t +PREHOOK: Output: default@t POSTHOOK: query: explain merge into t as t using upd_t as u ON t.a = u.a WHEN MATCHED THEN UPDATE SET b = 99 WHEN NOT MATCHED THEN INSERT VALUES(u.a, u.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t +POSTHOOK: Input: default@upd_t +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@t +POSTHOOK: Output: default@t 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/163caed7/ql/src/test/results/clientpositive/llap/stats11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/stats11.q.out b/ql/src/test/results/clientpositive/llap/stats11.q.out index 5b8e18c..d244ddf 100644 --- a/ql/src/test/results/clientpositive/llap/stats11.q.out +++ b/ql/src/test/results/clientpositive/llap/stats11.q.out @@ -33,9 +33,13 @@ POSTHOOK: Output: default@srcbucket_mapjoin_part_n16 PREHOOK: query: explain load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_part_n16 partition(ds='2008-04-08') PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@srcbucket_mapjoin_part_n16 POSTHOOK: query: explain load data local inpath '../../data/files/bmj/000000_0' INTO TABLE srcbucket_mapjoin_part_n16 partition(ds='2008-04-08') POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@srcbucket_mapjoin_part_n16 STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 @@ -289,12 +293,20 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n15 a join srcbucket_mapjoin_part_n16 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n15 +PREHOOK: Input: default@srcbucket_mapjoin_part_n16 +PREHOOK: Input: default@srcbucket_mapjoin_part_n16@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n7 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n7 select /*+mapjoin(b)*/ a.key, a.value, b.value from srcbucket_mapjoin_n15 a join srcbucket_mapjoin_part_n16 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n15 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n16 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n16@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n7 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_n15` @@ -723,12 +735,20 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n15 a join srcbucket_mapjoin_part_n16 b on a.key=b.key where b.ds="2008-04-08" PREHOOK: type: QUERY +PREHOOK: Input: default@srcbucket_mapjoin_n15 +PREHOOK: Input: default@srcbucket_mapjoin_part_n16 +PREHOOK: Input: default@srcbucket_mapjoin_part_n16@ds=2008-04-08 +PREHOOK: Output: default@bucketmapjoin_tmp_result_n7 POSTHOOK: query: explain extended insert overwrite table bucketmapjoin_tmp_result_n7 select /*+mapjoin(a)*/ a.key, a.value, b.value from srcbucket_mapjoin_n15 a join srcbucket_mapjoin_part_n16 b on a.key=b.key where b.ds="2008-04-08" POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcbucket_mapjoin_n15 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n16 +POSTHOOK: Input: default@srcbucket_mapjoin_part_n16@ds=2008-04-08 +POSTHOOK: Output: default@bucketmapjoin_tmp_result_n7 OPTIMIZED SQL: SELECT `t0`.`key`, `t0`.`value`, `t2`.`value` AS `value1` FROM (SELECT `key`, `value` FROM `default`.`srcbucket_mapjoin_n15` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/stats_based_fetch_decision.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/stats_based_fetch_decision.q.out b/ql/src/test/results/clientpositive/llap/stats_based_fetch_decision.q.out index 591199b..62a569d 100644 --- a/ql/src/test/results/clientpositive/llap/stats_based_fetch_decision.q.out +++ b/ql/src/test/results/clientpositive/llap/stats_based_fetch_decision.q.out @@ -24,8 +24,12 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain select * from src where key is null PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src where key is null POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -46,8 +50,20 @@ STAGE PLANS: PREHOOK: query: explain select key,value from srcpart where key is null PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from srcpart where key is null POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -92,8 +108,12 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain select * from src where key is null PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src where key is null 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 @@ -134,8 +154,20 @@ STAGE PLANS: PREHOOK: query: explain select key,value from srcpart where key is null PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from srcpart where key is null POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/stats_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/stats_date.q.out b/ql/src/test/results/clientpositive/llap/stats_date.q.out index 228dbd2..4cc091a 100644 --- a/ql/src/test/results/clientpositive/llap/stats_date.q.out +++ b/ql/src/test/results/clientpositive/llap/stats_date.q.out @@ -29,8 +29,12 @@ POSTHOOK: Output: default@foo_n9 Warning: Value had a \n character in it. PREHOOK: query: explain select max(x) from foo_n9 PREHOOK: type: QUERY +PREHOOK: Input: default@foo_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select max(x) from foo_n9 POSTHOOK: type: QUERY +POSTHOOK: Input: default@foo_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -43,8 +47,12 @@ STAGE PLANS: PREHOOK: query: explain select count(x) from foo_n9 PREHOOK: type: QUERY +PREHOOK: Input: default@foo_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(x) from foo_n9 POSTHOOK: type: QUERY +POSTHOOK: Input: default@foo_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -57,8 +65,12 @@ STAGE PLANS: PREHOOK: query: explain select count(x), max(x), min(x) from foo_n9 PREHOOK: type: QUERY +PREHOOK: Input: default@foo_n9 +#### A masked pattern was here #### POSTHOOK: query: explain select count(x), max(x), min(x) from foo_n9 POSTHOOK: type: QUERY +POSTHOOK: Input: default@foo_n9 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/stats_noscan_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/stats_noscan_1.q.out b/ql/src/test/results/clientpositive/llap/stats_noscan_1.q.out index 2d3bac7..af55d23 100644 --- a/ql/src/test/results/clientpositive/llap/stats_noscan_1.q.out +++ b/ql/src/test/results/clientpositive/llap/stats_noscan_1.q.out @@ -36,9 +36,17 @@ POSTHOOK: Lineage: analyze_srcpart_n0 PARTITION(ds=2008-04-09,hr=12).value SIMPL PREHOOK: query: explain analyze table analyze_srcpart_n0 PARTITION(ds='2008-04-08',hr=11) compute statistics noscan PREHOOK: type: QUERY +PREHOOK: Input: default@analyze_srcpart_n0 +PREHOOK: Input: default@analyze_srcpart_n0@ds=2008-04-08/hr=11 +PREHOOK: Output: default@analyze_srcpart_n0 +PREHOOK: Output: default@analyze_srcpart_n0@ds=2008-04-08/hr=11 POSTHOOK: query: explain analyze table analyze_srcpart_n0 PARTITION(ds='2008-04-08',hr=11) compute statistics noscan POSTHOOK: type: QUERY +POSTHOOK: Input: default@analyze_srcpart_n0 +POSTHOOK: Input: default@analyze_srcpart_n0@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@analyze_srcpart_n0 +POSTHOOK: Output: default@analyze_srcpart_n0@ds=2008-04-08/hr=11 STAGE DEPENDENCIES: Stage-2 is a root stage @@ -298,9 +306,21 @@ POSTHOOK: Lineage: analyze_srcpart_partial PARTITION(ds=2008-04-09,hr=12).value PREHOOK: query: explain analyze table analyze_srcpart_partial PARTITION(ds='2008-04-08') compute statistics noscan PREHOOK: type: QUERY +PREHOOK: Input: default@analyze_srcpart_partial +PREHOOK: Input: default@analyze_srcpart_partial@ds=2008-04-08/hr=11 +PREHOOK: Input: default@analyze_srcpart_partial@ds=2008-04-08/hr=12 +PREHOOK: Output: default@analyze_srcpart_partial +PREHOOK: Output: default@analyze_srcpart_partial@ds=2008-04-08/hr=11 +PREHOOK: Output: default@analyze_srcpart_partial@ds=2008-04-08/hr=12 POSTHOOK: query: explain analyze table analyze_srcpart_partial PARTITION(ds='2008-04-08') compute statistics noscan POSTHOOK: type: QUERY +POSTHOOK: Input: default@analyze_srcpart_partial +POSTHOOK: Input: default@analyze_srcpart_partial@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@analyze_srcpart_partial@ds=2008-04-08/hr=12 +POSTHOOK: Output: default@analyze_srcpart_partial +POSTHOOK: Output: default@analyze_srcpart_partial@ds=2008-04-08/hr=11 +POSTHOOK: Output: default@analyze_srcpart_partial@ds=2008-04-08/hr=12 STAGE DEPENDENCIES: Stage-2 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/stats_only_external.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/stats_only_external.q.out b/ql/src/test/results/clientpositive/llap/stats_only_external.q.out index 97dc688..f0967a3 100644 --- a/ql/src/test/results/clientpositive/llap/stats_only_external.q.out +++ b/ql/src/test/results/clientpositive/llap/stats_only_external.q.out @@ -65,8 +65,12 @@ POSTHOOK: Output: default@stats_only_external_tab1_ext test.comment=Regular table should should compute using stats PREHOOK: query: explain select count(*) from stats_only_external_tab1 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_only_external_tab1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from stats_only_external_tab1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_only_external_tab1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -80,8 +84,12 @@ STAGE PLANS: test.comment=External table should not should compute using stats PREHOOK: query: explain select count(*) from stats_only_external_tab1_ext PREHOOK: type: QUERY +PREHOOK: Input: default@stats_only_external_tab1_ext +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from stats_only_external_tab1_ext POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_only_external_tab1_ext +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -137,8 +145,12 @@ STAGE PLANS: test.comment=Query predicates removed due to column stats PREHOOK: query: explain select count(*) from stats_only_external_tab1 where value is not null and key >= 0 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_only_external_tab1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from stats_only_external_tab1 where value is not null and key >= 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_only_external_tab1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -152,8 +164,12 @@ STAGE PLANS: test.comment=Predicate removal disabled for external tables PREHOOK: query: explain select count(*) from stats_only_external_tab1_ext where value is not null and key >= 0 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_only_external_tab1_ext +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from stats_only_external_tab1_ext where value is not null and key >= 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_only_external_tab1_ext +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/stats_only_null.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/stats_only_null.q.out b/ql/src/test/results/clientpositive/llap/stats_only_null.q.out index 8273872..3656d53 100644 --- a/ql/src/test/results/clientpositive/llap/stats_only_null.q.out +++ b/ql/src/test/results/clientpositive/llap/stats_only_null.q.out @@ -69,9 +69,13 @@ POSTHOOK: Lineage: stats_null_part PARTITION(dt=2011).d SIMPLE [(temps_null)temp PREHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null PREHOOK: type: QUERY +PREHOOK: Input: default@stats_null +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_null +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -129,9 +133,17 @@ STAGE PLANS: PREHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_null_part +PREHOOK: Input: default@stats_null_part@dt=2010 +PREHOOK: Input: default@stats_null_part@dt=2011 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_null_part +POSTHOOK: Input: default@stats_null_part@dt=2010 +POSTHOOK: Input: default@stats_null_part@dt=2011 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -305,9 +317,13 @@ Storage Desc Params: PREHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null PREHOOK: type: QUERY +PREHOOK: Input: default@stats_null +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_null +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -321,9 +337,13 @@ STAGE PLANS: PREHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null_part PREHOOK: type: QUERY +PREHOOK: Input: default@stats_null_part +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(a), count(b), count(c), count(d) from stats_null_part POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_null_part +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/llap/subquery_corr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/subquery_corr.q.out b/ql/src/test/results/clientpositive/llap/subquery_corr.q.out index e707d02..b4dbad1 100644 --- a/ql/src/test/results/clientpositive/llap/subquery_corr.q.out +++ b/ql/src/test/results/clientpositive/llap/subquery_corr.q.out @@ -1,7 +1,11 @@ PREHOOK: query: explain select * from src b where b.key in (select key from src a where b.value > a.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b where b.key in (select key from src a where b.value > a.value) 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 @@ -101,8 +105,12 @@ POSTHOOK: Input: default@src #### A masked pattern was here #### PREHOOK: query: explain select * from src b where b.key in (select key from src a where b.value <= a.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b where b.key in (select key from src a where b.value <= a.value) 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 @@ -702,8 +710,12 @@ POSTHOOK: Input: default@src 98 val_98 PREHOOK: query: explain select * from src b where b.key in (select key from src a where b.value > a.value and b.key < a.key) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b where b.key in (select key from src a where b.value > a.value and b.key < a.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/163caed7/ql/src/test/results/clientpositive/llap/subquery_exists.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/subquery_exists.q.out b/ql/src/test/results/clientpositive/llap/subquery_exists.q.out index 4ef0df9..8837e1b 100644 --- a/ql/src/test/results/clientpositive/llap/subquery_exists.q.out +++ b/ql/src/test/results/clientpositive/llap/subquery_exists.q.out @@ -7,6 +7,8 @@ where exists where b.value = a.value and a.key = b.key and a.value > 'val_9' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b @@ -16,6 +18,8 @@ where exists where b.value = a.value and a.key = b.key and a.value > 'val_9' ) 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 @@ -216,6 +220,8 @@ where exists where b.VALUE = a.VALUE ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b @@ -225,6 +231,8 @@ where exists where b.VALUE = a.VALUE ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -318,6 +326,8 @@ where exists where a.value > 'val_9' ) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src b @@ -327,6 +337,8 @@ where exists where a.value > 'val_9' ) 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 @@ -966,8 +978,14 @@ POSTHOOK: Lineage: t_n12.i SCRIPT [] Warning: Shuffle Join MERGEJOIN[16][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product PREHOOK: query: explain select * from t_n12 where exists (select count(*) from src where 1=2) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@t_n12 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t_n12 where exists (select count(*) from src where 1=2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@t_n12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1116,9 +1134,13 @@ POSTHOOK: Input: default@tx1_n0 PREHOOK: query: explain select count(*) as result,3 as expected from tx1_n0 u where exists (select * from tx1_n0 v where u.a=v.a and u.b <> v.b) PREHOOK: type: QUERY +PREHOOK: Input: default@tx1_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) as result,3 as expected from tx1_n0 u where exists (select * from tx1_n0 v where u.a=v.a and u.b <> v.b) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tx1_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1274,8 +1296,14 @@ POSTHOOK: Lineage: t2_n41.i SCRIPT [] POSTHOOK: Lineage: t2_n41.j SCRIPT [] PREHOOK: query: explain select * from t1_n68 where t1_n68.i in (select t2_n41.i from t2_n41 where t2_n41.j <> t1_n68.j) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n68 +PREHOOK: Input: default@t2_n41 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t1_n68 where t1_n68.i in (select t2_n41.i from t2_n41 where t2_n41.j <> t1_n68.j) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n68 +POSTHOOK: Input: default@t2_n41 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
