Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

Solved Go to solution

How to execute HIVE LLAP queries from Zeppelin in HDP 2.6.1

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

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

2 REPLIES 2

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

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

Highlighted

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

Cloudera Employee

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.