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/18.104.22.168-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.
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.
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+.
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:
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