Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-188

CLONE - Problem with NULL values in MySQL export

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0, 1.3.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      mac os x

      Description

      hive null data is stored as "\N" and during sqoop export, it doesn't consider that the same as "NULL". An example record that contains "NULL" values in a hive table:

      805^A537092^A3347387259^A468358^A19^A\N^A700^AD2D^A\N^A\N^A\N^A137.065002^A\N^A\N^A\N^A0^A0^A2010-05-14^A2^A2^A0^AS^A1^A

      error message:
      11/04/19 23:08:33 INFO mapred.JobClient: Task Id : attempt_201104191954_0010_m_000000_2, Status : FAILED
      java.lang.NumberFormatException: For input string: "\N"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
      at java.lang.Integer.parseInt(Integer.java:449)
      at java.lang.Integer.valueOf(Integer.java:554)
      at hive_offer_outcomes.__loadFromFields(hive_offer_outcomes.java:599)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              edwin ed
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: