Sqoop job fails when try to run using oozie, it works well using command line.
Error as below :
2018-07-16 11:19:07,280 WARN ShellActionExecutor:523 - SERVER[Server_hostname] USER[asif] GROUP[-] TOKEN APP[auto_ingest] JOB[0000007-180713182341268-oozie-oozi-W] ACTION[0000007-180713182341268-oozie-oozi-W@shell_2] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.ShellMain], exit code 
When your job has failed in oozie, you need to click through the oozie work flow manager and get into the YARN/MR logs. In my experience it is about 3-4 clicks deep to find the full logs. When you get to those logs, you will find the exact errors you need to resolve to allow your sqoop command to operate from oozie. Sometimes there is just a slight difference between the CLI command and the one that oozie needs.