hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh Balamohan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12534) Date functions with vectorization is returning wrong results
Date Fri, 27 Nov 2015 05:19:11 GMT
Rajesh Balamohan created HIVE-12534:
---------------------------------------

             Summary: 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: Hive
            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)

Mime
View raw message