[ 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)