question oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found in Archives of Support Questions (Read Only)

oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

sim6 — Mon, 02 May 2016 14:14:02 GMT

I have an oozie task that uses sqoop.

/user/oozie folder has /shared/lib/lib_xyz/ fodler which has the sqoop folder and relevant jars in it.

My job.properties looks like this:

nameNode=hdfs://serverFQDN:8020
jobTracker=serverFQDN:8050
queueName=default
oozie.use.system.libpath=true
oozie.action.sharelib.for.sqoop=hive,hcatalog,sqoop
ozie.libpath=hdfs://serverFQDN:8020/user/oozie/share/lib
oozie.coord.application.path=${nameNode}/user/${user.name}/scheduledimport
start=2016-04-26T00:00Z
end=2016-12-31T00:00Z
workflowAppUri=${nameNode}/user/${user.name}/scheduledimport

I get an error on sqoop task:

java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

How do I fix this?

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

RyanCicak — Tue, 03 May 2016 02:52:14 GMT

Hi @simran kaur

This error is indicating that the jars are not available through the classpath. Are you submitting using oozie.use.system.libpath=true? Could you post the launcher log?

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

ajay_kumar — Tue, 03 May 2016 06:07:06 GMT

Hi @simran kaur

Change ozie.libpath=hdfs://serverFQDN:8020/user/oozie/share/lib to

ozie.libpath=hdfs://serverFQDN:8020/user/oozie/shared/lib as you mentioned your oozie lib is under /user/oozie/shared/lib dir.

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

sim6 — Tue, 03 May 2016 11:32:06 GMT

@Ajay:No, No. Shared was a typo. It's in share/lib only

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

sim6 — Tue, 03 May 2016 19:00:09 GMT

@Ryan Cicak : Which file would be launcher logs? submitting using oozie.use.system.libpath=true? I do have it in my job.properties file if that is what you were asking? I did check the job logs and could not find sqoopMain exception is all that it gets in there.

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

quadoss — Thu, 12 May 2016 23:07:09 GMT

@simran kaur, it seems like this is a duplicate of the post https://community.hortonworks.com/questions/30437/error-in-oozie-class-orgapacheoozieactionhadoopsqo.html#answer-33008 where you were able to get past the issue. If you do, please update the solution here and close this thread.

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

sim6 — Fri, 13 May 2016 11:17:04 GMT

Not really. I had to do a fresh reinstall.

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

rahulammo — Fri, 24 Feb 2017 17:12:58 GMT

@simran kaur Is the issue is solved for you? I am getting the same error (java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found)

Can somebody please help.

Re: oozie task with sqoop : java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

aervits — Fri, 24 Feb 2017 19:47:57 GMT

Please post as new question and supply relevant logs and configs