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?
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.