You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/08/24 00:58:38 UTC
svn commit: r1620093 [5/5] - in /hive/branches/spark:
itests/src/test/resources/ ql/src/test/results/clientpositive/spark/
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/join8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/join8.q.out?rev=1620093&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/join8.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/join8.q.out Sat Aug 23 22:58:38 2014
@@ -0,0 +1,179 @@
+PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dest1
+POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
+FROM (
+ FROM
+ (
+ FROM src src1 SELECT src1.key AS c1, src1.value AS c2 WHERE src1.key > 10 and src1.key < 20
+ ) a
+ LEFT OUTER JOIN
+ (
+ FROM src src2 SELECT src2.key AS c3, src2.value AS c4 WHERE src2.key > 15 and src2.key < 25
+ ) b
+ ON (a.c1 = b.c3)
+ SELECT a.c1 AS c1, a.c2 AS c2, b.c3 AS c3, b.c4 AS c4
+) c
+INSERT OVERWRITE TABLE dest1 SELECT c.c1, c.c2, c.c3, c.c4 where c.c3 IS NULL AND c.c1 IS NOT NULL
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+FROM (
+ FROM
+ (
+ FROM src src1 SELECT src1.key AS c1, src1.value AS c2 WHERE src1.key > 10 and src1.key < 20
+ ) a
+ LEFT OUTER JOIN
+ (
+ FROM src src2 SELECT src2.key AS c3, src2.value AS c4 WHERE src2.key > 15 and src2.key < 25
+ ) b
+ ON (a.c1 = b.c3)
+ SELECT a.c1 AS c1, a.c2 AS c2, b.c3 AS c3, b.c4 AS c4
+) c
+INSERT OVERWRITE TABLE dest1 SELECT c.c1, c.c2, c.c3, c.c4 where c.c3 IS NULL AND c.c1 IS NOT NULL
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
+ Stage-3 depends on stages: Stage-0
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP SORT), Map 3 (GROUP SORT)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: src1
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((key > 10) and (key < 20)) and key is not null) (type: boolean)
+ Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: src2
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((key > 15) and (key < 25)) and key is not null) (type: boolean)
+ Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: _col2 is null (type: boolean)
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(_col2) (type: int), _col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+
+ Stage: Stage-2
+ Dependency Collection
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+
+ Stage: Stage-3
+ Stats-Aggr Operator
+
+PREHOOK: query: FROM (
+ FROM
+ (
+ FROM src src1 SELECT src1.key AS c1, src1.value AS c2 WHERE src1.key > 10 and src1.key < 20
+ ) a
+ LEFT OUTER JOIN
+ (
+ FROM src src2 SELECT src2.key AS c3, src2.value AS c4 WHERE src2.key > 15 and src2.key < 25
+ ) b
+ ON (a.c1 = b.c3)
+ SELECT a.c1 AS c1, a.c2 AS c2, b.c3 AS c3, b.c4 AS c4
+) c
+INSERT OVERWRITE TABLE dest1 SELECT c.c1, c.c2, c.c3, c.c4 where c.c3 IS NULL AND c.c1 IS NOT NULL
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to
+POSTHOOK: query: FROM (
+ FROM
+ (
+ FROM src src1 SELECT src1.key AS c1, src1.value AS c2 WHERE src1.key > 10 and src1.key < 20
+ ) a
+ LEFT OUTER JOIN
+ (
+ FROM src src2 SELECT src2.key AS c3, src2.value AS c4 WHERE src2.key > 15 and src2.key < 25
+ ) b
+ ON (a.c1 = b.c3)
+ SELECT a.c1 AS c1, a.c2 AS c2, b.c3 AS c3, b.c4 AS c4
+) c
+INSERT OVERWRITE TABLE dest1 SELECT c.c1, c.c2, c.c3, c.c4 where c.c3 IS NULL AND c.c1 IS NOT NULL
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest1
+POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c2 SIMPLE [(src)src1.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src2.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: dest1.c4 SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@dest1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@dest1
+#### A masked pattern was here ####
+11 val_11 NULL NULL
+12 val_12 NULL NULL
+12 val_12 NULL NULL
+15 val_15 NULL NULL
+15 val_15 NULL NULL
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/join9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/join9.q.out?rev=1620093&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/join9.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/join9.q.out Sat Aug 23 22:58:38 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/join_1to1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/join_1to1.q.out?rev=1620093&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/join_1to1.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/join_1to1.q.out Sat Aug 23 22:58:38 2014
@@ -0,0 +1,1278 @@
+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