Skip to content

Creating a File With Time and Timestamp Columns

Selfeer edited this page Nov 12, 2024 · 1 revision

TIME_MILLIS

Full example here

  {
    "name": "time_millis_field",
    "schemaType": "required",
    "physicalType": "INT32",
    "logicalType": "TIME_MILLIS",
    "data": [12345678, 23456789, 34567890, 45678901, 56789012]
  }

TIME_MICROS

Full example here

  {
    "name": "time_micros_field",
    "schemaType": "required",
    "physicalType": "INT64",
    "logicalType": "TIME_MICROS",
    "data": [123456789012, 234567890123, 345678901234, 456789012345, 567890123456]
  }

TIMESTAMP_MICROS

Full example here

  {
    "name": "timestamp_micros_field",
    "schemaType": "required",
    "physicalType": "INT64",
    "logicalType": "TIMESTAMP_MICROS",
    "data": [1609459200000000, 1609545600000000, 1609632000000000, 1609718400000000, 1609804800000000]
  }

TIMESTAMP_MILLIS

Full example here

  {
    "name": "timestamp_millis_field",
    "schemaType": "required",
    "physicalType": "INT64",
    "logicalType": "TIMESTAMP_MILLIS",
    "data": [1609459200000, 1609545600000, 1609632000000, 1609718400000, 1609804800000]
  }
Clone this wiki locally