How to create hive interpreter in Zeppelin 0.7?

[#1]

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.

[#2]

@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

[#3]

@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?

[#4]

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...

[#5]

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