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

Oozie Sqoop Error: Error during import: HBase jars are not present in classpath, cannot import to HBase!

Expert Contributor

I am unable to import into HBase using Oozie Sqoop. The command line works fine. Any one come across this?

16378 [main] INFO  org.apache.sqoop.orm.CompilationManager  - HADOOP_MAPRED_HOME is /usr/hdp/2.6.0.3-8/hadoop-mapreduce
2018-01-28 19:01:09,255 INFO  [main] orm.CompilationManager (CompilationManager.java:findHadoopJars(94)) - HADOOP_MAPRED_HOME is /usr/hdp/2.6.0.3-8/hadoop-mapreduce
18603 [main] INFO  org.apache.sqoop.orm.CompilationManager  - Writing jar file: /tmp/sqoop-yarn/compile/77d346afaacc732eba2256e5fcbbd275/QueryResult.jar
2018-01-28 19:01:11,480 INFO  [main] orm.CompilationManager (CompilationManager.java:jar(330)) - Writing jar file: /tmp/sqoop-yarn/compile/77d346afaacc732eba2256e5fcbbd275/QueryResult.jar
18617 [main] ERROR org.apache.sqoop.tool.ImportTool  - Error during import: HBase jars are not present in classpath, cannot import to HBase!
2018-01-28 19:01:11,494 ERROR [main] tool.ImportTool (ImportTool.java:run(621)) - Error during import: HBase jars are not present in classpath, cannot import to HBase!
Intercepting System.exit(1)

<<< Invocation of Main class completed <<<

Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

Oozie Launcher failed, finishing Hadoop job gracefully


2 REPLIES 2

@Joshua Adeleke,

Can you please run this command and check the output. If it is kerberized environment , run kinit before running the command

oozie admin -oozie http://{oozie-host}:11000/oozie -shareliblist

If the above command doesn't return output like below then run the below mentioned commands as well. Make sure that the below list is returned

[AvailableShareLib]
hive
distcp
mapreduce-streaming
spark
oozie
hcatalog
hive2
sqoop
pig
spark_orig

Create the share lib

# /usr/hdp/<HDP Version>/oozie/bin/oozie-setup.sh sharelib create -fs hdfs://${NAMENODE-HOST}:8020

Update Sharelib

# oozie admin -oozie http://{oozie-host}:11000/oozie -sharelibupdate

Thanks,

Aditya

Expert Contributor

Thanks @Aditya Sirna

I have checked using the sharelib command and error persists... I also ran the sharelibupdate command before relaunching...

oozie admin -oozie http://{oozie-server}:11000/oozie -shareliblist
[Available ShareLib]
hive
distcp
mapreduce-streaming
spark
oozie
hcatalog
hive2
sqoop
hbase
pig


oozie admin -oozie http://{oozie-server}:11000/oozie -sharelibupdate
[ShareLib update status]
        sharelibDirOld = hdfs://{name-node}:8020/user/oozie/share/lib/lib_20160610105311
        host = http://{oozie-server}:11000/oozie
        sharelibDirNew = hdfs://{name-node}:8020/user/oozie/share/lib/lib_20160610105311
        status = Successful