Configure Phoenix-Hive connector using Cloudera Manager

You must configure Phoenix-Hive connector before you can access Phoenix data from Hive.

Ensure that you have the phoenix-hive-version.jar. You can find this JAR file in the opt/cloudera/parcels/PHOENIX/lib/phoenix/ path on the Apache Phoenix node, or you can download it from the Cloudera respository.

To configure the Phoenix-Hive connector using Cloudera Manager:
  1. Go to the Hive service.
  2. Click the Configuration tab.
  3. Select Scope > Hive Cluster (Service-Wide).
  4. Select Category > Advanced.
  5. Locate the Hive Auxiliary JARs Directory property or search for it by typing its name in the Search box.
  6. Add the following auxiliary path directory: /usr/local/phoenix-hive.
  7. Locate the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml property or search for it by typing its name in the Search box.
  8. Add the following property values:

    Name: hive.aux.jars.path

    Value: file:///opt/cloudera/parcels/PHOENIX/lib/phoenix/phoenix-hive-VERSION-shaded.jar

  9. Select Scope > Gateway.
  10. Select Category > Advanced.
  11. Locate the Hive Client Advanced Configuration Snippet (Safety Valve) for hive-site.xml property or search for it by typing its name in the Search box.
  12. Add the following property values:

    Name: hive.aux.jars.path

    Value: file:///opt/cloudera/parcels/PHOENIX/lib/phoenix/phoenix-hive-[***VERSION-shaded.jar

  13. Enter a Reason for change, and then click Save Changes to commit the changes.
  14. Restart the role and service when Cloudera Manager prompts you to restart.