PREHOOK: query: -- with string
CREATE TABLE escape3_1
( 
GERUND STRING, 
ABBREV STRING,
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@escape3_1
POSTHOOK: query: -- with string
CREATE TABLE escape3_1
( 
GERUND STRING, 
ABBREV STRING,
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@escape3_1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_1
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@escape3_1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_1
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@escape3_1
PREHOOK: query: select * from escape3_1
PREHOOK: type: QUERY
PREHOOK: Input: default@escape3_1
#### A masked pattern was here ####
POSTHOOK: query: select * from escape3_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@escape3_1
#### A masked pattern was here ####
re|ading	V|A	100
writ|ing	MD	200
w|aiting	|NC	300
seein|g	TN|	400
runn|ing	WV	500
PREHOOK: query: -- with varchar
CREATE TABLE escape3_2
( 
GERUND VARCHAR(10), 
ABBREV VARCHAR(3), 
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@escape3_2
POSTHOOK: query: -- with varchar
CREATE TABLE escape3_2
( 
GERUND VARCHAR(10), 
ABBREV VARCHAR(3), 
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@escape3_2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_2
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@escape3_2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_2
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@escape3_2
PREHOOK: query: select * from escape3_2
PREHOOK: type: QUERY
PREHOOK: Input: default@escape3_2
#### A masked pattern was here ####
POSTHOOK: query: select * from escape3_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@escape3_2
#### A masked pattern was here ####
re|ading	V|A	100
writ|ing	MD	200
w|aiting	|NC	300
seein|g	TN|	400
runn|ing	WV	500
PREHOOK: query: -- with char
CREATE TABLE escape3_3
( 
GERUND CHAR(10), 
ABBREV CHAR(3), 
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@escape3_3
POSTHOOK: query: -- with char
CREATE TABLE escape3_3
( 
GERUND CHAR(10), 
ABBREV CHAR(3), 
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@escape3_3
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_3
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@escape3_3
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_3
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@escape3_3
PREHOOK: query: select * from escape3_3
PREHOOK: type: QUERY
PREHOOK: Input: default@escape3_3
#### A masked pattern was here ####
POSTHOOK: query: select * from escape3_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@escape3_3
#### A masked pattern was here ####
re|ading  	V|A	100
writ|ing  	MD 	200
w|aiting  	|NC	300
seein|g   	TN|	400
runn|ing  	WV 	500
PREHOOK: query: DROP TABLE escape3_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@escape3_1
PREHOOK: Output: default@escape3_1
POSTHOOK: query: DROP TABLE escape3_1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@escape3_1
POSTHOOK: Output: default@escape3_1
PREHOOK: query: DROP TABLE escape3_2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@escape3_2
PREHOOK: Output: default@escape3_2
POSTHOOK: query: DROP TABLE escape3_2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@escape3_2
POSTHOOK: Output: default@escape3_2
PREHOOK: query: DROP TABLE escape3_3
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@escape3_3
PREHOOK: Output: default@escape3_3
POSTHOOK: query: DROP TABLE escape3_3
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@escape3_3
POSTHOOK: Output: default@escape3_3