Elasticsearch nested aggregation with JAVA

Question

How to create the following nested agg query with ES JAVA API

Let's say my query is looking like the following :

 GET /agg_vitaly_test_api_2016-11-01/_search
    {
     "size": 0,
     "query": {
          "range": {
            "time": {
              "gte": "1477962000000",
              "lte": "1477965600000"
            }
          }
     },
      "aggs" : {
           "group_by_time" : {
               "date_histogram" : {
                   "field" : "time",
                   "interval" : "hour"
               },

               "aggs": {
                 "sum_player_load": {
                   "sum": {
                     "field": "playerload"
                   }
                 }
           }
       }
    }

the java code should be somethink like this :

SearchRequestBuilder searchRequestBuilder = FETCH_CLIENT.prepareSearch().setIndices(indexName).setTypes(pixelType.getType()).setSize(0);

           // here need to complete the nested aggregation....
            AggregationBuilder aggb = addAggregation(groupBy);

         searchRequestBuilder.addAggregation(aggb);

  // ....
 SearchResponse res = searchRequestBuilder.execute().actionGet();

please any suggestions ? :)

BR

Nishant · Accepted Answer · 2016-11-08 06:51:04Z

3

Your addAggregation method would be like:

public AggregationBuilder addAggregation(){
        return AggregationBuilders.dateHistogram("group_by_time").field("time").interval(DateHistogram.Interval.HOUR)
                                                                        .subAggregation(AggregationBuilders.sum("sum_player_load").field("playerload"));
}

answered Nov 8, 2016 at 6:51

Nishant

4582 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch nested aggregation with JAVA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related