[
https://issues.apache.org/jira/browse/AVRO-739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14081463#comment-14081463
]
Tom White commented on AVRO-739:
--------------------------------
Thanks Dmitry. The Parquet project recently added date and time types
(PARQUET-12 and
https://github.com/apache/incubator-parquet-format/pull/3/files) and I think it
would be very useful to align the two where possible, since this would make
Hive integration easier (for example).
For DateTimeInstant I would propose the two types (one string, one int):
{code}
{ "type": "string", "logicalType": "ISO-8601-datetime-offset" }
{ "type": "long", "logicalType": "timestamp-millis" }
{code}
For LocalDate we could have two logical types, one for Avro string (ISO-8610
encoding), and one for int (days since Unix epoch):
{code}
{ "type": "string", "logicalType": "ISO-8601-date" }
{ "type": "int", "logicalType": "date" }
{code}
We might also consider time and interval logical types.
> Add Date/Time data types
> ------------------------
>
> Key: AVRO-739
> URL: https://issues.apache.org/jira/browse/AVRO-739
> Project: Avro
> Issue Type: New Feature
> Components: spec
> Reporter: Jeff Hammerbacher
> Attachments: AVRO-739.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.2#6252)
