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)
