[ https://issues.apache.org/jira/browse/SQOOP-1048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13661969#comment-13661969 ]
Jarek Jarcec Cecho commented on SQOOP-1048: ------------------------------------------- I'm expecting that the proper format will be further defined by SQOOP-777 (once fully implemented), however I'm +1 for immediate solution. > Sqoop2: NPE when importing NULL value > -------------------------------------- > > Key: SQOOP-1048 > URL: https://issues.apache.org/jira/browse/SQOOP-1048 > Project: Sqoop > Issue Type: Bug > Affects Versions: 1.99.2 > Environment: Mysql DB > Reporter: Vasanth kumar RJ > Assignee: Vasanth kumar RJ > Fix For: 1.99.3 > > Attachments: SQOOP-1048.patch > > > Throws NullPointerException when column value is NULL, since result set > return null object. > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs during > extractor run > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:94) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:370) > at org.apache.hadoop.mapred.Child$4.run(Child.java:255) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121) > at org.apache.hadoop.mapred.Child.main(Child.java:249) > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > write to the data writer > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:142) > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeArrayRecord(SqoopMapper.java:124) > at > org.apache.sqoop.connector.jdbc.GenericJdbcImportExtractor.extract(GenericJdbcImportExtractor.java:60) > at > org.apache.sqoop.connector.jdbc.GenericJdbcImportExtractor.extract(GenericJdbcImportExtractor.java:31) > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:89) > ... 7 more > Caused by: java.lang.NullPointerException > at org.apache.sqoop.job.io.Data.hashCode(Data.java:140) > at > org.apache.hadoop.mapreduce.lib.partition.HashPartitioner.getPartition(HashPartitioner.java:29) > at > org.apache.hadoop.mapred.MapTask$NewOutputCollector.write(MapTask.java:691) > at > org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80) > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:140) > ... 11 more -- 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