from size 默认查超过1万条之后的数据会报错,使用search after是一个不错的选择。
#######分页 search after
DELETE users
POST users/_doc
{“id”:1,“name”:“user1”,“age”:10}
POST users/_doc
{“id”:2,“name”:“user2”,“age”:11}
POST users/_doc
{“id”:3,“name”:“user3”,“age”:12}
POST users/_doc
{“id”:4,“name”:“user4”,“age”:13}
POST users/_doc
{“id”:5,“name”:“user5”,“age”:14}
POST users/_doc
{“id”:6,“name”:“user6”,“age”:15}
POST users/_doc
{“id”:7,“name”:“user7”,“age”:16}
POST users/_doc
{“id”:8,“name”:“user8”,“age”:13}
POST users/_count
POST users/_search
{
“size”: 2,
“query”: {
“match_all”: {}
},
“sort”: [
{“id”: “desc”}
]
}
#"search_after"后面的值是id的值
POST users/_search
{
“size”: 2,
“query”: {
“match_all”: {}
},
“search_after”:[2],
“sort”: [
{“id”: “desc”}
]
}