Sqoop should be creating a script that it runs against hive. Can you check that script or try running it yourself? It should be "hive-script-<some unique identifier>.txt" under "/tmp" or where ever "test.build.data" is pointing to. Feel free to post the contents of that script.
-Abe On Thu, Nov 6, 2014 at 10:44 AM, Felipe Naberezny Lopes < [email protected]> wrote: > Yes, this is Oozie + Sqoop via Hue. > > > > The full sqoop command is: > > > > Sqoop command arguments : > > import > > --direct > > -m > > 1 > > --verbose > > --connect > > jdbc:oracle:thin:@10.3.0.110:1528:BWRDWPR1 > > --username > > apptarkena > > --password > > apptarkena > > --table > > RDW12DM.CHAIN_QG > > --delete-target-dir > > --hive-database > > mds > > --hive-table > > DS_CHAIN_QG > > --hive-import > > --hive-overwrite > > > > I think the problem is with the quotes in the path. > > > > The path, in the log, is ‘’ path ‘’ ( the path is between two single > quotes ‘‘ <- 2 characters. Yes, it is two single quotes, not one double > quote, like this -> “ ). > > > > I don’t know why the command is that way and I don’t know how to fix it. > > > > > > *De:* Abraham Elmahrek [mailto:[email protected]] > *Enviada em:* quinta-feira, 6 de novembro de 2014 16:06 > *Para:* [email protected] > *Assunto:* Re: Invalid path > > > > Hey there, > > > > I'm assuming this is Oozie + Sqoop via Hue? > > > > Could you provide your full sqoop command? I'd check to see if > "hdfs://bwdhdbpr059.hadoop.b2wdigital:8020/user/hdfs/RDW12DM.CHAIN_QG" > exists. > > > > -Abe > > > > On Thu, Nov 6, 2014 at 9:29 AM, Felipe Naberezny Lopes < > [email protected]> wrote: > > Hi, > > > > Can anyone help me with the following error? > > > > 39552 [Thread-31] INFO org.apache.sqoop.hive.HiveImport - FAILED: > SemanticException Line 2:17 Invalid path > ''hdfs://bwdhdbpr059.hadoop.b2wdigital:8020/user/hdfs/RDW12DM.CHAIN_QG'' > > 39905 [main] ERROR org.apache.sqoop.tool.ImportTool - Encountered > IOException running import job: java.io.IOException: Hive exited with > status 64 > > > > I'm trying to run a sqoop workflow in Hue. > > > > 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 > > > > >
