Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - Sqoop to Hive Import


Copy link to this message
-
Re: Sqoop to Hive Import
Cyril Bogus 2013-02-19, 18:38
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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>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
>