Re: Where are jars stored for permanent functions

[dhruv kapatel]

In order to add it permanently recommended ways are as follows.

   1.

   add in hive-site.xml

hive.aux.jars.path
   file://localpath/yourjar.jar 
   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>

Re: Where are jars stored for permanent functions

[Jason Dere]

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

[http://marketing-email-assets.handybook.com/smalllogo.png]