You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/11/25 03:42:41 UTC
svn commit: r1641519 [2/4] - in /hive/branches/spark/ql/src/test:
queries/clientpositive/ results/clientpositive/
results/clientpositive/spark/ results/clientpositive/tez/
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: CREATE TABLE over1k(t tinyint,
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE over1k(t tinyint,
si smallint,
i int,
b bigint,
@@ -14,7 +16,9 @@ STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@over1k
-POSTHOOK: query: CREATE TABLE over1k(t tinyint,
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE over1k(t tinyint,
si smallint,
i int,
b bigint,
@@ -153,33 +157,6 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-6 6
-6 6
-6 6
-6 6
-6 6
-6 6
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
14 14
14 14
14 14
@@ -204,6 +181,12 @@ POSTHOOK: Input: default@t2
45 45
45 45
45 45
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
62 62
62 62
62 62
@@ -259,22 +242,6 @@ POSTHOOK: Input: default@t2
89 89
89 89
89 89
-PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
-6 6
-6 6
-6 6
-6 6
-6 6
-6 6
9 9
9 9
9 9
@@ -296,6 +263,16 @@ POSTHOOK: Input: default@t2
9 9
9 9
9 9
+PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
14 14
14 14
14 14
@@ -320,6 +297,12 @@ POSTHOOK: Input: default@t2
45 45
45 45
45 45
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
62 62
62 62
62 62
@@ -375,22 +358,6 @@ POSTHOOK: Input: default@t2
89 89
89 89
89 89
-PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
-6 6
-6 6
-6 6
-6 6
-6 6
-6 6
9 9
9 9
9 9
@@ -412,6 +379,16 @@ POSTHOOK: Input: default@t2
9 9
9 9
9 9
+PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
14 14
14 14
14 14
@@ -436,6 +413,12 @@ POSTHOOK: Input: default@t2
45 45
45 45
45 45
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
62 62
62 62
62 62
@@ -491,3 +474,24 @@ POSTHOOK: Input: default@t2
89 89
89 89
89 89
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out Tue Nov 25 02:42:39 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key > '1' ) src1
@@ -7,7 +9,9 @@ JOIN
ON src1.c1 = src2.c3 AND src1.c1 < '400'
WHERE src1.c1 > '20' and (src1.c2 < 'val_50' or src1.c1 > '2') and (src2.c3 > '50' or src1.c1 < '50') and (src2.c3 <> '4')
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key > '1' ) src1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join2.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join2.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
@@ -10,7 +12,9 @@ JOIN
ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join3.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join3.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_join3.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '11' ) src1
@@ -10,7 +12,9 @@ JOIN
ON src1.c1 = src3.c5
WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src where src.key <> '11' ) src1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM
src a
LEFT OUTER JOIN
@@ -7,7 +9,9 @@ PREHOOK: query: EXPLAIN
SELECT a.key, a.value, b.key, b.value
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM
src a
LEFT OUTER JOIN
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM
src a
RIGHT OUTER JOIN
@@ -7,7 +9,9 @@ PREHOOK: query: EXPLAIN
SELECT a.key, a.value, b.key, b.value
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM
src a
RIGHT OUTER JOIN
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM
src a
LEFT OUTER JOIN
@@ -10,7 +12,9 @@ PREHOOK: query: EXPLAIN
SELECT a.key, a.value, b.key, b.value, c.key
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM
src a
LEFT OUTER JOIN
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out Tue Nov 25 02:42:39 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out Tue Nov 25 02:42:39 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@src_nontemp
-POSTHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_join_tests.q.out Tue Nov 25 02:42:39 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: explain
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+explain
select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key
PREHOOK: type: QUERY
-POSTHOOK: query: explain
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+explain
select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -130,6 +134,113 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+146 val_146 146 val_146
+146 val_146 146 val_146
+146 val_146 146 val_146
+146 val_146 146 val_146
+150 val_150 150 val_150
+213 val_213 213 val_213
+213 val_213 213 val_213
+213 val_213 213 val_213
+213 val_213 213 val_213
+224 val_224 224 val_224
+224 val_224 224 val_224
+224 val_224 224 val_224
+224 val_224 224 val_224
+238 val_238 238 val_238
+238 val_238 238 val_238
+238 val_238 238 val_238
+238 val_238 238 val_238
+255 val_255 255 val_255
+255 val_255 255 val_255
+255 val_255 255 val_255
+255 val_255 255 val_255
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+278 val_278 278 val_278
+278 val_278 278 val_278
+278 val_278 278 val_278
+278 val_278 278 val_278
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+66 val_66 66 val_66
+98 val_98 98 val_98
+98 val_98 98 val_98
+98 val_98 98 val_98
+98 val_98 98 val_98
NULL NULL 0 val_0
NULL NULL 0 val_0
NULL NULL 0 val_0
@@ -593,6 +704,16 @@ NULL NULL 95 val_95
NULL NULL 96 val_96
NULL NULL 97 val_97
NULL NULL 97 val_97
+PREHOOK: query: select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key)) x right outer join src c on (x.value = c.value) order by x.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Input: default@src1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key)) x right outer join src c on (x.value = c.value) order by x.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src1
+#### A masked pattern was here ####
128 val_128 128 val_128
128 val_128 128 val_128
128 val_128 128 val_128
@@ -700,16 +821,6 @@ NULL NULL 97 val_97
98 val_98 98 val_98
98 val_98 98 val_98
98 val_98 98 val_98
-PREHOOK: query: select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key)) x right outer join src c on (x.value = c.value) order by x.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Input: default@src1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key)) x right outer join src c on (x.value = c.value) order by x.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Input: default@src1
-#### A masked pattern was here ####
NULL NULL 0 val_0
NULL NULL 0 val_0
NULL NULL 0 val_0
@@ -1173,113 +1284,6 @@ NULL NULL 95 val_95
NULL NULL 96 val_96
NULL NULL 97 val_97
NULL NULL 97 val_97
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-146 val_146 146 val_146
-146 val_146 146 val_146
-146 val_146 146 val_146
-146 val_146 146 val_146
-150 val_150 150 val_150
-213 val_213 213 val_213
-213 val_213 213 val_213
-213 val_213 213 val_213
-213 val_213 213 val_213
-224 val_224 224 val_224
-224 val_224 224 val_224
-224 val_224 224 val_224
-224 val_224 224 val_224
-238 val_238 238 val_238
-238 val_238 238 val_238
-238 val_238 238 val_238
-238 val_238 238 val_238
-255 val_255 255 val_255
-255 val_255 255 val_255
-255 val_255 255 val_255
-255 val_255 255 val_255
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-278 val_278 278 val_278
-278 val_278 278 val_278
-278 val_278 278 val_278
-278 val_278 278 val_278
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-66 val_66 66 val_66
-98 val_98 98 val_98
-98 val_98 98 val_98
-98 val_98 98 val_98
-98 val_98 98 val_98
PREHOOK: query: select * from src1 a left outer join src b on (a.key = b.key) right outer join src c on (a.value = c.value) order by a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -1290,6 +1294,103 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
+ val_165 NULL NULL 165 val_165
+ val_165 NULL NULL 165 val_165
+ val_193 NULL NULL 193 val_193
+ val_193 NULL NULL 193 val_193
+ val_193 NULL NULL 193 val_193
+ val_265 NULL NULL 265 val_265
+ val_265 NULL NULL 265 val_265
+ val_27 NULL NULL 27 val_27
+ val_409 NULL NULL 409 val_409
+ val_409 NULL NULL 409 val_409
+ val_409 NULL NULL 409 val_409
+ val_484 NULL NULL 484 val_484
+146 val_146 146 val_146 146 val_146
+146 val_146 146 val_146 146 val_146
+146 val_146 146 val_146 146 val_146
+146 val_146 146 val_146 146 val_146
+150 val_150 150 val_150 150 val_150
+213 val_213 213 val_213 213 val_213
+213 val_213 213 val_213 213 val_213
+213 val_213 213 val_213 213 val_213
+213 val_213 213 val_213 213 val_213
+238 val_238 238 val_238 238 val_238
+238 val_238 238 val_238 238 val_238
+238 val_238 238 val_238 238 val_238
+238 val_238 238 val_238 238 val_238
+255 val_255 255 val_255 255 val_255
+255 val_255 255 val_255 255 val_255
+255 val_255 255 val_255 255 val_255
+255 val_255 255 val_255 255 val_255
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+273 val_273 273 val_273 273 val_273
+278 val_278 278 val_278 278 val_278
+278 val_278 278 val_278 278 val_278
+278 val_278 278 val_278 278 val_278
+278 val_278 278 val_278 278 val_278
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+311 val_311 311 val_311 311 val_311
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+401 val_401 401 val_401 401 val_401
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+406 val_406 406 val_406 406 val_406
+66 val_66 66 val_66 66 val_66
+98 val_98 98 val_98 98 val_98
+98 val_98 98 val_98 98 val_98
+98 val_98 98 val_98 98 val_98
+98 val_98 98 val_98 98 val_98
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
@@ -1749,103 +1850,6 @@ NULL NULL NULL NULL 95 val_95
NULL NULL NULL NULL 96 val_96
NULL NULL NULL NULL 97 val_97
NULL NULL NULL NULL 97 val_97
- val_165 NULL NULL 165 val_165
- val_165 NULL NULL 165 val_165
- val_193 NULL NULL 193 val_193
- val_193 NULL NULL 193 val_193
- val_193 NULL NULL 193 val_193
- val_265 NULL NULL 265 val_265
- val_265 NULL NULL 265 val_265
- val_27 NULL NULL 27 val_27
- val_409 NULL NULL 409 val_409
- val_409 NULL NULL 409 val_409
- val_409 NULL NULL 409 val_409
- val_484 NULL NULL 484 val_484
-146 val_146 146 val_146 146 val_146
-146 val_146 146 val_146 146 val_146
-146 val_146 146 val_146 146 val_146
-146 val_146 146 val_146 146 val_146
-150 val_150 150 val_150 150 val_150
-213 val_213 213 val_213 213 val_213
-213 val_213 213 val_213 213 val_213
-213 val_213 213 val_213 213 val_213
-213 val_213 213 val_213 213 val_213
-238 val_238 238 val_238 238 val_238
-238 val_238 238 val_238 238 val_238
-238 val_238 238 val_238 238 val_238
-238 val_238 238 val_238 238 val_238
-255 val_255 255 val_255 255 val_255
-255 val_255 255 val_255 255 val_255
-255 val_255 255 val_255 255 val_255
-255 val_255 255 val_255 255 val_255
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-273 val_273 273 val_273 273 val_273
-278 val_278 278 val_278 278 val_278
-278 val_278 278 val_278 278 val_278
-278 val_278 278 val_278 278 val_278
-278 val_278 278 val_278 278 val_278
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-311 val_311 311 val_311 311 val_311
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-401 val_401 401 val_401 401 val_401
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-406 val_406 406 val_406 406 val_406
-66 val_66 66 val_66 66 val_66
-98 val_98 98 val_98 98 val_98
-98 val_98 98 val_98 98 val_98
-98 val_98 98 val_98 98 val_98
-98 val_98 98 val_98 98 val_98
PREHOOK: query: select * from src1 a left outer join src b on (a.key = b.key) left outer join src c on (a.value = c.value) order by a.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/tez_joins_explain.q.out Tue Nov 25 02:42:39 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: explain
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+explain
select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key
PREHOOK: type: QUERY
-POSTHOOK: query: explain
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+explain
select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -130,6 +134,113 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+128 val_128 128 val_128
+146 val_146 146 val_146
+146 val_146 146 val_146
+146 val_146 146 val_146
+146 val_146 146 val_146
+150 val_150 150 val_150
+213 val_213 213 val_213
+213 val_213 213 val_213
+213 val_213 213 val_213
+213 val_213 213 val_213
+224 val_224 224 val_224
+224 val_224 224 val_224
+224 val_224 224 val_224
+224 val_224 224 val_224
+238 val_238 238 val_238
+238 val_238 238 val_238
+238 val_238 238 val_238
+238 val_238 238 val_238
+255 val_255 255 val_255
+255 val_255 255 val_255
+255 val_255 255 val_255
+255 val_255 255 val_255
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+273 val_273 273 val_273
+278 val_278 278 val_278
+278 val_278 278 val_278
+278 val_278 278 val_278
+278 val_278 278 val_278
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+311 val_311 311 val_311
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+369 val_369 369 val_369
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+401 val_401 401 val_401
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+406 val_406 406 val_406
+66 val_66 66 val_66
+98 val_98 98 val_98
+98 val_98 98 val_98
+98 val_98 98 val_98
+98 val_98 98 val_98
NULL NULL 0 val_0
NULL NULL 0 val_0
NULL NULL 0 val_0
@@ -593,110 +704,3 @@ NULL NULL 95 val_95
NULL NULL 96 val_96
NULL NULL 97 val_97
NULL NULL 97 val_97
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-128 val_128 128 val_128
-146 val_146 146 val_146
-146 val_146 146 val_146
-146 val_146 146 val_146
-146 val_146 146 val_146
-150 val_150 150 val_150
-213 val_213 213 val_213
-213 val_213 213 val_213
-213 val_213 213 val_213
-213 val_213 213 val_213
-224 val_224 224 val_224
-224 val_224 224 val_224
-224 val_224 224 val_224
-224 val_224 224 val_224
-238 val_238 238 val_238
-238 val_238 238 val_238
-238 val_238 238 val_238
-238 val_238 238 val_238
-255 val_255 255 val_255
-255 val_255 255 val_255
-255 val_255 255 val_255
-255 val_255 255 val_255
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-273 val_273 273 val_273
-278 val_278 278 val_278
-278 val_278 278 val_278
-278 val_278 278 val_278
-278 val_278 278 val_278
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-311 val_311 311 val_311
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-369 val_369 369 val_369
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-401 val_401 401 val_401
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-406 val_406 406 val_406
-66 val_66 66 val_66
-98 val_98 98 val_98
-98 val_98 98 val_98
-98 val_98 98 val_98
-98 val_98 98 val_98
Modified: hive/branches/spark/ql/src/test/results/clientpositive/temp_table_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/temp_table_join1.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/temp_table_join1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/temp_table_join1.q.out Tue Nov 25 02:42:39 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@src_nontemp
-POSTHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out Tue Nov 25 02:42:39 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/join1.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/join1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/join1.q.out Tue Nov 25 02:42:39 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_j1
-POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out Tue Nov 25 02:42:39 2014
@@ -1,4 +1,6 @@
-PREHOOK: query: CREATE TABLE over1k(t tinyint,
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE over1k(t tinyint,
si smallint,
i int,
b bigint,
@@ -14,7 +16,9 @@ STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@over1k
-POSTHOOK: query: CREATE TABLE over1k(t tinyint,
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE over1k(t tinyint,
si smallint,
i int,
b bigint,
@@ -151,38 +155,15 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-45 45
-45 45
-45 45
-45 45
-45 45
-79 79
-79 79
-79 79
-79 79
-79 79
-79 79
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
17 17
17 17
17 17
@@ -193,6 +174,11 @@ POSTHOOK: Input: default@t2
17 17
17 17
17 17
+45 45
+45 45
+45 45
+45 45
+45 45
6 6
6 6
6 6
@@ -229,6 +215,19 @@ POSTHOOK: Input: default@t2
64 64
64 64
64 64
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
89 89
89 89
89 89
@@ -241,32 +240,6 @@ POSTHOOK: Input: default@t2
89 89
89 89
89 89
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
9 9
9 9
9 9
@@ -288,17 +261,25 @@ POSTHOOK: Input: default@t2
9 9
9 9
9 9
-45 45
-45 45
-45 45
-45 45
-45 45
-79 79
-79 79
-79 79
-79 79
-79 79
-79 79
+PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
17 17
17 17
17 17
@@ -309,6 +290,11 @@ POSTHOOK: Input: default@t2
17 17
17 17
17 17
+45 45
+45 45
+45 45
+45 45
+45 45
6 6
6 6
6 6
@@ -345,6 +331,19 @@ POSTHOOK: Input: default@t2
64 64
64 64
64 64
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
89 89
89 89
89 89
@@ -357,32 +356,6 @@ POSTHOOK: Input: default@t2
89 89
89 89
89 89
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@t1
-PREHOOK: Input: default@t2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@t1
-POSTHOOK: Input: default@t2
-#### A masked pattern was here ####
9 9
9 9
9 9
@@ -404,17 +377,25 @@ POSTHOOK: Input: default@t2
9 9
9 9
9 9
-45 45
-45 45
-45 45
-45 45
-45 45
-79 79
-79 79
-79 79
-79 79
-79 79
-79 79
+PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
17 17
17 17
17 17
@@ -425,6 +406,11 @@ POSTHOOK: Input: default@t2
17 17
17 17
17 17
+45 45
+45 45
+45 45
+45 45
+45 45
6 6
6 6
6 6
@@ -461,6 +447,19 @@ POSTHOOK: Input: default@t2
64 64
64 64
64 64
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
89 89
89 89
89 89
@@ -473,19 +472,24 @@ POSTHOOK: Input: default@t2
89 89
89 89
89 89
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out?rev=1641519&r1=1641518&r2=1641519&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out Tue Nov 25 02:42:39 2014 differ