You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2015/11/30 21:10:11 UTC

[jira] [Commented] (HIVE-12534) Date functions with vectorization is returning wrong results

    [ https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032379#comment-15032379 ] 

Sergey Shelukhin commented on HIVE-12534:
-----------------------------------------

[~mmccline] fyi

> Date functions with vectorization is returning wrong results
> ------------------------------------------------------------
>
>                 Key: HIVE-12534
>                 URL: https://issues.apache.org/jira/browse/HIVE-12534
>             Project: Hive
>          Issue Type: Bug
>          Components: Vectorization
>            Reporter: Rajesh Balamohan
>
> {noformat}
> select c.effective_date, year(c.effective_date), month(c.effective_date) from customers c where c.customer_id = 1000046028;
> hive> set hive.vectorized.execution.enabled=true;
> hive> select c.effective_date, year(c.effective_date), month(c.effective_date) from customers c where c.customer_id = 1000046028;
> 2015-11-19      0       0
> hive> set hive.vectorized.execution.enabled=false;
> hive> select c.effective_date, year(c.effective_date), month(c.effective_date) from customers c where c.customer_id = 1000046028;
> 2015-11-19      2015    11
> {noformat}
> \cc [~gopalv], [~sseth], [~sershe]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)