elasticsearch Get aggregations in Java

Question

How can I get the aggregations of a query in Java?

This is my query:

GET my_dataset/document/_search
     {
        "query": {
             "match": {
                 "docId": "1"
            }
        },
        "aggs": {
            "text": {
                "avg": {
                    "script": "doc['text'].values.size()" 
               }
            }
        }
     }

This is the output that I get

..
},
  "aggregations": {
    "text": {
      "value": 32
    }
  }

How can I get the value 32? I am trying the following with no success

response.getAggregations().getValue("text");

This is how I build the query in Java and get the response

  XContentBuilder aggregationBuilder = XContentFactory.jsonBuilder();
        aggregationBuilder.startObject()
               .startObject("query")
               .startObject("match")
               .field("docId", docID)
               .endObject()
               .endObject()
               .startObject("aggs")
               .startObject("text")
               .startObject("max")
               .field("script", "doc['text'].values.size()")
               .endObject()
               .endObject()
               .endObject()
               .endObject();

                SearchResponse response = client.prepareSearch("my_dataset").setTypes("document")
                                        .setSource(aggregationBuilder)
                                        .execute()
                                        .actionGet();

This is the response that I got while debugging

Can you show how you're building your query in Java? Can you try response.getAggregations().get("text").get("value");? — Val
– Val, Commented May 27, 2016 at 3:24
get() is not a valid method for the aggregation. get("value") gives that error before compiling. — nabrugir
– nabrugir, Commented May 27, 2016 at 3:31
Fair enough. If you set a breakpoint after the query has run, what do you see in the response.getAggregations() object? — Val
– Val, Commented May 27, 2016 at 3:34
Solved. It is response.getAggregations().get("text").getProperty("value") — nabrugir
– nabrugir, Commented May 27, 2016 at 4:17

nabrugir · Accepted Answer · 2016-06-10 18:17:16Z

1

The solution that worked is

response.getAggregations().get("text").getProperty("value")

getProperty("value") has to be used instead of getValue().

edited Jun 10, 2016 at 18:17

answered May 27, 2016 at 4:18

nabrugir

1,8892 gold badges22 silver badges39 bronze badges

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

1 Comment

Martin Frank Over a year ago

can you please explain, why you propose this solution? the question is very nice formulated and it seems a bit trivial to post such a bare answer (i'm pretty sure it's the right answer, but let us know why and how it helps with the problem mentioned)

JVXR · Accepted Answer · 2016-05-26 22:24:23Z

0

Can you try

response.getAggregations().get("text").getValue();

answered May 26, 2016 at 22:24

JVXR

1,3221 gold badge11 silver badges20 bronze badges

6 Comments

JVXR Over a year ago

Which version of ES client are you using ?

nabrugir Over a year ago

It is the version 2.3.3

JVXR Over a year ago

static.javadoc.io/org.elasticsearch/elasticsearch/2.3.3/org/… if you are using the 2.3.3 lib the get("text") must not complain , also change the last call to getProperty static.javadoc.io/org.elasticsearch/elasticsearch/2.3.3/org/…

nabrugir Over a year ago

get("text") does not complain but doesnt give me the value. getProperty() does not compile, same as getValue();

JVXR Over a year ago

OK, so what does get("text").getProperty("value") give you back ?

|

Fuad Efendi · Accepted Answer · 2016-08-09 19:02:58Z

0

See https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/_metrics_aggregations.html

Example:

import org.elasticsearch.search.aggregations.metrics.avg.Avg;
...
Avg avg = searchResponse.getAggregations().get("text");
double value = avg.getValue();

Tested with version 2.3.3.

edited Aug 9, 2016 at 19:02

answered Aug 5, 2016 at 20:14

Fuad Efendi

1471 silver badge9 bronze badges

Collectives™ on Stack Overflow

elasticsearch Get aggregations in Java

3 Answers 3

1 Comment

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related