Using Apache Phoenix to store and access data
Also available as:

Considerations for setting up Hive

Make phoenix-$VERSION-hive.jar available for Hive:

  • Add the phoenix-hive JAR to the HIVE_AUX_JARS_PATH variable in
    For HDP 3.0, you can add the following jar to the hive.aux.jars.path parameter as a comma-separated list. The exact file name for HDP-3.0 exists below, but please note that the version will be different for subsequent HDP 3.x.x releases.
  • Add a property to hive-site.xml so that Hive MapReduce jobs can also add the phoenix-hive jar to the classpath: