hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jasper Knulst <>
Subject Re: Making UDFs "permanent"
Date Wed, 27 Jun 2012 05:27:58 GMT
Hi Denny,

I asked the same question a few days ago and got this reference to another

"If you want to make your temporary function permanent , you have to patch
hive source code. Please refer to this discussion

So you are right, the only way seems to be to rebuild hive-exec-* yourself.

I solved the issue temporarily by invoking a hive script ( with hive -i
'/path/to/hive-init.sql')  command that does the repetitive commands for
me. When you create a nix alias (alias hive='hive -i
"/path/to/hive_init.sql" ') for it it works fine for me.


2012/6/27 Denny Lee <>

> We have a scenario where we want to make a UDF permanent so that way a
> query through the HiveODBC driver will be able to access the UDF.  I seem
> to recall that after creating the UDF, you can make it "permanent" by
> adding it into the Function Registry.
> But it seems that I also need to rebuild the hive-exec-*.jar and bundle my
> UDF within it. Is this actually a necessary step or is it possible to
> register my UDFs and make them permanent?
> Thanks!
> Denny


View raw message