uring insert into hive hbase table the vertex is failing classnotfoundexception,could anybody guide where to add jar to avoid this exception

[#1]

Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.hbase.HiveHFileOutputFormat at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.apache.hive.com.esotericsoftware.kryo.util.DefaultClassResolver.readName(DefaultClassResolver.java:136)

[#2 · Accepted solution]

try adding these jars in hive aux jars or at session level using add jar option and see if it helps

hive-hbase-handler-*.jar

hbase-client-*.jar

ADD JAR /usr/hdp/current/hive-client/lib/hive-hbase-handler-*.jar;

ADD JAR /usr/hdp/2.3.2.0-2950/hbase/lib/hbase-client-*.jar ;