Implement Elasticsearch aggregation and sort query using Java API and sort based on reversed

Question

I have an Elasticsearch nested aggregation query(below), that I am trying to implement in Java using the Elasticsearch Java API. The query counts keywords and sorts using the reversed_nested _count. The query works in dev tools and partly Java, the only I can not sort using the Java API using the reversed_count.

GET products/_search
{
  "size": 0,
  "aggs": {
    "products": {
      "nested": {
        "path": "affectedProducts.seller"
      },
      "aggs": {
        "filtered_nestedobjects": {
          "filter": {
            "term": {
              "affectedProducts.seller.onOrWith": false
            }
          },
          "aggs": {
            "filter_products": {
              "terms": {
                "field": "affectedProducts.seller.vendor.keyword",
                "order": {
                  "reversed_count": "desc"
                }
              },
              "aggs": {
                "reversed_count": {
                  "reverse_nested": {}
                }
              }
            }
          }
        }
      }
    }
  }
}

How can I implement using the java API to sort using reversed_count? I have tried using BucketOrder.count button working.

Please help.

Thanks

  public SearchRequest createSearchRequest() {
    final NestedAggregationBuilder vendor;
    vendor = nested("products_count", "affectedProducts.seller")
        .subAggregation(filter("running", termQuery("affectedProducts.seller.onOrWith", false))
            .subAggregation(terms("filter_products").field("affectedProducts.seller.vendor.keyword").order(BucketOrder.count(false)))
            .subAggregation(reverseNested("vendors_reverse")));

    return searchRequest("products")
        .aggregation(
            global(AGG)
                .subAggregation(vendor)
        )
//        .sort(new Sortable().setSort("_count"))
        .page(limitTo(0))
        .build();
  }

ES Version: 7.10.6

Are you using HLRC?

rabbitbr
– rabbitbr

2022-08-03 12:25:11 +00:00
Commented Aug 3, 2022 at 12:25 — rabbitbr
– rabbitbr, Commented Aug 3, 2022 at 12:25

rabbitbr · Accepted Answer · 2022-08-03 12:36:47Z

1

I believe the error is that the reversed_count subAggs must be subaggregation of filter_products.

   final NestedAggregationBuilder vendor;
    vendor = nested("products_count", "affectedProducts.seller")
        .subAggregation(filter("filtered_nestedobjects", termQuery("affectedProducts.seller.onOrWith", false))
            .subAggregation(terms("filter_products").field("affectedProducts.seller.vendor.keyword")
                .order(BucketOrder.aggregation("reversed_count", false))
                .subAggregation(reverseNested("reversed_count"))));

    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    SearchRequest searchRequest = new SearchRequest("products");
    searchSourceBuilder.aggregation(vendor);
    searchRequest.source(searchSourceBuilder);

answered Aug 3, 2022 at 12:36

rabbitbr

3,2812 gold badges8 silver badges20 bronze badges

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

1 Comment

Denis Kisina Over a year ago

Thanks @rabbitbr the reversed_count subAgg was in the wrong place.

Collectives™ on Stack Overflow

Implement Elasticsearch aggregation and sort query using Java API and sort based on reversed

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related