[SQOOP-3015] nullpointException

• Type: Wish
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.99.4
• Component/s: connectors

Environment

hadoop 2.6.0
sqoop2 1.99.4

• Assignee: Unassigned
• Reporter: yb
• Created: 29/Sep/16 03:21
• Updated: 29/Sep/16 03:21

Description

i use sqoop2 export data from hdfs to mysql
while some data is null in HDFS
and i use command like this "start job -jid 2"
i got exception like this
Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot write to the data writer
at org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeContent(SqoopMapper.java:148)
at org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeStringRecord(SqoopMapper.java:128)
at org.apache.sqoop.connector.hdfs.HdfsExtractor.extractTextFile(HdfsExtractor.java:170)
at org.apache.sqoop.connector.hdfs.HdfsExtractor.extractFile(HdfsExtractor.java:82)
at org.apache.sqoop.connector.hdfs.HdfsExtractor.extract(HdfsExtractor.java:65)
at org.apache.sqoop.connector.hdfs.HdfsExtractor.extract(HdfsExtractor.java:45)
at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:94)
... 7 more
Caused by: java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:453)
at java.lang.Long.valueOf(Long.java:540)
at org.apache.sqoop.connector.idf.CSVIntermediateDataFormat.getObjectData(CSVIntermediateDataFormat.java:206)
at org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeContent(SqoopMapper.java:143)
... 13 more

i know i can resolve this by change source code
can i resolve this NPE by other ways