Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

sqoop incremental import error

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
Highlighted

Re: sqoop incremental import error

Don't have an account?
Coming from Hortonworks? Activate your account here