ElasticSearch查询超过10000条（1000页）时出现Result window is too large的问题

问题描述:

我用from&size的方法进行分页查询，每次超过10000条的时候就会报错:

（’Result window is too large, from + size must be less than or equal to: [10000] but was [10100]. 
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.’)

解决方法:

1.设置所有的index

登录服务器执行

curl -H "Content-Type: application/json" -XPUT http://10.81.90.217:9200/_settings -d '{ "index" : { "max_result_window" : 300000000}}'

2.设置个别index

方法一:

登录服务器执行

curl -H "Content-Type: application/json" -XPUT http://10.81.90.217:9200/xxxindex/_settings -d '{ "index" : { "max_result_window" : 300000000}}'

方法二:

在插件elasticsearch-head插件中设置

 

效果查看