Thejas M Nair created HIVE-14231:
------------------------------------
Summary: timestamp support is limited to 4 digit year
Key: HIVE-14231
URL: https://issues.apache.org/jira/browse/HIVE-14231
Project: Hive
Issue Type: Bug
Components: Types
Reporter: Thejas M Nair
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.
{code}
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 |
+----------------------+--+
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
