support for timestamps before 1970 or after 2038

2013-05-08 Thread Mikhail Bautin
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

Re: support for timestamps before 1970 or after 2038

2013-05-08 Thread Mikhail Bautin
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