question Re: Adding hive auxiliary jar files in Archives of Support Questions (Read Only)

Adding hive auxiliary jar files

bandarusridhar1 — Fri, 08 Jul 2016 21:14:38 GMT

Hi,

In HIVE CLI we can directly add jar files to their session but in Beeline we need to have admin permissions to add the jar file to the session as we are using SQL Standard Based Hive Authorization.

1. What is the best way to grant privileges to Beeline users in order for them to add jars/files? We don't want to grant admin privileges to all beeline users.

2. Is there any best practices in regarding the use of adding jars from beeline?

Thanks in advance.

Re: Adding hive auxiliary jar files

sunile_manjee — Sat, 09 Jul 2016 00:04:55 GMT

@Sri Bandaru you can add the jars in hive.aux.jars.path=/path/to/jar

to add them to global location. then you don't need admin access.

Re: Adding hive auxiliary jar files

bandarusridhar1 — Sat, 09 Jul 2016 01:19:54 GMT

@Sunile Manjee

Thanks for the quick response. Is this the correct way?

mkdir /usr/hdp/current/hive-server2/auxlib/

copy required jars to /usr/hdp/current/hive-server2/auxlib/ loaction.

Added below property to hive-site.xml

<property>
  <name>hive.aux.jars.path</name>
  <value>/usr/hdp/current/hive-server2/auxlib/</value>
</property>

Re: Adding hive auxiliary jar files

sunile_manjee — Sat, 09 Jul 2016 02:26:48 GMT

@Sri Bandaru yes and then put your jars in that directory.

Re: Adding hive auxiliary jar files

bandarusridhar1 — Mon, 11 Jul 2016 22:07:39 GMT

@Sunile Manjee

Okay, Even after setting this property, still do I need to register jar files? Because I'm getting the same error even after setting the property.

Re: Adding hive auxiliary jar files

sunile_manjee — Tue, 12 Jul 2016 00:03:59 GMT

@Sri Bandaru add your jars to .hiverc file.

Re: Adding hive auxiliary jar files

bandarusridhar1 — Fri, 29 Jul 2016 09:14:10 GMT

@Sunile Manjee

What's the best way to give

hive.aux.jars.path=/path/to/jar
hive.aux.jars.path=file:///path/to/jar

If I give /path/to/jar will it check for hdfs or local filesystem?

Re: Adding hive auxiliary jar files

paulhernandez — Fri, 23 Feb 2018 23:23:43 GMT

Hhi @smanjee hi @Sridhar Reddy

I try to add the phoenix-hive.jar to hive permanently and general available for external applications but I don't know exactly how to do that with ambari.

I set the hive.aux.jars.path property in cusmto hive-site in abari to a location in hdfs to centrally reach the jars but it is not working.

If I create a auxlib folder in a node, then it works but only for this node.

Any comment will be appreciated.

Kind regards,

Paul