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
