question Re: Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox in Archives of Support Questions (Read Only)

Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox

gkeys — Sat, 10 Sep 2016 04:35:15 GMT

In the 2.4 sandbox, Zeppelin interpreters include %hive and %phoenix (but not %jdbc) but in the 2.5 TP sandbox there is a %jdbc interpreter (but not %hive and %phoenix).

2.4 sandbox uses Zeppelin 0.6.0.2.5.0.0-817 whereas 2.5 sandbox uses Zeppelin 0.6.0.2.4.0.0-169.

Is this just the way Zeppelin 0.6.0 minor versions were packaged for the sandboxes? Or does the Zeppelin GA (which is 0.6.0) only use %jdbc. NOTE that in 2.5 sandbox I was able to create hive tables with %jdbc identically as creating them with %hive.

Re: Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox

lgeorge — Sat, 10 Sep 2016 04:41:40 GMT

HDP 2.5 only uses %jdbc. %jdbc(hive) is fully supported (see http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.0/bk_zeppelin-component-guide/content/zeppelin-with-hive.html), and I believe %jdbc(phoenix) is available as a technical preview.

Re: Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox

gkeys — Sat, 10 Sep 2016 04:47:42 GMT

@lgeorge Excellent. Thank you. I noticed also that 2.4 had %psql also but 2.5 did not. Thoughts or comments?

Re: Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox

lgeorge — Sun, 11 Sep 2016 06:39:21 GMT

@gkeys, oh--interesting. As far as I know, %psql is not supported for HDP 2.5.0; I'll doublecheck.

Re: Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox

lgeorge — Thu, 22 Sep 2016 02:15:57 GMT

@gkeys I confirmed that %psql is not supported at this time, and is not in plan for at least a few months.

Re: Zeppelin: %hive and %phoenix interpreters in 2.4 sandbox but only %jdbc in 2.5 sandbox

gkeys — Thu, 22 Sep 2016 08:41:41 GMT

Thank you for confirming.