[HIVE-14231] timestamp support is limited to 4 digit year

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Types
• Labels: newbie
• Assignee: Arun Khetarpal
• Reporter: Takahiko Saito
• Created: 13/Jul/16 22:44
• Updated: 27/Oct/16 19:45

Description

Hive doesn't handle timestamp type that have a year with more than 4 digits.
This limitation seems to be primarily around string to timestamp conversion.

Following insert query would insert NULL record -
create table ts_test (t timestamp);
insert into ts_test values ('2015-01-01 1:1:1');
insert into ts_test values ('20151-01-01 1:1:1');
select CAST(t as String)  from ts_test;
+----------------------+--+
|          t           |
+----------------------+--+
| 2015-01-01 01:01:01  |
| NULL                 |
+----------------------+--+