[ARROW-315] Finalize timestamp type

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.1.0
• Component/s: Format
• External issue URL: https://github.com/apache/arrow/issues/15760
• Assignee: Julien Le Dem
• Reporter: Julien Le Dem
• Created: 03/Oct/16 22:22
• Updated: 11/Jan/23 07:08
• Resolved: 04/Oct/16 22:12

Description

support int64 UNIX timestamps with a particular resolution.

Parquet supports timestamp millis and micros (no nanos)
https://github.com/apache/parquet-format/blob/master/LogicalTypes.md#datetime-types

currently Arrow timestamps have a timezone field.
https://github.com/apache/arrow/blob/master/format/Message.fbs#L67
proposal to change timestamp as follows:

• remove "timestamp" field and say it's UTC
• add unit field (MICROS | MILLIS)

Issue Links

• blocks: ARROW-272 Arrow release 0.1
• relates to: ARROW-637 [Format] Add time zone metadata to Timestamp type
• links to: PR