Date histogram error

[Tomo_M (Tomohiro Mitani)]

Is there some difference from the previous topic?

Getting every 2nd element from _source

So the true problem is the necessary size for query could be hundreds of thousands and too wasteful. Then you can use Date histogram aggregation | Elasticsearch Guide [7.16] | Elastic with Top hits aggregation | Elasticsearch Guide [7.16] | Elastic. Top hit with size=1 and sort by date, you can get last (or first) documents in the date-histo buckets.

If you need some last metrics other than last document, you can use top metrics aggregation sorted by time stamp.

Top metrics aggregation | Elasticsearch Guide [master] | Elastic