question Re: What is the supported range for Hive's Timestamp data types. in Archives of Support Questions (Read Only)

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

dev_emr — Thu, 30 Mar 2017 20:47:16 GMT

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.

jvaria — Fri, 31 Mar 2017 01:40:51 GMT

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

dev_emr — Sat, 01 Apr 2017 05:53:55 GMT

You are right. This is the issue.