2. Configuring Phoenix to Run in a Secure Cluster

To configure Phoenix to run in a secure Hadoop cluster, set HBASE_CONF_PATH as follows:


For example:

export HBASE_CONF_PATH=/etc/hbase/conf

Alternately, you can use the pre-2.2 method:

  1. Link the HBase configuration file with the Phoenix libraries:

    ln -sf <HBASE_CONFIG_DIR>/hbase-site.xml /usr/hdp/current/phoenix-client/bin/hbase-site.xml

  2. Link the Hadoop configuration file with the Phoenix libraries:

    ln -sf <HADOOP_CONFIG_DIR>/core-site.xml /usr/hdp/current/phoenix-client/bin/core-site.xml


When running the pssql.py and sqlline.py Phoenix scripts in secure mode, you can safely ignore the following warnings:

14/04/19 00:56:24 WARN util.NativeCodeLoader: Unable to load native- hadoop library for your platform... using builtin-java classes where applicable 14/04/19 00:56:24 WARN util.DynamicClassLoader: Failed to identify the fs of dir hdfs://<HOSTNAME>:8020/apps/hbase/data/lib, ignoredjava.io.IOException: No FileSystem for scheme: hdfs

loading table of contents...