Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

Expert Contributor

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

@Ramya Marella

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

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.