Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain 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
+
Mikhail Bautin 2013-05-09, 03:34
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB