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.