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.


On Thu, Nov 6, 2014 at 10:44 AM, Felipe Naberezny Lopes <felipe.naberezny@b2wdigital.com> wrote:

Yes, this is Oozie + Sqoop via Hue.


The full sqoop command is:


Sqoop command arguments :






















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:abe@cloudera.com]
Enviada em: quinta-feira, 6 de novembro de 2014 16:06
Para: user@sqoop.apache.org
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.




On Thu, Nov 6, 2014 at 9:29 AM, Felipe Naberezny Lopes <felipe.naberezny@b2wdigital.com> wrote:



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.





Felipe Naberezny

B2W Digital / B2W Labs

+55 11 3454-3021 / +55 11 9 8561-8525




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