Can you send over your oozie job or sqoop command? On Fri, May 8, 2015 at 8:30 AM, Aravindakshan Srinivasan < [email protected]> 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. > > -------------------------------------------------------------------------------------------- > > > >
