聚合后的弹性搜索排序

发布于 2025-02-11 04:35:55 字数 540 浏览 1 评论 0 原文

我有一个弹性搜索查询，显示了[cvid]的独特值，对于每个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"
          }
        }
      }
   }}
}

原文

I have an elastic search query showing distinct value for [Have CVID], for each CONTACT_ID, and I want to sort by [Have CVID] count after aggregation. Where can I add the sort by here?

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"
          }
        }
      }
   }}
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

疯狂的代价 2025-02-18 04:35:55

您可以将 order 添加到 enter 聚合并指定订单的子聚集，如以下：

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 noreflow noreferrer“

You can add order to your terms aggregation and specify a sub-aggregation to order by, like this:

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 documentation

回复收藏 0 原文

~没有更多了~