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

Sqoop HsqldbJobStorage class not found error

Explorer

I get this error after running a sqoop job in Hsqldb metastore.

From logs, the map reduce job is getting through. But, looks like incremental value is not getting updated in the metastore.db.script.

Please advice on how to resolve this error.

 

                Bytes Read=0
        File Output Format Counters
                Bytes Written=879432
20/06/01 13:39:38 INFO mapreduce.ImportJobBase: Transferred 858.8203 KB in 56.22 seconds (15.2761 KB/sec)
20/06/01 13:39:38 INFO mapreduce.ImportJobBase: Retrieved 3901 records.
20/06/01 13:39:38 INFO util.AppendUtils: Appending to directory aec_inbound_details
20/06/01 13:39:38 INFO util.AppendUtils: Using found partition 2976
20/06/01 13:39:38 INFO tool.ImportTool: Saving incremental import state to the metastore
20/06/01 13:39:38 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class com.cloudera.sqoop.metastore.hsqldb.HsqldbJobStorage not found
java.lang.RuntimeException: java.lang.ClassNotFoundException: Class com.cloudera.sqoop.metastore.hsqldb.HsqldbJobStorage not found
        at org.apache.hadoop.conf.Configuration.getClasses(Configuration.java:2484)
        at org.apache.sqoop.config.ConfigurationHelper.getInstances(ConfigurationHelper.java:201)
        at org.apache.sqoop.metastore.JobStorageFactory.getJobStorage(JobStorageFactory.java:62)
        at org.apache.sqoop.tool.ImportTool.saveIncrementalState(ImportTool.java:172)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:552)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:633)
        at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:248)
        at org.apache.sqoop.tool.JobTool.run(JobTool.java:303)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:146)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:182)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:233)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:242)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:251)
Caused by: java.lang.ClassNotFoundException: Class com.cloudera.sqoop.metastore.hsqldb.HsqldbJobStorage not found
        at org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:2409)
        at org.apache.hadoop.conf.Configuration.getClasses(Configuration.java:2480)
        ... 13 more

 

 

Thanks

0 REPLIES 0