Sorting on an aggregation in Elasticsearch

To sort on an aggregation in Elasticsearch, you can use the "order" parameter in the aggregation definition.

Here is an example using the "terms" aggregation:

GET /my_index/_search
{
  "size": 0,
  "aggs": {
    "my_agg": {
      "terms": {
        "field": "my_field",
        "order": {
          "my_metric": "desc"
        }
      },
      "aggs": {
        "my_metric": {
          "avg": {
            "field": "my_numeric_field"
          }
        }
      }
    }
  }
}

In this example, the "terms" aggregation groups documents by the "my_field" field and calculates the average of the "my_numeric_field" field for each group using the "avg" aggregation. The "order" parameter sorts the groups in descending order based on the average calculated by the "my_metric" aggregation.

You can adjust the sorting order by changing the "desc" parameter to "asc" if you want to sort in ascending order. You can also sort based on other metrics or fields by changing the value of the "my_metric" parameter in the "order" parameter.

댓글

이 블로그의 인기 게시물

Using the MinIO API via curl

How to split a list into chunks of 100 items in JavaScript, 자바스크립트 리스트 쪼개기

HTML Inline divisions at one row by Tailwind

Boilerplate for typescript server programing

가속도 & 속도

Gradle multi-module project

How to checkout branch of remote git, 깃 리모트 브랜치 체크아웃

CDPEvents in puppeteer

Sparse encoder

Reactjs datetime range picker