Hive Internal Error: java.lang.ClassNotFoundException(org.apache.atlas.hive.hook.HiveHook)

Basically this error is due to missing atlas jar in oozie share lib.In HDP the Atlas jar is available in /usr/hdp/2.3.0.0-2557/atlas/Put all the jars related to atlas in hadoop share lib ..

hadoop fs -put /usr/hdp/2.3.0.0-2557/atlas/hook/hive/* /user/oozie/share/lib/lib200344/hive 

Add 'export HIVE_AUX_JARS_PATH=<atlas package>/hook/hive' in hive-env.sh .
Copy <atlas package>/conf/application.propertiesto hive conf directory.

Restart the oozie services. This will solve this problem. If anybody face the problem please comment here so that I can help.

[Comment by Immo Huneke: when using the Hortonworks sandbox VM, I found that just putting the jar files in the share/lib folder under HDFS was enough to resolve the problem. I didn't have to update hive-env.sh or copy the application.properties file. But check the exact path of your share/lib folder by executing the command hdfs dfs -ls /user/oozie/share/lib before copying.]

hive>add jar /usr/hdp//atlas/hook/hive/hive-bridge-${VERSION}.jar

it will be ok.

hope help for u.

It Seems You CLASS is not found exception.

Have you installed Oozie Sharedlib, if Yes, please update all the hive dependent Jar in the sharedLib Location, and check if the status

Also check if Hive Client is available in all the Nodes under the cluster and same should be running