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 create hive interpreter in Zeppelin 0.7?

Highlighted

How to create hive interpreter in Zeppelin 0.7?

New Contributor

I've installed Zeppelin 0.7 and it doesn't have hive as an interpreter by default. In the website it suggested to use jdbc instead.

Should I create a new interpreter manually and name it hive with required parameter? Which group it should belong to? What would be the parameters?

I searched the Apache website and read instructions but couldn't get hive (%hql) up and running.

Any suggestion/links would be greatly appreciated.

4 REPLIES 4

Re: How to create hive interpreter in Zeppelin 0.7?

Expert Contributor

@Mehrdad Niasari

If the interpreter is not loaded by default try loading it dynamically. Have a look at http://zeppelin.apache.org/docs/0.7.0/manual/dynamicinterpreterload.html#load-unload-interpreters-us... and see if it helps.

Also found this related question -https://community.hortonworks.com/questions/51351/how-to-add-hive-to-zeppelin-in-hdp-25.html

Re: How to create hive interpreter in Zeppelin 0.7?

New Contributor

@pankaj singh Based on https://zeppelin.apache.org/docs/0.7.0/interpreter/hive.html hive interpreter will be deprecated. It's not in the list of interpreters any more at $ZEPPELIN_HOME/conf/interpreters-list.

If I want to add it manually, which jar files do I need?

Re: How to create hive interpreter in Zeppelin 0.7?

Expert Contributor

Not sure if you're using an HDP distribution with Zeppelin 0.7, but for HDP 2.5.x with Zeppelin 0.6 (supported) there's some info at

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_zeppelin-component-guide/content/using-jd...

Re: How to create hive interpreter in Zeppelin 0.7?

Please use %jdbc(hive) instead of %hql, it worked for me.