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/09/11 00:37:37 UTC
svn commit: r1624160 - in /hive/branches/spark: ./
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/clientpositive/tez/
Author: brock
Date: Wed Sep 10 22:37:37 2014
New Revision: 1624160
URL: http://svn.apache.org/r1624160
Log:
Merged from trunk - HIVE-8035 - Add SORT_QUERY_RESULTS for test that doesn't guarantee order (Rui Li via Brock)
Modified:
hive/branches/spark/ (props changed)
hive/branches/spark/ql/src/test/queries/clientpositive/groupby1.q
hive/branches/spark/ql/src/test/queries/clientpositive/groupby4.q
hive/branches/spark/ql/src/test/queries/clientpositive/having.q
hive/branches/spark/ql/src/test/queries/clientpositive/limit_pushdown.q
hive/branches/spark/ql/src/test/queries/clientpositive/merge1.q
hive/branches/spark/ql/src/test/queries/clientpositive/merge2.q
hive/branches/spark/ql/src/test/queries/clientpositive/union_remove_19.q
hive/branches/spark/ql/src/test/results/clientpositive/groupby1.q.out
hive/branches/spark/ql/src/test/results/clientpositive/groupby4.q.out
hive/branches/spark/ql/src/test/results/clientpositive/having.q.out
hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out
hive/branches/spark/ql/src/test/results/clientpositive/merge1.q.out
hive/branches/spark/ql/src/test/results/clientpositive/merge2.q.out
hive/branches/spark/ql/src/test/results/clientpositive/tez/groupby1.q.out
hive/branches/spark/ql/src/test/results/clientpositive/tez/having.q.out
hive/branches/spark/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out
hive/branches/spark/ql/src/test/results/clientpositive/tez/merge1.q.out
hive/branches/spark/ql/src/test/results/clientpositive/tez/merge2.q.out
hive/branches/spark/ql/src/test/results/clientpositive/union_remove_19.q.out
Propchange: hive/branches/spark/
------------------------------------------------------------------------------
Merged /hive/trunk:r1624159
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/groupby1.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/groupby1.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/groupby1.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/groupby1.q Wed Sep 10 22:37:37 2014
@@ -1,6 +1,8 @@
set hive.map.aggr=false;
set hive.groupby.skewindata=true;
+-- SORT_QUERY_RESULTS
+
CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE;
set fs.default.name=invalidscheme:///;
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/groupby4.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/groupby4.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/groupby4.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/groupby4.q Wed Sep 10 22:37:37 2014
@@ -1,6 +1,8 @@
set hive.map.aggr=false;
set hive.groupby.skewindata=true;
+-- SORT_QUERY_RESULTS
+
CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
EXPLAIN
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/having.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/having.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/having.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/having.q Wed Sep 10 22:37:37 2014
@@ -1,3 +1,4 @@
+-- SORT_QUERY_RESULTS
EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3;
SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3;
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/limit_pushdown.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/limit_pushdown.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/limit_pushdown.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/limit_pushdown.q Wed Sep 10 22:37:37 2014
@@ -1,6 +1,8 @@
set hive.limit.pushdown.memory.usage=0.3f;
set hive.optimize.reducededuplication.min.reducer=1;
+-- SORT_QUERY_RESULTS
+
-- HIVE-3562 Some limit can be pushed down to map stage
explain
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/merge1.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/merge1.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/merge1.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/merge1.q Wed Sep 10 22:37:37 2014
@@ -1,5 +1,7 @@
set hive.merge.mapredfiles=true;
+-- SORT_QUERY_RESULTS
+
create table dest1(key int, val int);
explain
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/merge2.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/merge2.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/merge2.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/merge2.q Wed Sep 10 22:37:37 2014
@@ -5,6 +5,8 @@ set mapred.min.split.size.per.node=256;
set mapred.min.split.size.per.rack=256;
set mapred.max.split.size=256;
+-- SORT_QUERY_RESULTS
+
create table test1(key int, val int);
explain
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/union_remove_19.q
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/union_remove_19.q?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/union_remove_19.q (original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/union_remove_19.q Wed Sep 10 22:37:37 2014
@@ -16,6 +16,8 @@ set mapred.input.dir.recursive=true;
-- Since this test creates sub-directories for the output table outputTbl1, it might be easier
-- to run the test only on hadoop 23
+-- SORT_QUERY_RESULTS
+
create table inputTbl1(key string, val string) stored as textfile;
create table outputTbl1(key string, values bigint) stored as textfile;
Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby1.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/groupby1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/groupby1.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_g1
-POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby4.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/groupby4.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/having.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/having.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/having.q.out Wed Sep 10 22:37:37 2014
@@ -1,6 +1,8 @@
-PREHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+PREHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -67,14 +69,14 @@ POSTHOOK: Input: default@src
#### A masked pattern was here ####
4
4
-5
4
-5
-5
4
4
-5
4
+5
+5
+5
+5
PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
Modified: hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/limit_pushdown.q.out Wed Sep 10 22:37:37 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
PREHOOK: type: QUERY
-POSTHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
@@ -136,26 +140,26 @@ POSTHOOK: query: select key,value from s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-98 val_98
-98 val_98
-97 val_97
-97 val_97
-96 val_96
-95 val_95
-95 val_95
-92 val_92
+82 val_82
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+9 val_9
90 val_90
90 val_90
90 val_90
-9 val_9
-87 val_87
-86 val_86
-85 val_85
-84 val_84
-84 val_84
-83 val_83
-83 val_83
-82 val_82
+92 val_92
+95 val_95
+95 val_95
+96 val_96
+97 val_97
+97 val_97
+98 val_98
+98 val_98
PREHOOK: query: explain
select value, sum(key + 1) as sum from src group by value limit 20
PREHOOK: type: QUERY
@@ -407,26 +411,26 @@ POSTHOOK: query: select distinct(cdouble
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL
--16379.0
--16373.0
--16372.0
--16369.0
--16355.0
--16339.0
--16324.0
--16311.0
--16310.0
--16309.0
--16307.0
--16306.0
--16305.0
--16300.0
--16296.0
--16280.0
--16277.0
--16274.0
-16269.0
+-16274.0
+-16277.0
+-16280.0
+-16296.0
+-16300.0
+-16305.0
+-16306.0
+-16307.0
+-16309.0
+-16310.0
+-16311.0
+-16324.0
+-16339.0
+-16355.0
+-16369.0
+-16372.0
+-16373.0
+-16379.0
+NULL
PREHOOK: query: explain
select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
@@ -496,26 +500,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 2932
--64 24
--63 19
--62 27
--61 25
--60 27
--59 31
--58 23
--57 35
--56 36
--55 29
--54 26
--53 22
--52 33
--51 21
--50 30
--49 26
--48 29
--47 22
-46 24
+-47 22
+-48 29
+-49 26
+-50 30
+-51 21
+-52 33
+-53 22
+-54 26
+-55 29
+-56 36
+-57 35
+-58 23
+-59 31
+-60 27
+-61 25
+-62 27
+-63 19
+-64 24
+NULL 2932
PREHOOK: query: -- multi distinct
explain
select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
@@ -587,26 +591,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 3065 3
--64 3 13
--63 3 16
--62 3 23
--61 3 25
--60 3 25
--59 3 27
--58 3 24
--57 3 23
--56 3 22
--55 3 21
--54 3 21
--53 3 17
--52 3 21
--51 1012 1045
--50 3 25
--49 3 24
--48 3 27
--47 3 23
-46 3 19
+-47 3 23
+-48 3 27
+-49 3 24
+-50 3 25
+-51 1012 1045
+-52 3 21
+-53 3 17
+-54 3 21
+-55 3 21
+-56 3 22
+-57 3 23
+-58 3 24
+-59 3 27
+-60 3 25
+-61 3 25
+-62 3 23
+-63 3 16
+-64 3 13
+NULL 3065 3
PREHOOK: query: -- limit zero
explain
select key,value from src order by key limit 0
@@ -726,25 +730,25 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
val_0 0.0
-val_2 2.0
-val_4 4.0
-val_8 8.0
-val_9 9.0
val_10 10.0
val_11 11.0
-val_5 15.0
+val_12 24.0
+val_15 30.0
val_17 17.0
+val_18 36.0
val_19 19.0
+val_2 2.0
val_20 20.0
-val_12 24.0
val_27 27.0
val_28 28.0
val_30 30.0
-val_15 30.0
val_33 33.0
val_34 34.0
-val_18 36.0
+val_4 4.0
val_41 41.0
+val_5 15.0
+val_8 8.0
+val_9 9.0
PREHOOK: query: -- subqueries
explain
select * from
@@ -1246,102 +1250,102 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
-200.0
-206.0
-208.0
-105.0
10.0
+105.0
+11.0
111.0
-226.0
114.0
+1150.0
116.0
-236.0
-357.0
-11.0
-240.0
-250.0
126.0
-384.0
-258.0
-24.0
131.0
133.0
-268.0
136.0
-274.0
-552.0
143.0
145.0
-292.0
-298.0
150.0
-304.0
153.0
155.0
156.0
157.0
158.0
-30.0
160.0
162.0
163.0
-328.0
-330.0
166.0
-501.0
168.0
-676.0
+17.0
170.0
-344.0
-348.0
-350.0
-352.0
177.0
178.0
-358.0
-17.0
180.0
181.0
183.0
186.0
-561.0
189.0
-36.0
+19.0
190.0
-382.0
192.0
-579.0
194.0
-390.0
196.0
-394.0
-597.0
-19.0
-400.0
+20.0
+200.0
201.0
202.0
+206.0
+208.0
+214.0
+218.0
+222.0
+226.0
+226.0
+228.0
+235.0
+236.0
+24.0
+240.0
+250.0
+258.0
+268.0
+274.0
+292.0
+298.0
+30.0
+304.0
+328.0
+330.0
+344.0
+348.0
+350.0
+352.0
+357.0
+358.0
+36.0
+382.0
+384.0
+390.0
+394.0
+400.0
406.0
410.0
414.0
-624.0
418.0
-20.0
426.0
-214.0
432.0
434.0
-218.0
438.0
442.0
-222.0
446.0
448.0
-226.0
-228.0
458.0
-1150.0
466.0
-235.0
474.0
476.0
478.0
+501.0
+552.0
+561.0
+579.0
+597.0
+624.0
+676.0
Modified: hive/branches/spark/ql/src/test/results/clientpositive/merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/merge1.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/merge1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/merge1.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: create table dest1(key int, val int)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table dest1(key int, val int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
-POSTHOOK: query: create table dest1(key int, val int)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table dest1(key int, val int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/merge2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/merge2.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/merge2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/merge2.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: create table test1(key int, val int)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table test1(key int, val int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test1
-POSTHOOK: query: create table test1(key int, val int)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table test1(key int, val int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/groupby1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/groupby1.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/groupby1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/groupby1.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_g1
-POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/having.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/having.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/having.q.out Wed Sep 10 22:37:37 2014
@@ -1,6 +1,8 @@
-PREHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+PREHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -73,14 +75,14 @@ POSTHOOK: Input: default@src
#### A masked pattern was here ####
4
4
-5
4
-5
-5
4
4
-5
4
+5
+5
+5
+5
PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out Wed Sep 10 22:37:37 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
PREHOOK: type: QUERY
-POSTHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
@@ -148,26 +152,26 @@ POSTHOOK: query: select key,value from s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-98 val_98
-98 val_98
-97 val_97
-97 val_97
-96 val_96
-95 val_95
-95 val_95
-92 val_92
+82 val_82
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+9 val_9
90 val_90
90 val_90
90 val_90
-9 val_9
-87 val_87
-86 val_86
-85 val_85
-84 val_84
-84 val_84
-83 val_83
-83 val_83
-82 val_82
+92 val_92
+95 val_95
+95 val_95
+96 val_96
+97 val_97
+97 val_97
+98 val_98
+98 val_98
PREHOOK: query: explain
select value, sum(key + 1) as sum from src group by value limit 20
PREHOOK: type: QUERY
@@ -437,26 +441,26 @@ POSTHOOK: query: select distinct(cdouble
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL
--16379.0
--16373.0
--16372.0
--16369.0
--16355.0
--16339.0
--16324.0
--16311.0
--16310.0
--16309.0
--16307.0
--16306.0
--16305.0
--16300.0
--16296.0
--16280.0
--16277.0
--16274.0
-16269.0
+-16274.0
+-16277.0
+-16280.0
+-16296.0
+-16300.0
+-16305.0
+-16306.0
+-16307.0
+-16309.0
+-16310.0
+-16311.0
+-16324.0
+-16339.0
+-16355.0
+-16369.0
+-16372.0
+-16373.0
+-16379.0
+NULL
PREHOOK: query: explain
select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
@@ -532,26 +536,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 2932
--64 24
--63 19
--62 27
--61 25
--60 27
--59 31
--58 23
--57 35
--56 36
--55 29
--54 26
--53 22
--52 33
--51 21
--50 30
--49 26
--48 29
--47 22
-46 24
+-47 22
+-48 29
+-49 26
+-50 30
+-51 21
+-52 33
+-53 22
+-54 26
+-55 29
+-56 36
+-57 35
+-58 23
+-59 31
+-60 27
+-61 25
+-62 27
+-63 19
+-64 24
+NULL 2932
PREHOOK: query: -- multi distinct
explain
select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
@@ -629,26 +633,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 3065 3
--64 3 13
--63 3 16
--62 3 23
--61 3 25
--60 3 25
--59 3 27
--58 3 24
--57 3 23
--56 3 22
--55 3 21
--54 3 21
--53 3 17
--52 3 21
--51 1012 1045
--50 3 25
--49 3 24
--48 3 27
--47 3 23
-46 3 19
+-47 3 23
+-48 3 27
+-49 3 24
+-50 3 25
+-51 1012 1045
+-52 3 21
+-53 3 17
+-54 3 21
+-55 3 21
+-56 3 22
+-57 3 23
+-58 3 24
+-59 3 27
+-60 3 25
+-61 3 25
+-62 3 23
+-63 3 16
+-64 3 13
+NULL 3065 3
PREHOOK: query: -- limit zero
explain
select key,value from src order by key limit 0
@@ -764,25 +768,25 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
val_0 0.0
-val_2 2.0
-val_4 4.0
-val_8 8.0
-val_9 9.0
val_10 10.0
val_11 11.0
-val_5 15.0
+val_12 24.0
+val_15 30.0
val_17 17.0
+val_18 36.0
val_19 19.0
+val_2 2.0
val_20 20.0
-val_12 24.0
val_27 27.0
val_28 28.0
val_30 30.0
-val_15 30.0
val_33 33.0
val_34 34.0
-val_18 36.0
+val_4 4.0
val_41 41.0
+val_5 15.0
+val_8 8.0
+val_9 9.0
PREHOOK: query: -- subqueries
explain
select * from
@@ -1280,102 +1284,102 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
-200.0
-206.0
-208.0
-105.0
10.0
+105.0
+11.0
111.0
-226.0
114.0
+1150.0
116.0
-236.0
-357.0
-11.0
-240.0
-250.0
126.0
-384.0
-258.0
-24.0
131.0
133.0
-268.0
136.0
-274.0
-552.0
143.0
145.0
-292.0
-298.0
150.0
-304.0
153.0
155.0
156.0
157.0
158.0
-30.0
160.0
162.0
163.0
-328.0
-330.0
166.0
-501.0
168.0
-676.0
+17.0
170.0
-344.0
-348.0
-350.0
-352.0
177.0
178.0
-358.0
-17.0
180.0
181.0
183.0
186.0
-561.0
189.0
-36.0
+19.0
190.0
-382.0
192.0
-579.0
194.0
-390.0
196.0
-394.0
-597.0
-19.0
-400.0
+20.0
+200.0
201.0
202.0
+206.0
+208.0
+214.0
+218.0
+222.0
+226.0
+226.0
+228.0
+235.0
+236.0
+24.0
+240.0
+250.0
+258.0
+268.0
+274.0
+292.0
+298.0
+30.0
+304.0
+328.0
+330.0
+344.0
+348.0
+350.0
+352.0
+357.0
+358.0
+36.0
+382.0
+384.0
+390.0
+394.0
+400.0
406.0
410.0
414.0
-624.0
418.0
-20.0
426.0
-214.0
432.0
434.0
-218.0
438.0
442.0
-222.0
446.0
448.0
-226.0
-228.0
458.0
-1150.0
466.0
-235.0
474.0
476.0
478.0
+501.0
+552.0
+561.0
+579.0
+597.0
+624.0
+676.0
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/merge1.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/merge1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/merge1.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: create table dest1(key int, val int)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table dest1(key int, val int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
-POSTHOOK: query: create table dest1(key int, val int)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table dest1(key int, val int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/merge2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/merge2.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/merge2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/merge2.q.out Wed Sep 10 22:37:37 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: create table test1(key int, val int)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table test1(key int, val int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test1
-POSTHOOK: query: create table test1(key int, val int)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table test1(key int, val int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/union_remove_19.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/union_remove_19.q.out?rev=1624160&r1=1624159&r2=1624160&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/union_remove_19.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/union_remove_19.q.out Wed Sep 10 22:37:37 2014
@@ -8,6 +8,8 @@ PREHOOK: query: -- This is to test the u
-- Since this test creates sub-directories for the output table outputTbl1, it might be easier
-- to run the test only on hadoop 23
+-- SORT_QUERY_RESULTS
+
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -22,6 +24,8 @@ POSTHOOK: query: -- This is to test the
-- Since this test creates sub-directories for the output table outputTbl1, it might be easier
-- to run the test only on hadoop 23
+-- SORT_QUERY_RESULTS
+
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -227,14 +231,14 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@outputtbl1
#### A masked pattern was here ####
1 1
-2 1
-3 1
-7 1
-8 2
1 1
2 1
+2 1
+3 1
3 1
7 1
+7 1
+8 2
8 2
PREHOOK: query: -- filter should be fine
explain