I have created a hbase table via hive-hbase storagehandler. I would like to run some reports on it via hive table in Zeppelin. I am using spark interpreter's HiveContext for the same. But while executing my result, I get the following error
"error in loading storage handler.org.apache.hadoop.hive.hbase.HBaseStorageHandler".
I tried various ways out to make it work but unfortunately, none of them could resolve it. Following are the different ways I tried -
1. I added the classpath in /etc/zeppelin/conf/zeppelin-env.sh with EXPORT ZEPPELIN_INTP_CLASSPATH_OVERRIDES as /etc/hive/conf
(my hive-site.xml is updated with hive.aux.jars.path with value pointing to folder containing all the needed jars)
2. Added the hardcoded maven repository's dependency "org.spark-project.hive:hive-hbase-handler:1.2.1.spark" using Dependencies section for Spark interpreter in Zeppelin UI.
3. Created a Hive view on the table. And then tried executing using HiveContext
4. Tried adding all the relevant jars (zookeeper, hive-hbase-handler, guava, hbase-client, hbase-common, hbase-protocol, hbase-server, hbase-shell, hbase-thrift needed) in local file path for JDBC inteperpreter as dependecies.
None of the ways worked for me. Is there any way out to resolve this issue?