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

最新推荐文章于 2025-12-16 16:02:25 发布

原创最新推荐文章于 2025-12-16 16:02:25 发布 · 83 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#less #java #数据库 #前端 #css

本文介绍了解决SQL查询返回结果过大的问题，通过调整Elasticsearch中的index.max_result_window参数来实现。当请求的数据量超过默认限制时，可以通过修改索引设置来增加结果窗口的大小。

使用sql插件执行如下语句的时候报错
http://10.127.0.1:9200/_sql?sql=select * from test limit 1000000

错误信息：
{"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 [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 setting."}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"dfs","grouped":true,"failed_shards":[{"shard":0,"index":"test","node":"2mrGnp0TTbKYzxwRX_GPSQ","reason":{"type":"query_phase_execution_exception","reason":"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 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 [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 setting."}},"status":500}

意思是返回结果太大，目前最大值是10000，而我却要求返回1000000条数据。可以设置索引的index.max_result_window属性返回结果的大小

put http://10.127.0.1:9200/test/_settings
{
"index.max_result_window":1000001
}