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:
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.