ElasticSearch - Result window is too large, from + size must be less than or equal to: [10000]

elasticsearch-result-window-is-too-large-from-size.md

Result window is too large, from + size must be less than or equal to: [10000] but was [1000000]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level parameter

I suppose the proper fix would be to modify the code to use the scroll API, but for a quick fix, you can use the following:

curl -XPUT http://localhost:9200/doraana/_settings -d '{ "index" : { "max_result_window" : 1000000 } }'

Use kibana

With Elastic server: http://localhost:9200/doraana, with index: doraana

PUT _settings
{
  "index": {
    "max_result_window": 1000000
  }
}

Use kibana for ElasticSearch 5

PUT doraana/_settings
{
  "index": {
    "max_result_window": 1000000
  }
}

Reference: https://www.elastic.co/guide/en/elasticsearch/reference/current/index-modules.htm

Looks like a fix in v5 elastic/elasticsearch#18237 ?

We can apply this solution https://www.elastic.co/guide/en/elasticsearch/reference/7.10/paginate-search-results.html#search-after
:)