Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Trying to create phoenix interpreter using %jdbc in Zeppelin using 2.5

avatar
Guru

I am trying to create phoenix interpreter using %jdbc in Zeppelin using 2.5 and am not succeeding.

Steps are:

  1. Log into Zeppelin (sandbox 2.5)
  2. Create new interpreter as follows

    7540-screen-shot-2016-09-12-at-52103-pm.png

  3. restart (just to be paranoid)
  4. go to my notebook and bind interpreter

    7541-screen-shot-2016-09-12-at-54305-pm.png

  5. when I run with %jdbc(phoenix) I get Prefix not found.
  6. when I run it with %jdbc.phoenix I get jdbc.phoenix interpreter not found

What am I missing?

1 ACCEPTED SOLUTION

avatar

Hi, @gkeys, following the RedShift example here, the properties in your JDBC interpreter settings would be phoenix.user, phoenix.driver, phoenix.url, instead. Since you have modified the "default" prefix, does the plain "%jdbc" not work for the interpreter setting?

View solution in original post

4 REPLIES 4

avatar

Hi, @gkeys, following the RedShift example here, the properties in your JDBC interpreter settings would be phoenix.user, phoenix.driver, phoenix.url, instead. Since you have modified the "default" prefix, does the plain "%jdbc" not work for the interpreter setting?

avatar
Guru

@Randy Gelhausen

Thanks. What threw me off is that when creating a new jdbc interpretter (at least in sandbox) it is prepopulutated with default prefix properties and psql values.. Did not know that entire property and value needed to be deleted and recreated with new prefix (vs only new values).

avatar
Master Guru

I just installed HDP 2.5 from Ambari on a small openstack cluster choosing Zeppelin from ambari.

%jdbc(phoenix)

select * from phillycrime limit 100

worked for me.

Try to restart the jdbc interpreter

Make sure you have:

under:

jdbc %jdbc (default)

edit restart remove

Option

shared Interpreter for note

Connect to existing process

phoenix.driver org.apache.phoenix.jdbc.PhoenixDriver

phoenix.hbase.client.retries.number 1

phoenix.password

phoenix.url jdbc:phoenix:192.168.1.100:/hbase-unsecure

phoenix.user phoenixuser

avatar
Guru

@Timothy Spann very effective answer, but similar information as @Randy Gelhausen and he was first in.