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

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