http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/join_acid_non_acid.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_acid_non_acid.q.out b/ql/src/test/results/clientpositive/join_acid_non_acid.q.out deleted file mode 100644 index f1c93cd0..0000000 --- a/ql/src/test/results/clientpositive/join_acid_non_acid.q.out +++ /dev/null @@ -1,54 +0,0 @@ -PREHOOK: query: CREATE TABLE orc_update_table (k1 INT, f1 STRING, op_code STRING) -CLUSTERED BY (k1) INTO 2 BUCKETS -STORED AS ORC TBLPROPERTIES("transactional"="true") -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@orc_update_table -POSTHOOK: query: CREATE TABLE orc_update_table (k1 INT, f1 STRING, op_code STRING) -CLUSTERED BY (k1) INTO 2 BUCKETS -STORED AS ORC TBLPROPERTIES("transactional"="true") -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@orc_update_table -PREHOOK: query: INSERT INTO TABLE orc_update_table VALUES (1, 'a', 'I') -PREHOOK: type: QUERY -PREHOOK: Output: default@orc_update_table -POSTHOOK: query: INSERT INTO TABLE orc_update_table VALUES (1, 'a', 'I') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@orc_update_table -POSTHOOK: Lineage: orc_update_table.f1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: orc_update_table.k1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: orc_update_table.op_code SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -PREHOOK: query: CREATE TABLE orc_table (k1 INT, f1 STRING) -CLUSTERED BY (k1) SORTED BY (k1) INTO 2 BUCKETS -STORED AS ORC -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@orc_table -POSTHOOK: query: CREATE TABLE orc_table (k1 INT, f1 STRING) -CLUSTERED BY (k1) SORTED BY (k1) INTO 2 BUCKETS -STORED AS ORC -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@orc_table -PREHOOK: query: INSERT OVERWRITE TABLE orc_table VALUES (1, 'x') -PREHOOK: type: QUERY -PREHOOK: Output: default@orc_table -POSTHOOK: query: INSERT OVERWRITE TABLE orc_table VALUES (1, 'x') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@orc_table -POSTHOOK: Lineage: orc_table.f1 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: orc_table.k1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: SELECT t1.*, t2.* FROM orc_table t1 -JOIN orc_update_table t2 ON t1.k1=t2.k1 ORDER BY t1.k1 -PREHOOK: type: QUERY -PREHOOK: Input: default@orc_table -PREHOOK: Input: default@orc_update_table -#### A masked pattern was here #### -POSTHOOK: query: SELECT t1.*, t2.* FROM orc_table t1 -JOIN orc_update_table t2 ON t1.k1=t2.k1 ORDER BY t1.k1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@orc_table -POSTHOOK: Input: default@orc_update_table -#### A masked pattern was here #### -1 x 1 a I
http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/join_filters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join_filters.q.out b/ql/src/test/results/clientpositive/join_filters.q.out deleted file mode 100644 index fa0584d..0000000 --- a/ql/src/test/results/clientpositive/join_filters.q.out +++ /dev/null @@ -1,1484 +0,0 @@ -PREHOOK: query: -- SORT_AND_HASH_QUERY_RESULTS - -CREATE TABLE myinput1(key int, value int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@myinput1 -POSTHOOK: query: -- SORT_AND_HASH_QUERY_RESULTS - -CREATE TABLE myinput1(key int, value int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@myinput1 -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in3.txt' INTO TABLE myinput1 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@myinput1 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in3.txt' INTO TABLE myinput1 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@myinput1 -Warning: Shuffle Join JOIN[8][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -Warning: Shuffle Join JOIN[6][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -PREHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL 12 35 NULL NULL -NULL NULL 48 NULL NULL NULL -NULL NULL NULL 40 NULL NULL -BYad/CYbc/RASCgl63S7Ww== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -PREHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -PREHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL 12 35 NULL NULL -NULL NULL 48 NULL NULL NULL -NULL NULL NULL 40 NULL NULL -BYad/CYbc/RASCgl63S7Ww== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -Warning: Map Join MAPJOIN[15][bigTable=?] in task 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -Warning: Map Join MAPJOIN[15][bigTable=?] in task 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@smb_input1 -POSTHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@smb_input1 -PREHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@smb_input2 -POSTHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@smb_input2 -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@smb_input1 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@smb_input1 -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@smb_input1 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@smb_input1 -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@smb_input2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@smb_input2 -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@smb_input2 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@smb_input2 -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -148 NULL NULL NULL -200 200 200 200 -48 NULL NULL NULL -NULL 135 NULL NULL -NULL 35 NULL NULL -t2boI39B33IANcqlsXXA3g== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -148 NULL NULL NULL -200 200 200 200 -48 NULL NULL NULL -NULL 135 NULL NULL -NULL 35 NULL NULL -t2boI39B33IANcqlsXXA3g== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -148 NULL NULL NULL -200 200 200 200 -48 NULL NULL NULL -NULL 135 NULL NULL -NULL 35 NULL NULL -t2boI39B33IANcqlsXXA3g== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -NULL NULL 148 NULL -NULL NULL 48 NULL -NULL NULL NULL 135 -NULL NULL NULL 35 -UBr9lyqgsjDFvooMgQlZ9w== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -NULL NULL 148 NULL -NULL NULL 48 NULL -NULL NULL NULL 135 -NULL NULL NULL 35 -UBr9lyqgsjDFvooMgQlZ9w== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -NULL NULL 148 NULL -NULL NULL 48 NULL -NULL NULL NULL 135 -NULL NULL NULL 35 -UBr9lyqgsjDFvooMgQlZ9w== -Warning: Shuffle Join JOIN[8][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -Warning: Shuffle Join JOIN[6][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -JIHZKZaNhNR9LYBcRFyxng== -PREHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -PREHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL 12 35 NULL NULL -NULL NULL 48 NULL NULL NULL -NULL NULL NULL 40 NULL NULL -BYad/CYbc/RASCgl63S7Ww== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -PREHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) RIGHT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -PREHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) LEFT OUTER JOIN myinput1 c ON (b.key=c.key AND c.key > 40 AND c.value > 50 AND c.key = c.value AND b.key > 40 AND b.value > 50 AND b.key = b.value) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL 12 35 NULL NULL -NULL NULL 48 NULL NULL NULL -NULL NULL NULL 40 NULL NULL -BYad/CYbc/RASCgl63S7Ww== -PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.key = c.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value AND c.key > 40 AND c.value > 50 AND c.key = c.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 100 100 -NULL NULL NULL NULL 12 35 -NULL NULL NULL NULL 48 NULL -NULL NULL NULL NULL NULL 40 -AzUxen/yR7DlsL00zfSITA== -Warning: Map Join MAPJOIN[15][bigTable=?] in task 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -Warning: Map Join MAPJOIN[15][bigTable=?] in task 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -YaI1msgLVpfEx943Tfea/Q== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -12 35 NULL NULL -48 NULL NULL NULL -NULL 40 NULL NULL -M3MWtBJdRXSWIJY5Qr/otw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@myinput1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@myinput1 -#### A masked pattern was here #### -100 100 100 100 -NULL NULL 12 35 -NULL NULL 48 NULL -NULL NULL NULL 40 -LNZKrcVNAvaeDALnsg72bw== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.key = b.key AND a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -fRHAbs52npY0rAF1I1Npfg== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -148 NULL NULL NULL -200 200 200 200 -48 NULL NULL NULL -NULL 135 NULL NULL -NULL 35 NULL NULL -t2boI39B33IANcqlsXXA3g== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -148 NULL NULL NULL -200 200 200 200 -48 NULL NULL NULL -NULL 135 NULL NULL -NULL 35 NULL NULL -t2boI39B33IANcqlsXXA3g== -PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -148 NULL NULL NULL -200 200 200 200 -48 NULL NULL NULL -NULL 135 NULL NULL -NULL 35 NULL NULL -t2boI39B33IANcqlsXXA3g== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -NULL NULL 148 NULL -NULL NULL 48 NULL -NULL NULL NULL 135 -NULL NULL NULL 35 -UBr9lyqgsjDFvooMgQlZ9w== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input1 -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input1 -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -NULL NULL 148 NULL -NULL NULL 48 NULL -NULL NULL NULL 135 -NULL NULL NULL 35 -UBr9lyqgsjDFvooMgQlZ9w== -PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -PREHOOK: type: QUERY -PREHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value AND a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@smb_input2 -#### A masked pattern was here #### -100 100 100 100 -200 200 200 200 -NULL NULL 148 NULL -NULL NULL 48 NULL -NULL NULL NULL 135 -NULL NULL NULL 35 -UBr9lyqgsjDFvooMgQlZ9w==