Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-2793

Hitting a Null Pointer Exception when executing an lastmodified incremental job to import a table into HBASE.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.5, 1.4.6
    • Fix Version/s: None
    • Component/s: hbase-integration, tools
    • Labels:
      None

      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)
      

        Attachments

        1. SQOOP-2793.patch
          0.7 kB
          RyanTotti

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ryantotti RyanTotti
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: