[jira] [Commented] (AVRO-1683) Add microsecond-precision time and timestamp logical type specs

["Tom White (JIRA)" <ji...@apache.org>]

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

Tom White commented on AVRO-1683:
---------------------------------

+1

> Add microsecond-precision time and timestamp logical type specs
> ---------------------------------------------------------------
>
>                 Key: AVRO-1683
>                 URL: https://issues.apache.org/jira/browse/AVRO-1683
>             Project: Avro
>          Issue Type: Improvement
>          Components: spec
>            Reporter: Ryan Blue
>            Assignee: Ryan Blue
>         Attachments: AVRO-1683-1.patch
>
>
> SQL engines that store data in Avro need to be able to store times and timestamps to meet the SQL spec. For portability, those values should be labelled so other readers can work with the data. I propose adding two new logical types:
> * time-micros: annotates a long, represents the number of microseconds from midnight.
> * timestamp-micros: annotates a long, represents the number of microseconds from the unix epoch.
> Like the other time types, these representations match the ones that were just added to Parquet (PARQUET-200) to make implementations easier.



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