ES报错信息:
{ "error": { "root_cause": [ { "type": "query_phase_execution_exception", "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [200000000]. 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." } ], "type": "search_phase_execution_exception", "reason": "all shards failed", "phase": "query", "grouped": true, "failed_shards": [ { "shard": 0, "index": "view_log", "node": "f7Mhj8hJTbCecKixd2ZFIQ", "reason": { "type": "query_phase_execution_exception", "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [200000000]. 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." } } ], "caused_by": { "type": "query_phase_execution_exception", "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [200000000]. 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." } }, "status": 500}
执行语句:
POST:
http://127.0.0.1:9200/demo/_search
body:
{ "query": { "bool": { "filter": [ { "match": { "userid": "f8d3e9ad7ec3482a9f92318eb18f8173" } } ] } }, "from": 0, "size": 200000000}
原因:从上面的报错信息,可以看到ES提示我结果窗口太大了,目前最大值为10000,而我却要求给我10000000。并且在后面也提到了要求我修改index.max_result_window
参数来增大结果窗口大小。
解决:
POST:
http://127.0.0.1:9200/demo/_settings
body:
{ "index": { "max_result_window": 100000000 }}