Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Calling same UDF multiple times in a SELECT query

Copy link to this message
Re: Calling same UDF multiple times in a SELECT query
fucntion return values are not stored for repeat use of same (as per my

I know you may have already thought about other approach as

select a , if (call <-1, -1 call) as b from (select a, fooudf(a) as call
from table
On Wed, Jul 24, 2013 at 12:42 AM, Sanjay Subramanian <

>  Hi
>  V r using version hive-exec-0.9.0-cdh4.1.2 in production
>  I need to check and use the output from a UDF in a query to assign
> values to 2 columns in a SELECT query
>  Example
>      a,
>      IF(fooUdf(a) < -1  , -1, fooUdf(a)) as b,
>      IF(fooUdf(a) < -1  , fooUdf(a), 0) as c
>      my_hive_table
>  So will fooUdf be called 4 times ? Or once ?
>  Why this is important is because in our case this UDF calls a web
> service and I don't want so many calls to the service.
>  Thanks
>  sanjay
> =====================> This email message and any attachments are for the exclusive use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply email and destroy all copies of the original message along
> with any attachments, from your computer system. If you are the intended
> recipient, please be advised that the content of this message is subject to
> access, review and disclosure by the sender's Email System Administrator.

Nitin Pawar