sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Oozie + Sqoop + MySql UPSERT
Date Fri, 08 May 2015 17:06:45 GMT
Can you send over your oozie job or sqoop command?

On Fri, May 8, 2015 at 8:30 AM, Aravindakshan Srinivasan <
s_aravind@yahoo.com> wrote:

> Friends,
>
> I have an odd problem. I am trying to run an MySql upsert via Sqoop. It
> works fine from the edge node that has Sqoop 1.4.5 installed. When I try to
> run via Oozie, I get this error.
>
> org.apache.sqoop.tool.ExportTool - Error during export: Mixed
> update/insert is not supported against the target database
>
> This feature is available in the newer versions of Sqoop starting with
> Sqoop 1.4.3, which is what my Oozie sharelib contains. Still, my first
> reaction was that the Sqoop jars in Oozie's sharelib are different and
> hence throwing this error. As you know, the Sqoop via Oozie runs on the
> Hadoop compute nodes. I tried copying the Sqoop jars from my edge node to
> the workflow/lib dir. It still didn't work.
>
>
>
> Since then, I have tried everything I can think of, but can't get past
> this error. I have even rebuilt the Oozie sharelib with Sqoop 1.4.5 and
> tried both  oozie.libpath and oozie.action.sharelib.for.sqoop pointing to
> my rebuilt lib. Still no luck. What am I missing?
>
> Thanks,
> Aravind
>
>
> --------------------------------------------------------------------------------------------
> Aravind Srinivasan
>
> http://goodcynicsports.blogspot.com
>
> I have decided to stick with love. Hate is too great a burden to bear.
> - MLK, Jr.
>
> --------------------------------------------------------------------------------------------
>
>
>
>

Mime
View raw message