search - 在Elasticsearch中按子项聚合过滤父项

Question

我在ES映射中有一个父子关系，我想通过其子项的聚合值(avg)过滤父项。也就是说，我只想检索该值在给定范围内的 parent 。

我试图用aggs和post-filters来做到这一点，但无法使其正常工作。

{
  "apartments" : {
    "mappings" : {
      "apartment_availability" : {
        "_parent" : {
          "type" : "apartment"
        },
        "_routing" : {
          "required" : true
        },
        "properties" : {
          "availability_date" : {
            "type" : "date"
          },
          "apartment_id" : {
            "type" : "long"
          },
          "id" : {
            "type" : "long"
          },
          "price_cents" : {
            "type" : "long"
          },
          "status" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          }
        }
      },
      "apartment" : {
        "properties" : {
          "id" : {
            "type" : "long"
          },
        }
      }
    }
  }
}

如果oru用户选择3月24日至3月31日之间的某个时段，且价格范围在€150-€300之间，那么我们想向他们显示该时段内所有免费的公寓，并且该时段内的平均价格在€150- €300欧元范围。

到目前为止，这里是:

{
  "query": {
    "bool": {
      "filter": {
        "bool": {
          "must": [{
            "has_child": {
              "type": "apartment_availability",
              "min_children": 8,
              "max_children": 8,
              "query": {
                "bool": {
                  "must": [{
                    "term": {
                      "status": "available"
                    }
                  }, {
                    "range": {
                      "availability_date": {
                        "gte": "2017-03-24",
                        "lte": "2017-03-31"
                      }
                    }
                  }]
                }
              }
            }
          }]
        }
      }
    }
  }
}

Answer 1

我的建议是，使用bucket_selector聚合在公寓之间进行选择:

GET /apartments/apartment/_search
{
  "query": {
    "bool": {
      "filter": {
        "bool": {
          "must": [
            {
              "has_child": {
                "type": "apartment_availability",
                "query": {
                  "bool": {
                    "must": [
                      {
                        "term": {
                          "status": "available"
                        }
                      },
                      {
                        "range": {
                          "availability_date": {
                            "gte": "2017-04-01",
                            "lte": "2017-04-03"
                          }
                        }
                      }
                    ]
                  }
                }
              }
            }
          ]
        }
      }
    }
  },
  "aggs": {
    "apartments_ids": {
      "terms": {
        "field": "id",
        "size": 10
      },
      "aggs": {
        "avails": {
          "children": {
            "type": "apartment_availability"
          },
          "aggs": {
            "filter_avails": {
              "filter": {
                "bool": {
                  "must": [
                    {
                      "term": {
                        "status": "available"
                      }
                    },
                    {
                      "range": {
                        "availability_date": {
                          "gte": "2017-04-01",
                          "lte": "2017-04-03"
                        }
                      }
                    }
                  ]
                }
              },
              "aggs": {
                "average": {
                  "avg": {
                    "field": "price_cents"
                  }
                }
              }
            }
          }
        },
        "avg_bucket_filter": {
          "bucket_selector": {
            "buckets_path": {
              "avg": "avails>filter_avails.average"
            },
            "script": "params.avg > 150 && params.avg < 300"
          }
        }
      }
    }
  }
}