Phoenix Client Environment Preparation

Last updated: 2019-07-26 17:47:04

PDF

Apache Phoenix is a massively parallel relational database engine supporting OLTP for Hadoop using Apache HBase as its backing store. Phoenix compiles simple queries in just milliseconds and queries millions of rows of data in seconds. By default, Phoenix is enabled for EMR clusters included HBase component.

Phoenix version 4.8.1 is compiled in EMR environment. First, download phoenix-4.8.1-HBase-1.2 client.

  • Download Phoenix client

  • To prepare the environment for the client, copy and decompress the downloaded package to any directory in any node of the EMR cluster (preferably the Hadoop home directory), then enter the Hbin directory and copy the HBase configuration file Hbase-site.xml to the following directory:

      cp /usr/local/service/hbase/conf/hbase-site.xml 

To switch to a Hadoop user, use Phoenix command lines for Python :

./sqlline.py

Once the environment for client is prepared, you will see the message on the screen:

Configuration success