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
}
}