[IMPALA-3598] Timestamp casting is inconsistent

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.6.0
• Component/s: Backend
• Epic Link: Timestamp Compatibility
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Taras Bobrovytsky
• Created: 23/May/16 21:48
• Updated: 30/Oct/18 17:14
• Resolved: 30/Oct/18 17:14

Description

The following two queries result in different timestamp casting behavior.

select cast(253430000000 as timestamp);

Result:

10000-11-16 14:13:20

The following query returns NULL.

select cast("10000-11-16 14:13:20" as timestamp);

Issue Links

• relates to: IMPALA-5664 Unix time to timestamp conversions may crash impala (boost exception)