Henrique Andrade created SQOOP-2312:
---------------------------------------
Summary: Problem when exporting files that has \n as part as the
content columns
Key: SQOOP-2312
URL: https://issues.apache.org/jira/browse/SQOOP-2312
Project: Sqoop
Issue Type: Bug
Components: connectors/generic
Environment: Sqoop 1.4.6-rc1
Reporter: Henrique Andrade
Priority: Critical
I have exported from my SQL Server some data related to our customers.
One of the columns has some comments from customers and this is the data that
is there:
"Pecém\n" +
" \n" +
"
(São Gonçalo do Amarante)
The problem is that Sqoop is breaking the Record at this point and the rest of
the process is failing.
I tried to use some different options such as lines-terminated by with
different character (ˆ) but looks like hadoop library is not accepting that and
is taking all the 29.000 records as a single record.
"--fields-terminated-by", "|",
"--lines-terminated-by", "ˆ",
"--enclosed-by","'",
"--escaped-by","\\"};
I have read in some threads that looks like the only lines-terminated-by
character that was accepted was \n. Is this changed on this 1.4.6 version?
Is there a way for avoiding the content of the columns to break the import?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
