Open honzakral opened 5 years ago
Pinging @elastic/kibana-app
My understanding is, ES SQL also uses composite aggregation, and it currently faces some limitations in sorting the rows, that we would have in a data table visualization: https://github.com/elastic/elasticsearch/issues/35118
I think it's worth watching that issue to figure out when could be a time to implement this for Kibana
ES issue has been closed. Is it a good time to look into this again @tsullivan?
Some users want to see an exhaustive list of results in a data table visualization. Doing this in a simple aggregation is often prohibitively expensive for both elasticsearch and the browser. Ability to use
composite
aggregation to paginate would be ideal for this use case.