hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karen Coppage (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-21234) Enforce timestamp range
Date Wed, 13 Feb 2019 14:17:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-21234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Karen Coppage updated HIVE-21234:
---------------------------------
    Attachment: HIVE-21234.2.patch
        Status: Patch Available  (was: Open)

> 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
>
>
> 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)

Mime
View raw message