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 access phoenix data from zepplein

Highlighted

how to access phoenix data from zepplein

New Contributor

I am having my phoenix data in one of the cluster and I want to access using zepplein.

5 REPLIES 5

Re: how to access phoenix data from zepplein

@PAVAN KUMAR JALLA

You can refer to this example notebook here

https://www.zeppelinhub.com/viewer/notebooks/aHR0cHM6Ly9yYXcuZ2l0aHVidXNlcmNvbnRlbnQuY29tL2hvcnRvbnd...

just replace %phoenix with %jdbc(phoenix)

HDP Zeppelin comes with jdbc(phoenix) interpreter for you to use

Re: how to access phoenix data from zepplein

Expert Contributor

@PAVAN KUMAR JALLA, you can use the %jdbc interpreter to access Phoenix in HDP 2.6 and 2.5; use %jdbc(phoenix). Basics (without Kerberos) are similar to instructions for %jdbc(hive), at

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

Re: how to access phoenix data from zepplein

Super Guru

%jdbc(phoenix)

select weather, temperature_string, dewpoint_string, feelslike_string, latitude, longitude, observation_time, precip_today_string, relative_humidity, temp_c, temp_f, visibility_mi, wind_dir, wind_mph, wind_string from current_observation order by observation_time desc

Re: how to access phoenix data from zepplein

Expert Contributor

Also, the following info is for enabling user impersonation with %jdbc(phoenix):

Make sure following the following configs are set up;

  • In HBase, ensure that these three settings exist (if not, then add):       enable phoenix sql       In advance setting:       hbase.thrift.support.proxyuser=true       hbase.regionserver.thrift.http=true
  • in HDFS config, ensure that these configs are set:    hadoop.proxyuser.hbase.groups=*    hadoop.proxyuser.hbase.hosts=*    hadoop.proxyuser.zeppelin.groups=*    hadoop.proxyuser.zeppelin.hosts=*

Make sure the user has access to HBase, which can be verified from "hbase shell", and then running a command like user_permissions.

Re: how to access phoenix data from zepplein

Super Collaborator

Try to search HCC for zeppelin and phoenix keywords. Most of the problems with configuration and common issues were previously covered here. For example you may need to update libraries in zeppelin configuration to get it working with Phoenix:

Zeppelin with Phoenix on HDP

Don't have an account?
Coming from Hortonworks? Activate your account here