Orchestrating SQL and APIs with Apache Phoenix

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

The following drivers are currently supported:

  • JDBC driver
  • Microsoft .Net driver
  • Other non-Java drivers (example, Python driver)

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 6 artifacts from the Cloudera Maven repository from here: https://archive.cloudera.com/phoenix/6.2/maven-repository/. You can access the Maven repository using your Enterprise Support Subscription credentials.

Microsoft .NET Driver

Download and install a NuGet package for Microsoft .NET Driver for Apache Phoenix. for more information, see https://www.nuget.org/packages/Microsoft.Phoenix.Client/.

Other non-Java drivers

Other non-JDBC Drivers for Phoenix are available as CDH add-ons and on other websites, but they are not currently supported by Cloudera. You can find compatible client drivers by constructing a web search string consisting of "avatica" and the name of an application programming language that you want to use. Example: avatica python.

For more information about obtaining drivers for your application development, see http://phoenix.apache.org/faq.html.