While writing a query, we can mention "from" and "size" to get a specific number of results at a time. By updating "from" we can then get the next set of results. In aggregations, we can mention "size", but I am having a hard time on how to mention "from".
I'm not sure you can. Aggregations are built on the full result set, whatever from and size are.
My requirement is to show the results from an aggregation in paginated format. I just want to avoid storing all the results in memory and showing only a few out of them at a time. I fear it will not scale.
I don't understand the use case.
Not sure you need to complicate something which is working well out of the box.
I think the following github issue might be relevant to your question: https://github.com/elastic/elasticsearch/issues/4915