Details
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)