Unlimite the max response

(Nuwan Vithanage) #1

Hi

when I execute the following query in Kibana dev tools I got below issue

Query
GET /ticker_quote_*/_search
{
"size": 10002,
"query": {
"terms": {
"asset": ["ACAN"]
}
}
}

{ "type": "query_phase_execution_exception", "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [10002]. 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 setting." }

seem like search result limited to 10000 how can make it unlimited?

Thank you

#2

You can increase it, but please think twice if you decide to do that for a production cluster/index. This 10000 limit is set for a reason. It protects your cluster from abusively large search requests.

PUT /ticker_quote_*/_settings
{
    "index" : {
        "max_result_window" : 20000
    }
}
(Nuwan Vithanage) #3

Hi Azasypkin,

Thank you very much for your response and your answer. I highly appreciate it

1 Like
(Nuwan Vithanage) #4

"what would be the consequences of having abusive requests? Slowness or crash?"

Thank you,

Nuwan