How can we change the minTimestamp configuration for the __time column?

When ingesting data, we select an applicable time based column for the __time column, however when this column contains a negative EPOCH value or a STRING value earlier than 01/01/1970 it results in the following error:

Error: Failed to sample data: Cannot add row[SamplerInputRow{row=MapBasedInputRow{timestamp=1967-01-30T00:00:00.000Z, event=

{ID=1, DOB=1967-01-30}

, dimensions=[ID]}}] because it is below the minTimestamp[1970-01-01T00:00:00.000Z]

Is there a way to change the minTimestamp configuration? If not, is there a reason for this limitation?

The Unix Epoch begins on that date:

For event data, the __time column is the date “when an event occured” – remembering that “events” are typically things like user actions on websites, IOT readings, and the like. See Druid data model · Apache Druid

As an alternative, perhaps give the __time a default value, and then store the DOB in another way.

1 Like