http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out index 6be0911..6383d0a 100644 --- a/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out +++ b/ql/src/test/results/clientpositive/llap/metadata_only_queries_with_filters.q.out @@ -153,9 +153,13 @@ POSTHOOK: Output: default@stats_tbl_part_n0@dt=2014 PREHOOK: query: explain select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt = 2010 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(1), sum(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt = 2010 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -178,9 +182,13 @@ POSTHOOK: Input: default@stats_tbl_part_n0 PREHOOK: query: explain select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt > 2010 PREHOOK: type: QUERY +PREHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*), count(1), sum(1), sum(2), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part_n0 where dt > 2010 POSTHOOK: type: QUERY +POSTHOOK: Input: default@stats_tbl_part_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage
http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out index 6735c58..1ed6810 100644 --- a/ql/src/test/results/clientpositive/llap/metadataonly1.q.out +++ b/ql/src/test/results/clientpositive/llap/metadataonly1.q.out @@ -8,8 +8,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@TEST1_n12 PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -102,8 +106,14 @@ POSTHOOK: Output: default@test1_n12 POSTHOOK: Output: default@test1_n12@ds=1 PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -243,8 +253,14 @@ POSTHOOK: Input: default@test1_n12@ds=1 NULL PREHOOK: query: explain extended select count(distinct ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(distinct ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -385,8 +401,14 @@ POSTHOOK: Input: default@test1_n12@ds=1 0 PREHOOK: query: explain extended select count(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -535,9 +557,17 @@ POSTHOOK: Output: default@test1_n12@ds=2 PREHOOK: query: explain extended select count(*) from TEST1_n12 a2 join (select max(ds) m from TEST1_n12) b on a2.ds=b.m PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +PREHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from TEST1_n12 a2 join (select max(ds) m from TEST1_n12) b on a2.ds=b.m POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +POSTHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -942,8 +972,18 @@ POSTHOOK: Output: default@test2_n8 POSTHOOK: Output: default@test2_n8@ds=1/hr=3 PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1190,8 +1230,18 @@ POSTHOOK: Input: default@test2_n8@ds=1/hr=3 #### A masked pattern was here #### PREHOOK: query: explain extended select ds, count(hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1440,8 +1490,16 @@ POSTHOOK: Input: default@test2_n8@ds=1/hr=3 #### A masked pattern was here #### PREHOOK: query: explain extended select max(ds) from TEST1_n12 PREHOOK: type: QUERY +PREHOOK: Input: default@test1_n12 +PREHOOK: Input: default@test1_n12@ds=1 +PREHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### POSTHOOK: query: explain extended select max(ds) from TEST1_n12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test1_n12 +POSTHOOK: Input: default@test1_n12@ds=1 +POSTHOOK: Input: default@test1_n12@ds=2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1681,8 +1739,22 @@ POSTHOOK: Output: default@test2_n8 POSTHOOK: Output: default@test2_n8@ds=01%3A10%3A20/hr=02 PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n8 +PREHOOK: Input: default@test2_n8@ds=01%3A10%3A10/hr=01 +PREHOOK: Input: default@test2_n8@ds=01%3A10%3A20/hr=02 +PREHOOK: Input: default@test2_n8@ds=1/hr=1 +PREHOOK: Input: default@test2_n8@ds=1/hr=2 +PREHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2_n8 group by ds POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n8 +POSTHOOK: Input: default@test2_n8@ds=01%3A10%3A10/hr=01 +POSTHOOK: Input: default@test2_n8@ds=01%3A10%3A20/hr=02 +POSTHOOK: Input: default@test2_n8@ds=1/hr=1 +POSTHOOK: Input: default@test2_n8@ds=1/hr=2 +POSTHOOK: Input: default@test2_n8@ds=1/hr=3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/mm_all.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mm_all.q.out b/ql/src/test/results/clientpositive/llap/mm_all.q.out index 95734b6..98fac89 100644 --- a/ql/src/test/results/clientpositive/llap/mm_all.q.out +++ b/ql/src/test/results/clientpositive/llap/mm_all.q.out @@ -51,8 +51,18 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm_n0 PREHOOK: query: explain insert into table part_mm_n0 partition(key_mm=455) select key from intermediate_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@intermediate_n0 +PREHOOK: Input: default@intermediate_n0@p=455 +PREHOOK: Input: default@intermediate_n0@p=456 +PREHOOK: Input: default@intermediate_n0@p=457 +PREHOOK: Output: default@part_mm_n0@key_mm=455 POSTHOOK: query: explain insert into table part_mm_n0 partition(key_mm=455) select key from intermediate_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@intermediate_n0 +POSTHOOK: Input: default@intermediate_n0@p=455 +POSTHOOK: Input: default@intermediate_n0@p=456 +POSTHOOK: Input: default@intermediate_n0@p=457 +POSTHOOK: Output: default@part_mm_n0@key_mm=455 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mm_bhif.q.out b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out index f6a7ed3..953b433 100644 --- a/ql/src/test/results/clientpositive/llap/mm_bhif.q.out +++ b/ql/src/test/results/clientpositive/llap/mm_bhif.q.out @@ -48,9 +48,15 @@ POSTHOOK: Input: default@t1_mm@ds=1 PREHOOK: query: explain select count(distinct key) from T1_mm PREHOOK: type: QUERY +PREHOOK: Input: default@t1_mm +PREHOOK: Input: default@t1_mm@ds=1 +#### A masked pattern was here #### POSTHOOK: query: explain select count(distinct key) from T1_mm POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_mm +POSTHOOK: Input: default@t1_mm@ds=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/mrr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mrr.q.out b/ql/src/test/results/clientpositive/llap/mrr.q.out index 2a8a2fc..8ce190d 100644 --- a/ql/src/test/results/clientpositive/llap/mrr.q.out +++ b/ql/src/test/results/clientpositive/llap/mrr.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT key, count(value) as cnt FROM src GROUP BY key ORDER BY cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -392,8 +396,12 @@ POSTHOOK: Input: default@src 98 2 PREHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -826,8 +834,12 @@ POSTHOOK: Input: default@src 98 1 PREHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT s2.key, count(distinct s2.value) as cnt FROM src s1 join src s2 on (s1.key = s2.key) GROUP BY s2.key ORDER BY cnt,s2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1267,6 +1279,8 @@ WHERE s1.cnt > 1 ORDER BY s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM @@ -1283,6 +1297,8 @@ WHERE s1.cnt > 1 ORDER BY s1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1604,12 +1620,16 @@ FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src ON (s1.key = src.key) order by s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT * FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src ON (s1.key = src.key) order by s1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out index f8adcd4..b29f0dd 100644 --- a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out @@ -166,6 +166,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM (select bigTbl.key as key, bigTbl.value as value1, @@ -175,6 +179,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -329,6 +337,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM (select bigTbl.key as key, bigTbl.value as value1, @@ -338,6 +350,10 @@ select count(*) FROM JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -493,6 +509,10 @@ JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) group by smallTbl2.key PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) FROM (select bigTbl.key as key, bigTbl.value as value1, @@ -503,6 +523,10 @@ JOIN smallTbl2 on (firstjoin.value1 = smallTbl2.value) group by smallTbl2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -775,6 +799,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -808,6 +838,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1110,6 +1146,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -1143,6 +1185,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1445,6 +1493,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -1478,6 +1532,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1811,6 +1871,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) PREHOOK: type: QUERY +PREHOOK: Input: default@bigtbl +PREHOOK: Input: default@smalltbl1 +PREHOOK: Input: default@smalltbl2 +PREHOOK: Input: default@smalltbl3 +PREHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT SUM(HASH(join3.key1)), SUM(HASH(join3.key2)), @@ -1844,6 +1910,12 @@ FROM (SELECT join2.key1 as key1, JOIN smallTbl3 ON (join2.key2 = smallTbl3.key)) join3 JOIN smallTbl4 ON (join3.key3 = smallTbl4.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@bigtbl +POSTHOOK: Input: default@smalltbl1 +POSTHOOK: Input: default@smalltbl2 +POSTHOOK: Input: default@smalltbl3 +POSTHOOK: Input: default@smalltbl4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out index 61b7c4e..7252811 100644 --- a/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out +++ b/ql/src/test/results/clientpositive/llap/multiMapJoin2.q.out @@ -5,6 +5,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp.key FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) @@ -12,6 +15,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -243,6 +249,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp.key FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) @@ -250,6 +259,9 @@ FROM (SELECT x1.key AS key FROM src x1 JOIN src1 y1 ON (x1.key = y1.key) SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -493,6 +505,9 @@ FROM (SELECT x1.key AS key FROM src1 x1 GROUP BY x1.key SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp.key FROM (SELECT x1.key AS key FROM src1 x1 GROUP BY x1.key @@ -500,6 +515,9 @@ FROM (SELECT x1.key AS key FROM src1 x1 GROUP BY x1.key SELECT x2.key AS key FROM src x2 JOIN src1 y2 ON (x2.key = y2.key)) tmp ORDER BY tmp.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -701,6 +719,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -713,6 +734,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -941,6 +965,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -953,6 +980,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1181,6 +1211,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -1193,6 +1226,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1405,6 +1441,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT tmp1.key as key, count(*) as cnt FROM (SELECT x1.key AS key @@ -1417,6 +1456,9 @@ ON (tmp1.key = tmp2.key) GROUP BY tmp1.key ORDER BY key, cnt POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1662,10 +1704,20 @@ PREHOOK: query: EXPLAIN SELECT count(*) FROM part_table_n0 x JOIN src1 y ON (x.key = y.key) PREHOOK: type: QUERY +PREHOOK: Input: default@part_table_n0 +PREHOOK: Input: default@part_table_n0@partitionid=1 +PREHOOK: Input: default@part_table_n0@partitionid=2 +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT count(*) FROM part_table_n0 x JOIN src1 y ON (x.key = y.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@part_table_n0 +POSTHOOK: Input: default@part_table_n0@partitionid=1 +POSTHOOK: Input: default@part_table_n0@partitionid=2 +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1781,6 +1833,8 @@ SELECT x.key FROM ( JOIN src c ON tmp.key=c.key ) x order by x.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT x.key FROM ( SELECT c.key FROM @@ -1792,6 +1846,8 @@ SELECT x.key FROM ( JOIN src c ON tmp.key=c.key ) x order by x.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out index f6b6fec..141cc16 100644 --- a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out @@ -104,9 +104,13 @@ POSTHOOK: Input: default@emps_n1 PREHOOK: query: explain select * from emps_n1 where (empno+1,deptno) in ((1,2),(3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n1 where (empno+1,deptno) in ((1,2),(3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -127,9 +131,13 @@ STAGE PLANS: PREHOOK: query: explain select * from emps_n1 where (empno+1,deptno) not in ((1,2),(3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n1 where (empno+1,deptno) not in ((1,2),(3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -195,8 +203,12 @@ POSTHOOK: Input: default@emps_n1 2 5 22 PREHOOK: query: explain select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out index 81fdb13..72f532a 100644 --- a/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_column_in_single.q.out @@ -114,9 +114,13 @@ POSTHOOK: Input: default@emps_n7 PREHOOK: query: explain select * from emps_n7 where (empno+1,deptno) in ((3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n7 where (empno+1,deptno) in ((3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -137,9 +141,13 @@ STAGE PLANS: PREHOOK: query: explain select * from emps_n7 where (empno+1,deptno) not in ((3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n7 where (empno+1,deptno) not in ((3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -159,8 +167,12 @@ STAGE PLANS: PREHOOK: query: explain select * from emps_n7 where ((empno*2)|1,deptno) in ((empno+2,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@emps_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emps_n7 where ((empno*2)|1,deptno) in ((empno+2,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@emps_n7 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out index 9633ae0..a049b02 100644 --- a/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out @@ -23,8 +23,12 @@ POSTHOOK: Lineage: employee.education_level SCRIPT [] POSTHOOK: Lineage: employee.gender SCRIPT [] PREHOOK: query: explain select count(distinct department_id), count(distinct gender), count(distinct education_level) from employee PREHOOK: type: QUERY +PREHOOK: Input: default@employee +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select count(distinct department_id), count(distinct gender), count(distinct education_level) from employee POSTHOOK: type: QUERY +POSTHOOK: Input: default@employee +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -163,9 +167,13 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select count(distinct gender), count(distinct department_id), count(distinct gender), count(distinct education_level), count(distinct education_level, department_id), count(distinct department_id, education_level), count(distinct department_id, education_level, gender) from employee PREHOOK: type: QUERY +PREHOOK: Input: default@employee +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select count(distinct gender), count(distinct department_id), count(distinct gender), count(distinct education_level), count(distinct education_level, department_id), count(distinct department_id, education_level), count(distinct department_id, education_level, gender) from employee POSTHOOK: type: QUERY +POSTHOOK: Input: default@employee +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multi_insert.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_insert.q.out b/ql/src/test/results/clientpositive/llap/multi_insert.q.out index 53ae291..11462f8 100644 --- a/ql/src/test/results/clientpositive/llap/multi_insert.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_insert.q.out @@ -19,11 +19,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -232,11 +238,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -445,11 +457,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -658,11 +676,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -871,11 +895,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1093,11 +1123,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1315,11 +1351,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1537,11 +1579,17 @@ from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from src insert overwrite table src_multi1_n5 select * where key < 10 group by key, value insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 group by key, value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -1759,11 +1807,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2050,11 +2104,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2341,11 +2401,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2632,11 +2698,17 @@ from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n5 +PREHOOK: Output: default@src_multi2_n6 POSTHOOK: query: explain from (select * from src union all select * from src) s insert overwrite table src_multi1_n5 select * where key < 10 insert overwrite table src_multi2_n6 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n5 +POSTHOOK: Output: default@src_multi2_n6 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2923,10 +2995,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -3026,10 +3102,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -3129,10 +3209,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -3232,10 +3316,14 @@ PREHOOK: query: explain from src #### A masked pattern was here #### PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain from src #### A masked pattern was here #### POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out b/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out index 74a6945..ecca6ea 100644 --- a/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out +++ b/ql/src/test/results/clientpositive/llap/multi_insert_lateral_view.q.out @@ -39,11 +39,17 @@ from src_10_n0 insert overwrite table src_lv1 select key, C lateral view explode(array(key+1, key+2)) A as C insert overwrite table src_lv2 select key, C lateral view explode(array(key+3, key+4)) A as C PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, C lateral view explode(array(key+1, key+2)) A as C insert overwrite table src_lv2 select key, C lateral view explode(array(key+3, key+4)) A as C POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -355,11 +361,17 @@ from src_10_n0 insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key insert overwrite table src_lv2 select key, sum(C) lateral view explode(array(key+3, key+4)) A as C group by key PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key insert overwrite table src_lv2 select key, sum(C) lateral view explode(array(key+3, key+4)) A as C group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -670,12 +682,20 @@ insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key insert overwrite table src_lv2 select key, count(value) where key > 200 group by key insert overwrite table src_lv3 select key, count(value) where key < 200 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 +PREHOOK: Output: default@src_lv3 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, sum(C) lateral view explode(array(key+1, key+2)) A as C group by key insert overwrite table src_lv2 select key, count(value) where key > 200 group by key insert overwrite table src_lv3 select key, count(value) where key < 200 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 +POSTHOOK: Output: default@src_lv3 STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -1041,12 +1061,20 @@ insert overwrite table src_lv1 select C, sum(distinct key) lateral view explode( insert overwrite table src_lv2 select C, sum(distinct key) lateral view explode(array(key+3, key+4)) A as C group by C insert overwrite table src_lv3 select value, sum(distinct key) group by value PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 +PREHOOK: Output: default@src_lv3 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select C, sum(distinct key) lateral view explode(array(key+1, key+2)) A as C group by C insert overwrite table src_lv2 select C, sum(distinct key) lateral view explode(array(key+3, key+4)) A as C group by C insert overwrite table src_lv3 select value, sum(distinct key) group by value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 +POSTHOOK: Output: default@src_lv3 STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -1492,6 +1520,11 @@ insert overwrite table src_lv2 select key, sum(distinct C) lateral view explode( insert overwrite table src_lv3 select value, sum(distinct key) where key > 200 group by value insert overwrite table src_lv4 select value, sum(distinct key) where key < 200 group by value PREHOOK: type: QUERY +PREHOOK: Input: default@src_10_n0 +PREHOOK: Output: default@src_lv1 +PREHOOK: Output: default@src_lv2 +PREHOOK: Output: default@src_lv3 +PREHOOK: Output: default@src_lv4 POSTHOOK: query: explain from src_10_n0 insert overwrite table src_lv1 select key, sum(distinct C) lateral view explode(array(key+1, key+2)) A as C group by key @@ -1499,6 +1532,11 @@ insert overwrite table src_lv2 select key, sum(distinct C) lateral view explode( insert overwrite table src_lv3 select value, sum(distinct key) where key > 200 group by value insert overwrite table src_lv4 select value, sum(distinct key) where key < 200 group by value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_10_n0 +POSTHOOK: Output: default@src_lv1 +POSTHOOK: Output: default@src_lv2 +POSTHOOK: Output: default@src_lv3 +POSTHOOK: Output: default@src_lv4 STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/nonmr_fetch_threshold.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/nonmr_fetch_threshold.q.out b/ql/src/test/results/clientpositive/llap/nonmr_fetch_threshold.q.out index 0461224..1db317a 100644 --- a/ql/src/test/results/clientpositive/llap/nonmr_fetch_threshold.q.out +++ b/ql/src/test/results/clientpositive/llap/nonmr_fetch_threshold.q.out @@ -1,7 +1,13 @@ PREHOOK: query: explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -16,8 +22,12 @@ Stage-0 PREHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -32,8 +42,14 @@ Stage-0 PREHOOK: query: explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -48,8 +64,12 @@ Stage-0 PREHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -64,8 +84,12 @@ Stage-0 PREHOOK: query: explain select concat(key, value) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select concat(key, value) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -78,8 +102,14 @@ Stage-0 PREHOOK: query: explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain select * from srcpart where ds='2008-04-08' AND hr='11' limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -94,8 +124,12 @@ Stage-0 PREHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select cast(key as int) * 10, upper(value) from src limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -110,8 +144,12 @@ Stage-0 PREHOOK: query: explain select concat(key, value) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select concat(key, value) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -127,8 +165,12 @@ Stage-0 PREHOOK: query: explain select key, value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -141,8 +183,12 @@ Stage-0 PREHOOK: query: explain select key from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -155,8 +201,12 @@ Stage-0 PREHOOK: query: explain select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -169,8 +219,12 @@ Stage-0 PREHOOK: query: explain select key,1 from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,1 from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -183,8 +237,12 @@ Stage-0 PREHOOK: query: explain select cast(key as char(20)),1 from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select cast(key as char(20)),1 from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/offset_limit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/offset_limit.q.out b/ql/src/test/results/clientpositive/llap/offset_limit.q.out index 0e718fd..f07224f 100644 --- a/ql/src/test/results/clientpositive/llap/offset_limit.q.out +++ b/ql/src/test/results/clientpositive/llap/offset_limit.q.out @@ -1,9 +1,13 @@ PREHOOK: query: EXPLAIN SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 10,10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 10,10 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/c39b5d1b/ql/src/test/results/clientpositive/llap/offset_limit_ppd_optimizer.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/offset_limit_ppd_optimizer.q.out b/ql/src/test/results/clientpositive/llap/offset_limit_ppd_optimizer.q.out index 4c62d7f..063fb61 100644 --- a/ql/src/test/results/clientpositive/llap/offset_limit_ppd_optimizer.q.out +++ b/ql/src/test/results/clientpositive/llap/offset_limit_ppd_optimizer.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select key,value from src order by key limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -89,9 +93,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select key,value from src order by key desc limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key desc limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -177,9 +185,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select value, sum(key + 1) as sum from src group by value order by value limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key + 1) as sum from src group by value order by value limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -274,9 +286,13 @@ val_15 32.0 PREHOOK: query: explain select value,avg(key + 1) from src group by value order by value limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value,avg(key + 1) from src group by value order by value limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -375,9 +391,13 @@ val_15 16.0 PREHOOK: query: explain select distinct(cdouble) as dis from alltypesorc order by dis limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select distinct(cdouble) as dis from alltypesorc order by dis limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -469,9 +489,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint order by ctinyint limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint order by ctinyint limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -568,9 +592,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(cdouble) from (select ctinyint, cdouble from alltypesorc group by ctinyint, cdouble) t1 group by ctinyint order by ctinyint limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(cdouble) from (select ctinyint, cdouble from alltypesorc group by ctinyint, cdouble) t1 group by ctinyint order by ctinyint limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -667,9 +695,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint order by ctinyint limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint order by ctinyint limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -763,9 +795,13 @@ POSTHOOK: Input: default@alltypesorc PREHOOK: query: explain select key,value from src order by key limit 0,0 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value from src order by key limit 0,0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -787,9 +823,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select value, sum(key) as sum from src group by value order by sum, value limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key) as sum from src group by value order by sum, value limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -896,9 +936,13 @@ val_65 65.0 PREHOOK: query: explain select value, sum(key) as sum from src group by value order by value limit 10,20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select value, sum(key) as sum from src group by value order by value limit 10,20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -987,9 +1031,13 @@ val_15 30.0 PREHOOK: query: explain select key,value,value,value,value,value,value,value,value from src order by key limit 30,70 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key,value,value,value,value,value,value,value,value from src order by key limit 30,70 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 @@ -1125,9 +1173,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 30,70 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select sum(key) as sum from src group by concat(key,value,value,value,value,value,value,value,value,value) order by sum limit 30,70 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 @@ -1286,6 +1338,8 @@ join (select key, count(1) from src group by key limit 20,20) subq2 on subq.key=subq2.key limit 3,5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select key, count(1) from src group by key order by key limit 10,20) subq @@ -1293,6 +1347,8 @@ join (select key, count(1) from src group by key limit 20,20) subq2 on subq.key=subq2.key limit 3,5 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/c39b5d1b/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out b/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out index e4e3f74..81f6de3 100644 --- a/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out +++ b/ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out @@ -37,9 +37,15 @@ POSTHOOK: Lineage: t2_n60.v SCRIPT [] PREHOOK: query: explain select * from t1_n97 where t1_n97.k in (select t2_n60.k from t2_n60 where t2_n60.v='people') and t1_n97.k<15 PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n97 +PREHOOK: Input: default@t2_n60 +#### A masked pattern was here #### POSTHOOK: query: explain select * from t1_n97 where t1_n97.k in (select t2_n60.k from t2_n60 where t2_n60.v='people') and t1_n97.k<15 POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n97 +POSTHOOK: Input: default@t2_n60 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out b/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out index eca9027..bd15e9b 100644 --- a/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out +++ b/ql/src/test/results/clientpositive/llap/optimize_nullscan.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain extended select key from src where false PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain extended select key from src where false POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -34,9 +38,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain extended select count(key) from srcpart where 1=2 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(key) from srcpart where 1=2 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -130,9 +138,23 @@ POSTHOOK: Input: default@srcpart PREHOOK: query: explain extended select * from (select key from src where false) a left outer join (select key from srcpart limit 0) b on a.key=b.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +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 extended select * from (select key from src where false) a left outer join (select key from srcpart limit 0) b on a.key=b.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +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 @@ -529,9 +551,23 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 PREHOOK: query: explain extended select count(key) from src where false union all select count(key) from srcpart PREHOOK: type: QUERY +PREHOOK: Input: default@src +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 extended select count(key) from src where false union all select count(key) from srcpart POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +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 @@ -944,9 +980,23 @@ Warning: Shuffle Join MERGEJOIN[15][tables = [a, b]] in Stage 'Reducer 2' is a c PREHOOK: query: explain extended select * from (select key from src where false) a left outer join (select value from srcpart limit 0) b PREHOOK: type: QUERY +PREHOOK: Input: default@src +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 extended select * from (select key from src where false) a left outer join (select value from srcpart limit 0) b POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +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 @@ -1342,9 +1392,15 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 PREHOOK: query: explain extended select * from (select key from src union all select src.key from src left outer join srcpart on src.key = srcpart.key) a where false PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@srcpart +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from (select key from src union all select src.key from src left outer join srcpart on src.key = srcpart.key) a where false POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@srcpart +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1598,9 +1654,13 @@ POSTHOOK: Input: default@srcpart PREHOOK: query: explain extended select * from src s1, src s2 where false and s1.value = s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain extended select * from src s1, src s2 where false and s1.value = s2.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 @@ -1816,9 +1876,13 @@ POSTHOOK: Input: default@src PREHOOK: query: explain extended select count(1) from src where null = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(1) from src where null = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/orc_llap.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_llap.q.out b/ql/src/test/results/clientpositive/llap/orc_llap.q.out index 7f8667e..3f641c8 100644 --- a/ql/src/test/results/clientpositive/llap/orc_llap.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_llap.q.out @@ -125,9 +125,13 @@ Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reduc PREHOOK: query: explain select count(1) from orc_llap_small y join orc_llap_small x PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_small +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from orc_llap_small y join orc_llap_small x POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_small +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -237,9 +241,13 @@ POSTHOOK: Input: default@orc_llap_small PREHOOK: query: explain select sum(hash(*)) from (select cint, csmallint, cbigint from orc_llap where cint > 10 and cbigint is not null) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select cint, csmallint, cbigint from orc_llap where cint > 10 and cbigint is not null) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -310,9 +318,13 @@ POSTHOOK: Input: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select * from orc_llap where cint > 10 and cbigint is not null) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select * from orc_llap where cint > 10 and cbigint is not null) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -383,9 +395,13 @@ POSTHOOK: Input: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select cstring2 from orc_llap where cint > 5 and cint < 10) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select cstring2 from orc_llap where cint > 5 and cint < 10) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -456,9 +472,13 @@ NULL PREHOOK: query: explain select sum(hash(*)) from (select cstring1, cstring2, count(*) from orc_llap group by cstring1, cstring2) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select cstring1, cstring2, count(*) from orc_llap group by cstring1, cstring2) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -551,9 +571,13 @@ POSTHOOK: Input: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select o1.cstring1, o2.cstring2 from orc_llap o1 inner join orc_llap o2 on o1.csmallint = o2.csmallint where o1.cbigint is not null and o2.cbigint is not null) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select o1.cstring1, o2.cstring2 from orc_llap o1 inner join orc_llap o2 on o1.csmallint = o2.csmallint where o1.cbigint is not null and o2.cbigint is not null) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -695,9 +719,13 @@ POSTHOOK: Output: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select cint, csmallint, cbigint from orc_llap where cint > 10 and cbigint is not null) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select cint, csmallint, cbigint from orc_llap where cint > 10 and cbigint is not null) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -768,9 +796,13 @@ POSTHOOK: Input: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select * from orc_llap where cint > 10 and cbigint is not null) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select * from orc_llap where cint > 10 and cbigint is not null) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -841,9 +873,13 @@ POSTHOOK: Input: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select cstring2 from orc_llap where cint > 5 and cint < 10) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select cstring2 from orc_llap where cint > 5 and cint < 10) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -914,9 +950,13 @@ NULL PREHOOK: query: explain select sum(hash(*)) from (select cstring1, cstring2, count(*) from orc_llap group by cstring1, cstring2) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select cstring1, cstring2, count(*) from orc_llap group by cstring1, cstring2) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1009,9 +1049,13 @@ POSTHOOK: Input: default@orc_llap PREHOOK: query: explain select sum(hash(*)) from (select o1.cstring1, o2.cstring2 from orc_llap o1 inner join orc_llap o2 on o1.csmallint = o2.csmallint where o1.cbigint is not null and o2.cbigint is not null) t PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap +#### A masked pattern was here #### POSTHOOK: query: explain select sum(hash(*)) from (select o1.cstring1, o2.cstring2 from orc_llap o1 inner join orc_llap o2 on o1.csmallint = o2.csmallint where o1.cbigint is not null and o2.cbigint is not null) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/orc_llap_nonvector.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_llap_nonvector.q.out b/ql/src/test/results/clientpositive/llap/orc_llap_nonvector.q.out index 364da93..5f8e1ab 100644 --- a/ql/src/test/results/clientpositive/llap/orc_llap_nonvector.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_llap_nonvector.q.out @@ -68,9 +68,13 @@ POSTHOOK: Lineage: orc_llap_nonvector.rdm EXPRESSION [] PREHOOK: query: explain select * from orc_llap_nonvector limit 100 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_nonvector +#### A masked pattern was here #### POSTHOOK: query: explain select * from orc_llap_nonvector limit 100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_nonvector +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -219,9 +223,13 @@ NULL 6544 -316718275 -1887561756 NULL 6544.0 w624FVokyo7m7a220 4hA4KQj2vD3fI6gX8 PREHOOK: query: explain select cint, cstring1 from orc_llap_nonvector limit 1025 PREHOOK: type: QUERY +PREHOOK: Input: default@orc_llap_nonvector +#### A masked pattern was here #### POSTHOOK: query: explain select cint, cstring1 from orc_llap_nonvector limit 1025 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orc_llap_nonvector +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/orc_merge1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge1.q.out b/ql/src/test/results/clientpositive/llap/orc_merge1.q.out index 7189964..036ca75 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge1.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge1.q.out @@ -45,11 +45,14 @@ PREHOOK: query: EXPLAIN SELECT key, value, PMOD(HASH(key), 2) as part FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge1_n1@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge1_n1 PARTITION (ds='1', part) SELECT key, value, PMOD(HASH(key), 2) as part FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -173,11 +176,14 @@ PREHOOK: query: EXPLAIN SELECT key, value, PMOD(HASH(key), 2) as part FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge1b_n1@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge1b_n1 PARTITION (ds='1', part) SELECT key, value, PMOD(HASH(key), 2) as part FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6 @@ -346,11 +352,14 @@ PREHOOK: query: EXPLAIN SELECT key, value, PMOD(HASH(key), 2) as part FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge1c_n1@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge1c_n1 PARTITION (ds='1', part) SELECT key, value, PMOD(HASH(key), 2) as part FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/orc_merge10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge10.q.out b/ql/src/test/results/clientpositive/llap/orc_merge10.q.out index 0f9bb2d..a0b1c40 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge10.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge10.q.out @@ -45,11 +45,14 @@ PREHOOK: query: EXPLAIN SELECT key, value, PMOD(HASH(key), 2) as part FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge1@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge1 PARTITION (ds='1', part) SELECT key, value, PMOD(HASH(key), 2) as part FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -170,11 +173,14 @@ PREHOOK: query: EXPLAIN SELECT key, value, PMOD(HASH(key), 2) as part FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge1b@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge1b PARTITION (ds='1', part) SELECT key, value, PMOD(HASH(key), 2) as part FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6 @@ -343,11 +349,14 @@ PREHOOK: query: EXPLAIN SELECT key, value, PMOD(HASH(key), 2) as part FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge1c@ds=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge1c PARTITION (ds='1', part) SELECT key, value, PMOD(HASH(key), 2) as part FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6 @@ -569,8 +578,12 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 500 PREHOOK: query: explain ALTER TABLE orcfile_merge1 PARTITION (ds='1', part='0') CONCATENATE PREHOOK: type: ALTER_PARTITION_MERGE +PREHOOK: Input: default@orcfile_merge1 +PREHOOK: Output: default@orcfile_merge1@ds=1/part=0 POSTHOOK: query: explain ALTER TABLE orcfile_merge1 PARTITION (ds='1', part='0') CONCATENATE POSTHOOK: type: ALTER_PARTITION_MERGE +POSTHOOK: Input: default@orcfile_merge1 +POSTHOOK: Output: default@orcfile_merge1@ds=1/part=0 STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/orc_merge2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge2.q.out b/ql/src/test/results/clientpositive/llap/orc_merge2.q.out index b6e4dd6..bd7f5df 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge2.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge2.q.out @@ -19,11 +19,14 @@ PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge2a_n0 PARTITION (one PMOD(HASH(value), 10) as three FROM src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@orcfile_merge2a_n0@one=1 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge2a_n0 PARTITION (one='1', two, three) SELECT key, value, PMOD(HASH(key), 10) as two, PMOD(HASH(value), 10) as three FROM src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/c39b5d1b/ql/src/test/results/clientpositive/llap/orc_merge3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/orc_merge3.q.out b/ql/src/test/results/clientpositive/llap/orc_merge3.q.out index b1254f7..89b7de2 100644 --- a/ql/src/test/results/clientpositive/llap/orc_merge3.q.out +++ b/ql/src/test/results/clientpositive/llap/orc_merge3.q.out @@ -51,9 +51,17 @@ POSTHOOK: Lineage: orcfile_merge3a_n0 PARTITION(ds=2).value SIMPLE [(src)src.Fie PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge3b_n0 SELECT key, value FROM orcfile_merge3a_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@orcfile_merge3a_n0 +PREHOOK: Input: default@orcfile_merge3a_n0@ds=1 +PREHOOK: Input: default@orcfile_merge3a_n0@ds=2 +PREHOOK: Output: default@orcfile_merge3b_n0 POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge3b_n0 SELECT key, value FROM orcfile_merge3a_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@orcfile_merge3a_n0 +POSTHOOK: Input: default@orcfile_merge3a_n0@ds=1 +POSTHOOK: Input: default@orcfile_merge3a_n0@ds=2 +POSTHOOK: Output: default@orcfile_merge3b_n0 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1
