Hi,
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. <action name='shell1'>
<shell xmlns="uri:oozie:shell-action:0.1">
<job-tracker>${jobTracker}</job-tracker>
<name-node>${nameNode}</name-node>
<configuration>
<property>
<name>mapred.job.queue.name</name>
<value>default</value>
</property>
</configuration>
<exec>psql.sh</exec>
<file>${wf_path}/psql.sh</file>
<file>${sharedlib}/postgresql-42.2.1.jar</file>
<file>${wf_path}/script.sql</file>
</shell>
<ok to="end" />
<error to="fail" />
</action> Please suggest me what i should do here. My problem is ->i have to run some update queries (will be placed in hdfs path) to postgre db through oozie
... View more
