Support Questions
Find answers, ask questions, and share your expertise

while transfering data from mysql to hive getting error as ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Cannot run program "hive": error=2, No such file or directory

New Contributor

hi I used the below code

sqoop import \ --connect jdbc:mysql://localhost:3306/sqoop \ --username root \ --password tiger \ --table customer -m 1 --hive-import

The error message screen shot isscreenshot-from-2017-11-09-072341.png

3 REPLIES 3

Re: while transfering data from mysql to hive getting error as ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Cannot run program "hive": error=2, No such file or directory

Expert Contributor

Please provide more information like job you are trying to run, services you using for import and specific log messages.

Re: while transfering data from mysql to hive getting error as ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Cannot run program "hive": error=2, No such file or directory

@Ramya Marella

I'm suspected that issue with either sqoop mysql driver or directory on hdfs

Re: while transfering data from mysql to hive getting error as ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Cannot run program "hive": error=2, No such file or directory

New Contributor

hi,

I used the below code

sqoop import \ --connect jdbc:mysql://localhost:3306/sqoop \ --username root \ --password tiger \ --table customer -m 1

--hive-import

the error message screenshot is screenshot-from-2017-11-09-072341.png