Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-622

possible import bug with embedded LF (0x0A) in VARCHAR field

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Invalid
    • 1.4.1-incubating
    • 1.4.1-incubating
    • connectors
    • CentOS 5.8

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            jsciandra Joel Sciandra
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: