聚合后弹性搜索排序

Question

我有一个弹性搜索查询，为每个CONTACT_ID显示不同的值，并希望在聚合后按CVID计数进行排序。我在哪能把这一种加进去？

POST /dashboard/_search?size=0
{
  "query": {
    "bool": {
      "must_not": [
       {
          "match": {
            "Have CVID": ""
          }
        }
      ]
    }
  },
  "aggs": {
        "CVID": {
          "terms": {
            "field": "CONTACT_ID.keyword"
          },
      "aggs": {
        "type_count": {
          "cardinality": {
            "field": "Have CVID.keyword"
          }
        }
      }
   }}
}

Answer 1

可以将order添加到terms聚合中，并指定要按顺序排序的子聚合，如下所示：

POST /dashboard/_search?size=0
{
  "query": {
    "bool": {
      "must_not": [{
        "match": {
          "Have CVID": ""
        }
      }]
    }
  },
  "aggs": {
    "CVID": {
      "terms": {
        "field": "CONTACT_ID.keyword",
        "order": {
          "type_count": "desc"
        }
      },
      "aggs": {
        "type_count": {
          "cardinality": {
            "field": "Have CVID.keyword"
          }
        }
      }
    }
  }
}

ElasticSearch 文档