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-env.sh.

  HIVE_AUX_JARS_PATH=[..],file:///usr/hdp/current/phoenix-client/phoenix-$VERSION-hive.jar

  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.

  file:///usr/hdp/current/phoenix-client/phoenix-5.0.0.3.0.0.0-1634-hive.jar

• Add a property to hive-site.xml so that Hive MapReduce jobs can also add the phoenix-hive jar to the classpath:

  
  <property>
  <name>hive.aux.jars.path</name>
  <value>file:///usr/hdp/current/phoenix-client/phoenix-$VERSION-hive.jar</value>
  </property>