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.

Running Sqoop using Oozie

Highlighted

Running Sqoop using Oozie

New Contributor

I've been getting this error and unable to identify the root cause. I've tried copying the jar file to the libpath as specified in the error log below "user/root/lib" but no luck. I run the exact same command in the shell and it works fine. It only fails when using Oozie.

Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

Any guidance ? Thanks!

Error Log:

2018-10-07 05:35:05,066  WARN SqoopActionExecutor:523 - SERVER[sandbox-hdp.hortonworks.com] USER[admin] GROUP[-] TOKEN[] APP[TestWorkflow] JOB[0000441-180930024054767-oozie-oozi-W] ACTION[0000441-180930024054767-oozie-oozi-W@sqoop_truncate] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
2018-10-07 05:52:56,279  WARN ParameterVerifier:523 - SERVER[sandbox-hdp.hortonworks.com] USER[admin] GROUP[-] TOKEN[] APP[TestWorkflow] JOB[0000441-180930024054767-oozie-oozi-W] ACTION[] The application does not define formal parameters in its XML definition
2018-10-07 05:52:56,291  WARN LiteWorkflowAppService:523 - SERVER[sandbox-hdp.hortonworks.com] USER[admin] GROUP[-] TOKEN[] APP[TestWorkflow] JOB[0000441-180930024054767-oozie-oozi-W] ACTION[] libpath [hdfs://sandbox-hdp.hortonworks.com:8020/user/root/lib] does not exist
2018-10-07 05:54:08,671  WARN SqoopActionExecutor:523 - SERVER[sandbox-hdp.hortonworks.com] USER[admin] GROUP[-] TOKEN[] APP[TestWorkflow] JOB[0000441-180930024054767-oozie-oozi-W] ACTION[0000441-180930024054767-oozie-oozi-W@sqoop_truncate] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
2018-10-07 05:59:37,381  WARN ParameterVerifier:523 - SERVER[sandbox-hdp.hortonworks.com] USER[admin] GROUP[-] TOKEN[] APP[TestWorkflow] JOB[0000441-180930024054767-oozie-oozi-W] ACTION[] The application does not define formal parameters in its XML definition
2018-10-07 06:00:58,772  WARN SqoopActionExecutor:523 - SERVER[sandbox-hdp.hortonworks.com] USER[admin] GROUP[-] TOKEN[] APP[TestWorkflow] JOB[0000441-180930024054767-oozie-oozi-W] ACTION[0000441-180930024054767-oozie-oozi-W@sqoop_truncate] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]