In order to add it permanently recommended ways are as follows.
1.
add in hive-site.xml
<property> <name>hive.aux.jars.path</name>
<value>file://localpath/yourjar.jar</value> </property>
2.
Copy and paste the JAR file to the ${HIVE_HOME}/auxlib/ folder (create
it if it does not exist).
Source: Apache hive essentials book
On 10 June 2016 at 02:20, Jason Dere <jd...@hortonworks.com> wrote:
> Hive doesn't currently handle storing of the JARs. Doing ADD JAR only
> adds the jars to the current session, but won't help for other sessions.
>
> The permanent functions syntax allows you to specify JAR paths when you
> create the function. These should be on HDFS or other non-local path.
>
>
> create function ST_GeomFromWKT as 'com.esri.hadoop.hive.ST_GeomFromWKT'
> using jar 'hdfs:/path/to/spatial-sdk-hive-1.1.jar', jar 'hdfs:/path/to/
> esri-geometry-api-1.2.1.jar';
>
>
> ------------------------------
> *From:* Marcin Tustin <mtus...@handybook.com>
> *Sent:* Wednesday, June 08, 2016 1:10 PM
> *To:* user@hive.apache.org
> *Subject:* Where are jars stored for permanent functions
>
> Hi All,
>
> I just added local jars to my hive session, created permanent functions,
> and find that they are available across sessions and machines. This is of
> course excellent, but I'm wondering where those jars are being stored? What
> setting or what default directory would I find them in.
>
> My session was:
>
> add jars /mnt/storage/spatial-sdk-hive-1.1.jar
> /mnt/storage/esri-geometry-api-1.2.1.jar;
>
> create function ST_GeomFromWKT as 'com.esri.hadoop.hive.ST_GeomFromWKT';
>
>
> Then that function was available via the thriftserver.
>
>
> Thanks,
>
> Marcin
>
> Want to work at Handy? Check out our culture deck and open roles
> <http://www.handy.com/careers>
> Latest news <http://www.handy.com/press> at Handy
> Handy just raised $50m
> <http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/>
> led
> by Fidelity
>
>
--
*With Regards:Kapatel Dhruv vmobile:+919909214243*
<https://www.facebook.com/kapateldhruv> <https://twitter.com/kapatel_dhruv>
<https://www.linkedin.com/in/kapateldhruv>
<https://plus.google.com/u/0/107663824071419377609/posts>
<http://stackoverflow.com/users/2016271/dhruv>
<https://github.com/kapateldhruv>
