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
