You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/08/20 05:27:03 UTC
svn commit: r1619027 - in
/hive/trunk/ql/src/test/results/clientpositive/tez: union2.q.out
union3.q.out union5.q.out union7.q.out union8.q.out union9.q.out
Author: brock
Date: Wed Aug 20 03:27:02 2014
New Revision: 1619027
URL: http://svn.apache.org/r1619027
Log:
HIVE-7786 - add --SORT_BEFORE_DIFF to union all tez .q.out files (Brock reviewed by Szehon)
Modified:
hive/trunk/ql/src/test/results/clientpositive/tez/union2.q.out
hive/trunk/ql/src/test/results/clientpositive/tez/union3.q.out
hive/trunk/ql/src/test/results/clientpositive/tez/union5.q.out
hive/trunk/ql/src/test/results/clientpositive/tez/union7.q.out
hive/trunk/ql/src/test/results/clientpositive/tez/union8.q.out
hive/trunk/ql/src/test/results/clientpositive/tez/union9.q.out
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/union2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/union2.q.out?rev=1619027&r1=1619026&r2=1619027&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/union2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/union2.q.out Wed Aug 20 03:27:02 2014
@@ -1,10 +1,12 @@
-PREHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
+PREHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
explain
select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
select s2.key as key, s2.value as value from src s2) unionsrc
PREHOOK: type: QUERY
-POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
explain
select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/union3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/union3.q.out?rev=1619027&r1=1619026&r2=1619027&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/union3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/union3.q.out Wed Aug 20 03:27:02 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: explain
+PREHOOK: query: -- SORT_BEFORE_DIFF
+
+explain
SELECT *
FROM (
SELECT 1 AS id
@@ -16,7 +18,9 @@ FROM (
FROM (SELECT * FROM src LIMIT 1) s2
) a
PREHOOK: type: QUERY
-POSTHOOK: query: explain
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+
+explain
SELECT *
FROM (
SELECT 1 AS id
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/union5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/union5.q.out?rev=1619027&r1=1619026&r2=1619027&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/union5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/union5.q.out Wed Aug 20 03:27:02 2014
@@ -1,11 +1,13 @@
-PREHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
+PREHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
UNION ALL
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
PREHOOK: type: QUERY
-POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/union7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/union7.q.out?rev=1619027&r1=1619026&r2=1619027&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/union7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/union7.q.out Wed Aug 20 03:27:02 2014
@@ -1,11 +1,13 @@
-PREHOOK: query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
+PREHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key
PREHOOK: type: QUERY
-POSTHOOK: query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/union8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/union8.q.out?rev=1619027&r1=1619026&r2=1619027&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/union8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/union8.q.out Wed Aug 20 03:27:02 2014
@@ -1,11 +1,13 @@
-PREHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink
+PREHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink
explain
select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
select s2.key as key, s2.value as value from src s2 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
PREHOOK: type: QUERY
-POSTHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink
explain
select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/union9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/union9.q.out?rev=1619027&r1=1619026&r2=1619027&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/union9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/union9.q.out Wed Aug 20 03:27:02 2014
@@ -1,11 +1,13 @@
-PREHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink
+PREHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink
explain
select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
select s2.key as key, s2.value as value from src s2 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
PREHOOK: type: QUERY
-POSTHOOK: query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+-- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink
explain
select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION ALL