Sqoop needs hive/hive libs to execute a hive "LOAD" statement. I'd make sure you hive installed on the same machine Sqoop is running. Also, make sure you've set HIVE_HOME appropriately as well as per: http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_importing_data_into_hive .
On Mon, Jul 20, 2015 at 6:42 PM, Lee S <[email protected]> wrote: > Hi all: > I try to import data from mysql to hive in another computer not on the > same cluster where hive installed. > And I programmed with java to submit sqoop job with SqoopOptions and > ImportTool, but encountered an exception as below. > Data was successfully transferred to hdfs. The job is submitted > successfully, > but loading into hive failed. And I read the code of HiveImport, it seems > to > find hive in the computer I run the programme not on the clusters, any > idea? > or can I set hive_home as a remote uri? > > ERROR org.apache.sqoop.tool.ImportTool - Encountered IOException running > import job: java.io.IOException: Cannot run program "hive": error=2, No > such file or directory > at java.lang.ProcessBuilder.start(ProcessBuilder.java:1047) > at java.lang.Runtime.exec(Runtime.java:617) > at java.lang.Runtime.exec(Runtime.java:528) > at org.apache.sqoop.util.Executor.exec(Executor.java:76) > at > org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:382) > at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:335) > at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:239) > at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:425) > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:506) > at Sqoop.main(Sqoop.java:22) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at com.intellij.rt.execution.application.AppMain.main(AppMain.java:140) >
