We have shell script(psql.sh) which executes psql query(script.sql). It works perfectly fine when i run directly run like `sh psql.sh`. But when i add the same to oozie workflow inside shell-action. It is not recognizing the psql command.
Running a psql script using shell action would need the psql command to be available on all the NodeManagers and the user launching the oozie job, needs to be able to launch the psql command across the NM's.
Can you check to see if psql is available across all the NM's?
Also, it would be great if you can also post in the exception that you are seeing from the oozie launcher job for this shell action as shell action would be executed inside the oozie launcher.