如何将Elasticsearch查询转换为聚合Builder

Question

我正在尝试使用Elasticsearch编写查询，其中响应应为具有其他字段条件的列的总和。我能够使用Elasticsearch查询来完成此操作，但无法做到的是在Elasticsearch API中使用Elasticsearch gentregationBuilder。有人请帮助我在Elasticsearch API中编写代码，如以下附加查询吗？

{
   "query": {
    "bool": {
      "must": [
        {
          "match": {
            "customerId": "13b7e2e8-8bf0-435b-b7f7-949c2e69b1d7"
          }
        }
      ],
      "must_not": [
        {
          "match": {
            "state": "Cancelled"
          }
        }
      ],
      "should": []
    }
  },
  "aggs": {
    "totalStakes": {
      "sum": {
        "field": "totalStake"
      }
    }
  }
}

我已经尝试了以下代码，但没有预期的工作。

AggregationBuilder sumOfTotalStake = AggregationBuilders.sum("totalStake").field("totalStake");
        BoolQueryBuilder bqb = boolQuery().mustNot(termQuery("state", "Cancelled").must(termQuery("customerId", "13b7e2e8-8bf0-435b-b7f7-949c2e69b1d7")));
        // create the filter aggregation and add the sub-aggregation
        FilterAggregationBuilder aggregation = AggregationBuilders.filter("totalStakes", bqb)
                .subAggregation(sumOfTotalStake);

预期结果应低于格式：

{
  "took": 3,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 10,
    "max_score": 4.3412046,
    "hits": []
  },
  "aggregations": {
    "totalStakes": {
      "value": 65579
    }
  }
}

Answer 1

您可以在Java中使用以下代码。该代码在ES 7.X版本中，但相同或使用较小的更改将起作用。

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

BoolQueryBuilder qb = QueryBuilders.boolQuery()
                .must(QueryBuilders.matchQuery("customerId", "13b7e2e8-8bf0-435b-b7f7-949c2e69b1d7"))
                .mustNot(QueryBuilders.matchQuery("state", "Cancelled"));

searchSourceBuilder.query(qb);

AggregationBuilder ab = AggregationBuilders.sum("totalStakes").field("totalStake");
searchSourceBuilder.aggregation(ab);

searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);

更新：

您可以设置size param to 0获得预期结果。您可以保持上述代码，并且它将仅返回聚合输出。

searchSourceBuilder.size(0);