[
https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033380#comment-15033380
]
Rajesh Balamohan commented on HIVE-12534:
-----------------------------------------
HIve-12479 fixes the query mentioned in this bug. But it returned wrong results
with another query involving date.. Will attach the plan shortly. Setting "set
hive.vectorized.execution.reduce.enabled=false;" / "set
hive.vectorized.execution.enabled=false" fixes the problem
> 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
> Priority: Critical
> Attachments: plan.txt
>
>
> {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)
