Hi,
  I have a bunch of custom UDFs  and I d like the others in the company to make use of then in an easy way  .    Im not very happy  with the 'CREATE TEMPORARY FUNCTION' arrangement   for each session .   It d be great if our site-specific  functions  , work the sameway as the inbuilt functions.  What options do I have other than  modifying FunctionRegistry and recompiling ?
  
Sam William
[EMAIL PROTECTED]

On Dec 8, 2011, at 12:20 PM, Sam William wrote:

>  I have a bunch of custom UDFs  and I d like the others in the company to make use of then in an easy way  .    Im not very happy  with the 'CREATE TEMPORARY FUNCTION' arrangement   for each session .   It d be great if our site-specific  functions  , work the sameway as the inbuilt functions.  What options do I have other than  modifying FunctionRegistry and recompiling ?
Hey Sam,

At Facebook, we use a standard Hive init script to preload the temporary functions, using the CLI's -i option:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli

You could also take a look at the work I recently did on loading builtins from a separate jar using Hive's PDK.  If you want to work on an enhancement, it shouldn't be too hard to add a configuration option to preload additional jars and their functions using the same technique:

https://issues.apache.org/jira/browse/HIVE-2523

A real SQL/J implementation of persistent functions in the metastore would be preferable, but that's a lot of work.

JVS