What is the supported range for Hive's Timestamp data types.

[#1]

I have an ORC table tbl1 having timestamp column. I inserted these values:

insert into tbl1 values ('0001-01-01 00:00:20.0');
insert into tbl1 values ('9999-01-01 00:00:20.0');

I created another ORC table tbl2 having timestamp column. Then I tried:

insert into tbl2 select * from tbl1;

Data in tbl2 is corrupted:

1754-08-28 22:44:01.128654848
1815-03-31 05:56:28.066277376

Am I using out of range values?

Is there any specific range for timestamp?

This problem is only for ORC file format. For other file formats like textfile, avro, parquet, etc it's working fine.

[#2 · Accepted solution]

Hi @Devender Yadav, what version of hive are you running? It might be due to known vectorization issue mentioned in this jira:

https://issues.apache.org/jira/browse/HIVE-9862

[#3]

You are right. This is the issue.