Support Questions
Find answers, ask questions, and share your expertise

sqoop incremental import error

sqoop import --hbase-create-table --hbase-table test_remedy --column-family remedy_data --hbase-row-key INCIDENT_NUMBER --connect jdbc:oracle:thin:@//****.****.com:1521/rmd00p41 --driver oracle.jdbc.driver.OracleDriver --query "SQL QUERY" --incremental lastmodified --check-column LAST_MODFIED_DATE --last-value '10-SEP-18' -m 1 --username ********** --password "*******#"

Error

18/09/10 16:36:42 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-n9984593/compile/0545001f7504e4c60da4a897e26f0f3b/QueryResult.jar 18/09/10 16:36:43 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException java.lang.NullPointerException at org.apache.hadoop.fs.FileSystem.fixRelativePart(FileSystem.java:2254) at org.apache.hadoop.hdfs.DistributedFileSystem.fixRelativePart(DistributedFileSystem.java:2512) at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:1437) at org.apache.hadoop.fs.FileSystem.exists(FileSystem.java:1447) at org.apache.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:321) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:498) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.main(Sqoop.java:243)

1 REPLY 1

Re: sqoop incremental import error