question Re: Oozie sqoop job failing in Support Questions

Oozie sqoop job failing

agareta — Tue, 10 May 2016 01:01:53 GMT

Hi,

I am successfully able to do sqoop action from shell. But not able to do with oozie. I have read several question in hortonworks that states need to add mysql jar in oozie/lib. I have added that too.. but still no success.

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

My workflow.xml looks like

<action name="sqoop-action">
   <sqoop xmlns="uri:oozie:sqoop-action:0.2">
      <job-tracker>${jobTracker}</job-tracker>
      <name-node>${nameNode}</name-node>
      <prepare>
         <delete path="${deleteHdfsPath}"/>
      </prepare>
      <configuration>
         <property>
            <name>oozie.hive.defaults</name>
            <value>/usr/hdp/current/hive-client/conf/hive-site.xml</value>
         </property>
      </configuration>
      <command>${command}</command>
      <archive>mysql-connector-java.jar#mysql-connector-java.jar</archive>
   </sqoop>
   <ok to="hive-action" />
   <error to="kill" />
</action>oozielog.zip

I am attaching my log file as well Can anybody help me ?

Re: Oozie sqoop job failing

pminovic — Tue, 10 May 2016 08:01:27 GMT

Your sqoop command begins with "sqoop":

No such sqoop tool: sqoop. See 'sqoop help'.Intercepting System.exit(1)

Remove "sqoop" from the command, it should start with "import", and retry.

Re: Oozie sqoop job failing

agareta — Tue, 10 May 2016 15:18:07 GMT

Thanks, It was a silly mistake.

Re: Oozie sqoop job failing

pminovic — Tue, 10 May 2016 15:26:48 GMT

No problems, it can happen to the best of us. Also glad to hear that it worked for your, because many people have been having troubles with Oozie Sqoop actions recently. By the way, for me it worked without specifying "archive" in the workflow file, I just uploaded mysql-connector jar to Oozie Sqoop share lib. Happy sqooping!