CREATE TABLE escape_inno
(
id int AUTO_INCREMENT PRIMARY KEY,
sVal varchar(50),
createDate datetime
) ENGINE=INNODB DEFAULT CHARSET utf8;

CREATE TABLE escape_columnstore
(
id int NOT NULL,
sVal varchar(50),
createDate datetime
) ENGINE=columnstore DEFAULT CHARSET utf8 COMMENT='autoincrement=id';

LOAD DATA INFILE '/mnt/data/testEscape.asc.data1' INTO TABLE escape_inno CHARACTER SET UTF8; – GOOD: transform per 2 "\" to a "\"
LOAD DATA INFILE '/mnt/data/testEscape.asc.data1' INTO TABLE escape_columnstore CHARACTER SET UTF8; – BAD: transform per 4 "\" to a "\"