How to add Hive to Zeppelin in HDP 2.5

[#1]

Hi! I have gotten the HDP 2.5 Sandbox. I am trying to use Zeppelin but I see that a lot of interpreters that were "included" in HDP 2.4 are not available anymore.

How does one add a hive interpreter to Zeppelin?

[#2]

I believe hive interpreter support in 2.5 is removed but yes it was present in 2.4.

2.4 was based on apache zeppelin 0.5.6 and hive was supported: https://github.com/apache/zeppelin/tree/branch-0.5.6/hive

2.5 is based on apache zeppelin 0.6 and hive is not supported here: https://github.com/apache/zeppelin/tree/branch-0.6

[#3]

I see, @vkumar . Thanks!

[#4 · Accepted solution]

Use the jdbc interpreter

https://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html#hive

It can be used for Hive and Phoenix.

[#5]

Thanks a lot @Timothy Spann ! I will check it up 🙂

[#6]

let me know if it works! It worked for me.