You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Felipe Naberezny Lopes <fe...@b2wdigital.com> on 2014/11/06 18:29:30 UTC
Invalid path
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<ma...@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
RES: Invalid path
Posted by Felipe Naberezny Lopes <fe...@b2wdigital.com>.
I’m not finding the script. Is it in hdfs directory or on a local machine?
De: Abraham Elmahrek [mailto:abe@cloudera.com]
Enviada em: quinta-feira, 6 de novembro de 2014 17:17
Para: user@sqoop.apache.org
Assunto: Re: Invalid path
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 <fe...@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<ma...@cloudera.com>]
Enviada em: quinta-feira, 6 de novembro de 2014 16:06
Para: user@sqoop.apache.org<ma...@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 <fe...@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<tel:%2B55%2011%203454-3021> / +55 11 9 8561-8525
felipe.naberezny@b2wdigital.com<ma...@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
Re: Invalid path
Posted by Abraham Elmahrek <ab...@cloudera.com>.
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
>
>
>
>
>
RES: Invalid path
Posted by Felipe Naberezny Lopes <fe...@b2wdigital.com>.
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 <fe...@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<tel:%2B55%2011%203454-3021> / +55 11 9 8561-8525
felipe.naberezny@b2wdigital.com<ma...@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
Re: Invalid path
Posted by Abraham Elmahrek <ab...@cloudera.com>.
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
>
>
>