Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> support for timestamps before 1970 or after 2038


Copy link to this message
-
support for timestamps before 1970 or after 2038
Hello,

Are there plans to support timestamps that cannot be represented by a
signed 32-bit integer number of seconds since the UNIX epoch? (i.e. those
before 1970 or after a certain point in 2038). Currently Hive's behavior
regarding these timestamps is inconsistent, because it is possible to
insert them into a table, but Hive does not handle them properly. Trying to
serialize and deserialize the "1969-12-31 23:59:59" timestamp using
TimestampWritable results in a "2038-01-19 03:14:07" timestamp.

Thanks,
Mikhail