elasticsearch - 嵌套聚合查询中的嵌套聚合

Question

在Elastic Search 7.1中拥有以下(缩写)文档。专注于questions.influencerReponse.selectAllThatApplyResponses路径。

{
  "questions": [
    {
      "questionId": "79cfc6e7-731e-4d83-9dd6-82f4f39fff03",
      "questionKind": "select_all_that_apply",
      "questionText": "Have you heard of any of the following charities?",
      "questionOptions": {
        "1": "Plan International",
        "2": "Young Women's Trust",
        "3": "Women For Refugee Women",
        "4": "The FPA"
      },
      "influencerReponse": {
        "questionId": "79cfc6e7-731e-4d83-9dd6-82f4f39fff03",
        "questionKind": "select_all_that_apply",
        "text": null,
        "questionOrder": 3,
        "order": null,
        "shortAnswerResponse": null,
        "viewerSentimentResponse": null,
        "yesNoResponse": null,
        "selectAllThatApplyResponses": [
          {
            "key": "2",
            "value": "Young Women's Trust"
          }
        ]
      }
    }
  ]
}

我想获取键或值的术语集合，两者均为关键字类型。我以前做到了这一点，但没有达到 selectAllThatApplyResponses嵌套类型的级别。

这是到目前为止，我抛出以下错误。

{
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "sponsorshipId": {
                            "value": "33c7140f-23ae-46f2-a0fe-49e2251114e4"
                        }
                    }
                }
            ]
        }
    },
    "track_total_hits": true,
    "size": 0,
    "aggs": {
        "select_all_that_apply_responses": {
            "nested": {
                "path": "questions"
            },
            "aggs": {
                "filter_types": {
                    "filter": {
                        "bool": {
                            "must": [
                                {
                                    "match": {
                                        "questions.questionId": "79cfc6e7-731e-4d83-9dd6-82f4f39fff03"
                                    }
                                }
                            ]
                        }
                    },
                    "aggs": {
                        "select_all_that_apply_nested": {
                            "nested": {
                                "path": "questions.influencerReponse.selectAllThatApplyResponses"
                            },
                            "aggs": {
                                "terms": {
                                    "field": "questions.influencerReponse.selectAllThatApplyResponses.key"
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

我收到以下错误。

{
    "error": {
        "root_cause": [
            {
                "type": "parsing_exception",
                "reason": "Expected [START_OBJECT] under [field], but got a [VALUE_STRING] in [terms]",
                "line": 42,
                "col": 46
            }
        ],
        "type": "parsing_exception",
        "reason": "Expected [START_OBJECT] under [field], but got a [VALUE_STRING] in [terms]",
        "line": 42,
        "col": 46
    },
    "status": 400
}

Answer 1

最后的terms agg也需要一个名称-我称它为select_all_that_apply_nested_terms。

...

  "select_all_that_apply_nested":{
    "nested":{
      "path":"questions.influencerReponse.selectAllThatApplyResponses"
    },
    "aggs":{
      "select_all_that_apply_nested_terms":{
        "terms":{
          "field":"questions.influencerReponse.selectAllThatApplyResponses.key"
        }
      }
    }
  }

...