Multiple average aggregations in elasticsearch Java API

Question

Is there a Java code equivalent to this sub aggregation. I need Java code to build the sub aggregation object.

{
  "query": {
    "SOME BOOL QUERIES HERE"
  },
 "aggs" : {
        "trs_timestamp" : {
            "date_histogram" : {
                "field" : "trs_timestamp",
                "interval" : "day"
            },
        "aggs" : {
                "AvgTT" : { "avg" : { "field" : "action_time" }},
                "AvgST" : { "avg" : { "field" : "st" }},
                "AvgCALC" : { "avg" : { "field" : "ncalc" }},
                "AvgRC" : { "avg" : { "field" : "rc" }},
                "AvgFR" : { "avg" : { "field" : "st" }}
            }
        }
    } 
}

Darshan Mehta · Accepted Answer · 2019-02-07 09:34:03Z

2

You can use Elasticsearch Java API and AggregationBuilders for this, e.g.:

SearchResponse response = client.prepareSearch()
        .addAggregation(AggregationBuilders.avg("AvgTT").field("action_time"))
        .addAggregation(AggregationBuilders.avg("AvgST").field("st"))
        .addAggregation(AggregationBuilders.avg("AvgCALC").field("ncalc"))
        .addAggregation(AggregationBuilders.avg("AvgRC").field("rc"))
        .addAggregation(AggregationBuilders.avg("AvgFR").field("st"))
        .execute()
        .actionGet();

answered Feb 7, 2019 at 9:34

Darshan Mehta

31k14 gold badges75 silver badges111 bronze badges

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

Comments

Antoniossss · Accepted Answer · 2019-02-07 09:32:58Z

0

By example:

SearchResponse sr = node.client().prepareSearch()
        .setQuery( /* your query */ )
        .addAggregation( /* add an aggregation */ )
        .execute().actionGet();

You can see that there is addAggregation not set implying that you can add multiple aggregations to a query. https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/java-aggs.html

answered Feb 7, 2019 at 9:32

Antoniossss

32.7k7 gold badges67 silver badges119 bronze badges

Collectives™ on Stack Overflow

Multiple average aggregations in elasticsearch Java API

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related