Joel Sciandra created SQOOP-622:
-----------------------------------
Summary: possible import bug with embedded LF (0x0A) in VARCHAR
field
Key: SQOOP-622
URL: https://issues.apache.org/jira/browse/SQOOP-622
Project: Sqoop
Issue Type: Bug
Components: connectors
Affects Versions: 1.4.1-incubating
Environment: CentOS 5.8
Reporter: Joel Sciandra
Priority: Minor
Given the command:
sqoop import --connect jdbc:oracle:thin:@//somecomputer.com:2115/bla --username
USER_SELECT --password itssecret --target-dir /user/me/sqoop --table
PROD2.XXX_TRANS --fields-terminated-by '\0x7C' --enclosed-by '\0x60'
I have a REMARKS field defined as a VARCHAR2(4000). It is for a comments text
box on a web site. Sometimes customers hit <CR> and that gets embedded in the
remarks field.
When that gets processed, it appears that SQOOP is responding to the contents
of the field instead of just outputting the whole thing within the enclosed-by
characters.
grep 53159612 part-m-00000
`53159612`|`53159611`|`anapi`|`OWENS TEGRA`|`USPS=8101 LEPRECHAUN WAY
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
