Feature: Terms Aggregation with From Parameter

[kelaban]

Forgive me if there is a better way to do this.

In the #6299, from was added to top_hits aggregations. If terms aggregations also had a from field, it would allow to to do distinct type of queries.

Consider the following documents in an index:

[
  { "revision": "a1", "id": 1, "updatedAt": 0 },
  { "revision": "b1", "id": 1, "updatedAt": 1 },
  { "revision": "a2", "id": 2, "updatedAt": 2 }
]

We can use a terms aggregation on id + top_hits aggregation sorted by updatedAt to get the latest revision for each id. However to get the second page of this request would be non-trivial as it would require getting both the first and second page of the top level terms aggregation combined in one response.

[clintongormley]

Hi @kelaban

Unfortunately, there is no better way to support from in aggregations than retrieving all the buckets you need. See #4915 for more discussion.