Hi,

If you use annotation, Hive should be able to optimize it to single call:

 @UDFType(deterministic = true)

The obvious condition is that it must always return the identical result
when called with same parameters.

Little bit more on this can be found in Mark Grovers post at
http://mark.thegrovers.ca/1/post/2012/06/how-to-write-a-hive-udf.html.

Regards,
Jan
On Tue, Jul 23, 2013 at 9:25 PM, Nitin Pawar <[EMAIL PROTECTED]>wrote: