sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Invalid path
Date Thu, 06 Nov 2014 19:16:59 GMT
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
>
>
>
>
>

Mime
View raw message