So if I have a web-client calling the Hive server, will step 1 & 2 need to be executed for every call as a sequence (that would be inconvenient). I really want this UDF to be available to every user of our web interface. They shouldn't need to know where the jar is. -Ayon See My Photos on Flickr Also check out my 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 11:38 PM Subject: RE: How to install UDF jar into Hive server 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 on Flickr Also check out my 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 on Flickr Also check out my Blog for answers to commonly asked questions.
