[
https://issues.apache.org/jira/browse/PARQUET-200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ryan Blue resolved PARQUET-200.
-------------------------------
Resolution: Fixed
> Add microsecond time and timestamp annotations
> ----------------------------------------------
>
> Key: PARQUET-200
> URL: https://issues.apache.org/jira/browse/PARQUET-200
> Project: Parquet
> Issue Type: Improvement
> Components: parquet-format
> Reporter: Ryan Blue
> Assignee: Ryan Blue
>
> When the date/time type annotations were added, we decided not to add
> precisions smaller than milliseconds because there wasn't a clear
> requirement. I think that the requirement is for nanosecond precision. The
> SQL spec requires at least microsecond. Some databases support nanosecond,
> including SQL engines on Hadoop like Phoenix. Hive and Impala currently
> support nanosecond times using an int96, but intend to move to microsecond
> precision with this spec.
> I propose adding the following type annotations:
> * {{TIME_MICROS}}: annotates an int64 (8 bytes), represents the number of
> microseconds from midnight.
> * {{TIMESTAMP_MICROS}}: annotates an int64 (8 bytes), represents the number
> of microseconds from the unix epoch.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
