You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "vinisha (JIRA)" <ji...@apache.org> on 2018/11/07 19:38:00 UTC

[jira] [Comment Edited] (HIVE-8131) Support timestamp in Avro

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

vinisha edited comment on HIVE-8131 at 11/7/18 7:37 PM:
--------------------------------------------------------

This change only supports timestamp-millis. Avro 1.8.2 also supports timestamp-micros. [https://avro.apache.org/docs/1.8.2/spec.html#Timestamp+%28microsecond+precision%29]

timestamp-micros should also be supported in hive AvroSerde because hive timestamps support nano second level precision.

[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-TimestampstimestampTimestamps]

One possibility is to support avro timestamp-millis and avro timestamp-micros in serialization. Avro Deserializer can map hive timestamp to timestamp-micros. 

 


was (Author: vinisha):
This change only supports timestamp-millis. Avro 1.8.2 also supports timestamp-micros. [https://avro.apache.org/docs/1.8.2/spec.html#Timestamp+%28microsecond+precision%29]

timestamp-micros should also be supported in hive AvroSerde because hive timestamps support nano second level precision.

[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-TimestampstimestampTimestamps]

> Support timestamp in Avro
> -------------------------
>
>                 Key: HIVE-8131
>                 URL: https://issues.apache.org/jira/browse/HIVE-8131
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Brock Noland
>            Assignee: Ferdinand Xu
>            Priority: Major
>              Labels: TODOC15
>             Fix For: 1.1.0
>
>         Attachments: HIVE-8131.1.patch, HIVE-8131.patch, HIVE-8131.patch
>
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)