Elasticsearch - Query field against aggregation

Question

I am exploring the ease of querying and aggregating the data using elasticsearch. But i am not able to pivot and aggregate the data in a single query as below:

Considering the data:

Is there a way to query the below result that pivots and aggregates the value as below:

Required Result:

{  
   {  
      "A":a1,
      "B":b1,
      "Value":3
   },
   {  
      "A":a1,
      "B":b2,
      "Value":3
   },
   {  
      "A":a2,
      "B":b2,
      "Value":4
   },
   {  
      "A":a1,
      "B":b3,
      "Value":11
   }
}

Val · Accepted Answer · 2018-11-19 06:38:09Z

1

Yes, you can nest two terms aggregations for A and B, like this, and you'll get exactly the results you expect:

{
  "size": 0,
  "aggs": {
    "A": {
      "terms": {
        "field": "A"
      },
      "aggs": {
        "B": {
          "terms": {
            "field": "B"
          },
          "aggs": {
            "value_sum": {
              "sum": {
                "field": "Value1"
              }
            }
          }
        }
      }
    }
  }
}

edited Nov 19, 2018 at 6:38

answered Nov 14, 2018 at 13:08

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gowtham Over a year ago

Thanks Val. It worked exactly. Just had to add a label to the Sum.

Collectives™ on Stack Overflow

Elasticsearch - Query field against aggregation

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related