Created 05-09-2017 09:09 PM
I am having my phoenix data in one of the cluster and I want to access using zepplein.
Created 05-09-2017 09:14 PM
You can refer to this example notebook here
just replace %phoenix with %jdbc(phoenix)
HDP Zeppelin comes with jdbc(phoenix) interpreter for you to use
Created 05-09-2017 09:18 PM
@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
Created 05-09-2017 09:20 PM
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
Created 05-09-2017 09:43 PM
Also, the following info is for enabling user impersonation with %jdbc(phoenix):
Make sure following the following configs are set up;
Make sure the user has access to HBase, which can be verified from "hbase shell", and then running a command like user_permissions.
Created 05-10-2017 07:18 PM
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: