I can't ingest time longer than 24 hours

Elastic Stack Elasticsearch
1

I need to create a dashboard based on a json that will be ingested repeatedly, this json has 2 fields of type time the first field is TA and the second is TT.

The value of these fields is represented by HH:mm:ss, but this value can exceed 24 hours, for example:

TA
58:45:21

TT
69:48:22

I'm trying to ingest these fields using the data type: DATE and format: hour_minute_second, but I'm getting an error because the time is greater than 24 hours.

2

You'll probably need to use a script processor in an ingest pipeline to convert that to a proper date. Otherwise Elasticsearch will not accept it.

3

That looks like a duration and not a date, for which as far as I know there is no native data type. I would therefore recommend transforming it into seconds before ingesting it into Elasticsearch.