Author: jdere Date: Fri Nov 7 22:08:23 2014 New Revision: 1637472 URL: http://svn.apache.org/r1637472 Log: HIVE-8618: Add SORT_QUERY_RESULTS for test that doesn't guarantee order #3 (Chao via Xuefu) - adding to branch-0.14
Modified: hive/branches/branch-0.14/ql/src/test/queries/clientpositive/auto_join26.q hive/branches/branch-0.14/ql/src/test/queries/clientpositive/date_join1.q hive/branches/branch-0.14/ql/src/test/queries/clientpositive/join40.q hive/branches/branch-0.14/ql/src/test/queries/clientpositive/vector_decimal_mapjoin.q hive/branches/branch-0.14/ql/src/test/results/clientpositive/auto_join26.q.out hive/branches/branch-0.14/ql/src/test/results/clientpositive/date_join1.q.out hive/branches/branch-0.14/ql/src/test/results/clientpositive/join40.q.out hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out Modified: hive/branches/branch-0.14/ql/src/test/queries/clientpositive/auto_join26.q URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/queries/clientpositive/auto_join26.q?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/queries/clientpositive/auto_join26.q (original) +++ hive/branches/branch-0.14/ql/src/test/queries/clientpositive/auto_join26.q Fri Nov 7 22:08:23 2014 @@ -1,4 +1,4 @@ ---SORT_QUERY_RESULTS +-- SORT_QUERY_RESULTS CREATE TABLE dest_j1(key INT, cnt INT); set hive.auto.convert.join = true; Modified: hive/branches/branch-0.14/ql/src/test/queries/clientpositive/date_join1.q URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/queries/clientpositive/date_join1.q?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/queries/clientpositive/date_join1.q (original) +++ hive/branches/branch-0.14/ql/src/test/queries/clientpositive/date_join1.q Fri Nov 7 22:08:23 2014 @@ -1,5 +1,7 @@ drop table date_join1; +-- SORT_QUERY_RESULTS + create table date_join1 ( ORIGIN_CITY_NAME string, DEST_CITY_NAME string, Modified: hive/branches/branch-0.14/ql/src/test/queries/clientpositive/join40.q URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/queries/clientpositive/join40.q?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/queries/clientpositive/join40.q (original) +++ hive/branches/branch-0.14/ql/src/test/queries/clientpositive/join40.q Fri Nov 7 22:08:23 2014 @@ -1,5 +1,7 @@ set hive.join.cache.size=1; +-- SORT_QUERY_RESULTS + EXPLAIN SELECT x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key); Modified: hive/branches/branch-0.14/ql/src/test/queries/clientpositive/vector_decimal_mapjoin.q URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/queries/clientpositive/vector_decimal_mapjoin.q?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/queries/clientpositive/vector_decimal_mapjoin.q (original) +++ hive/branches/branch-0.14/ql/src/test/queries/clientpositive/vector_decimal_mapjoin.q Fri Nov 7 22:08:23 2014 @@ -1,3 +1,5 @@ +-- SORT_QUERY_RESULTS + CREATE TABLE decimal_mapjoin STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, @@ -16,4 +18,4 @@ EXPLAIN SELECT l.cint, r.cint, l.cdecima SELECT l.cint, r.cint, l.cdecimal1, r.cdecimal2 FROM decimal_mapjoin l JOIN decimal_mapjoin r ON l.cint = r.cint - WHERE l.cint = 6981; \ No newline at end of file + WHERE l.cint = 6981; Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/auto_join26.q.out URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/auto_join26.q.out?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/results/clientpositive/auto_join26.q.out (original) +++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/auto_join26.q.out Fri Nov 7 22:08:23 2014 @@ -1,10 +1,10 @@ -PREHOOK: query: --SORT_QUERY_RESULTS +PREHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE dest_j1(key INT, cnt INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@dest_j1 -POSTHOOK: query: --SORT_QUERY_RESULTS +POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE dest_j1(key INT, cnt INT) POSTHOOK: type: CREATETABLE Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/date_join1.q.out URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/date_join1.q.out?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/results/clientpositive/date_join1.q.out (original) +++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/date_join1.q.out Fri Nov 7 22:08:23 2014 @@ -2,7 +2,9 @@ PREHOOK: query: drop table date_join1 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table date_join1 POSTHOOK: type: DROPTABLE -PREHOOK: query: create table date_join1 ( +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table date_join1 ( ORIGIN_CITY_NAME string, DEST_CITY_NAME string, FL_DATE date, @@ -12,7 +14,9 @@ PREHOOK: query: create table date_join1 PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@date_join1 -POSTHOOK: query: create table date_join1 ( +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table date_join1 ( ORIGIN_CITY_NAME string, DEST_CITY_NAME string, FL_DATE date, @@ -47,27 +51,27 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@date_join1 #### A masked pattern was here #### 1064 2000-11-20 1064 2000-11-20 -1142 2000-11-21 1142 2000-11-21 -1599 2000-11-22 1599 2000-11-22 -361 2000-11-23 361 2000-11-23 -897 2000-11-24 897 2000-11-24 -1531 2000-11-25 1531 2000-11-25 -1610 2000-11-26 1610 2000-11-26 -3198 2000-11-27 3198 2000-11-27 -1142 2000-11-28 1064 2000-11-28 -1142 2000-11-28 1142 2000-11-28 1064 2000-11-28 1064 2000-11-28 1064 2000-11-28 1142 2000-11-28 1064 2010-10-20 1064 2010-10-20 +1064 2010-10-28 1064 2010-10-28 +1142 2000-11-21 1142 2000-11-21 +1142 2000-11-28 1064 2000-11-28 +1142 2000-11-28 1142 2000-11-28 1142 2010-10-21 1142 2010-10-21 -1599 2010-10-22 1599 2010-10-22 -361 2010-10-23 361 2010-10-23 -897 2010-10-24 897 2010-10-24 +1142 2010-10-29 1142 2010-10-29 +1531 2000-11-25 1531 2000-11-25 1531 2010-10-25 1531 2010-10-25 +1599 2000-11-22 1599 2000-11-22 +1599 2010-10-22 1599 2010-10-22 +1610 2000-11-26 1610 2000-11-26 1610 2010-10-26 1610 2010-10-26 +3198 2000-11-27 3198 2000-11-27 3198 2010-10-27 3198 2010-10-27 -1064 2010-10-28 1064 2010-10-28 -1142 2010-10-29 1142 2010-10-29 +361 2000-11-23 361 2000-11-23 +361 2010-10-23 361 2010-10-23 +897 2000-11-24 897 2000-11-24 +897 2010-10-24 897 2010-10-24 PREHOOK: query: drop table date_join1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@date_join1 Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/join40.q.out URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/join40.q.out?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/results/clientpositive/join40.q.out (original) +++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/join40.q.out Fri Nov 7 22:08:23 2014 @@ -1,7 +1,11 @@ -PREHOOK: query: EXPLAIN SELECT x.key, x.value, y.key, y.value +PREHOOK: query: -- SORT_QUERY_RESULTS + +EXPLAIN SELECT x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT x.key, x.value, y.key, y.value +POSTHOOK: query: -- SORT_QUERY_RESULTS + +EXPLAIN SELECT x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) POSTHOOK: type: QUERY STAGE DEPENDENCIES: @@ -1855,6 +1859,64 @@ SORT BY src1.key, src1.value, src2.key, POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +2 val_2 2 val_2 2 val_2 +4 val_4 4 val_4 4 val_4 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +8 val_8 8 val_8 8 val_8 +9 val_9 9 val_9 9 val_9 NULL NULL NULL NULL 10 val_10 NULL NULL NULL NULL 100 val_100 NULL NULL NULL NULL 100 val_100 @@ -2345,64 +2407,6 @@ NULL NULL NULL NULL 97 val_97 NULL NULL NULL NULL 97 val_97 NULL NULL NULL NULL 98 val_98 NULL NULL NULL NULL 98 val_98 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -2 val_2 2 val_2 2 val_2 -4 val_4 4 val_4 4 val_4 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -8 val_8 8 val_8 8 val_8 -9 val_9 9 val_9 9 val_9 PREHOOK: query: EXPLAIN SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value @@ -2516,6 +2520,64 @@ SORT BY src1.key, src1.value, src2.key, POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 +2 val_2 2 val_2 2 val_2 +4 val_4 4 val_4 4 val_4 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 +8 val_8 8 val_8 8 val_8 +9 val_9 9 val_9 9 val_9 NULL NULL NULL NULL 10 val_10 NULL NULL NULL NULL 100 val_100 NULL NULL NULL NULL 100 val_100 @@ -3006,64 +3068,6 @@ NULL NULL NULL NULL 97 val_97 NULL NULL NULL NULL 97 val_97 NULL NULL NULL NULL 98 val_98 NULL NULL NULL NULL 98 val_98 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -0 val_0 0 val_0 0 val_0 -2 val_2 2 val_2 2 val_2 -4 val_4 4 val_4 4 val_4 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 -8 val_8 8 val_8 8 val_8 -9 val_9 9 val_9 9 val_9 PREHOOK: query: EXPLAIN SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key) @@ -3151,572 +3155,572 @@ FROM src x left outer JOIN (select * fro POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -238 val_238 NULL NULL -86 val_86 86 val_86 -311 val_311 NULL NULL -27 val_27 27 val_27 -165 val_165 NULL NULL -409 val_409 NULL NULL -255 val_255 NULL NULL -278 val_278 NULL NULL -98 val_98 98 val_98 -98 val_98 98 val_98 -484 val_484 NULL NULL -265 val_265 NULL NULL -193 val_193 NULL NULL -401 val_401 NULL NULL -150 val_150 NULL NULL -273 val_273 NULL NULL -224 val_224 NULL NULL -369 val_369 NULL NULL -66 val_66 66 val_66 -128 val_128 NULL NULL -213 val_213 NULL NULL -146 val_146 NULL NULL -406 val_406 NULL NULL -429 val_429 NULL NULL -374 val_374 NULL NULL -152 val_152 NULL NULL -469 val_469 NULL NULL +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +10 val_10 10 val_10 +100 val_100 100 val_100 +100 val_100 100 val_100 +100 val_100 100 val_100 +100 val_100 100 val_100 +103 val_103 NULL NULL +103 val_103 NULL NULL +104 val_104 NULL NULL +104 val_104 NULL NULL +105 val_105 NULL NULL +11 val_11 11 val_11 +111 val_111 NULL NULL +113 val_113 NULL NULL +113 val_113 NULL NULL +114 val_114 NULL NULL +116 val_116 NULL NULL +118 val_118 NULL NULL +118 val_118 NULL NULL +119 val_119 NULL NULL +119 val_119 NULL NULL +119 val_119 NULL NULL +12 val_12 12 val_12 +12 val_12 12 val_12 +12 val_12 12 val_12 +12 val_12 12 val_12 +120 val_120 NULL NULL +120 val_120 NULL NULL +125 val_125 NULL NULL +125 val_125 NULL NULL +126 val_126 NULL NULL +128 val_128 NULL NULL +128 val_128 NULL NULL +128 val_128 NULL NULL +129 val_129 NULL NULL +129 val_129 NULL NULL +131 val_131 NULL NULL +133 val_133 NULL NULL +134 val_134 NULL NULL +134 val_134 NULL NULL +136 val_136 NULL NULL +137 val_137 NULL NULL +137 val_137 NULL NULL +138 val_138 NULL NULL +138 val_138 NULL NULL +138 val_138 NULL NULL +138 val_138 NULL NULL +143 val_143 NULL NULL 145 val_145 NULL NULL -495 val_495 NULL NULL -37 val_37 37 val_37 -37 val_37 37 val_37 -327 val_327 NULL NULL -281 val_281 NULL NULL -277 val_277 NULL NULL -209 val_209 NULL NULL +146 val_146 NULL NULL +146 val_146 NULL NULL +149 val_149 NULL NULL +149 val_149 NULL NULL 15 val_15 15 val_15 15 val_15 15 val_15 -82 val_82 82 val_82 -403 val_403 NULL NULL -166 val_166 NULL NULL -417 val_417 NULL NULL -430 val_430 NULL NULL -252 val_252 NULL NULL -292 val_292 NULL NULL -219 val_219 NULL NULL -287 val_287 NULL NULL +15 val_15 15 val_15 +15 val_15 15 val_15 +150 val_150 NULL NULL +152 val_152 NULL NULL +152 val_152 NULL NULL 153 val_153 NULL NULL -193 val_193 NULL NULL -338 val_338 NULL NULL -446 val_446 NULL NULL -459 val_459 NULL NULL -394 val_394 NULL NULL -237 val_237 NULL NULL -482 val_482 NULL NULL -174 val_174 NULL NULL -413 val_413 NULL NULL -494 val_494 NULL NULL -207 val_207 NULL NULL -199 val_199 NULL NULL -466 val_466 NULL NULL -208 val_208 NULL NULL -174 val_174 NULL NULL -399 val_399 NULL NULL -396 val_396 NULL NULL -247 val_247 NULL NULL -417 val_417 NULL NULL -489 val_489 NULL NULL +155 val_155 NULL NULL +156 val_156 NULL NULL +157 val_157 NULL NULL +158 val_158 NULL NULL +160 val_160 NULL NULL 162 val_162 NULL NULL -377 val_377 NULL NULL -397 val_397 NULL NULL -309 val_309 NULL NULL -365 val_365 NULL NULL -266 val_266 NULL NULL -439 val_439 NULL NULL -342 val_342 NULL NULL -367 val_367 NULL NULL -325 val_325 NULL NULL +163 val_163 NULL NULL +164 val_164 NULL NULL +164 val_164 NULL NULL +165 val_165 NULL NULL +165 val_165 NULL NULL +166 val_166 NULL NULL 167 val_167 NULL NULL -195 val_195 NULL NULL -475 val_475 NULL NULL +167 val_167 NULL NULL +167 val_167 NULL NULL +168 val_168 NULL NULL +169 val_169 NULL NULL +169 val_169 NULL NULL +169 val_169 NULL NULL +169 val_169 NULL NULL 17 val_17 17 val_17 -113 val_113 NULL NULL -155 val_155 NULL NULL -203 val_203 NULL NULL -339 val_339 NULL NULL -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -455 val_455 NULL NULL -128 val_128 NULL NULL -311 val_311 NULL NULL -316 val_316 NULL NULL -57 val_57 57 val_57 -302 val_302 NULL NULL -205 val_205 NULL NULL -149 val_149 NULL NULL -438 val_438 NULL NULL -345 val_345 NULL NULL -129 val_129 NULL NULL 170 val_170 NULL NULL +172 val_172 NULL NULL +172 val_172 NULL NULL +174 val_174 NULL NULL +174 val_174 NULL NULL +175 val_175 NULL NULL +175 val_175 NULL NULL +176 val_176 NULL NULL +176 val_176 NULL NULL +177 val_177 NULL NULL +178 val_178 NULL NULL +179 val_179 NULL NULL +179 val_179 NULL NULL +18 val_18 18 val_18 +18 val_18 18 val_18 +18 val_18 18 val_18 +18 val_18 18 val_18 +180 val_180 NULL NULL +181 val_181 NULL NULL +183 val_183 NULL NULL +186 val_186 NULL NULL +187 val_187 NULL NULL +187 val_187 NULL NULL +187 val_187 NULL NULL +189 val_189 NULL NULL +19 val_19 19 val_19 +190 val_190 NULL NULL +191 val_191 NULL NULL +191 val_191 NULL NULL +192 val_192 NULL NULL +193 val_193 NULL NULL +193 val_193 NULL NULL +193 val_193 NULL NULL +194 val_194 NULL NULL +195 val_195 NULL NULL +195 val_195 NULL NULL +196 val_196 NULL NULL +197 val_197 NULL NULL +197 val_197 NULL NULL +199 val_199 NULL NULL +199 val_199 NULL NULL +199 val_199 NULL NULL +2 val_2 2 val_2 20 val_20 20 val_20 -489 val_489 NULL NULL -157 val_157 NULL NULL -378 val_378 NULL NULL -221 val_221 NULL NULL -92 val_92 92 val_92 -111 val_111 NULL NULL -47 val_47 47 val_47 -72 val_72 72 val_72 -72 val_72 72 val_72 -4 val_4 4 val_4 -280 val_280 NULL NULL -35 val_35 35 val_35 -35 val_35 35 val_35 -35 val_35 35 val_35 -427 val_427 NULL NULL -277 val_277 NULL NULL +200 val_200 NULL NULL +200 val_200 NULL NULL +201 val_201 NULL NULL +202 val_202 NULL NULL +203 val_203 NULL NULL +203 val_203 NULL NULL +205 val_205 NULL NULL +205 val_205 NULL NULL +207 val_207 NULL NULL +207 val_207 NULL NULL 208 val_208 NULL NULL -356 val_356 NULL NULL -399 val_399 NULL NULL -169 val_169 NULL NULL -382 val_382 NULL NULL -498 val_498 NULL NULL -125 val_125 NULL NULL -386 val_386 NULL NULL -437 val_437 NULL NULL -469 val_469 NULL NULL -192 val_192 NULL NULL -286 val_286 NULL NULL -187 val_187 NULL NULL -176 val_176 NULL NULL -54 val_54 54 val_54 -459 val_459 NULL NULL -51 val_51 51 val_51 -51 val_51 51 val_51 -138 val_138 NULL NULL -103 val_103 NULL NULL -239 val_239 NULL NULL +208 val_208 NULL NULL +208 val_208 NULL NULL +209 val_209 NULL NULL +209 val_209 NULL NULL 213 val_213 NULL NULL +213 val_213 NULL NULL +214 val_214 NULL NULL 216 val_216 NULL NULL -430 val_430 NULL NULL -278 val_278 NULL NULL -176 val_176 NULL NULL -289 val_289 NULL NULL +216 val_216 NULL NULL +217 val_217 NULL NULL +217 val_217 NULL NULL +218 val_218 NULL NULL +219 val_219 NULL NULL +219 val_219 NULL NULL 221 val_221 NULL NULL -65 val_65 65 val_65 -318 val_318 NULL NULL -332 val_332 NULL NULL -311 val_311 NULL NULL -275 val_275 NULL NULL -137 val_137 NULL NULL -241 val_241 NULL NULL -83 val_83 83 val_83 -83 val_83 83 val_83 -333 val_333 NULL NULL -180 val_180 NULL NULL -284 val_284 NULL NULL -12 val_12 12 val_12 -12 val_12 12 val_12 +221 val_221 NULL NULL +222 val_222 NULL NULL +223 val_223 NULL NULL +223 val_223 NULL NULL +224 val_224 NULL NULL +224 val_224 NULL NULL +226 val_226 NULL NULL +228 val_228 NULL NULL +229 val_229 NULL NULL +229 val_229 NULL NULL 230 val_230 NULL NULL -181 val_181 NULL NULL -67 val_67 67 val_67 -67 val_67 67 val_67 -260 val_260 NULL NULL -404 val_404 NULL NULL -384 val_384 NULL NULL -489 val_489 NULL NULL -353 val_353 NULL NULL -373 val_373 NULL NULL -272 val_272 NULL NULL -138 val_138 NULL NULL -217 val_217 NULL NULL -84 val_84 84 val_84 -84 val_84 84 val_84 -348 val_348 NULL NULL -466 val_466 NULL NULL -58 val_58 58 val_58 -58 val_58 58 val_58 -8 val_8 8 val_8 -411 val_411 NULL NULL 230 val_230 NULL NULL -208 val_208 NULL NULL -348 val_348 NULL NULL +230 val_230 NULL NULL +230 val_230 NULL NULL +230 val_230 NULL NULL +233 val_233 NULL NULL +233 val_233 NULL NULL +235 val_235 NULL NULL +237 val_237 NULL NULL +237 val_237 NULL NULL +238 val_238 NULL NULL +238 val_238 NULL NULL +239 val_239 NULL NULL +239 val_239 NULL NULL 24 val_24 24 val_24 24 val_24 24 val_24 -463 val_463 NULL NULL -431 val_431 NULL NULL -179 val_179 NULL NULL -172 val_172 NULL NULL -42 val_42 42 val_42 -42 val_42 42 val_42 -129 val_129 NULL NULL -158 val_158 NULL NULL -119 val_119 NULL NULL -496 val_496 NULL NULL -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -322 val_322 NULL NULL -197 val_197 NULL NULL -468 val_468 NULL NULL -393 val_393 NULL NULL -454 val_454 NULL NULL -100 val_100 100 val_100 -100 val_100 100 val_100 -298 val_298 NULL NULL -199 val_199 NULL NULL -191 val_191 NULL NULL -418 val_418 NULL NULL -96 val_96 96 val_96 +24 val_24 24 val_24 +24 val_24 24 val_24 +241 val_241 NULL NULL +242 val_242 NULL NULL +242 val_242 NULL NULL +244 val_244 NULL NULL +247 val_247 NULL NULL +248 val_248 NULL NULL +249 val_249 NULL NULL +252 val_252 NULL NULL +255 val_255 NULL NULL +255 val_255 NULL NULL +256 val_256 NULL NULL +256 val_256 NULL NULL +257 val_257 NULL NULL +258 val_258 NULL NULL 26 val_26 26 val_26 26 val_26 26 val_26 -165 val_165 NULL NULL -327 val_327 NULL NULL -230 val_230 NULL NULL -205 val_205 NULL NULL -120 val_120 NULL NULL -131 val_131 NULL NULL -51 val_51 51 val_51 -51 val_51 51 val_51 -404 val_404 NULL NULL -43 val_43 43 val_43 -436 val_436 NULL NULL -156 val_156 NULL NULL -469 val_469 NULL NULL -468 val_468 NULL NULL -308 val_308 NULL NULL -95 val_95 95 val_95 -95 val_95 95 val_95 -196 val_196 NULL NULL -288 val_288 NULL NULL -481 val_481 NULL NULL -457 val_457 NULL NULL -98 val_98 98 val_98 -98 val_98 98 val_98 +26 val_26 26 val_26 +26 val_26 26 val_26 +260 val_260 NULL NULL +262 val_262 NULL NULL +263 val_263 NULL NULL +265 val_265 NULL NULL +265 val_265 NULL NULL +266 val_266 NULL NULL +27 val_27 27 val_27 +272 val_272 NULL NULL +272 val_272 NULL NULL +273 val_273 NULL NULL +273 val_273 NULL NULL +273 val_273 NULL NULL +274 val_274 NULL NULL +275 val_275 NULL NULL +277 val_277 NULL NULL +277 val_277 NULL NULL +277 val_277 NULL NULL +277 val_277 NULL NULL +278 val_278 NULL NULL +278 val_278 NULL NULL +28 val_28 28 val_28 +280 val_280 NULL NULL +280 val_280 NULL NULL +281 val_281 NULL NULL +281 val_281 NULL NULL 282 val_282 NULL NULL -197 val_197 NULL NULL -187 val_187 NULL NULL -318 val_318 NULL NULL -318 val_318 NULL NULL -409 val_409 NULL NULL -470 val_470 NULL NULL -137 val_137 NULL NULL -369 val_369 NULL NULL -316 val_316 NULL NULL -169 val_169 NULL NULL -413 val_413 NULL NULL -85 val_85 85 val_85 -77 val_77 77 val_77 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -490 val_490 NULL NULL -87 val_87 87 val_87 -364 val_364 NULL NULL -179 val_179 NULL NULL -118 val_118 NULL NULL -134 val_134 NULL NULL -395 val_395 NULL NULL 282 val_282 NULL NULL -138 val_138 NULL NULL -238 val_238 NULL NULL -419 val_419 NULL NULL -15 val_15 15 val_15 -15 val_15 15 val_15 -118 val_118 NULL NULL -72 val_72 72 val_72 -72 val_72 72 val_72 -90 val_90 90 val_90 -90 val_90 90 val_90 -90 val_90 90 val_90 -307 val_307 NULL NULL -19 val_19 19 val_19 -435 val_435 NULL NULL -10 val_10 10 val_10 -277 val_277 NULL NULL -273 val_273 NULL NULL +283 val_283 NULL NULL +284 val_284 NULL NULL +285 val_285 NULL NULL +286 val_286 NULL NULL +287 val_287 NULL NULL +288 val_288 NULL NULL +288 val_288 NULL NULL +289 val_289 NULL NULL +291 val_291 NULL NULL +292 val_292 NULL NULL +296 val_296 NULL NULL +298 val_298 NULL NULL +298 val_298 NULL NULL +298 val_298 NULL NULL +30 val_30 30 val_30 +302 val_302 NULL NULL +305 val_305 NULL NULL 306 val_306 NULL NULL -224 val_224 NULL NULL +307 val_307 NULL NULL +307 val_307 NULL NULL +308 val_308 NULL NULL 309 val_309 NULL NULL -389 val_389 NULL NULL +309 val_309 NULL NULL +310 val_310 NULL NULL +311 val_311 NULL NULL +311 val_311 NULL NULL +311 val_311 NULL NULL +315 val_315 NULL NULL +316 val_316 NULL NULL +316 val_316 NULL NULL +316 val_316 NULL NULL +317 val_317 NULL NULL +317 val_317 NULL NULL +318 val_318 NULL NULL +318 val_318 NULL NULL +318 val_318 NULL NULL +321 val_321 NULL NULL +321 val_321 NULL NULL +322 val_322 NULL NULL +322 val_322 NULL NULL +323 val_323 NULL NULL +325 val_325 NULL NULL +325 val_325 NULL NULL 327 val_327 NULL NULL -242 val_242 NULL NULL -369 val_369 NULL NULL -392 val_392 NULL NULL -272 val_272 NULL NULL +327 val_327 NULL NULL +327 val_327 NULL NULL +33 val_33 33 val_33 331 val_331 NULL NULL -401 val_401 NULL NULL -242 val_242 NULL NULL -452 val_452 NULL NULL -177 val_177 NULL NULL -226 val_226 NULL NULL -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -497 val_497 NULL NULL -402 val_402 NULL NULL -396 val_396 NULL NULL -317 val_317 NULL NULL -395 val_395 NULL NULL -58 val_58 58 val_58 -58 val_58 58 val_58 +331 val_331 NULL NULL +332 val_332 NULL NULL +333 val_333 NULL NULL +333 val_333 NULL NULL +335 val_335 NULL NULL +336 val_336 NULL NULL +338 val_338 NULL NULL +339 val_339 NULL NULL +34 val_34 34 val_34 +341 val_341 NULL NULL +342 val_342 NULL NULL +342 val_342 NULL NULL +344 val_344 NULL NULL +344 val_344 NULL NULL +345 val_345 NULL NULL +348 val_348 NULL NULL +348 val_348 NULL NULL +348 val_348 NULL NULL +348 val_348 NULL NULL +348 val_348 NULL NULL 35 val_35 35 val_35 35 val_35 35 val_35 35 val_35 35 val_35 -336 val_336 NULL NULL -95 val_95 95 val_95 -95 val_95 95 val_95 -11 val_11 11 val_11 -168 val_168 NULL NULL -34 val_34 34 val_34 -229 val_229 NULL NULL -233 val_233 NULL NULL -143 val_143 NULL NULL -472 val_472 NULL NULL -322 val_322 NULL NULL -498 val_498 NULL NULL -160 val_160 NULL NULL -195 val_195 NULL NULL +35 val_35 35 val_35 +35 val_35 35 val_35 +35 val_35 35 val_35 +35 val_35 35 val_35 +35 val_35 35 val_35 +35 val_35 35 val_35 +351 val_351 NULL NULL +353 val_353 NULL NULL +353 val_353 NULL NULL +356 val_356 NULL NULL +360 val_360 NULL NULL +362 val_362 NULL NULL +364 val_364 NULL NULL +365 val_365 NULL NULL +366 val_366 NULL NULL +367 val_367 NULL NULL +367 val_367 NULL NULL +368 val_368 NULL NULL +369 val_369 NULL NULL +369 val_369 NULL NULL +369 val_369 NULL NULL +37 val_37 37 val_37 +37 val_37 37 val_37 +37 val_37 37 val_37 +37 val_37 37 val_37 +373 val_373 NULL NULL +374 val_374 NULL NULL +375 val_375 NULL NULL +377 val_377 NULL NULL +378 val_378 NULL NULL +379 val_379 NULL NULL +382 val_382 NULL NULL +382 val_382 NULL NULL +384 val_384 NULL NULL +384 val_384 NULL NULL +384 val_384 NULL NULL +386 val_386 NULL NULL +389 val_389 NULL NULL +392 val_392 NULL NULL +393 val_393 NULL NULL +394 val_394 NULL NULL +395 val_395 NULL NULL +395 val_395 NULL NULL +396 val_396 NULL NULL +396 val_396 NULL NULL +396 val_396 NULL NULL +397 val_397 NULL NULL +397 val_397 NULL NULL +399 val_399 NULL NULL +399 val_399 NULL NULL +4 val_4 4 val_4 +400 val_400 NULL NULL +401 val_401 NULL NULL +401 val_401 NULL NULL +401 val_401 NULL NULL +401 val_401 NULL NULL +401 val_401 NULL NULL +402 val_402 NULL NULL +403 val_403 NULL NULL +403 val_403 NULL NULL +403 val_403 NULL NULL +404 val_404 NULL NULL +404 val_404 NULL NULL +406 val_406 NULL NULL +406 val_406 NULL NULL +406 val_406 NULL NULL +406 val_406 NULL NULL +407 val_407 NULL NULL +409 val_409 NULL NULL +409 val_409 NULL NULL +409 val_409 NULL NULL +41 val_41 41 val_41 +411 val_411 NULL NULL +413 val_413 NULL NULL +413 val_413 NULL NULL +414 val_414 NULL NULL +414 val_414 NULL NULL +417 val_417 NULL NULL +417 val_417 NULL NULL +417 val_417 NULL NULL +418 val_418 NULL NULL +419 val_419 NULL NULL 42 val_42 42 val_42 42 val_42 42 val_42 -321 val_321 NULL NULL +42 val_42 42 val_42 +42 val_42 42 val_42 +421 val_421 NULL NULL +424 val_424 NULL NULL +424 val_424 NULL NULL +427 val_427 NULL NULL +429 val_429 NULL NULL +429 val_429 NULL NULL +43 val_43 43 val_43 430 val_430 NULL NULL -119 val_119 NULL NULL -489 val_489 NULL NULL -458 val_458 NULL NULL -78 val_78 78 val_78 -76 val_76 76 val_76 -76 val_76 76 val_76 -41 val_41 41 val_41 -223 val_223 NULL NULL -492 val_492 NULL NULL -149 val_149 NULL NULL +430 val_430 NULL NULL +430 val_430 NULL NULL +431 val_431 NULL NULL +431 val_431 NULL NULL +431 val_431 NULL NULL +432 val_432 NULL NULL +435 val_435 NULL NULL +436 val_436 NULL NULL +437 val_437 NULL NULL +438 val_438 NULL NULL +438 val_438 NULL NULL +438 val_438 NULL NULL +439 val_439 NULL NULL +439 val_439 NULL NULL +44 val_44 44 val_44 +443 val_443 NULL NULL +444 val_444 NULL NULL +446 val_446 NULL NULL +448 val_448 NULL NULL 449 val_449 NULL NULL -218 val_218 NULL NULL -228 val_228 NULL NULL -138 val_138 NULL NULL +452 val_452 NULL NULL 453 val_453 NULL NULL -30 val_30 30 val_30 -209 val_209 NULL NULL -64 val_64 64 val_64 +454 val_454 NULL NULL +454 val_454 NULL NULL +454 val_454 NULL NULL +455 val_455 NULL NULL +457 val_457 NULL NULL +458 val_458 NULL NULL +458 val_458 NULL NULL +459 val_459 NULL NULL +459 val_459 NULL NULL +460 val_460 NULL NULL +462 val_462 NULL NULL +462 val_462 NULL NULL +463 val_463 NULL NULL +463 val_463 NULL NULL +466 val_466 NULL NULL +466 val_466 NULL NULL +466 val_466 NULL NULL +467 val_467 NULL NULL 468 val_468 NULL NULL -76 val_76 76 val_76 -76 val_76 76 val_76 -74 val_74 74 val_74 -342 val_342 NULL NULL -69 val_69 69 val_69 -230 val_230 NULL NULL -33 val_33 33 val_33 -368 val_368 NULL NULL -103 val_103 NULL NULL -296 val_296 NULL NULL -113 val_113 NULL NULL -216 val_216 NULL NULL -367 val_367 NULL NULL -344 val_344 NULL NULL -167 val_167 NULL NULL -274 val_274 NULL NULL -219 val_219 NULL NULL -239 val_239 NULL NULL -485 val_485 NULL NULL -116 val_116 NULL NULL -223 val_223 NULL NULL -256 val_256 NULL NULL -263 val_263 NULL NULL -70 val_70 70 val_70 -70 val_70 70 val_70 -70 val_70 70 val_70 -487 val_487 NULL NULL +468 val_468 NULL NULL +468 val_468 NULL NULL +468 val_468 NULL NULL +469 val_469 NULL NULL +469 val_469 NULL NULL +469 val_469 NULL NULL +469 val_469 NULL NULL +469 val_469 NULL NULL +47 val_47 47 val_47 +470 val_470 NULL NULL +472 val_472 NULL NULL +475 val_475 NULL NULL +477 val_477 NULL NULL +478 val_478 NULL NULL +478 val_478 NULL NULL +479 val_479 NULL NULL 480 val_480 NULL NULL -401 val_401 NULL NULL -288 val_288 NULL NULL -191 val_191 NULL NULL +480 val_480 NULL NULL +480 val_480 NULL NULL +481 val_481 NULL NULL +482 val_482 NULL NULL +483 val_483 NULL NULL +484 val_484 NULL NULL +485 val_485 NULL NULL +487 val_487 NULL NULL +489 val_489 NULL NULL +489 val_489 NULL NULL +489 val_489 NULL NULL +489 val_489 NULL NULL +490 val_490 NULL NULL +491 val_491 NULL NULL +492 val_492 NULL NULL +492 val_492 NULL NULL +493 val_493 NULL NULL +494 val_494 NULL NULL +495 val_495 NULL NULL +496 val_496 NULL NULL +497 val_497 NULL NULL +498 val_498 NULL NULL +498 val_498 NULL NULL +498 val_498 NULL NULL +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 5 val_5 5 val_5 5 val_5 5 val_5 5 val_5 5 val_5 5 val_5 -244 val_244 NULL NULL -438 val_438 NULL NULL -128 val_128 NULL NULL -467 val_467 NULL NULL -432 val_432 NULL NULL -202 val_202 NULL NULL -316 val_316 NULL NULL -229 val_229 NULL NULL -469 val_469 NULL NULL -463 val_463 NULL NULL -280 val_280 NULL NULL -2 val_2 2 val_2 -35 val_35 35 val_35 -35 val_35 35 val_35 -35 val_35 35 val_35 -283 val_283 NULL NULL -331 val_331 NULL NULL -235 val_235 NULL NULL -80 val_80 80 val_80 -44 val_44 44 val_44 -193 val_193 NULL NULL -321 val_321 NULL NULL -335 val_335 NULL NULL -104 val_104 NULL NULL -466 val_466 NULL NULL -366 val_366 NULL NULL -175 val_175 NULL NULL -403 val_403 NULL NULL -483 val_483 NULL NULL -53 val_53 53 val_53 -105 val_105 NULL NULL -257 val_257 NULL NULL -406 val_406 NULL NULL -409 val_409 NULL NULL -190 val_190 NULL NULL -406 val_406 NULL NULL -401 val_401 NULL NULL -114 val_114 NULL NULL -258 val_258 NULL NULL -90 val_90 90 val_90 -90 val_90 90 val_90 -90 val_90 90 val_90 -203 val_203 NULL NULL -262 val_262 NULL NULL -348 val_348 NULL NULL -424 val_424 NULL NULL -12 val_12 12 val_12 -12 val_12 12 val_12 -396 val_396 NULL NULL -201 val_201 NULL NULL -217 val_217 NULL NULL -164 val_164 NULL NULL -431 val_431 NULL NULL -454 val_454 NULL NULL -478 val_478 NULL NULL -298 val_298 NULL NULL -125 val_125 NULL NULL -431 val_431 NULL NULL -164 val_164 NULL NULL -424 val_424 NULL NULL -187 val_187 NULL NULL -382 val_382 NULL NULL 5 val_5 5 val_5 5 val_5 5 val_5 5 val_5 5 val_5 +51 val_51 51 val_51 +51 val_51 51 val_51 +51 val_51 51 val_51 +51 val_51 51 val_51 +53 val_53 53 val_53 +54 val_54 54 val_54 +57 val_57 57 val_57 +58 val_58 58 val_58 +58 val_58 58 val_58 +58 val_58 58 val_58 +58 val_58 58 val_58 +64 val_64 64 val_64 +65 val_65 65 val_65 +66 val_66 66 val_66 +67 val_67 67 val_67 +67 val_67 67 val_67 +67 val_67 67 val_67 +67 val_67 67 val_67 +69 val_69 69 val_69 70 val_70 70 val_70 70 val_70 70 val_70 70 val_70 70 val_70 -397 val_397 NULL NULL -480 val_480 NULL NULL -291 val_291 NULL NULL -24 val_24 24 val_24 -24 val_24 24 val_24 -351 val_351 NULL NULL -255 val_255 NULL NULL -104 val_104 NULL NULL 70 val_70 70 val_70 70 val_70 70 val_70 70 val_70 70 val_70 -163 val_163 NULL NULL -438 val_438 NULL NULL -119 val_119 NULL NULL -414 val_414 NULL NULL -200 val_200 NULL NULL -491 val_491 NULL NULL -237 val_237 NULL NULL -439 val_439 NULL NULL -360 val_360 NULL NULL -248 val_248 NULL NULL -479 val_479 NULL NULL -305 val_305 NULL NULL -417 val_417 NULL NULL -199 val_199 NULL NULL -444 val_444 NULL NULL -120 val_120 NULL NULL -429 val_429 NULL NULL -169 val_169 NULL NULL -443 val_443 NULL NULL -323 val_323 NULL NULL -325 val_325 NULL NULL -277 val_277 NULL NULL -230 val_230 NULL NULL -478 val_478 NULL NULL -178 val_178 NULL NULL -468 val_468 NULL NULL -310 val_310 NULL NULL -317 val_317 NULL NULL -333 val_333 NULL NULL -493 val_493 NULL NULL -460 val_460 NULL NULL -207 val_207 NULL NULL -249 val_249 NULL NULL -265 val_265 NULL NULL -480 val_480 NULL NULL +70 val_70 70 val_70 +70 val_70 70 val_70 +70 val_70 70 val_70 +72 val_72 72 val_72 +72 val_72 72 val_72 +72 val_72 72 val_72 +72 val_72 72 val_72 +74 val_74 74 val_74 +76 val_76 76 val_76 +76 val_76 76 val_76 +76 val_76 76 val_76 +76 val_76 76 val_76 +77 val_77 77 val_77 +78 val_78 78 val_78 +8 val_8 8 val_8 +80 val_80 80 val_80 +82 val_82 82 val_82 +83 val_83 83 val_83 +83 val_83 83 val_83 83 val_83 83 val_83 83 val_83 83 val_83 -136 val_136 NULL NULL -353 val_353 NULL NULL -172 val_172 NULL NULL -214 val_214 NULL NULL -462 val_462 NULL NULL -233 val_233 NULL NULL -406 val_406 NULL NULL -133 val_133 NULL NULL -175 val_175 NULL NULL -189 val_189 NULL NULL -454 val_454 NULL NULL -375 val_375 NULL NULL -401 val_401 NULL NULL -421 val_421 NULL NULL -407 val_407 NULL NULL -384 val_384 NULL NULL -256 val_256 NULL NULL -26 val_26 26 val_26 -26 val_26 26 val_26 -134 val_134 NULL NULL -67 val_67 67 val_67 -67 val_67 67 val_67 -384 val_384 NULL NULL -379 val_379 NULL NULL -18 val_18 18 val_18 -18 val_18 18 val_18 -462 val_462 NULL NULL -492 val_492 NULL NULL -100 val_100 100 val_100 -100 val_100 100 val_100 -298 val_298 NULL NULL -9 val_9 9 val_9 -341 val_341 NULL NULL -498 val_498 NULL NULL -146 val_146 NULL NULL -458 val_458 NULL NULL -362 val_362 NULL NULL -186 val_186 NULL NULL -285 val_285 NULL NULL -348 val_348 NULL NULL -167 val_167 NULL NULL -18 val_18 18 val_18 -18 val_18 18 val_18 -273 val_273 NULL NULL -183 val_183 NULL NULL -281 val_281 NULL NULL -344 val_344 NULL NULL -97 val_97 97 val_97 -97 val_97 97 val_97 -469 val_469 NULL NULL -315 val_315 NULL NULL 84 val_84 84 val_84 84 val_84 84 val_84 -28 val_28 28 val_28 -37 val_37 37 val_37 -37 val_37 37 val_37 -448 val_448 NULL NULL -152 val_152 NULL NULL -348 val_348 NULL NULL -307 val_307 NULL NULL -194 val_194 NULL NULL -414 val_414 NULL NULL -477 val_477 NULL NULL -222 val_222 NULL NULL -126 val_126 NULL NULL +84 val_84 84 val_84 +84 val_84 84 val_84 +85 val_85 85 val_85 +86 val_86 86 val_86 +87 val_87 87 val_87 +9 val_9 9 val_9 90 val_90 90 val_90 90 val_90 90 val_90 90 val_90 90 val_90 -169 val_169 NULL NULL -403 val_403 NULL NULL -400 val_400 NULL NULL -200 val_200 NULL NULL +90 val_90 90 val_90 +90 val_90 90 val_90 +90 val_90 90 val_90 +90 val_90 90 val_90 +90 val_90 90 val_90 +90 val_90 90 val_90 +92 val_92 92 val_92 +95 val_95 95 val_95 +95 val_95 95 val_95 +95 val_95 95 val_95 +95 val_95 95 val_95 +96 val_96 96 val_96 +97 val_97 97 val_97 +97 val_97 97 val_97 97 val_97 97 val_97 97 val_97 97 val_97 +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: EXPLAIN SELECT COUNT(1) FROM SRC A JOIN SRC B ON (A.KEY=B.KEY) PREHOOK: type: QUERY Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out?rev=1637472&r1=1637471&r2=1637472&view=diff ============================================================================== --- hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out (original) +++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out Fri Nov 7 22:08:23 2014 @@ -1,4 +1,6 @@ -PREHOOK: query: CREATE TABLE decimal_mapjoin STORED AS ORC AS +PREHOOK: query: -- SORT_QUERY_RESULTS + +CREATE TABLE decimal_mapjoin STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, cint @@ -7,7 +9,9 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@alltypesorc PREHOOK: Output: database:default PREHOOK: Output: default@decimal_mapjoin -POSTHOOK: query: CREATE TABLE decimal_mapjoin STORED AS ORC AS +POSTHOOK: query: -- SORT_QUERY_RESULTS + +CREATE TABLE decimal_mapjoin STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, cint @@ -109,103 +113,103 @@ POSTHOOK: query: SELECT l.cint, r.cint, POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_mapjoin #### A masked pattern was here #### +6981 6981 -515.6210729730 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 +6981 6981 -515.6210729730 6984454.211097692 +6981 6981 -515.6210729730 6984454.211097692 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 5831542.269248378 -617.5607769230769 +6981 6981 5831542.269248378 -617.5607769230769 +6981 6981 5831542.269248378 6984454.211097692 +6981 6981 5831542.269248378 NULL +6981 6981 5831542.269248378 NULL +6981 6981 5831542.269248378 NULL +6981 6981 5831542.269248378 NULL +6981 6981 5831542.269248378 NULL +6981 6981 5831542.269248378 NULL +6981 6981 5831542.269248378 NULL +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.5607769230769 +6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.211097692 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 NULL 6984454.211097692 -6981 6981 NULL 6984454.211097692 -6981 6981 NULL 6984454.211097692 -6981 6981 NULL 6984454.211097692 -6981 6981 5831542.269248378 6984454.211097692 -6981 6981 NULL 6984454.211097692 -6981 6981 NULL 6984454.211097692 -6981 6981 NULL 6984454.211097692 -6981 6981 -515.6210729730 6984454.211097692 -6981 6981 -515.6210729730 6984454.211097692 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 5831542.269248378 -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 5831542.269248378 -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769