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 > > --
