Issue when trying to use --direct along with sqoop import statement


#1

Dear Team,

Was trying --direct along with sqoop import statement in our lab, was getting below error.
Need your support for resolution. Thanks in advance.

Understood that we have mysqldump in below path. Guess I don’t access to this program.
[rrajkumar9999@gw03 ~]$ which mysqldump
/bin/mysqldump

[rrajkumar9999@gw03 ~]$ ls -ltr /usr/bin/mysqldump
-rwxr-xr-x 1 root root 9796490 Dec 9 03:10 /usr/bin/mysqldump

18/03/28 02:15:51 INFO mapreduce.Job: Task Id : attempt_1520592249193_33181_m_000000_0, Status : FAILED
Error: java.io.IOException: Cannot run program “mysqldump”: error=2, No such file or directory

18/03/28 02:15:51 INFO mapreduce.Job: Task Id : attempt_1520592249193_33181_m_000003_0, Status : FAILED
Error: java.io.IOException: Cannot run program “mysqldump”: error=13, Permission denied

ERROR tool.ImportTool: Error during import: Import job failed!


#2

Direct path reads are not supported in the lab.