Cloudera Docs

Enabling the Phoenix SQL editor in Cloudera Data Explorer (Hue)

To query Apache HBase tables from Hue using Phoenix SQL, configure the Phoenix interpreter settings in the Hue Advanced Configuration Snippet.

Add {USER} to the HBASE (cm_hbase) Ranger policy that governs access to all tables, columns, column-family, and so on. Grant {USER} the required permissions such as read, write, create, execute, admin, and so on.

  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue > Configuration and add the following lines in the Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini field: 
    [notebook]
[[interpreters]]
[[[phoenix]]]
name=phoenix
interface=sqlalchemy
options='{"url": "phoenix://[***PHOENIX-URL***]:[***PHOENIX-PORT***]"}'
  3. Click Save Changes.
  4. Restart the Hue service.