分页与遍历:From,Size,Search After &Scroll API

本文介绍了Elasticsearch中两种主要的遍历数据的方式:使用from和size参数进行分页,以及利用Search After API进行高效的数据浏览。通过示例展示了如何在查询请求中设置这些参数,以及如何在用户排序和ID的基础上进行搜索。同时,还探讨了Scroll API的使用,用于大数据集的深度分页,并展示了如何通过滚动ID在一段时间内保持会话状态。
摘要由CSDN通过智能技术生成

POST movies/_search
{
  "from":0,
  "size": 100,
  "query": {
    "match_all": {}
  }
}

//Search After
DELETE users
POST users/_doc
{ "name":"user1","age":10}
POST users/_doc
{ "name":"user2","age":11}
POST users/_doc
{ "name":"user3","age":12} 
POST users/_doc
{ "name":"user4","age":13} 

POST users/_count
POST users/_search
{
  "size": 1,
  "query": {
    "match_all": {}
  },
  "sort": [
    {"age":"desc"},
    {"_id":"asc"}
  ]
}

POST users/_search
{
  "size": 1,
  "query": {
    "match_all": {}
  },
  "search_after":[
      13,
          "JEOYUn0BQpSWQp29DG_V"
    ],
  "sort": [
    {"age":"desc"},
    {"_id":"asc"}
  ]
}

POST users/_search
{
  "size": 1,
  "query": {
    "match_all": {}
  },
  "search_after":[
          12,
          "I0OYUn0BQpSWQp29BW-o"
        ],
  "sort": [
    {"age":"desc"},
    {"_id":"asc"}
  ]
}

//Scroll API
DELETE users
POST users/_doc
{"name":"user1","age":10}

POST users/_doc
{"name":"user2","age":20}

POST users/_doc
{"name":"user3","age":30}

GET /users/_count

POST /users/_search?scroll=5m
{
  "size": 1,
  "query": {
    "match_all": {}
  }
}

"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR",

POST users/_doc
{"name":"user4","age":40}

POST /_search/scroll
{
  "scroll":"1m",
  "scroll_id":"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"
}

"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"

POST /_search/scroll
{
  "scroll":"1m",
  "scroll_id":"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"
}

"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"

POST /_search/scroll
{
  "scroll":"1m",
  "scroll_id":"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"
}

"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"

POST /_search/scroll
{
  "scroll":"1m",
  "scroll_id":"FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFnBJSElzcTlVU1BxM2xyODZJckxrN1EAAAAAAAD__BZSaWJaUUpENVNzV2RmbUpMeHcyNzBR"
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值