[
https://issues.apache.org/jira/browse/HIVE-21234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karen Coppage updated HIVE-21234:
---------------------------------
Status: Open (was: Patch Available)
> Enforce timestamp range
> -----------------------
>
> Key: HIVE-21234
> URL: https://issues.apache.org/jira/browse/HIVE-21234
> Project: Hive
> Issue Type: Improvement
> Components: Hive
> Affects Versions: 3.1.0
> Reporter: Karen Coppage
> Assignee: Karen Coppage
> Priority: Major
> Labels: TODOC, backwards-compatibility
> Attachments: HIVE-21234.1.patch, HIVE-21234.2.patch,
> HIVE-21234.3.patch, HIVE-21234.4.patch
>
>
> 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 0000-9999. (0000
> converted to 0001)
> Since the inner representation was changed to LocalDateTime (HIVE-20007),
> negative timestamps overflow because of a formatting error.
> I propose simply disabling negative timestamps, and timestamps beyond year
> 9999. No data is much better than bad data.
> See [2] for more details.
> [1]
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-TimestampstimestampTimestamps
> [2]
> https://docs.google.com/document/d/1y-GcyzzALXM2AJB3bFuyTAEq5fq6p41gu5eH1pF8I7o/edit?usp=sharing
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
