De-Duplication Query

Elastic Stack Elasticsearch
1

I have a collection of documents where each document looks like
{
"_id": ... ,
"Author": ...,
"Content": ....,
"DateTime": ...
}

I would like to issue one query to the collection so that I get in response the oldest document from each author. I am considering using a terms aggregation but when I do that I get a list of buckets, being the unique Author values, telling me nothing about which of their documents is the oldest. Furthermore, that approach requires a subsequent call to ES, which is undesirable.

Any advice you could offer would be greatly appreciated. Thanks.

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.