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
HIVE_AUX_JARS_PATH=[..],file:///usr/hdp/current/phoenix-client/phoenix-$VERSION-hive.jarFor 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
<property> <name>hive.aux.jars.path</name> <value>file:///usr/hdp/current/phoenix-client/phoenix-$VERSION-hive.jar</value> </property>