Thanks again for the info! On Thu, Apr 23, 2015 at 8:30 PM, sadhana yr <[email protected]> wrote:
> For global configuration add the statements to $HIVE_HOME/bin/.hiverc. > > One other alternative, > > Add following property to your hive-site.xml > > <property> > <name>hive.aux.jars.path</name> > > <value>file:///home/me/my.jar,file:///home/you/your.jar,file:///home/us/our.jar</value> > </property> > > > > > On Thu, Apr 23, 2015 at 11:13 PM, Buntu Dev <[email protected]> wrote: > >> Thanks but is there a way to make it available to other users and avoid >> 'add jar <jar>' step? >> >> On Thu, Apr 23, 2015 at 7:50 PM, Sadhana <[email protected]> wrote: >> >>> Yes, functions declared will only be available in the current session. >>> You will have to add the JAR to the class path and create the function in >>> each session. >>> If you use the same Jar files and functions frequently, you can add >>> those statements to your $HOME/.hiverc file. >>> >>> >>> > On Apr 23, 2015, at 10:37 PM, Buntu Dev <[email protected]> wrote: >>> > >>> > Does the JAR need to be added for every session before using the >>> custom UDF created using "CREATE FUNCTION"? >>> > >>> > I'm using Hive 0.13 and was able to add a custom UDF successfully and >>> use it in a sample query. But in the subsequent Hive sessions, I do see the >>> function but I get this error when using the function: >>> > >>> > FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function >>> 'my_func' >>> > >>> > Thanks for the help! >>> >> >> > > > -- > Sadhana > [email protected] > 408-837-2419 >
