Pagination with Aggregation Queries


(Deepak Mane) #1

I have table having more 40 lakhs records. I have to load the data with grouping. After grouping data will be more the 5 lakhs records.

I have tried many solutions but not succeed.

  1. From and Size is not supported
  2. Include not working as expected
  3. Top Hits in Aggregation only give top records

Is there any way please suggest?


(Val Crettaz) #2

Note that you can specify any size you want (<10000) in the top_hits aggregation, it doesn't have to return only the top three records.


(Deepak Mane) #3

Thanks Val.

Yes, I can only set Size in top_hits. but not From offset (Limit start Offset).
And I have huge data more than (>10000). I have to load that with pagination. Can you please suggest how I can do this (If Example) ?


(system) #4

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