[HIVE-12196] NPE when converting bad timestamp value

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.1
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Hive
• Assignee: Aihua Xu
• Reporter: Ryan Blue
• Created: 15/Oct/15 21:11
• Updated: 16/Feb/16 23:51
• Resolved: 16/Nov/15 15:36

Description

When I convert a timestamp value that is slightly wrong, the result is a NPE. Other queries correctly reject the timestamp:

hive> select from_utc_timestamp('2015-04-11-12:24:34.535', 'UTC');
FAILED: NullPointerException null
hive> select TIMESTAMP '2015-04-11-12:24:34.535';
FAILED: SemanticException Unable to convert time literal '2015-04-11-12:24:34.535' to time value.