Details
Description
From the Sqoop Developer Guide:
"Hive does not support enclosing and escaping characters. You must
choose unambiguous field and record-terminating delimiters without the
help of escaping and enclosing characters when working with Hive; this
is a limitation of Hive's input parsing abilities."
In fact, Hive does support the ability to define escaping characters:
CREATE TABLE tab(a STRING, b STRING, c STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ',' ESCAPED BY '
'
STORED AS TEXTFILE;