Orchestrating SQL and APIs with Apache Phoenix

You can use the standard JDBC APIs instead of the regular HBase client APIs to create tables, insert data, and query your HBase data.

Obtaining a driver for application development

Based on your application development requirements, you can obtain one of the following drivers:

JDBC driver

Use the /opt/cloudera/parcels/phoenix parcel/lib/phoenix/phoenix parcel-client.jar file in the Phoenix server-client repository. If you use the repository, download the JAR file corresponding to your installed CDH version.

JDBC driver as a Maven dependency

You can pull the CDH 5 artifacts from the Cloudera Maven repository from here: https://archive.cloudera.com/phoenix/5.16.2/maven-repository/. You can access the Maven repository using your Enterprise Support Subscription credentials.