doupeng8419 2019-08-16 08:27
浏览 133

在ElasticSearch上使用特定搜索类型进行分页

We are currently using ElasticSearch 6.7 and have a huge amount of data making some request taking too much time. To avoid this problem, we want to set up pagination within our research towards elasticsearch. The problem is that I can't put one of the pagination methods proposed by ES on the different requests that already exist. For example, this request contains different aggregations and a query: https://github.com/trackit/trackit/blob/master/usageReports/lambda/es_request_constructor.go#L61-L75 In addition, the results are sorted after the information is collected.

I tried to set up the Search After method as well as a form of pagination using from & size. Scroll doesn't works with aggregations and composite aggregation doesn't accept query.

So, there is any good way to do pagination in ElasticSearch combined with other request type and how to do it with the example above?

  • 写回答

1条回答 默认 最新

  • doushou8299 2019-08-17 07:22
    关注

    composite aggregation doesn't accept query

    It does accept query. In the example below, the results are filtered based on play_name. The aggregation only get applied to the result of the query and it can be paginated using the after option.

    {
        "query": {
            "term": {
                "play_name": "A Winters Tale"
            }
        },
        "size": 0,
        "aggs": {
            "speaker": {
                "composite": {
                    "after": {
                        "product": "FLORIZEL"
                    },
                    "sources": [
                        {
                            "product": {
                                "terms": {
                                    "field": "speaker"
                                }
                            }
                        }
                    ]
                },
                "aggs": {
                    "speech_number": {
                        "terms": {
                            "field": "speech_number"
                        },
                        "aggs": {
                            "line_id": {
                                "terms": {
                                    "field": "line_id"
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题