Getting aggregated value using ElasticsearchTemplate and aggregators

Question

I am having problems extracting the aggregated value.

configuration is spring with spring-boot-starter-data-elasticsearch.

Document user indexed multiples times in database.

I want to return sum of fields 'commentsCnt'

@Autowired
ElasticsearchTemplate elasticsearchTemplate;

SearchQuery searchQuery = new NativeSearchQueryBuilder()
    .withIndices("comment")             
    .withQuery(matchQuery("user", userName))       
    .addAggregation(AggregationBuilders.sum("sum_of_comments").field("commentsCnt"))
    .build();

Aggregations aggregations = elasticsearchTemplate.query(searchQuery, 
        new ResultsExtractor<Aggregations>() {
            @Override
            public Aggregations extract(SearchResponse response) {
                return response.getAggregations();
        }
});

Aggregation ret = aggregations.get("sum_of_comments");

How to extract the value? Maybe there is a better approach?

YerivanLazerev · Accepted Answer · 2018-07-12 12:45:15Z

1

    for (Aggregation aggs : aggregations) {

         Sum sum = (Sum) aggs;
         double sumValue = sum.getValue();
          System.out.println("sumValue=" + sumValue);
  }

answered Jul 12, 2018 at 12:45

YerivanLazerev

3754 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Getting aggregated value using ElasticsearchTemplate and aggregators

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related