Yeah - this works. I have been thinking for a while that we should have a .init type of file with some hive commands that are always executed before the session starts. (can add standard script files etc. into the environment as well)
________________________________ From: Zheng Shao [mailto:zsh...@gmail.com] Sent: Monday, February 23, 2009 10:51 PM To: hive-user@hadoop.apache.org Subject: Re: how to store UDFs in Hive system? I was thinking of both copying the jars and do "CREATE TEMP FUNCTION" for all UDFs that can be used in this session. This might be the easiest way for users to manager UDFs. If Hive takes over all UDF registration, then it might be a pain for users to upgrade the jars containing UDFs. Zheng On Mon, Feb 23, 2009 at 10:40 PM, Joydeep Sen Sarma <jssa...@facebook.com<mailto:jssa...@facebook.com>> wrote: My bad. Obviously this doesn't work (need to call registerudf) Zheng - what was ur idea here? (I think we should make this a little simpler - perhaps if the operator is not found in the registry - we can try to load a class with the same name and use that as fallback.) ________________________________ From: Joydeep Sen Sarma [mailto:jssa...@facebook.com<mailto:jssa...@facebook.com>] Sent: Monday, February 23, 2009 10:16 PM To: hive-user@hadoop.apache.org<mailto:hive-user@hadoop.apache.org> Subject: RE: how to store UDFs in Hive system? We already pick up all jars from auxlib/ (both for client side and execution). Also modifiable via -auxpath switch ________________________________ From: Zheng Shao [mailto:zsh...@gmail.com<mailto:zsh...@gmail.com>] Sent: Monday, February 23, 2009 8:29 PM To: hive-user@hadoop.apache.org<mailto:hive-user@hadoop.apache.org> Subject: Re: how to store UDFs in Hive system? Hi Min, Hive does not have that capability right now. The reason is that Hive does not copy the jars that contains user registered UDFs. However, if we can keep the jars at a safe place, it shouldn't be hard to modify hive client side (bin/hive) to load all the UDFs from the jars before the hive client side starts. Zheng On Mon, Feb 23, 2009 at 6:58 PM, Min Zhou <coderp...@gmail.com<mailto:coderp...@gmail.com>> wrote: Hi list, If we have many UDFs registered, does Hive have any mechanism that can automatically reload them when we restart Hive service or migrate Hive to another cluster? Thanks, Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. http://coderplay.javaeye.com -- Yours, Zheng -- Yours, Zheng