Apache Phoenix is a SQL skin on top of HBase. Using Apache phoenix you are use HBase for OTLP operations (for example, serve HBase as a backend for a web application) . It supports RDBMS like schema design, secondary index, CRUD, and experimental atomic transactions across multiple tables.
In this article, let me explain how to get started with Phoenix.
Set JAVA_HOME to JDK 1.8
Download hbase binary
Download phoenix binary and copy necessary jars to $HBASE_HOME/lib
To verify that phoenix-5.0.0-HBase-2.0-server.jar and phoenix-core-5.0.0-HBase-2.0.jar are loaded to the HBase server, open jconsole and connect the JVM service.
Open SQL workbench and configure a new driver for phoenix-5.0.0-HBase-2.0-client.jar.
Now using the driver create a connection.
Test the connection and click OK. Run the following commands.