The oraoop jar needs to be in hdfs for oozie to run I believe. Please copy the oraoop jar to hdfs and give that path to oozie conf.
On Thu, Sep 18, 2014 at 2:32 PM, Felipe Naberezny Lopes < [email protected]> wrote: > Without Oozie the plugin works and the Oraoop jar is in the Oozie share > lib. > > I'm not using a Cloudera distribution for Hadoop. > > Maybe that is the problem. I don't know anything else to check. > > -----Mensagem original----- > De: Gwen Shapira [mailto:[email protected]] > Enviada em: quinta-feira, 18 de setembro de 2014 15:25 > Para: [email protected] > Assunto: Re: Sqoop with Oozie > > Also, does everything work without Oozie? > > On Thu, Sep 18, 2014 at 11:24 AM, Gwen Shapira <[email protected]> > wrote: > > Do you have the Oraoop jar in Oozie's share lib path? > > > > On Thu, Sep 18, 2014 at 10:46 AM, Felipe Naberezny Lopes > > <[email protected]> wrote: > >> Gwen, > >> > >> It's throwing the same exception: > >> > >> 4569 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Got error > >> creating database manager: java.lang.ClassCastException: > >> com.quest.oraoop.OracleConnectionFactory cannot be cast to > >> com.cloudera.sqoop.manager.ManagerFactory > >> > >> -----Mensagem original----- > >> De: Gwen Shapira [mailto:[email protected]] Enviada em: > >> quinta-feira, 18 de setembro de 2014 14:32 > >> Para: [email protected] > >> Assunto: Re: Sqoop with Oozie > >> > >> I believe you need to add this: > >> > >> import -D > >> sqoop.connection.factories=com.cloudera.sqoop.manager.DefaultManagerF > >> actory,com.quest.oraoop.OraOopManagerFactory > >> > >> On Thu, Sep 18, 2014 at 10:30 AM, Felipe Naberezny Lopes < > [email protected]> wrote: > >>> The plugin is QuestDataConnector for Oracle and Hadoop. The plugin > >>> is a connection manager between Oracle and Hadoop. > >>> > >>> > >>> > >>> When I install it in my Sqoop Client Machine, it stays in > >>> SQOOP_HOME/conf/managers.d > >>> > >>> > >>> > >>> I’m trying to make Oozie use the plugin. > >>> > >>> > >>> > >>> The jars are in my Hadoop cluster. > >>> > >>> > >>> > >>> I set the property “sqoop.connection.factories “ with the path to > >>> the jars of plugin. > >>> > >>> > >>> > >>> Apparently, Oozie is using that configuration, but it’s throwing the > >>> given > >>> error: > >>> > >>> > >>> > >>> “ 5542 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Got error > >>> creating database manager: java.lang.ClassCastException: > >>> com.quest.oraoop.OracleConnectionFactory cannot be cast to > >>> com.cloudera.sqoop.manager.ManagerFactory “ > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> De: pratik khadloya [mailto:[email protected]] Enviada em: > >>> quinta-feira, 18 de setembro de 2014 14:15 > >>> > >>> > >>> Para: [email protected] > >>> Assunto: Re: Sqoop with Oozie > >>> > >>> > >>> > >>> Can you share the plugin name and what error (with stack trace) you > >>> are getting? > >>> > >>> > >>> > >>> ~Pratik > >>> > >>> > >>> > >>> On Thu, Sep 18, 2014 at 10:04 AM, Felipe Naberezny Lopes > >>> <[email protected]> wrote: > >>> > >>> I'm connecting Sqoop with Oracle. > >>> > >>> There is a plugin made by Toad that improve the performance of data > import. > >>> > >>> I'm trying to use it, but I don't know how to make Oozie use that > plugin. > >>> > >>> You know something that solves this? > >>> > >>> -----Mensagem original----- > >>> De: Gwen Shapira [mailto:[email protected]] Enviada em: > >>> quinta-feira, 18 de setembro de 2014 13:55 > >>> Para: [email protected] > >>> Assunto: Re: Sqoop with Oozie > >>> > >>> > >>> We typically don't configure SQOOP_CONF_DIR for Oozie. Rather, we > >>> make sure the list of parameters we include in the Sqoop action > >>> includes all the relevant configurations. > >>> > >>> Gwen > >>> > >>> 2014-09-18 7:18 GMT-07:00 Felipe Naberezny Lopes > >>> <[email protected]>: > >>>> Hi, > >>>> > >>>> > >>>> > >>>> How do I set SQOOP_CONF_DIR using Oozie? > >>>> > >>>> > >>>> > >>>> Any idea? > >>>> > >>>> > >>>> > >>>> Tks > >>>> > >>>> > >>>> > >>>> Felipe Naberezny > >>>> > >>>> B2W Digital / B2W Labs > >>>> > >>>> +55 11 3454-3021 / +55 11 9 8561-8525 > >>>> > >>>> [email protected] > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> ________________________________ > >>>> > >>>> Esta mensagem pode conter informações confidenciais e somente o > >>>> indivíduo ou entidade a quem foi destinada pode utilizá-la. A > >>>> transmissão incorreta da mensagem não acarreta a perda de sua > >>>> confidencialidade. Caso esta mensagem tenha sido recebida por > >>>> engano, solicitamos que o fato seja comunicado ao remetente e que a > >>>> mensagem seja eliminada de seu sistema imediatamente. É vedado a > >>>> qualquer pessoa que não seja o destinatário usar, revelar, > >>>> distribuir ou copiar qualquer parte desta mensagem. Ambiente de > >>>> comunicação sujeito a monitoramento. > >>>> > >>>> This message may include confidential information and only the > >>>> intended addresses have the right to use it as is, or any part of it. > >>>> A wrong transmission does not break its confidentiality. If you've > >>>> received it because of a mistake or erroneous transmission, please > >>>> notify the sender and delete it from your system immediately. This > >>>> communication environment is controlled and monitored. > >>>> > >>>> B2W Digital > >>>> > >>>> > >>> > >>> ________________________________ > >>> Esta mensagem pode conter informações confidenciais e somente o > >>> indivíduo ou entidade a quem foi destinada pode utilizá-la. A > >>> transmissão incorreta da mensagem não acarreta a perda de sua > >>> confidencialidade. Caso esta mensagem tenha sido recebida por > >>> engano, solicitamos que o fato seja comunicado ao remetente e que a > >>> mensagem seja eliminada de seu sistema imediatamente. É vedado a > >>> qualquer pessoa que não seja o destinatário usar, revelar, > >>> distribuir ou copiar qualquer parte desta mensagem. Ambiente de > comunicação sujeito a monitoramento. > >>> > >>> This message may include confidential information and only the > >>> intended addresses have the right to use it as is, or any part of it. > >>> A wrong transmission does not break its confidentiality. If you've > >>> received it because of a mistake or erroneous transmission, please > >>> notify the sender and delete it from your system immediately. This > >>> communication environment is controlled and monitored. > >>> > >>> B2W Digital > >>> > >>> > >> > >> ________________________________ > >> Esta mensagem pode conter informações confidenciais e somente o > indivíduo ou entidade a quem foi destinada pode utilizá-la. A transmissão > incorreta da mensagem não acarreta a perda de sua confidencialidade. Caso > esta mensagem tenha sido recebida por engano, solicitamos que o fato seja > comunicado ao remetente e que a mensagem seja eliminada de seu sistema > imediatamente. É vedado a qualquer pessoa que não seja o destinatário usar, > revelar, distribuir ou copiar qualquer parte desta mensagem. Ambiente de > comunicação sujeito a monitoramento. > >> > >> This message may include confidential information and only the intended > addresses have the right to use it as is, or any part of it. A wrong > transmission does not break its confidentiality. If you've received it > because of a mistake or erroneous transmission, please notify the sender > and delete it from your system immediately. This communication environment > is controlled and monitored. > >> > >> B2W Digital > >> >
