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

Attila Magyar updated HIVE-25242:
---------------------------------
    Environment:     (was: If hive.vectorized.adaptor.usage.mode is set to 
chosen only certain UDFS are vectorized through the vectorized adaptor.

Queries like this one, performs very slowly because the concat is not chosen to 
be vectorized.
{code:java}
select count(*) from tbl where to_date(concat(year, '-', month, '-', day)) 
between to_date('2018-12-01') and to_date('2021-03-01');  {code})

>  Query performs extremely slow with hive.vectorized.adaptor.usage.mode = 
> chosen
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-25242
>                 URL: https://issues.apache.org/jira/browse/HIVE-25242
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 4.0.0
>            Reporter: Attila Magyar
>            Priority: Major
>             Fix For: 4.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to