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>
