Support Questions

Find answers, ask questions, and share your expertise

Zeppelin unable to interact with table from Hive-Hbase handler

zeppelin-hive-hbase-handler.png

Hello,

I am using Zeppelin to analyze the table that I created using Hive-Hbase handler. However, when I execute, it gives handler.org.apache.hadoop.hive.hbase.HBaseStorageHandler. I tried it with HiveContext as someone pointed out in one of the threads. But, result is the same.

What would be the workaround for this?

Thanks

[Update] I also tried re-updating hive-site.xml with the following property in hive folder, but still the same problem.

Just to verify, I also cross checked in beeline and hive cli , the query works perfectly fine in them.
Could someone possibly help me with this issue in Zeppelin?

<property><name>hive.aux.jars.path</name><value>file:///usr/hdp/2.5.3.0-37/hive/lib/zookeeper-3.4.6.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hive/lib/hive-hbase-handler-1.2.1000.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hive/lib/guava-14.0.1.jar,file:///usr/hdp/2.5.3.0-37/hbase/lib/hbase-client-1.1.2.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hbase/lib/hbase-common-1.1.2.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hbase/lib/hbase-protocol-1.1.2.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hbase/lib/hbase-server-1.1.2.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hbase/lib/hbase-shell-1.1.2.2.5.3.0-37.jar,file:///usr/hdp/2.5.3.0-37/hbase/lib/hbase-thrift-1.1.2.2.5.3.0-37.jar
    </value></property> 

38511-zeppelin-hive-hbase-handler.png

1 REPLY 1

New Contributor

hi @Jasim Waheed Ansari, did you find any solution for this?