I am having my phoenix data in one of the cluster and I want to access using zepplein.
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
@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
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
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.
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: