[SQOOP-2793] Hitting a Null Pointer Exception when executing an lastmodified incremental job to import a table into HBASE.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.5, 1.4.6
• Component/s: hbase-integration, tools
• Assignee: Unassigned
• Reporter: RyanTotti
• Created: 18/Jan/16 05:24
• Updated: 18/Jan/16 05:41

Description

Sqoop command sample:

sqoop job --create job3 -- import --connect --connect jdbc:mysql://mysqlserver:3306/test /
 --username root --password root /
 --query "SELECT ID as rowkey ,conf,created_time  FROM WF_ACTIONS WHERE \$CONDITIONS" /
 --columns rowkey,conf,created_time -m 1 /
 --hbase-table job3  --column-family info --hbase-row-key rowkey /
 --split-by ID --class-name job3  / 
 --check-column created_time --incremental lastmodified --last-value '2000-01-07 08:47:00' 

With exception:

ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
	at org.apache.hadoop.fs.FileSystem.fixRelativePart(FileSystem.java:2207)
	at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:1300)
	at org.apache.hadoop.fs.FileSystem.exists(FileSystem.java:1424)
	at org.apache.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:320)
	at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
	at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
	at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:228)
	at org.apache.sqoop.tool.JobTool.run(JobTool.java:283)
	at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
	at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
	at org.apache.sqoop.Sqoop.main(Sqoop.java:236)