Apache Phoenix is a massively parallel relational database engine supporting OLTP for Hadoop with 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.
cp /usr/local/service/hbase/conf/hbase-site.xml Target path
To switch to a Hadoop user, use the Phoenix command line for Python:./sqlline.py
If the execution succeeds, the following result is displayed:
Was this page helpful?