如何在java中生成弹性搜索嵌套聚合？

Question

我有以下聚合查询，我需要将其转换为java

下面的聚合查询需要使用elastic search client RestHighLevelCleint转换为java，我不确定我尝试了多次，但java代码无法按照下面的查询进行转换。

{
  "aggs": {
    "recommendations": {
      "nested": {
        "path": "events.recommendationData"
      },
      "aggs": {
        "exception": {
          "filter": {
            "terms": {
              "events.recommendationData.exceptionId": [
                "2"
              ]
            }
          },
          "aggs": {
            "exceptionIds": {
              "terms": {
                "field": "events.recommendationData.exceptionId.keyword",
                "size": 10
              },
              "aggs": {
                "recommendations": {
                  "nested": {
                    "path": "events.recommendationData.recommendations"
                  },
                  "aggs": {
                    "recommendationType": {
                      "terms": {
                        "field": "events.recommendationData.recommendations.recommendationType",
                        "size": 10
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

在RestHighLevelClient中使用以下代码

AggregationBuilder recommendations =
                AggregationBuilders.nested("recommendations", "events.recommendationData");

        AggregationBuilder exception = AggregationBuilders
                    .filter("exception", QueryBuilders.termsQuery("events.recommendationData.exceptionId", "2"));

        AggregationBuilder exceptionIds = AggregationBuilders.terms("exceptionIds")
                .field("events.recommendationData.exceptionId.keyword").size(10);

        AggregationBuilder recommendations2 =
                AggregationBuilders.nested("recommendations", "events.recommendationData.recommendations");

        AggregationBuilder recommendationType = AggregationBuilders.terms("recommendationType")
                .field("events.recommendationData.recommendations.recommendationType").size(10);

        AggregationBuilder build = 
                recommendations
                        .subAggregation(exception)
                        .subAggregation(exceptionIds)
                        .subAggregation(recommendations2)
                        .subAggregation(recommendationType);

它产生了错误的查询，就像我在下面发布的那样，这是不起作用的。

{
  "aggregations": {
    "recommendations": {
      "nested": {
        "path": "events.recommendationData"
      },
      "aggregations": {
        "exception": {
          "filter": {
            "terms": {
              "events.recommendationData.exceptionId": [
                "1",
                "2"
              ],
              "boost": 1
            }
          }
        },
        "exceptionIds": {
          "terms": {
            "field": "events.recommendationData.exceptionId.keyword",
            "size": 10,
            "min_doc_count": 1,
            "shard_min_doc_count": 0,
            "show_term_doc_count_error": false,
            "order": [
              {
                "_count": "desc"
              },
              {
                "_key": "asc"
              }
            ]
          }
        },
        "recommendations": {
          "nested": {
            "path": "events.recommendationData.recommendations"
          }
        },
        "recommendationType": {
          "terms": {
            "field": "events.recommendationData.recommendations.recommendationType",
            "size": 10,
            "min_doc_count": 1,
            "shard_min_doc_count": 0,
            "show_term_doc_count_error": false,
            "order": [
              {
                "_count": "desc"
              },
              {
                "_key": "asc"
              }
            ]
          }
        }
      }
    }
  }
}

Answer 1

预期:每个聚合都是前一个聚合的子聚合。

因此，如果您看到预期的查询，则recommendationType是recommendations2的子聚合。这些都是对exceptionIds的子聚合，依此类推。因此，这里只需要更改一行代码，而不是

 AggregationBuilder build = 
                recommendations
                        .subAggregation(exception)
                        .subAggregation(exceptionIds)
                        .subAggregation(recommendations2)
                        .subAggregation(recommendationType);

使用这个，

recommendations.subAggregation(
        exception.subAggregation(
            exceptionIds.subAggregation(
                recommendations2.subAggregation(recommendationType)
            )
        )
    );