Since this does seem to be a problem in Hive, I went ahead and created a JIRA with a design proposal of a backward-compatible solution.
https://issues.apache.org/jira/browse/HIVE-4525 Years earlier than 1970 in particular are an important case for supporting historical data in many business applications. Thanks, Mikhail On Wed, May 8, 2013 at 3:15 PM, Mikhail Bautin < bautin.mailing.li...@gmail.com> wrote: > 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 > >
