Uploaded image for project: 'Apache Avro'
  1. Apache Avro
  2. AVRO-1683

Add microsecond-precision time and timestamp logical type specs

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.8.0
    • Component/s: spec
    • Labels:
      None

      Description

      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.

        Attachments

        1. AVRO-1683-1.patch
          3 kB
          Ryan Blue

          Activity

            People

            • Assignee:
              rdblue Ryan Blue
              Reporter:
              rdblue Ryan Blue
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: