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

Running Sqoop using Oozie

Running Sqoop using Oozie

Explorer

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]