Configure User Impersonation for Access to Phoenix

This section describes how to configure Apache Zeppelin user impersonation for Apache Phoenix.

User impersonation runs Phoenix queries under the user ID associated with the Zeppelin session.

To enable user impersonation for Phoenix, complete the following steps in the Ambari dashboard:

  1. In the HBase configuration settings, enable phoenix sql.
  2. In Advanced HBase settings, set the following properties:
    hbase.thrift.support.proxyuser=true
    hbase.regionserver.thrift.http=true
  3. In HDFS configuration settings, set the following properties:
    hadoop.proxyuser.hbase.groups=*
    hadoop.proxyuser.hbase.hosts=*
    hadoop.proxyuser.zeppelin.groups=*
    hadoop.proxyuser.zeppelin.hosts=*
  4. Make sure that the user has access to HBase. You can verify this from the HBase shell with the user_permissions command.