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 <felipe.naberezny@b2wdigital.com> 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: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.

 

-Abe

 

On Thu, Nov 6, 2014 at 9:29 AM, Felipe Naberezny Lopes <felipe.naberezny@b2wdigital.com> 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

felipe.naberezny@b2wdigital.com

 

 


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