Uploaded image for project: 'Zeppelin'
  1. Zeppelin
  2. ZEPPELIN-2911

Issues in running Hive-Hbase integrated table using Spark interpreter

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 0.6.0
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      HDP 2,5

      Description

      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?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jasimwhd Jasim Waheed Ansari
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: