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.
- From and Size is not supported
- Include not working as expected
- Top Hits in Aggregation only give top records
Is there any way please suggest?