Hi,
For example u have an UDF jar like lower.jar (Here u have the implementation for the lower function) in /home/myjars location. if it is Hive CLI or Hive Server or web client... what mode u r using there u need to execute the following queries 1. You need to add the jar to Hive class path for this u can execute this query add jar '/home/myjars/lower.jar'; 2. U need to create the function using this query create temporary fucntion my_lower as 'com.example.hive.udf.Lower'; then u r function is ready now u can use the function like select my_lower(title) from titles -Chinna Rao Lalam _____ From: Ayon Sinha [mailto:ayonsi...@yahoo.com] Sent: Wednesday, August 03, 2011 10:50 AM To: user@hive.apache.org Subject: Re: How to install UDF jar into Hive server Thanks Chinna. Unfortunately this doesn't say how to install it such that the HiveServer is able to use this jar. Examples in this wiki link does it all in the Hive CLI. -Ayon See My Photos <http://www.flickr.com/photos/ayonsinha/> on Flickr Also check out my <http://dailyadvisor.blogspot.com> Blog for answers to commonly asked questions. _____ From: Chinna <chinna...@huawei.com> To: user@hive.apache.org; 'Ayon Sinha' <ayonsi...@yahoo.com> Sent: Tuesday, August 2, 2011 9:22 PM Subject: RE: How to install UDF jar into Hive server Hi, In the below link this section " creating custom UDFs" will help u ... https://cwiki.apache.org/confluence/display/Hive/HivePlugins - Chinna Rao Lalam _____ From: Ayon Sinha [mailto:ayonsi...@yahoo.com] Sent: Wednesday, August 03, 2011 9:09 AM To: Hive Mailinglist Subject: How to install UDF jar into Hive server Hi, I have UDF jar that I need to install so that the Hive web clients can execute that function. Can someone point me to the doc that describes it? -Ayon See My Photos <http://www.flickr.com/photos/ayonsinha/> on Flickr Also check out my Blog <http://dailyadvisor.blogspot.com> for answers to commonly asked questions.
