[jira] [Commented] (HIVE-9298) Support reading alternate timestamp formats

["Lefty Leverenz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-9298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14302946#comment-14302946 ] 

Lefty Leverenz commented on HIVE-9298:
--------------------------------------

Doc note:  timestamp.formats can be documented in the Timestamps section of the Hive Data Types wikidoc.  (At present we don't have a section on SerDe properties in the wiki, but perhaps we should.)

* [Hive Data Types -- Timestamps | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Timestamps]
* [SerDe Overview | https://cwiki.apache.org/confluence/display/Hive/SerDe#SerDe-SerDeOverview]

> Support reading alternate timestamp formats
> -------------------------------------------
>
>                 Key: HIVE-9298
>                 URL: https://issues.apache.org/jira/browse/HIVE-9298
>             Project: Hive
>          Issue Type: Bug
>          Components: Serializers/Deserializers
>            Reporter: Jason Dere
>            Assignee: Jason Dere
>              Labels: TODOC1.2
>             Fix For: 1.2.0
>
>         Attachments: HIVE-9298.1.patch, HIVE-9298.2.patch, HIVE-9298.3.patch
>
>
> There are some users who want to be able to parse ISO-8601 timestamps, as well to set their own custom timestamp formats. We may be able to support this in LazySimpleSerDe through the use of a SerDe parameter to specify one or more alternative timestamp patterns to use to parse timestamp values from string.
> If we are doing this it might also be nice to work in support for HIVE-3844, to parse numeric strings as timestamp by treating the numeric value as millis since Unix epoch. This can be enabled through the SerDe params as well.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)