Thanks Jasper - much appreciated! On Tue, Jun 26, 2012 at 10:27 PM, Jasper Knulst <jasper.knu...@incentro.com>wrote:
> Hi Denny, > > I asked the same question a few days ago and got this reference to another > question: > > "If you want to make your temporary function permanent , you have to patch > hive source code. Please refer to this discussion > > http://mail-archives.apache.org/mod_mbox/hive-user/201101.mbox/%3caanlktimbx1rskkwqi1pnnhrjkgc9cjurun_be8yoy...@mail.gmail.com%3E > " > > > 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. > > > Jasper > > > > > 2012/6/27 Denny Lee <denny.g....@gmail.com> > >> 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 >> >> > > > -- >
