[IMPALA-16] Impala returns 0 for bad time values in UNIX_TIMESTAMP, Hive returns NULL

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 0.3
• Fix Version/s: Impala 1.0.1
• Assignee: Skye Wanderman-Milne
• Reporter: Henry Robinson
• Created: 09/Jan/13 01:41
• Updated: 15/May/13 18:50
• Resolved: 30/Apr/13 22:27

Description

Minor incompatibiliy between Impala and Hive:

Impala:

select UNIX_TIMESTAMP('10:02:01') ;
Query: select UNIX_TIMESTAMP('10:02:01')
Query finished, fetching results ...
0
Returned 1 row(s) in 0.01s

Hive:

hive> select UNIX_TIMESTAMP('10:02:01') FROM tmp;
<snip>
OK
NULL

In the code, we should probably check if (tv->date().is_special()) in both branches of TimestampFunctions::Unix.