PREHOOK: query: drop table varchar_join1_vc1 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table varchar_join1_vc1 POSTHOOK: type: DROPTABLE PREHOOK: query: drop table varchar_join1_vc2 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table varchar_join1_vc2 POSTHOOK: type: DROPTABLE PREHOOK: query: drop table varchar_join1_str PREHOOK: type: DROPTABLE POSTHOOK: query: drop table varchar_join1_str POSTHOOK: type: DROPTABLE PREHOOK: query: create table varchar_join1_vc1 ( c1 int, c2 varchar(10) ) PREHOOK: type: CREATETABLE POSTHOOK: query: create table varchar_join1_vc1 ( c1 int, c2 varchar(10) ) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@varchar_join1_vc1 PREHOOK: query: create table varchar_join1_vc2 ( c1 int, c2 varchar(20) ) PREHOOK: type: CREATETABLE POSTHOOK: query: create table varchar_join1_vc2 ( c1 int, c2 varchar(20) ) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@varchar_join1_vc2 PREHOOK: query: create table varchar_join1_str ( c1 int, c2 string ) PREHOOK: type: CREATETABLE POSTHOOK: query: create table varchar_join1_str ( c1 int, c2 string ) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@varchar_join1_str PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc1 PREHOOK: type: LOAD PREHOOK: Output: default@varchar_join1_vc1 POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc1 POSTHOOK: type: LOAD POSTHOOK: Output: default@varchar_join1_vc1 PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc2 PREHOOK: type: LOAD PREHOOK: Output: default@varchar_join1_vc2 POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc2 POSTHOOK: type: LOAD POSTHOOK: Output: default@varchar_join1_vc2 PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_str PREHOOK: type: LOAD PREHOOK: Output: default@varchar_join1_str POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_str POSTHOOK: type: LOAD POSTHOOK: Output: default@varchar_join1_str PREHOOK: query: -- Join varchar with same length varchar select * from varchar_join1_vc1 a join varchar_join1_vc1 b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY PREHOOK: Input: default@varchar_join1_vc1 #### A masked pattern was here #### POSTHOOK: query: -- Join varchar with same length varchar select * from varchar_join1_vc1 a join varchar_join1_vc1 b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@varchar_join1_vc1 #### A masked pattern was here #### 1 abc 1 abc 2 abc 2 abc 3 abc 3 abc PREHOOK: query: -- Join varchar with different length varchar select * from varchar_join1_vc1 a join varchar_join1_vc2 b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY PREHOOK: Input: default@varchar_join1_vc1 PREHOOK: Input: default@varchar_join1_vc2 #### A masked pattern was here #### POSTHOOK: query: -- Join varchar with different length varchar select * from varchar_join1_vc1 a join varchar_join1_vc2 b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@varchar_join1_vc1 POSTHOOK: Input: default@varchar_join1_vc2 #### A masked pattern was here #### 1 abc 1 abc 2 abc 2 abc 3 abc 3 abc PREHOOK: query: -- Join varchar with string select * from varchar_join1_vc1 a join varchar_join1_str b on (a.c2 = b.c2) order by a.c1 PREHOOK: type: QUERY PREHOOK: Input: default@varchar_join1_str PREHOOK: Input: default@varchar_join1_vc1 #### A masked pattern was here #### POSTHOOK: query: -- Join varchar with string select * from varchar_join1_vc1 a join varchar_join1_str b on (a.c2 = b.c2) order by a.c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@varchar_join1_str POSTHOOK: Input: default@varchar_join1_vc1 #### A masked pattern was here #### 1 abc 1 abc 2 abc 2 abc 3 abc 3 abc PREHOOK: query: drop table varchar_join1_vc1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@varchar_join1_vc1 PREHOOK: Output: default@varchar_join1_vc1 POSTHOOK: query: drop table varchar_join1_vc1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@varchar_join1_vc1 POSTHOOK: Output: default@varchar_join1_vc1 PREHOOK: query: drop table varchar_join1_vc2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@varchar_join1_vc2 PREHOOK: Output: default@varchar_join1_vc2 POSTHOOK: query: drop table varchar_join1_vc2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@varchar_join1_vc2 POSTHOOK: Output: default@varchar_join1_vc2 PREHOOK: query: drop table varchar_join1_str PREHOOK: type: DROPTABLE PREHOOK: Input: default@varchar_join1_str PREHOOK: Output: default@varchar_join1_str POSTHOOK: query: drop table varchar_join1_str POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@varchar_join1_str POSTHOOK: Output: default@varchar_join1_str