How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

[#1]

We enabled Hive LLAP through Ambari and are able to execute queries from beeline interface. Is it possible to run hive LLAP queries from Zeppelin ? Please let us know how to connect from Zeppelin [%??]

[#2 · Accepted solution]

Hi @Ramanathan Ramaiyah,

To execute the LLAP queries from Zeppelin you need to configure the interpreter.

For ex: If you want to connect using jdbc, under jdbc interpreter section add the following parameters

hive_interactive.url = <can be obtained from ambari. check HiveServer2 Interactive JDBC URL>
hive_interactive.driver = org.apache.hive.jdbc.HiveDriver
hive_interactive.user = <user>
hive_interactive.password = <pwd>

In your zeppelin paragraph, use %jdbc(hive_interactive). Hope this helps.

Thanks,

Aditya

[#3]

Before reading this post, I tried official document and failed.

https://zeppelin.apache.org/docs/0.7.0/interpreter/hive.html

Then I found my problem - I should set the correct properties with interpreter name.