You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by Cyril Bogus <cy...@gmail.com> on 2013/02/19 18:25:01 UTC

Sqoop to Hive Import

Hi,

I am trying to import a table from another computer to my hive using the
command --hive-import --hive-overwrite.
I am running Hadoop 1.0.4, sqoop 1.4.1_hadoop-1.0.0, and Hive 0.8.0

Problem is during the process I get the following error:

13/02/19 12:01:08 ERROR tool.ImportTool: Encountered IOException running
import job: java.io.IOException: Cannot run program "hive":
java.io.IOException: error=2, No such file or directory
    at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
    at java.lang.Runtime.exec(Runtime.java:593)
    at java.lang.Runtime.exec(Runtime.java:509)
    at org.apache.sqoop.util.Executor.exec(Executor.java:76)
    at
org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:361)
    at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:314)
    at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:226)
    at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:415)
    at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
    at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
    at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
    at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
    at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
    at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
Caused by: java.io.IOException: java.io.IOException: error=2, No such file
or directory
    at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
    at java.lang.ProcessImpl.start(ProcessImpl.java:65)
    at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
    ... 15 more

Thank you in advance for the reply

Re: Sqoop to Hive Import

Posted by Cyril Bogus <cy...@gmail.com>.

 Hi Vasanth,

Thank you for the reply,

You were right! Although I setup the class path to add Hive_home, I did the
export Hive_home you did within sqoop's directory and the import went as
intended.
Thank you for the help.


On Tue, Feb 19, 2013 at 1:03 PM, vasanth kumar <rj...@gmail.com>wrote:

> Hi Cyril,
>
> HIVE_HOME path is incorrect or not set. Set the HIVE_HOME path again.
>
> $export HIVE_HOME=*/HIVEHOME
>
> *
> Thanks,
> Vasanth kumar
>
>
> On Tue, Feb 19, 2013 at 10:55 PM, Cyril Bogus <cy...@gmail.com>wrote:
>
>> Hi,
>>
>> I am trying to import a table from another computer to my hive using the
>> command --hive-import --hive-overwrite.
>> I am running Hadoop 1.0.4, sqoop 1.4.1_hadoop-1.0.0, and Hive 0.8.0
>>
>> Problem is during the process I get the following error:
>>
>> 13/02/19 12:01:08 ERROR tool.ImportTool: Encountered IOException running
>> import job: java.io.IOException: Cannot run program "hive":
>> java.io.IOException: error=2, No such file or directory
>>     at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
>>     at java.lang.Runtime.exec(Runtime.java:593)
>>     at java.lang.Runtime.exec(Runtime.java:509)
>>     at org.apache.sqoop.util.Executor.exec(Executor.java:76)
>>     at
>> org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:361)
>>     at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:314)
>>     at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:226)
>>     at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:415)
>>     at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
>>     at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
>>     at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>>     at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
>>     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
>>     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
>>     at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
>>     at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
>> Caused by: java.io.IOException: java.io.IOException: error=2, No such
>> file or directory
>>     at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
>>     at java.lang.ProcessImpl.start(ProcessImpl.java:65)
>>     at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
>>     ... 15 more
>>
>> Thank you in advance for the reply
>>
>
>
>
> --
> Regards
> Vasanth kumar RJ
>

Re: Sqoop to Hive Import

Posted by vasanth kumar <rj...@gmail.com>.

Hi Cyril,

HIVE_HOME path is incorrect or not set. Set the HIVE_HOME path again.

$export HIVE_HOME=*/HIVEHOME

*
Thanks,
Vasanth kumar


On Tue, Feb 19, 2013 at 10:55 PM, Cyril Bogus <cy...@gmail.com> wrote:

> Hi,
>
> I am trying to import a table from another computer to my hive using the
> command --hive-import --hive-overwrite.
> I am running Hadoop 1.0.4, sqoop 1.4.1_hadoop-1.0.0, and Hive 0.8.0
>
> Problem is during the process I get the following error:
>
> 13/02/19 12:01:08 ERROR tool.ImportTool: Encountered IOException running
> import job: java.io.IOException: Cannot run program "hive":
> java.io.IOException: error=2, No such file or directory
>     at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
>     at java.lang.Runtime.exec(Runtime.java:593)
>     at java.lang.Runtime.exec(Runtime.java:509)
>     at org.apache.sqoop.util.Executor.exec(Executor.java:76)
>     at
> org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:361)
>     at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:314)
>     at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:226)
>     at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:415)
>     at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
>     at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
>     at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>     at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
>     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
>     at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
>     at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
>     at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
> Caused by: java.io.IOException: java.io.IOException: error=2, No such file
> or directory
>     at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
>     at java.lang.ProcessImpl.start(ProcessImpl.java:65)
>     at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
>     ... 15 more
>
> Thank you in advance for the reply
>



-- 
Regards
Vasanth kumar RJ