Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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.
Attachments
Issue Links
- links to