hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r1236489 [3/7] - in /hive/trunk/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Fri, 27 Jan 2012 01:41:37 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out Fri Jan 27 01:41:35 2012
@@ -20,12 +20,12 @@ PREHOOK: Output: default@join_1to1_2
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE join_1to1_2
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@join_1to1_2
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
@@ -39,15 +39,15 @@ POSTHOOK: Input: default@join_1to1_2
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -60,22 +60,22 @@ POSTHOOK: Input: default@join_1to1_2
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -85,15 +85,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -106,25 +106,27 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	10050	66	NULL	NULL	NULL
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	25	10025	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
-NULL	NULL	NULL	25	10025	66
 30	10030	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 50	10050	66	50	10050	66
@@ -135,24 +137,22 @@ NULL	NULL	NULL	25	10025	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	80	10040	66
-NULL	NULL	NULL	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -162,15 +162,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -183,25 +183,27 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	25	10025	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
-NULL	NULL	NULL	25	10025	66
 30	10030	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 50	10050	66	50	10050	66
@@ -212,14 +214,12 @@ NULL	NULL	NULL	25	10025	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	80	10040	66
-NULL	NULL	NULL	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
@@ -233,15 +233,15 @@ POSTHOOK: Input: default@join_1to1_2
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -254,22 +254,22 @@ POSTHOOK: Input: default@join_1to1_2
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -279,15 +279,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -300,25 +300,27 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	10050	66	NULL	NULL	NULL
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	25	10025	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
-NULL	NULL	NULL	25	10025	66
 30	10030	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 50	10050	66	50	10050	66
@@ -329,24 +331,22 @@ NULL	NULL	NULL	25	10025	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	80	10040	66
-NULL	NULL	NULL	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -356,15 +356,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -377,25 +377,27 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	25	10025	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
-NULL	NULL	NULL	25	10025	66
 30	10030	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 50	10050	66	50	10050	66
@@ -406,14 +408,12 @@ NULL	NULL	NULL	25	10025	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	80	10040	66
-NULL	NULL	NULL	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
@@ -424,18 +424,18 @@ POSTHOOK: Input: default@join_1to1_2
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
 40	10040	66	40	10040	66
-40	10040	88	40	10040	66
 40	10040	66	40	10040	88
+40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
-50	10050	88	50	10050	88
-50	10050	88	50	10050	88
 50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -448,40 +448,40 @@ POSTHOOK: Input: default@join_1to1_2
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
 40	10040	66	40	10040	66
-40	10040	88	40	10040	66
 40	10040	66	40	10040	88
+40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
-50	10050	88	50	10050	88
-50	10050	88	50	10050	88
 50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -494,25 +494,27 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	10050	66	NULL	NULL	NULL
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	25	10025	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
-NULL	NULL	NULL	25	10025	66
 30	10030	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 50	10050	66	50	10050	66
@@ -523,42 +525,40 @@ NULL	NULL	NULL	25	10025	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	80	10040	66
-NULL	NULL	NULL	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
 40	10040	66	40	10040	66
-40	10040	88	40	10040	66
 40	10040	66	40	10040	88
+40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
-50	10050	88	50	10050	88
-50	10050	88	50	10050	88
 50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -571,25 +571,27 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	25	10025	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	NULL	80	10040	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
-NULL	NULL	NULL	25	10025	66
 30	10030	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 50	10050	66	50	10050	66
@@ -600,14 +602,12 @@ NULL	NULL	NULL	25	10025	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	80	10040	66
-NULL	NULL	NULL	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
@@ -621,15 +621,15 @@ POSTHOOK: Input: default@join_1to1_2
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -642,22 +642,22 @@ POSTHOOK: Input: default@join_1to1_2
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -667,15 +667,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -688,45 +688,49 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	30	10030	88
+NULL	NULL	NULL	35	10035	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	NULL	NULL	NULL
 30	10030	66	NULL	NULL	NULL
-NULL	NULL	NULL	30	10030	88
 35	10035	88	NULL	NULL	NULL
-NULL	NULL	NULL	35	10035	88
-40	10040	66	40	10040	66
 40	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
+40	10040	66	40	10040	66
 40	10040	88	NULL	NULL	NULL
 40	10040	88	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 50	10050	66	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 60	10040	66	60	10040	66
@@ -734,33 +738,29 @@ NULL	NULL	NULL	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -770,15 +770,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -791,45 +791,49 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	30	10030	88
+NULL	NULL	NULL	35	10035	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	NULL	NULL	NULL
 30	10030	66	NULL	NULL	NULL
-NULL	NULL	NULL	30	10030	88
 35	10035	88	NULL	NULL	NULL
-NULL	NULL	NULL	35	10035	88
-40	10040	66	40	10040	66
 40	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
+40	10040	66	40	10040	66
 40	10040	88	NULL	NULL	NULL
 40	10040	88	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 50	10050	66	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	66	50	10050	66
 50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 60	10040	66	60	10040	66
@@ -837,23 +841,19 @@ NULL	NULL	NULL	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
@@ -867,15 +867,15 @@ POSTHOOK: Input: default@join_1to1_2
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -888,22 +888,22 @@ POSTHOOK: Input: default@join_1to1_2
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -913,15 +913,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -934,45 +934,49 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	30	10030	88
+NULL	NULL	NULL	35	10035	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	NULL	NULL	NULL
 30	10030	66	NULL	NULL	NULL
-NULL	NULL	NULL	30	10030	88
 35	10035	88	NULL	NULL	NULL
-NULL	NULL	NULL	35	10035	88
-40	10040	66	40	10040	66
 40	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
+40	10040	66	40	10040	66
 40	10040	88	NULL	NULL	NULL
 40	10040	88	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 50	10050	66	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
+50	10050	66	50	10050	66
 50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
-50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 60	10040	66	60	10040	66
@@ -980,33 +984,29 @@ NULL	NULL	NULL	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
@@ -1016,15 +1016,15 @@ NULL	NULL	NULL	10	10010	66
 40	10040	66	40	10040	88
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
 50	10050	66	50	10050	66
-50	10050	88	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
-50	10050	88	50	10050	88
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -1037,45 +1037,49 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	30	10030	88
+NULL	NULL	NULL	35	10035	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	NULL	NULL	NULL
 30	10030	66	NULL	NULL	NULL
-NULL	NULL	NULL	30	10030	88
 35	10035	88	NULL	NULL	NULL
-NULL	NULL	NULL	35	10035	88
-40	10040	66	40	10040	66
 40	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
+40	10040	66	40	10040	66
 40	10040	88	NULL	NULL	NULL
 40	10040	88	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 50	10050	66	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
+50	10050	66	50	10050	66
 50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
-50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 60	10040	66	60	10040	66
@@ -1083,23 +1087,19 @@ NULL	NULL	NULL	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
@@ -1110,18 +1110,18 @@ POSTHOOK: Input: default@join_1to1_2
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
 40	10040	66	40	10040	66
-40	10040	88	40	10040	66
 40	10040	66	40	10040	88
+40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
-50	10050	88	50	10050	88
-50	10050	88	50	10050	88
 50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -1134,40 +1134,40 @@ POSTHOOK: Input: default@join_1to1_2
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
 40	10040	66	40	10040	66
-40	10040	88	40	10040	66
 40	10040	66	40	10040	88
+40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
-50	10050	88	50	10050	88
-50	10050	88	50	10050	88
 50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -1180,45 +1180,49 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	30	10030	88
+NULL	NULL	NULL	35	10035	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	NULL	NULL	NULL
 30	10030	66	NULL	NULL	NULL
-NULL	NULL	NULL	30	10030	88
 35	10035	88	NULL	NULL	NULL
-NULL	NULL	NULL	35	10035	88
+40	10040	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 40	10040	88	NULL	NULL	NULL
-40	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 40	10040	88	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 50	10050	66	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
-50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
-50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 60	10040	66	60	10040	66
@@ -1226,51 +1230,47 @@ NULL	NULL	NULL	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
 40	10040	66	40	10040	66
-40	10040	88	40	10040	66
 40	10040	66	40	10040	88
+40	10040	88	40	10040	66
 40	10040	88	40	10040	88
-50	10050	66	50	10050	88
-50	10050	88	50	10050	88
-50	10050	88	50	10050	88
 50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
-50	10050	66	50	10050	66
 50	10050	88	50	10050	66
 50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
@@ -1283,45 +1283,49 @@ NULL	NULL	NULL	10	10010	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
 80	10040	88	80	10040	66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@join_1to1_1
 PREHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@join_1to1_1
 POSTHOOK: Input: default@join_1to1_2
 #### A masked pattern was here ####
-NULL	NULL	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	NULL	66
-NULL	10050	66	NULL	NULL	NULL
 NULL	NULL	NULL	NULL	10050	66
-5	10005	66	5	10005	66
 NULL	NULL	NULL	10	10010	66
+NULL	NULL	NULL	30	10030	88
+NULL	NULL	NULL	35	10035	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	40	10040	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	50	10050	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	NULL	70	10040	88
+NULL	NULL	66	NULL	NULL	NULL
+NULL	10050	66	NULL	NULL	NULL
+5	10005	66	5	10005	66
 15	10015	66	NULL	NULL	NULL
 20	10020	66	20	10020	66
 25	10025	88	NULL	NULL	NULL
 30	10030	66	NULL	NULL	NULL
-NULL	NULL	NULL	30	10030	88
 35	10035	88	NULL	NULL	NULL
-NULL	NULL	NULL	35	10035	88
+40	10040	66	NULL	NULL	NULL
 40	10040	66	40	10040	66
 40	10040	88	NULL	NULL	NULL
-40	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 40	10040	88	NULL	NULL	NULL
-NULL	NULL	NULL	40	10040	88
 50	10050	66	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
+50	10050	66	50	10050	66
+50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
 50	10050	88	NULL	NULL	NULL
-NULL	NULL	NULL	50	10050	88
-50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
-50	10050	66	50	10050	66
 50	10050	88	NULL	NULL	NULL
 50	10050	88	NULL	NULL	NULL
 60	10040	66	60	10040	66
@@ -1329,13 +1333,9 @@ NULL	NULL	NULL	50	10050	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 70	10040	66	NULL	NULL	NULL
-NULL	NULL	NULL	70	10040	88
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL
 80	10040	88	NULL	NULL	NULL

Modified: hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out Fri Jan 27 01:41:35 2012
@@ -20,98 +20,98 @@ PREHOOK: Output: default@jointwo
 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE joinTwo
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@jointwo
-PREHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2)
+PREHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2) ORDER BY joinone.key1 ASC, joinone.key2 ASC, joinone.value ASC, joinTwo.key1 ASC, joinTwo.key2 ASC, joinTwo.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@joinone
 PREHOOK: Input: default@jointwo
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2)
+POSTHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2) ORDER BY joinone.key1 ASC, joinone.key2 ASC, joinone.value ASC, joinTwo.key1 ASC, joinTwo.key2 ASC, joinTwo.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@joinone
 POSTHOOK: Input: default@jointwo
 #### A masked pattern was here ####
+NULL	10050	66	NULL	10050	66
+NULL	10050	66	50	10050	66
+NULL	10050	66	50	10050	66
+NULL	10050	66	50	10050	88
 5	10005	66	5	10005	66
 20	10020	66	20	10020	66
 25	10025	88	25	10025	66
 30	10030	66	30	10030	88
 35	10035	88	35	10035	88
-80	10040	88	80	10040	66
-80	10040	88	80	10040	66
-80	10040	88	40	10040	66
-80	10040	88	40	10040	88
-80	10040	88	60	10040	66
-80	10040	88	60	10040	66
-80	10040	88	70	10040	88
-80	10040	88	70	10040	88
-80	10040	88	80	10040	66
-80	10040	88	80	10040	66
-80	10040	88	40	10040	66
-80	10040	88	40	10040	88
-80	10040	88	60	10040	66
-80	10040	88	60	10040	66
-80	10040	88	70	10040	88
-80	10040	88	70	10040	88
-40	10040	66	80	10040	66
-40	10040	66	80	10040	66
 40	10040	66	40	10040	66
 40	10040	66	40	10040	88
 40	10040	66	60	10040	66
 40	10040	66	60	10040	66
 40	10040	66	70	10040	88
 40	10040	66	70	10040	88
-40	10040	88	80	10040	66
-40	10040	88	80	10040	66
+40	10040	66	80	10040	66
+40	10040	66	80	10040	66
 40	10040	88	40	10040	66
 40	10040	88	40	10040	88
 40	10040	88	60	10040	66
 40	10040	88	60	10040	66
 40	10040	88	70	10040	88
 40	10040	88	70	10040	88
-60	10040	66	80	10040	66
-60	10040	66	80	10040	66
+40	10040	88	80	10040	66
+40	10040	88	80	10040	66
+50	10050	66	NULL	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	66
+50	10050	66	50	10050	88
+50	10050	88	NULL	10050	66
+50	10050	88	NULL	10050	66
+50	10050	88	50	10050	66
+50	10050	88	50	10050	66
+50	10050	88	50	10050	66
+50	10050	88	50	10050	66
+50	10050	88	50	10050	88
+50	10050	88	50	10050	88
+60	10040	66	40	10040	66
 60	10040	66	40	10040	66
 60	10040	66	40	10040	88
+60	10040	66	40	10040	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
-60	10040	66	70	10040	88
-60	10040	66	70	10040	88
-60	10040	66	80	10040	66
-60	10040	66	80	10040	66
-60	10040	66	40	10040	66
-60	10040	66	40	10040	88
 60	10040	66	60	10040	66
 60	10040	66	60	10040	66
 60	10040	66	70	10040	88
 60	10040	66	70	10040	88
-70	10040	66	80	10040	66
-70	10040	66	80	10040	66
+60	10040	66	70	10040	88
+60	10040	66	70	10040	88
+60	10040	66	80	10040	66
+60	10040	66	80	10040	66
+60	10040	66	80	10040	66
+60	10040	66	80	10040	66
+70	10040	66	40	10040	66
 70	10040	66	40	10040	66
 70	10040	66	40	10040	88
+70	10040	66	40	10040	88
 70	10040	66	60	10040	66
 70	10040	66	60	10040	66
-70	10040	66	70	10040	88
-70	10040	66	70	10040	88
-70	10040	66	80	10040	66
-70	10040	66	80	10040	66
-70	10040	66	40	10040	66
-70	10040	66	40	10040	88
 70	10040	66	60	10040	66
 70	10040	66	60	10040	66
 70	10040	66	70	10040	88
 70	10040	66	70	10040	88
-50	10050	88	50	10050	66
-50	10050	88	50	10050	66
-50	10050	88	NULL	10050	66
-50	10050	88	50	10050	88
-50	10050	88	50	10050	66
-50	10050	88	50	10050	66
-50	10050	88	NULL	10050	66
-50	10050	88	50	10050	88
-NULL	10050	66	50	10050	66
-NULL	10050	66	50	10050	66
-NULL	10050	66	NULL	10050	66
-NULL	10050	66	50	10050	88
-50	10050	66	50	10050	66
-50	10050	66	50	10050	66
-50	10050	66	NULL	10050	66
-50	10050	66	50	10050	88
+70	10040	66	70	10040	88
+70	10040	66	70	10040	88
+70	10040	66	80	10040	66
+70	10040	66	80	10040	66
+70	10040	66	80	10040	66
+70	10040	66	80	10040	66
+80	10040	88	40	10040	66
+80	10040	88	40	10040	66
+80	10040	88	40	10040	88
+80	10040	88	40	10040	88
+80	10040	88	60	10040	66
+80	10040	88	60	10040	66
+80	10040	88	60	10040	66
+80	10040	88	60	10040	66
+80	10040	88	70	10040	88
+80	10040	88	70	10040	88
+80	10040	88	70	10040	88
+80	10040	88	70	10040	88
+80	10040	88	80	10040	66
+80	10040	88	80	10040	66
+80	10040	88	80	10040	66
+80	10040	88	80	10040	66



Mime
View raw message