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

["Ryan Blue (JIRA)" <ji...@apache.org>]

Ryan Blue created AVRO-1683:
-------------------------------

             Summary: 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


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)