hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikhail Bautin <mbau...@apache.org>
Subject Re: support for timestamps before 1970 or after 2038
Date Thu, 09 May 2013 03:34:32 GMT
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.lists@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message