You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@avro.apache.org by "Ryan Blue (JIRA)" <ji...@apache.org> on 2015/06/16 19:23:00 UTC

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

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

Ryan Blue updated AVRO-1683:
----------------------------
    Attachment: AVRO-1683-1.patch

Adding a patch with the updated spec.

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