oozie job is stucking on 95% in yarn when I submit the oozie job.

[#1]

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. final.pdf

[#2]

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 [2]

Oozie Launcher failed, finishing Hadoop job gracefully