[IMPALA-24] built-in function DATEDIFF returns wrong results

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 0.3
• Fix Version/s: Impala 0.5
• Labels: wrongresults
• Assignee: Skye Wanderman-Milne
• Reporter: Greg Rahn
• Created: 23/Jan/13 23:53
• Updated: 24/Jan/13 21:11
• Resolved: 24/Jan/13 21:11

Description

From https://cwiki.apache.org/Hive/languagemanual-udf.html
datediff(string enddate, string startdate)
Return the number of days from startdate to enddate:
datediff('2009-03-01', '2009-02-27') = 2

Impala 0.3:
[172.20.34.102:21000] > select datediff('2009-03-01', '2009-02-27');
Query: select datediff('2009-03-01', '2009-02-27')
Query finished, fetching results ...
-2
Returned 1 row(s) in 0.01s

Impala DATEDIFF() returns -2 when it should return 2.