Oozie Hive2 Action Failed with Error: “HiveSQLException: Failed to execute session hooks”

If you have an Oozie Hive2 job that fails with below error message randomly, which can be found in Oozie’s server log, located by default under /var/log/oozie: 2018-06-02 09:00:01,103 WARN org.apache.oozie.action.hadoop.Hive2Credentials: SERVER[hlp3058p.oocl.com] USER[dmsa_appln] GROUP[-] TOKEN[] APP[DMSA_CMTX_PCON_ETL_ONLY] JOB[0010548-180302135253124-oozie-oozi-W] ACTION[0010548-180302135253124-oozie-oozi-W@spark-6799] Exception in addtoJobConf org.apache.hive.service.cli.HiveSQLException: Failed to execute session hooks at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:241) at …