PREHOOK: query: CREATE TABLE joinone(key1 int, key2 int, value int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE joinone(key1 int, key2 int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@joinone
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in5.txt' INTO TABLE joinone
PREHOOK: type: LOAD
PREHOOK: Output: default@joinone
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in5.txt' INTO TABLE joinone
POSTHOOK: type: LOAD
POSTHOOK: Output: default@joinone
PREHOOK: query: CREATE TABLE joinTwo(key1 int, key2 int, value int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE joinTwo(key1 int, key2 int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@joinTwo
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE joinTwo
PREHOOK: type: LOAD
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) 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) 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
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	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
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	60	10040	66
60	10040	66	60	10040	66
60	10040	66	70	10040	88
60	10040	66	70	10040	88
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	60	10040	66
70	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	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