[ 
https://issues.apache.org/jira/browse/HIVE-7314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

dima machlin updated HIVE-7314:
-------------------------------

    Description: 
It seems that the expression caching doesn't work when using UDF inside another 
UDF or a hive function.

For example :
tbl has one row : 'a','b'
The following query :
{code:sql} select concat(custUDF(a),' ', custUDF(b)) from tbl; {code}

returns 'a a'

seems to cache custUDF(a)  and use it for custUDF(b).
Same query without the concat works fine.
Replacing the concat with another custom UDF also returns 'a a'

  was:
It seems that the expression caching doesn't work when using UDF inside another 
UDF or a hive function.

For example :
tbl has one row : 'a','b'
The following query :
select concat(custUDF(a),' ', custUDF(b)) from tbl;

returns 'a a'

seems to cache custUDF(a)  and use it for custUDF(b).
Same query without the concat works fine.
Replacing the concat with another custom UDF also returns 'a a'


> Wrong results of UDF when hive.cache.expr.evaluation is set
> -----------------------------------------------------------
>
>                 Key: HIVE-7314
>                 URL: https://issues.apache.org/jira/browse/HIVE-7314
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.12.0
>            Reporter: dima machlin
>
> It seems that the expression caching doesn't work when using UDF inside 
> another UDF or a hive function.
> For example :
> tbl has one row : 'a','b'
> The following query :
> {code:sql} select concat(custUDF(a),' ', custUDF(b)) from tbl; {code}
> returns 'a a'
> seems to cache custUDF(a)  and use it for custUDF(b).
> Same query without the concat works fine.
> Replacing the concat with another custom UDF also returns 'a a'



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to