-- with string
CREATE TABLE escape3_1
( 
GERUND STRING, 
ABBREV STRING,
CODE SMALLINT 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' ESCAPED BY '\134' 
STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_1;

select * from escape3_1;

-- 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;

LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_2;

select * from escape3_2;

-- 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;

LOAD DATA LOCAL INPATH '../../data/files/data_with_escape.txt' INTO TABLE escape3_3;

select * from escape3_3;

DROP TABLE escape3_1;
DROP TABLE escape3_2;
DROP TABLE escape3_3;