ELASTICSERCH-Inner_hits集計

Question

{"wildcare"：{"data.addresses.ces.cp"： "maria *"}、{"macth"：{"data.addresses.ces.direction"： "rodriguez"の集計を実行しようとしています}}フィールドですが、クエリの結果は返されません。

{ "_source": "created_at",
      "size": 1, 
      "sort": [
        {
          "created_at.keyword": {
            "order": "desc"
          }
        }
      ], 
      "query": {
        "nested": {
          "path": "data.addresses",
          "inner_hits": {
          },
          "query": {
            "nested": {
              "path": "data.addresses.ces",
              "query": 
                  {"wildcare": {"data.addresses.ces.cp": "maria*"},
                  {"macth": { "data.addresses.ces.direction": "rodriguez"}}
              }
            }
          }
        }
      }

JSONのすべての値ではなく、クエリの値を返す集計を実行するにはどうすればよいですか？集計がinner_hitsをサポートしていない場合、どうすればワイルドケアとmacthをagggで取得できますか？

Answer 1

選択したネストされたドキュメントでのみ集計が実行されるように、集計部分でフィルター条件を繰り返す必要があります。

{
  "_source": "created_at",
  "size": 1,
  "sort": [
    {
      "created_at.keyword": {
        "order": "desc"
      }
    }
  ],
  "query": {
    "nested": {
      "path": "data.addresses",
      "inner_hits": {},
      "query": {
        "nested": {
          "path": "data.addresses.ces",
          "query": {
            "bool": {
              "filter": [
                {
                  "wildcard": {
                    "data.addresses.ces.cp": "maria*"
                  }
                },
                {
                  "match": {
                    "data.addresses.ces.direction": "rodriguez"
                  }
                }
              ]
            }
          }
        }
      }
    }
  },
  "aggs": {
    "addresses": {
      "nested": {
        "path": "data.addresses"
      },
      "aggs": {
        "ces": {
          "nested": {
            "path": "data.addresses.ces"
          },
          "aggs": {
            "query": {
              "filter": {
                "bool": {
                  "filter": [
                    {
                      "wildcard": {
                        "data.addresses.ces.cp": "maria*"
                      }
                    },
                    {
                      "match": {
                        "data.addresses.ces.direction": "rodriguez"
                      }
                    }
                  ]
                }
              },
              "aggs": {
                "cp": {
                  "terms": {
                    "field": "data.addresses.ces.cp"
                  }
                },
                "direction": {
                  "terms": {
                    "field": "data.addresses.ces.direction"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}