Hi all,

Our Wiki specifies a range for DATE, but not for TIMESTAMP (well, there's a 
specified format (yyyy) but no explicitly specified range). [1]

TIMESTAMP used to have inner representation of java.sql.Timestamp which 
couldn't handle timestamps outside of the range of years 0001-9999.
But since the inner representation was changed to LocalDateTime (HIVE-20007), 
the range of Timestamps could in theory be  -999999999-01-01 00:00:00 to 
+999999999-12-31 23:59:59.999999999.
See [2] for details on behavior.

I'd like to know:
Does TIMESTAMP have an official range that was omitted from the Wiki?
If not, what should its range be?

[1] 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-TimestampstimestampTimestamps
[2] 
https://docs.google.com/document/d/1y-GcyzzALXM2AJB3bFuyTAEq5fq6p41gu5eH1pF8I7o/edit?usp=sharing
 
<http://docs.google.com/document/d/1y-GcyzzALXM2AJB3bFuyTAEq5fq6p41gu5eH1pF8I7o/edit?usp=sharing>

Reply via email to