You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/03/19 19:21:55 UTC
svn commit: r1579333 [1/2] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/
Author: hashutosh
Date: Wed Mar 19 18:21:53 2014
New Revision: 1579333
URL: http://svn.apache.org/r1579333
Log:
HIVE-6688 : Fix groupby_* qfile failures in hadoop-2 (Jason Dere via Ashutosh Chauhan)
Modified:
hive/trunk/ql/src/test/queries/clientpositive/groupby1_limit.q
hive/trunk/ql/src/test/queries/clientpositive/groupby1_map.q
hive/trunk/ql/src/test/queries/clientpositive/groupby1_map_skew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby1_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby2_limit.q
hive/trunk/ql/src/test/queries/clientpositive/groupby2_map.q
hive/trunk/ql/src/test/queries/clientpositive/groupby2_map_multi_distinct.q
hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew_multi_distinct.q
hive/trunk/ql/src/test/queries/clientpositive/groupby4_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby5_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby6_map.q
hive/trunk/ql/src/test/queries/clientpositive/groupby6_map_skew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby6_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby7_map.q
hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_multi_single_reducer.q
hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_skew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew_multi_single_reducer.q
hive/trunk/ql/src/test/queries/clientpositive/groupby8_map.q
hive/trunk/ql/src/test/queries/clientpositive/groupby8_map_skew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby8_noskew.q
hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr.q
hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr_multi_distinct.q
hive/trunk/ql/src/test/queries/clientpositive/groupby_resolution.q
hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew_multi_single_reducer.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_resolution.q.out
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby1_limit.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby1_limit.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby1_limit.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby1_limit.q Wed Mar 19 18:21:53 2014
@@ -5,6 +5,6 @@ CREATE TABLE dest1(key INT, value DOUBLE
EXPLAIN
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5;
-FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5;
+FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key ORDER BY src.key LIMIT 5;
SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC , dest1.value ASC;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby1_map.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby1_map.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby1_map.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby1_map.q Wed Mar 19 18:21:53 2014
@@ -9,4 +9,4 @@ FROM src INSERT OVERWRITE TABLE dest1 SE
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key;
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby1_map_skew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby1_map_skew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby1_map_skew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby1_map_skew.q Wed Mar 19 18:21:53 2014
@@ -9,4 +9,4 @@ FROM src INSERT OVERWRITE TABLE dest1 SE
FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key;
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby1_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby1_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby1_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby1_noskew.q Wed Mar 19 18:21:53 2014
@@ -9,4 +9,4 @@ FROM src INSERT OVERWRITE TABLE dest_g1
FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key;
-SELECT dest_g1.* FROM dest_g1;
+SELECT dest_g1.* FROM dest_g1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby2_limit.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby2_limit.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby2_limit.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby2_limit.q Wed Mar 19 18:21:53 2014
@@ -1,7 +1,7 @@
set mapred.reduce.tasks=31;
EXPLAIN
-SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5;
+SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 5;
-SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5;
+SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 5;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby2_map.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby2_map.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby2_map.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby2_map.q Wed Mar 19 18:21:53 2014
@@ -11,4 +11,4 @@ INSERT OVERWRITE TABLE dest1 SELECT subs
FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby2_map_multi_distinct.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby2_map_multi_distinct.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby2_map_multi_distinct.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby2_map_multi_distinct.q Wed Mar 19 18:21:53 2014
@@ -11,7 +11,7 @@ INSERT OVERWRITE TABLE dest1 SELECT subs
FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
-- HIVE-5560 when group by key is used in distinct funtion, invalid result are returned
@@ -22,4 +22,4 @@ INSERT OVERWRITE TABLE dest1 SELECT subs
FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1), count(DISTINCT substr(src.key,1,1)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew.q Wed Mar 19 18:21:53 2014
@@ -11,4 +11,4 @@ INSERT OVERWRITE TABLE dest_g2 SELECT su
FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1);
-SELECT dest_g2.* FROM dest_g2;
+SELECT dest_g2.* FROM dest_g2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew_multi_distinct.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew_multi_distinct.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew_multi_distinct.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby2_noskew_multi_distinct.q Wed Mar 19 18:21:53 2014
@@ -11,4 +11,4 @@ INSERT OVERWRITE TABLE dest_g2 SELECT su
FROM src
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))), sum(DISTINCT substr(src.value, 5)), count(src.value) GROUP BY substr(src.key,1,1);
-SELECT dest_g2.* FROM dest_g2;
+SELECT dest_g2.* FROM dest_g2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby4_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby4_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby4_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby4_noskew.q Wed Mar 19 18:21:53 2014
@@ -12,5 +12,5 @@ INSERT OVERWRITE TABLE dest1 SELECT subs
FROM src
INSERT OVERWRITE TABLE dest1 SELECT substr(src.key,1,1) GROUP BY substr(src.key,1,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY c1;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby5_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby5_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby5_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby5_noskew.q Wed Mar 19 18:21:53 2014
@@ -16,5 +16,5 @@ SELECT src.key, sum(substr(src.value,5))
FROM src
GROUP BY src.key;
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby6_map.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby6_map.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby6_map.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby6_map.q Wed Mar 19 18:21:53 2014
@@ -11,6 +11,6 @@ INSERT OVERWRITE TABLE dest1 SELECT DIST
FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY c1;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby6_map_skew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby6_map_skew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby6_map_skew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby6_map_skew.q Wed Mar 19 18:21:53 2014
@@ -11,6 +11,6 @@ INSERT OVERWRITE TABLE dest1 SELECT DIST
FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY c1;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby6_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby6_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby6_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby6_noskew.q Wed Mar 19 18:21:53 2014
@@ -12,6 +12,6 @@ INSERT OVERWRITE TABLE dest1 SELECT DIST
FROM src
INSERT OVERWRITE TABLE dest1 SELECT DISTINCT substr(src.value,5,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY c1;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby7_map.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby7_map.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby7_map.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby7_map.q Wed Mar 19 18:21:53 2014
@@ -18,5 +18,5 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_multi_single_reducer.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_multi_single_reducer.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_multi_single_reducer.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_multi_single_reducer.q Wed Mar 19 18:21:53 2014
@@ -17,5 +17,5 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_skew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_skew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_skew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby7_map_skew.q Wed Mar 19 18:21:53 2014
@@ -17,5 +17,5 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew.q Wed Mar 19 18:21:53 2014
@@ -18,5 +18,5 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew_multi_single_reducer.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew_multi_single_reducer.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew_multi_single_reducer.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby7_noskew_multi_single_reducer.q Wed Mar 19 18:21:53 2014
@@ -14,8 +14,8 @@ INSERT OVERWRITE TABLE DEST1 SELECT SRC.
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit 10;
FROM SRC
-INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit 10
-INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key limit 10;
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key ORDER BY SRC.key limit 10
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, sum(SUBSTR(SRC.value,5)) GROUP BY SRC.key ORDER BY SRC.key limit 10;
SELECT DEST1.* FROM DEST1 ORDER BY key ASC, value ASC;
SELECT DEST2.* FROM DEST2 ORDER BY key ASC, value ASC;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby8_map.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby8_map.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby8_map.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby8_map.q Wed Mar 19 18:21:53 2014
@@ -14,6 +14,6 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby8_map_skew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby8_map_skew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby8_map_skew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby8_map_skew.q Wed Mar 19 18:21:53 2014
@@ -14,6 +14,6 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby8_noskew.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby8_noskew.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby8_noskew.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby8_noskew.q Wed Mar 19 18:21:53 2014
@@ -15,5 +15,5 @@ FROM SRC
INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key;
-SELECT DEST1.* FROM DEST1;
-SELECT DEST2.* FROM DEST2;
+SELECT DEST1.* FROM DEST1 ORDER BY key;
+SELECT DEST2.* FROM DEST2 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr.q Wed Mar 19 18:21:53 2014
@@ -17,4 +17,4 @@ SELECT substr(src.key,1,1), count(DISTIN
WHERE src.ds = '2008-04-08'
GROUP BY substr(src.key,1,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr_multi_distinct.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr_multi_distinct.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr_multi_distinct.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby_map_ppr_multi_distinct.q Wed Mar 19 18:21:53 2014
@@ -17,4 +17,4 @@ SELECT substr(src.key,1,1), count(DISTIN
WHERE src.ds = '2008-04-08'
GROUP BY substr(src.key,1,1);
-SELECT dest1.* FROM dest1;
+SELECT dest1.* FROM dest1 ORDER BY key;
Modified: hive/trunk/ql/src/test/queries/clientpositive/groupby_resolution.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/groupby_resolution.q?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/groupby_resolution.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/groupby_resolution.q Wed Mar 19 18:21:53 2014
@@ -24,19 +24,22 @@ explain select b.key, count(*) from src
select key, count(*), rank() over(order by count(*))
from src b
where key < '12'
-group by b.key;
+group by b.key
+order by b.key;
-- having after group by
select key, count(*)
from src b
group by b.key
-having key < '12';
+having key < '12'
+order by b.key;
-- having and windowing
select key, count(*), rank() over(order by count(*))
from src b
group by b.key
having key < '12'
+order by b.key
;
explain
@@ -55,4 +58,4 @@ order by t.key;
-- cluster by
EXPLAIN
-SELECT x.key, x.value as key FROM SRC x CLUSTER BY key;
\ No newline at end of file
+SELECT x.key, x.value as key FROM SRC x CLUSTER BY key;
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out Wed Mar 19 18:21:53 2014
@@ -101,11 +101,11 @@ STAGE PLANS:
Stage: Stage-3
Stats-Aggr Operator
-PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key ORDER BY src.key LIMIT 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1
-POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key ORDER BY src.key LIMIT 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out Wed Mar 19 18:21:53 2014
@@ -82,30 +82,83 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -121,7 +174,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -138,7 +190,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -147,14 +198,12 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -164,8 +213,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -193,7 +240,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -205,20 +251,17 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -233,7 +276,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -251,7 +293,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -259,13 +300,11 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -277,7 +316,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -295,7 +333,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -304,19 +341,16 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -325,7 +359,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -345,7 +378,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -369,35 +401,3 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out Wed Mar 19 18:21:53 2014
@@ -107,30 +107,83 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -146,7 +199,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -163,7 +215,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -172,14 +223,12 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -189,8 +238,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -218,7 +265,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -230,20 +276,17 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -258,7 +301,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -276,7 +318,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -284,13 +325,11 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -302,7 +341,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -320,7 +358,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -329,19 +366,16 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -350,7 +384,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -370,7 +403,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -394,35 +426,3 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out Wed Mar 19 18:21:53 2014
@@ -76,30 +76,83 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_g1
POSTHOOK: Lineage: dest_g1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_g1.* FROM dest_g1
+PREHOOK: query: SELECT dest_g1.* FROM dest_g1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_g1.* FROM dest_g1
+POSTHOOK: query: SELECT dest_g1.* FROM dest_g1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest_g1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -115,7 +168,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -132,7 +184,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -141,14 +192,12 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -158,8 +207,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -187,7 +234,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -199,20 +245,17 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -227,7 +270,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -245,7 +287,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -253,13 +294,11 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -271,7 +310,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -289,7 +327,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -298,19 +335,16 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -319,7 +353,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -339,7 +372,6 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -363,35 +395,3 @@ POSTHOOK: Lineage: dest_g1.value EXPRESS
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out Wed Mar 19 18:21:53 2014
@@ -1,11 +1,12 @@
PREHOOK: query: EXPLAIN
-SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5
+SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 5
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
-SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5
+SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 5
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -42,26 +43,45 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- Limit
- Number of rows: 5
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: double)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 5
+ Statistics: Num rows: 5 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
Statistics: Num rows: 5 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 5 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
limit: 5
-PREHOOK: query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5
+PREHOOK: query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5
+POSTHOOK: query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key ORDER BY src.key LIMIT 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out Wed Mar 19 18:21:53 2014
@@ -87,11 +87,11 @@ POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out Wed Mar 19 18:21:53 2014
@@ -89,11 +89,11 @@ POSTHOOK: Lineage: dest1.c2 EXPRESSION [
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
@@ -210,11 +210,11 @@ POSTHOOK: Lineage: dest1.c4 EXPRESSION [
POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out Wed Mar 19 18:21:53 2014
@@ -80,11 +80,11 @@ POSTHOOK: Output: default@dest_g2
POSTHOOK: Lineage: dest_g2.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.c2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_g2.* FROM dest_g2
+PREHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_g2.* FROM dest_g2
+POSTHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g2
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out Wed Mar 19 18:21:53 2014
@@ -83,11 +83,11 @@ POSTHOOK: Lineage: dest_g2.c2 EXPRESSION
POSTHOOK: Lineage: dest_g2.c3 EXPRESSION [(src)src.null, ]
POSTHOOK: Lineage: dest_g2.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_g2.* FROM dest_g2
+PREHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_g2.* FROM dest_g2
+POSTHOOK: query: SELECT dest_g2.* FROM dest_g2 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g2
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out Wed Mar 19 18:21:53 2014
@@ -77,11 +77,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out Wed Mar 19 18:21:53 2014
@@ -88,30 +88,83 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -127,7 +180,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -144,7 +196,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -153,14 +204,12 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -170,8 +219,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -199,7 +246,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -211,20 +257,17 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -239,7 +282,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -257,7 +299,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -265,13 +306,11 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -283,7 +322,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -301,7 +339,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -310,19 +347,16 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -331,7 +365,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -351,7 +384,6 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -375,35 +407,3 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out Wed Mar 19 18:21:53 2014
@@ -82,11 +82,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out Wed Mar 19 18:21:53 2014
@@ -105,11 +105,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out Wed Mar 19 18:21:53 2014
@@ -77,11 +77,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out Wed Mar 19 18:21:53 2014
@@ -163,11 +163,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
@@ -176,19 +176,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -204,7 +257,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -221,7 +273,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -230,14 +281,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -247,8 +296,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -276,7 +323,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -288,20 +334,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -316,7 +359,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -334,7 +376,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -342,13 +383,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -360,7 +399,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -378,7 +416,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -387,19 +424,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -408,7 +442,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -428,7 +461,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -452,7 +484,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0 0.0
+2 2.0
+4 4.0
5 15.0
+8 8.0
+9 9.0
+10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
51 102.0
53 53.0
54 54.0
@@ -469,7 +540,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
76 152.0
77 77.0
78 78.0
-8 8.0
80 80.0
82 82.0
83 166.0
@@ -477,39 +547,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
85 85.0
86 86.0
87 87.0
-9 9.0
90 270.0
92 92.0
95 190.0
96 96.0
97 194.0
98 196.0
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-0 0.0
-10 10.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -525,7 +578,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -542,7 +594,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -551,14 +602,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -568,8 +617,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -597,7 +644,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -609,20 +655,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -637,7 +680,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -655,7 +697,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -663,13 +704,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -681,7 +720,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -699,7 +737,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -708,19 +745,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -729,7 +763,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -749,7 +782,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -773,35 +805,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out Wed Mar 19 18:21:53 2014
@@ -130,11 +130,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
@@ -143,19 +143,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -171,7 +224,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -188,7 +240,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -197,14 +248,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -214,8 +263,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -243,7 +290,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -255,20 +301,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -283,7 +326,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -301,7 +343,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -309,13 +350,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -327,7 +366,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -345,7 +383,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -354,19 +391,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -375,7 +409,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -395,7 +428,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -419,7 +451,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0 0.0
+2 2.0
+4 4.0
5 15.0
+8 8.0
+9 9.0
+10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
51 102.0
53 53.0
54 54.0
@@ -436,7 +507,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
76 152.0
77 77.0
78 78.0
-8 8.0
80 80.0
82 82.0
83 166.0
@@ -444,39 +514,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
85 85.0
86 86.0
87 87.0
-9 9.0
90 270.0
92 92.0
95 190.0
96 96.0
97 194.0
98 196.0
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-0 0.0
-10 10.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -492,7 +545,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -509,7 +561,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -518,14 +569,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -535,8 +584,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -564,7 +611,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -576,20 +622,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -604,7 +647,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -622,7 +664,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -630,13 +671,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -648,7 +687,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -666,7 +704,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -675,19 +712,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -696,7 +730,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -716,7 +749,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -740,35 +772,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=1579333&r1=1579332&r2=1579333&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Wed Mar 19 18:21:53 2014
@@ -213,11 +213,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT DEST1.* FROM DEST1
+PREHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST1.* FROM DEST1
+POSTHOOK: query: SELECT DEST1.* FROM DEST1 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
@@ -226,19 +226,72 @@ POSTHOOK: Lineage: dest1.value EXPRESSIO
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 0.0
+2 2.0
+4 4.0
+5 15.0
+8 8.0
+9 9.0
10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
+51 102.0
+53 53.0
+54 54.0
+57 57.0
+58 116.0
+64 64.0
+65 65.0
+66 66.0
+67 134.0
+69 69.0
+70 210.0
+72 144.0
+74 74.0
+76 152.0
+77 77.0
+78 78.0
+80 80.0
+82 82.0
+83 166.0
+84 168.0
+85 85.0
+86 86.0
+87 87.0
+90 270.0
+92 92.0
+95 190.0
+96 96.0
+97 194.0
+98 196.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -254,7 +307,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -271,7 +323,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -280,14 +331,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -297,8 +346,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -326,7 +373,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -338,20 +384,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -366,7 +409,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -384,7 +426,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -392,13 +433,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -410,7 +449,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -428,7 +466,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -437,19 +474,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -458,7 +492,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -478,7 +511,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -502,7 +534,46 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
+PREHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT DEST2.* FROM DEST2 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+0 0.0
+2 2.0
+4 4.0
5 15.0
+8 8.0
+9 9.0
+10 10.0
+11 11.0
+12 24.0
+15 30.0
+17 17.0
+18 36.0
+19 19.0
+20 20.0
+24 48.0
+26 52.0
+27 27.0
+28 28.0
+30 30.0
+33 33.0
+34 34.0
+35 105.0
+37 74.0
+41 41.0
+42 84.0
+43 43.0
+44 44.0
+47 47.0
51 102.0
53 53.0
54 54.0
@@ -519,7 +590,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
76 152.0
77 77.0
78 78.0
-8 8.0
80 80.0
82 82.0
83 166.0
@@ -527,39 +597,22 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
85 85.0
86 86.0
87 87.0
-9 9.0
90 270.0
92 92.0
95 190.0
96 96.0
97 194.0
98 196.0
-PREHOOK: query: SELECT DEST2.* FROM DEST2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT DEST2.* FROM DEST2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest2
-#### A masked pattern was here ####
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-0 0.0
-10 10.0
100 200.0
103 206.0
104 208.0
105 105.0
-11 11.0
111 111.0
113 226.0
114 114.0
116 116.0
118 236.0
119 357.0
-12 24.0
120 240.0
125 250.0
126 126.0
@@ -575,7 +628,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
145 145.0
146 292.0
149 298.0
-15 30.0
150 150.0
152 304.0
153 153.0
@@ -592,7 +644,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
167 501.0
168 168.0
169 676.0
-17 17.0
170 170.0
172 344.0
174 348.0
@@ -601,14 +652,12 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
177 177.0
178 178.0
179 358.0
-18 36.0
180 180.0
181 181.0
183 183.0
186 186.0
187 561.0
189 189.0
-19 19.0
190 190.0
191 382.0
192 192.0
@@ -618,8 +667,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
196 196.0
197 394.0
199 597.0
-2 2.0
-20 20.0
200 400.0
201 201.0
202 202.0
@@ -647,7 +694,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
237 474.0
238 476.0
239 478.0
-24 48.0
241 241.0
242 484.0
244 244.0
@@ -659,20 +705,17 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
256 512.0
257 257.0
258 258.0
-26 52.0
260 260.0
262 262.0
263 263.0
265 530.0
266 266.0
-27 27.0
272 544.0
273 819.0
274 274.0
275 275.0
277 1108.0
278 556.0
-28 28.0
280 560.0
281 562.0
282 564.0
@@ -687,7 +730,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
292 292.0
296 296.0
298 894.0
-30 30.0
302 302.0
305 305.0
306 306.0
@@ -705,7 +747,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
323 323.0
325 650.0
327 981.0
-33 33.0
331 662.0
332 332.0
333 666.0
@@ -713,13 +754,11 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
336 336.0
338 338.0
339 339.0
-34 34.0
341 341.0
342 684.0
344 688.0
345 345.0
348 1740.0
-35 105.0
351 351.0
353 706.0
356 356.0
@@ -731,7 +770,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
367 734.0
368 368.0
369 1107.0
-37 74.0
373 373.0
374 374.0
375 375.0
@@ -749,7 +787,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
396 1188.0
397 794.0
399 798.0
-4 4.0
400 400.0
401 2005.0
402 402.0
@@ -758,19 +795,16 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
406 1624.0
407 407.0
409 1227.0
-41 41.0
411 411.0
413 826.0
414 828.0
417 1251.0
418 418.0
419 419.0
-42 84.0
421 421.0
424 848.0
427 427.0
429 858.0
-43 43.0
430 1290.0
431 1293.0
432 432.0
@@ -779,7 +813,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
437 437.0
438 1314.0
439 878.0
-44 44.0
443 443.0
444 444.0
446 446.0
@@ -799,7 +832,6 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
467 467.0
468 1872.0
469 2345.0
-47 47.0
470 470.0
472 472.0
475 475.0
@@ -823,35 +855,3 @@ POSTHOOK: Lineage: dest2.value EXPRESSIO
496 496.0
497 497.0
498 1494.0
-5 15.0
-51 102.0
-53 53.0
-54 54.0
-57 57.0
-58 116.0
-64 64.0
-65 65.0
-66 66.0
-67 134.0
-69 69.0
-70 210.0
-72 144.0
-74 74.0
-76 152.0
-77 77.0
-78 78.0
-8 8.0
-80 80.0
-82 82.0
-83 166.0
-84 168.0
-85 85.0
-86 86.0
-87 87.0
-9 9.0
-90 270.0
-92 92.0
-95 190.0
-96 96.0
-97 194.0
-98 196.0