Composite Aggregation in ElasticSearch Java

Question

I went through many articles to find any appropriate solution to add a Composite aggregation but did not find any relevant solution.

I have achieved it . See the answer, hope this will help.

score 4 · Answer 1 · answered Apr 09 '20 at 07:28

4

Here's the solution. Happy Coding ;)

List<CompositeValuesSourceBuilder<?>> sources = new ArrayList<>();

        sources.add(new TermsValuesSourceBuilder("aggregation_Name")
                                .field("field_Name"));
        sources.add(new TermsValuesSourceBuilder("aggregation_Name")
                .field("other_field"));
        CompositeAggregationBuilder compositeAggregationBuilder = new CompositeAggregationBuilder(
                "Composite_aggregation_Name", sources)
                        .size(10000);

answered Apr 09 '20 at 07:28

Chirag Gupta

115
1
7

Any idea how to achieve composite aggregation and subaggregation as a composite aggregation as well? – user461127 Dec 11 '20 at 04:34
@user461127 Posting an answer for you. May be it helps – Chirag Gupta May 07 '21 at 19:25

score 0 · Answer 2 · answered May 07 '21 at 19:26

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

        searchSourceBuilder
                .query(QueryBuilders.boolQuery()
                        .must(QueryBuilders
                                .queryStringQuery(filterPayload.getPayload().getModuleFilters().get(0).getValue()))
                        .must(QueryBuilders.termQuery("response.matching_rules_count", 1)))
                .aggregation(AggregationBuilders.terms("intent").field("request.qualificationData.intent.keyword")
                        .subAggregation(
                                AggregationBuilders.terms("rule").field("response.matchingRules.rule.ref.keyword"))
                        .subAggregation(AggregationBuilders.terms("statusCode").field("response.httpStatusCode"))
                        .size(1000000));

Here is the answer @user461127

Composite Aggregation in ElasticSearch Java

2 Answers2