hive auxillary jars

[#1]

I want to use a few jars for executing some hive queries. I can do this by adding those jars in the beeline session. But is there a way of doing it permanently by specifying the HIVE_AUX_JARS. If so how can i do it in ambari. Also do these jars need to be present in all the nodes of the cluster?

I am using ambari 2.2.1

[#2]

@ARUNKUMAR RAMASAMY add a custom hive-site.xml properties with the name of hive.aux.jars.path if it is not available and add your jars file:///home/user/xyz.jar

[#3 · Accepted solution]

@ARUNKUMAR RAMASAMY

The jars need to be present on the Hiveserver machine. It is not necessary to have them on all the nodes.

You can refer to below link:

http://stackoverflow.com/questions/31802908/adding-hive-jars-permanently/31808016

Thanks and Regards,

Sindhu