|I am trying to do
automation through oozie over hive. For that I wrote a below given hive query
INSERT OVERWRITE LOCAL DIRECTORY '/tmp/hivefinal' SELECT * FROM gourav1;
Here, gourav1 table is already created inside hive.
When I am submitting oozie job. Oozie application goes to running mode and doesn't execute. Although I checked the yarn application list, were job was hanged on 95%.Please check the attached workflow.xml, script.q, workflow.xml.security and job.properties. I am also attaching the logs screenshot ,hive-site.xml, oozie-site.xml and yarn-site.xml with this post. Please let me know how to resolve this problem. Thanks in Advance.
This problem has been resolved by inserting the SET mapreduce.job.reduces=1.But now i am getting different error i.e
.<<< Invocation of Main class completed <<<
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.Hive2Main], exit code  Oozie Launcher failed, finishing Hadoop job gracefully