Support Questions
Find answers, ask questions, and share your expertise

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

New Contributor

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.

1 ACCEPTED SOLUTION

Explorer

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

View solution in original post

2 REPLIES 2

Explorer

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

New Contributor

You are right. This is the issue.

; ;