PREHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE join_1to1_1(key1 int, key2 int, value int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@join_1to1_1 POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE join_1to1_1(key1 int, key2 int, value int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@join_1to1_1 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in5.txt' INTO TABLE join_1to1_1 PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@join_1to1_1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in5.txt' INTO TABLE join_1to1_1 POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@join_1to1_1 PREHOOK: query: CREATE TABLE join_1to1_2(key1 int, key2 int, value int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@join_1to1_2 POSTHOOK: query: CREATE TABLE join_1to1_2(key1 int, key2 int, value int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@join_1to1_2 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in6.txt' INTO TABLE join_1to1_2 PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@join_1to1_2 POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in6.txt' INTO TABLE join_1to1_2 POSTHOOK: type: LOAD #### A masked pattern was here #### 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 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 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 30 10030 66 NULL NULL NULL 40 10040 66 40 10040 66 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL 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 NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 30 10030 66 NULL NULL NULL 40 10040 66 40 10040 66 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL 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 NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 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 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 30 10030 66 NULL NULL NULL 40 10040 66 40 10040 66 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL 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 NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 30 10030 66 NULL NULL NULL 40 10040 66 40 10040 66 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL 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 NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 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 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 30 10030 66 NULL NULL NULL 40 10040 66 40 10040 66 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL 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 NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 30 10030 66 NULL NULL NULL 40 10040 66 40 10040 66 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL 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 NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 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 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 25 10025 88 NULL NULL NULL 30 10030 66 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 66 40 10040 66 40 10040 88 NULL NULL NULL 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 66 50 10050 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL 80 10040 88 NULL NULL NULL 80 10040 88 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL 25 10025 66 NULL NULL NULL 30 10030 88 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 80 10040 66 NULL NULL NULL 80 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 25 10025 88 NULL NULL NULL 30 10030 66 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 66 40 10040 66 40 10040 88 NULL NULL NULL 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 66 50 10050 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL 80 10040 88 NULL NULL NULL 80 10040 88 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL 25 10025 66 NULL NULL NULL 30 10030 88 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 80 10040 66 NULL NULL NULL 80 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 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 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 25 10025 88 NULL NULL NULL 30 10030 66 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 66 40 10040 66 40 10040 88 NULL NULL NULL 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 66 50 10050 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL 80 10040 88 NULL NULL NULL 80 10040 88 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL 25 10025 66 NULL NULL NULL 30 10030 88 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 80 10040 66 NULL NULL NULL 80 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 25 10025 88 NULL NULL NULL 30 10030 66 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 66 40 10040 66 40 10040 88 NULL NULL NULL 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 66 50 10050 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL 80 10040 88 NULL NULL NULL 80 10040 88 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL 25 10025 66 NULL NULL NULL 30 10030 88 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 80 10040 66 NULL NULL NULL 80 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 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 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 25 10025 88 NULL NULL NULL 30 10030 66 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 66 40 10040 66 40 10040 88 NULL NULL NULL 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 66 50 10050 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL 80 10040 88 NULL NULL NULL 80 10040 88 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL 25 10025 66 NULL NULL NULL 30 10030 88 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 80 10040 66 NULL NULL NULL 80 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 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 66 40 10040 88 40 10040 88 40 10040 66 40 10040 88 40 10040 88 5 10005 66 5 10005 66 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 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 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 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 80 10040 88 80 10040 66 NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 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: 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: type: QUERY POSTHOOK: Input: default@join_1to1_1 POSTHOOK: Input: default@join_1to1_2 #### A masked pattern was here #### 15 10015 66 NULL NULL NULL 20 10020 66 20 10020 66 25 10025 88 NULL NULL NULL 30 10030 66 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 66 40 10040 66 40 10040 88 NULL NULL NULL 5 10005 66 5 10005 66 50 10050 66 50 10050 66 50 10050 66 50 10050 66 50 10050 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 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 66 NULL NULL NULL 70 10040 66 NULL NULL NULL 80 10040 88 NULL NULL NULL 80 10040 88 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66 NULL NULL NULL NULL NULL NULL 10 10010 66 NULL NULL NULL 25 10025 66 NULL NULL NULL 30 10030 88 NULL NULL NULL 35 10035 88 NULL NULL NULL 40 10040 88 NULL NULL NULL 50 10050 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 70 10040 88 NULL NULL NULL 80 10040 66 NULL NULL NULL 80 10040 66 NULL NULL NULL NULL 10050 66 NULL NULL NULL NULL NULL 66