Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

we are getting below error/exception while executing sqoop action via oozie ?

Solved Go to solution

we are getting below error/exception while executing sqoop action via oozie ?

New Contributor

img.pngwe are getting below error/exception while executing sqoop action via oozie .

Error - Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exception invoking main(), java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found

It seems some jars related to sqoop action not available on oozie share lib path i.e. “/user/oozie/share/lib/lib_20160807001458/sqoop”. We are getting access issues while trying to update the oozie share lib path with required jars.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: we are getting below error/exception while executing sqoop action via oozie ?

Guru

@kishore sanchina: You are getting permission issue because user(which you have used to login) does not have admin role on cluster. So please try with oozie user, you can do sudo to oozie.

sudo su - oozie

or

su oozie

2 REPLIES 2
Highlighted

Re: we are getting below error/exception while executing sqoop action via oozie ?

Guru

@kishore sanchina: You are getting permission issue because user(which you have used to login) does not have admin role on cluster. So please try with oozie user, you can do sudo to oozie.

sudo su - oozie

or

su oozie

Re: we are getting below error/exception while executing sqoop action via oozie ?

New Contributor

You are executing an oozie admin command, so you need to be using an oozie admin user. Usually 'oozie' user is configured as admin user in oozie You can take look at the 'adminusers.txt' file under oozie configuration. Once you switch to an oozie admin user, you should be able to update the oozie sharelib. 'sudo su - oozie'

The another error which you have mentioned regarding the 'java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found', I guess you did not specify the 'oozie.use.system.libpath=true' into your "job.properties" file. This should resolve both of your issues.

Note: If 'oozie.use.system.libpath=true' property was missing then just add it and submit/run the workflow, you need not to update the oozie share lib.