如何将返回的文档划分为fix数量的Elasticsearch中的存储库

Question

我有一个问题，我认为对Google来说很简单，但找不到答案。

我有一个具有可选字段价格的文章索引索引。

我想创建一个聚合，将所有与查询匹配的查询与这些属性匹配的查询的文章：

• price = 0的所有项目的存储桶
• >所有项目的固定数量的存储桶代码>价格＆GT; 0 （例如10），可能包含一个范围。

为了了解理想结果，鉴于价格为0到2000不等的搜索返回项目，聚合的结果可能是：

[
   {"from": 0, "to": 0, "doc_count": 100},
   {"from": 1, "to": 200, "doc_count": 23},
   {"from": 201, "to": 400, "doc_count": 11},
   {"from": 401, "to": 600, "doc_count": 23},
   {"from": 601, "to": 800, "doc_count": 120},
   {"from": 801, "to": 1000, "doc_count": 1100},
   {"from": 1001, "to": 1200, "doc_count": 25},
   {"from": 1201, "to": 1400, "doc_count": 12},
   {"from": 1401, "to": 1600, "doc_count": 24},
   {"from": 1601, "to": 1800, "doc_count": 42},
   {"from": 1801, "to": 2000, "doc_count": 52}
]

我已经研究了直方图 cartregation，但它专注于固定的间隔而不是固定数量的存储桶，我找不到一种用price = 0隔离项目的方法。

{
  "aggs": {
    "price": {
      "histogram": {
        "field": "price",
        "interval": 2500.0
      }
    }
  },
  "query": {
    "match_all": {}
  },
  "size": 0
}

通过一些后端处理，我能够获得以下结果，

[
  {
    "Key": {
      "From": 0,
      "To": 2499
    },
    "Items": 139
  },
  {
    "Key": {
      "From": 2500,
      "To": 4999
    },
    "Items": 17
  },
  {
    "Key": {
      "From": 5000,
      "To": 7499
    },
    "Items": 7
  },
  {
    "Key": {
      "From": 7500,
      "To": 9999
    },
    "Items": 2
  },
  {
    "Key": {
      "From": 10000,
      "To": 12499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 12500,
      "To": 14999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 15000,
      "To": 17499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 17500,
      "To": 19999
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 20000,
      "To": 22499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 22500,
      "To": 24999
    },
    "Items": 2
  },
  {
    "Key": {
      "From": 25000,
      "To": 27499
    },
    "Items": 2
  },
  {
    "Key": {
      "From": 27500,
      "To": 29999
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 30000,
      "To": 32499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 32500,
      "To": 34999
    },
    "Items": 2
  },
  {
    "Key": {
      "From": 35000,
      "To": 37499
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 37500,
      "To": 39999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 40000,
      "To": 42499
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 42500,
      "To": 44999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 45000,
      "To": 47499
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 47500,
      "To": 49999
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 50000,
      "To": 52499
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 52500,
      "To": 54999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 55000,
      "To": 57499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 57500,
      "To": 59999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 60000,
      "To": 62499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 62500,
      "To": 64999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 65000,
      "To": 67499
    },
    "Items": 1
  },
  {
    "Key": {
      "From": 67500,
      "To": 69999
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 70000,
      "To": 72499
    },
    "Items": 0
  },
  {
    "Key": {
      "From": 72500,
      "To": 74999
    },
    "Items": 2
  },
  {
    "Key": {
      "From": 75000,
      "To": null
    },
    "Items": 1
  }
]

我还使用range聚合丢弃了，因为它需要通过其边界定义定义明确的存储桶。

我希望我对自己要实现的目标和尝试的目标有足够的背景。

谢谢。

编辑：添加了有关range聚合的段落。

Answer 1

范围聚合将允许您创建价格范围，因此您将拥有想要

https://www.elastic.co/guide/guide/en/elasticsearch/reference/reference/reference/current/current/search-aggregations-bucket-bucket-bucket-range-aggregation.html

{
  "aggs": {
    "price": {
      "range": {
        "field": "price",
        "ranges": [
          { "from": 0.0, "to": 1.0 },
          { "from": 1.0, "to": 10.0 },
          { "from": 10.0, "to": 20.0 },
          { "from": 20.0 }
        ]
      }
    }
  }, 
  "size": 0
}