Elastic search aggregation pagination issue

Question

How do i perform a query similar to this one in elasticsearch?

SELECT field FROM table GROUP BY field OFFSET 10 LIMIT 10;

Thank for the answer

Possible duplicate of [How to control the elasticsearch aggregation results with From / Size?](https://stackoverflow.com/questions/43038131/how-to-control-the-elasticsearch-aggregation-results-with-from-size) — John Jones, Aug 09 '17 at 00:46

score 2 · Accepted Answer · answered Mar 11 '16 at 17:00

2

The short answer is that you can't (yet).

There's an open issue titled "Paging aggregation support" that should take care of this feature soon. As you can see that issue is two years old, still open and got many +1 from many people. It's still not slated for any releases yet, though.

In the meantime, you can retrieve your aggregation with size: 20 and then on the client side only consider the last 10 terms.

answered Mar 11 '16 at 17:00

Val

207,596
13
358
360

It helped me to not search for an answer, but thanks anyways :) – nogo0d May 07 '16 at 23:26
This feature was added in 5.2 FYI – John Jones Aug 09 '17 at 00:38
@JohnJones if you're referring to [partitionable aggregations](https://github.com/elastic/elasticsearch/issues/21487), it's a little different than pagination, but it helps achieve pretty much the same goal than pagination. – Val Aug 09 '17 at 04:34
That's exactly what I'm referring too. :) – John Jones Aug 09 '17 at 04:42

Elastic search aggregation pagination issue

1 Answers1

Linked