AnsweredAssumed Answered

NullPonterException running sqoop

Question asked by terrys on May 2, 2013
Latest reply on May 3, 2013 by dave_kincaid
On the latest version of sqoop (1.4.2) and MapR (2.1.2), we are receiving a NullPointerException when trying to show or execute saved jobs.  Digging further, it appears numerous config options are being added to the metastore.db.script file with null values.

I also came across this thread yesterday (, which seems to imply that MapR 2.1.x introduced a change which may be causing sqoop to read default values incorrectly and storing them in the metastore?  Note I tried previous versions of MapR, and was finally able to build a working setup using 2.0.0, which further validates my theory above.

Is there a change I need to make to allow sqoop to function properly again?

Here is some output to help troubleshoot.

        [mapr@aws-maprdev1 ~]$ sqoop job --show transaction-import
    Warning: /opt/mapr/hbase/hbase-0.92.2-mapr does not exist! HBase imports will fail.
    Please set $HBASE_HOME to the root of your HBase installation.
    13/05/03 13:14:17 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
            at java.util.Hashtable.put(
            at java.util.Properties.setProperty(
            at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.getV0Properties(
            at org.apache.sqoop.tool.JobTool.showJob(
            at org.apache.sqoop.Sqoop.runSqoop(
            at org.apache.sqoop.Sqoop.runTool(
            at org.apache.sqoop.Sqoop.runTool(
            at org.apache.sqoop.Sqoop.main(
            at com.cloudera.sqoop.Sqoop.main(

Some of then entries in metastore.db.script that I'm questioning:

        INSERT INTO SQOOP_SESSIONS VALUES('transaction-import','fs.s3.sleepTimeSeconds',NULL,'config')
        INSERT INTO SQOOP_SESSIONS VALUES('transaction-import','',NULL,'config')