在ElasticSearch中基于doc_count订购桶

Question

我是ElasticSearch的新手，我目前正在尝试编写一个涉及聚合的ElasticSearch查询，它将为我获取涉及某些字段的前5个桶（查询中涉及的字段数量是动态的，它可以在2个字段和5个字段之间的任何位置）。

我面临的问题是，团队当前的ElasticSearch版本不支持多术语，因此我恢复了复合聚合，将top_hits作为子聚合器，这样我就可以获得前5个桶。然而，我没有根据doc_count/命中以排序顺序获得结果。

请求:

{
  "query":{
    "bool":{
      "must":[{
          "exists":{"field":"uuid"}
        },{
          "query_string":{
            "query":"*","lowercase_expanded_terms":false
          }
        }]
    }
  },
  "aggs":{
    "test_aggregation":{
      "composite":{
        "sources":[{
          "zipCode":{"terms":{"field":"zipCode"}},
          "routeCode":{"terms":{"field":"routeCode"}}
        }]
      }
    },
    "aggs":{
      "test_aggregation_hits":{
        "top_hits":{
          "size":5,
          "_source":{
            "includes":["uuid"]
          }
        }
      }
    }
  },
  "size":"0"
}

回应：

{
    "took": 310,
    "timed_out": false,
    "num_reduce_phases": 2,
    "_shards": {
        "total": 140,
        "successful": 140,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": 8400,
        "max_score": 0.0,
        "hits": []
    },
    "aggregations": {
        "test_aggregation": {
            "after_key": {
                "zipCode": "someRandomZipCode",
                "routeCode": "someRandomRouteCode"
            },
            "buckets": [{
                "key": {
                    "zipCode": "someRandomValue-1",
                    "routeCode": "someRandomRouteCode-1"
                },
                "doc_count": 36,
                "test_aggregation_hits": {
                    "hits": {
                        "total": 36,
                        "max_score": 11.5650015,
                        "hits": [{
                          .... // some data
                        }]
                    }
                 }
            }, {
                "key": {
                    "zipCode": "someRandomValue-2",
                    "routeCode": "someRandomRouteCode-2"
                },
                "doc_count": 40,
                "test_aggregation_hits": {
                    "hits": {
                        "total": 40,
                        "max_score": 11.5658015,
                        "hits": [{
                          .... // some data
                        }]
                    }
                 }
            }, {
                "key": {
                    "zipCode": "someRandomValue-3",
                    "routeCode": "someRandomRouteCode-3"
                },
                "doc_count": 13,
                "test_aggregation_hits": {
                    "hits": {
                        "total": 13,
                        "max_score": 11.5750015,
                        "hits": [{
                          .... // some data
                        }]
                    }
                 }
            }
            ....  
            ....
          ]
        }
      }
}

< li >我想知道我采取的方法是否正确？ < li >如果方法不正确，我应该如何着手解决这个问题？ < li >如果方法是正确的，那么我做错了什么？我如何根据doc_count对存储桶进行排序？

Answer 1

能够通过使用存储桶排序弹性搜索聚合来解决此问题。

最终查询看起来像这样。

{
  "query":{
    "bool":{
      "must":[{
          "exists":{"field":"uuid"}
        },{
          "query_string":{
            "query":"*","lowercase_expanded_terms":false
          }
        }]
    }
  },
  "aggs":{
    "test_aggregation":{
      "composite":{
        "sources":[{
          "zipCode":{"terms":{"field":"zipCode"}},
          "routeCode":{"terms":{"field":"routeCode"}}
        }],
        "size":"100"
      }
    },
    "aggs":{
      "test_aggregation_hits":{
        "top_hits":{
          "size":"25",
          "_source":{
            "includes":["uuid"]
          }
        }
      },
      "sort_buckets": {
         "size":"10",
         "sort": [
            {"_count": { "order": "desc" } }
         ]
      }
    }
  },
  "size":"0"
}