I’m not finding the script. Is it in hdfs directory or on a local machine?
De: Abraham Elmahrek [mailto:[email protected]] Enviada em: quinta-feira, 6 de novembro de 2014 17:17 Para: [email protected] 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 <[email protected]<mailto:[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]<mailto:[email protected]>] Enviada em: quinta-feira, 6 de novembro de 2014 16:06 Para: [email protected]<mailto:[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]<mailto:[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<tel:%2B55%2011%203454-3021> / +55 11 9 8561-8525 [email protected]<mailto:[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
