How to add the Apache Phoenix Storage Handler for Hive to a HDP 2.5.3 Cluster

[#1]

Hi everyone,

I am trying to add the Apache Phoenix Storage Handler to our hdp 2.5.3 cluster following the directions I found hier:

Phoenix Storage Handler for Apache Hive

The problem is, I am working in a ambari managed cluster and I want to do it using ambari.

I created a folder auxlib in /usr/hdp/current/hive-server2/ but this only makes the jar available in the node where I created it.

I could potentially repeat this step for every node but I also want to access hive from clients outside the cluster.

I tried creating a property in the custom hive-site in ambari:

hive.aux.jars.path = hdfs:///hdp/apps/2.5.3.0-37/hive/auxjars/*        

But it did not work.

I also don't want to edit the jija template for the advanced hive-env section

Any comment will be appreciated.

Kind regards,

Paul

[#2]

@Paul Hernandez,

Hive Phoenix handler is not supported in HDP 2.5.3 version. It is available as a tech preview in HDP 2.6.2. Please check the below doc.

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.2/bk_release-notes/content/tech_previews.html

.

I guess HDP 2.5.3 should have Phoenix 4.7 version. The link which you have given shows Prerequisite as Phoenix 4.8.0+.

Thanks,

Aditya

[#3]

Hi @Aditya Sirna,

Thanks for your answer.

Independent of the Hive-Phoenix platform support I would like to know how to centrally add hive aux libs.

I am able to access the phoenix tables from the hive cli in two ways:

1. Running a "set hive.aux.jars.path=<jar location" in the cli
2. Adding a auxlib folder to hive

The problem with these 2 approaches is, the library is only available to the node or box where the cli is running. It does not work on hive ambari views or other clients/boxes.

Customization of the jinja template for hive-env seems to be extrem complicated for me and I will find a system engineer to do that.

I don't really know if it worth and we can just access the phoenix tables directly without hive.

Kind regards, Paul