[HIVE-12534] Date functions with vectorization is returning wrong results

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Component/s: Vectorization
• Target Version/s: 2.0.0
• Assignee: Rajesh Balamohan
• Reporter: Rajesh Balamohan
• Created: 27/Nov/15 05:18
• Updated: 17/Dec/15 01:27
• Resolved: 17/Dec/15 01:27

Description

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

\cc gopalv, sseth, sershe

Issue Links

• is superceded by: HIVE-12479 Vectorization: Vectorized Date UDFs with up-stream Joins