question How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1 in Archives of Support Questions (Read Only)

How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

ramanathan_ram1 — Wed, 20 Sep 2017 17:38:26 GMT

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 [%??]

Re: How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

asirna — Thu, 21 Sep 2017 00:50:46 GMT

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

Re: How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

zzeng — Wed, 21 Mar 2018 20:31:20 GMT

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.