Issues in running Hive-Hbase integrated table using Spark interpreter

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?