On Tue, Aug 23, 2011 at 11:= 21 AM, Chinna Rao Lalam 72745 <chinnarao@huawei.com> wrote:

Hi Amit,

=A0Pls check this issue HIVE-1405 it will help u .This issue targeting sam= e scenario.

Thanks
Chinna Rao Lalam

> Hi Chinna,
> =A0 That worked, Thanks a lot. So once the jar is picked up, is
> there a way
> to create a temporary function, that is retained even if i quit the > interactive shell and start it again? =A0Or do i have to use the creat= e
> command to register the function everytime?
>
> Thanks.
> Amit
>
> On Mon, Aug 22, 2011 at 10:00 PM, Chinna <chinnarao@huawei.com> wrote:
>
> > =A0Hi,****
> >
> > =A0 ****
> >
> > =A0 U need to mention the jar like this,****
> >
> > ** **
> >
> > ~/Documents/workspace/Hive_0_7_1/build/dist/conf$grep aux hive- > site.xml>
> >
> <property><name>hive.aux.jars.path</name><value&g= t;/Users/amsharma/dev/Perforce/development/depot/dataeng/hive/dist> */{U= RJARNAME}.jar*</value></property>
> >
> > ****
> >
> > ** **
> >
> > =A0U r using CLI mode =A0so after changing the value if u start > shell that is
> > ok...and in another mode also we can start hive that is
> hiveserver this case
> > after changing the value u need to restart the hive server**** > >
> > ** **
> >
> > Thanks,****
> >
> > Chinna Rao Lalam****
> > =A0------------------------------
> >
> > *From:* Amit Sharma [mailto:amitsharma1708@gmail.com]
> > *Sent:* Tuesday, August 23, 2011 3:35 AM
> >
> > *To:* user@hive.apache.or= g
> > *Subject:* Re: Hive Custom UDF - "hive.aux.jars.path" n= ot
> working****>
> > ** **
> >
> > Hi Vaibhav,
> > =A0 Excuse my ignorance as im a little new to Hive. What do you > mean by
> > restart the Hive Server? I am using the Hive Interactive shell > for my work.
> > So i start the shell after modifying the config variable. Which > server do i
> > need to restart?
> >
> > Amit****
> >
> > On Mon, Aug 22, 2011 at 2:49 PM, Aggarwal, Vaibhav
> <vaggarw@amazon.com>&g= t; wrote:****
> >
> > Did you restart the hive server after modifying the hive-
> site.xml settings?
> > ****
> >
> > I think you need to restart the server to pick up the latest
> settings in
> > the config file.****
> >
> > =A0****
> >
> > Thanks****
> >
> > Vaibhav****
> >
> > =A0****
> >
> > *From:* Amit Sharma [mailto:amitsharma1708@gmail.com]
> > *Sent:* Monday, August 22, 2011 2:42 PM
> > *To:* user@hive.apache.or= g
> > *Subject:* Hive Custom UDF - "hive.aux.jars.path" not w= orking****
> >
> > =A0****
> >
> > Hi,
> > =A0 I build custom UDFS for hive and they seem to work fine when = i
> explicitly> register the jars using the "add jar <jarname&g= t;"
> command or put in in the
> > environment variable "HIVE_AUX_JARS_PATH". But if i add= it as a
> > configuration variable in the hive-site.xml file and try to
> register the
> > function using "create temporary function <functionname&g= t; as
> 'funciton' ", it
> > cannot find the jar. Any idea whats going on here?
> >
> > Here is the snippet from hive-site.xml:
> >
> > ~/Documents/workspace/Hive_0_7_1/build/dist/conf$grep aux hive- > site.xml>
> >
> <property><name>hive.aux.jars.path</name><value&g= t;/Users/amsharma/dev/Perforce/development/depot/dataeng/hive/dist</valu= e></property>>

> > Amit****
> >
> > ** **
> >
>