Elastis 如何只获取date_histogram聚合结果的前两个

Question

 "aggs": {
    "group_by_category1": {
      "terms": {
        "field": "merchandise.Level1.keyword"
      },
      "aggs": {
        "group_by_category3": {
          "terms": {
            "field": "merchandise.Level3.keyword"
          },
          "aggs": {
            "group_by_createdDate": {
              "date_histogram": {
                "field": "createdDate",
                "interval": "1d",
                "time_zone": "+08:00",
                "format": "yyyy-MM-dd",
                "min_doc_count": 1,
                "order": {
                  "_key": "desc"
                }
              },
              "aggs": {
                "avg_price": {
                  "avg": {
                    "field": "merchandise.unitPrice"
                  }
                }
              }
            }
          }
        }
      }
    }
  }

Answer 1

使用size来指定返回几个，参考：

elasticsearch对聚合后的结果进行范围筛选_西凉的悲伤博客-CSDN博客 书接上文，上一篇文章写了elasticsearch对聚合后的结果排序这一篇写对聚合后的范围筛选。一般的我们可以在query或filter里使用range进行范围筛选查询，但是我们在聚合里怎么对聚合后的结果筛选出符合范围的聚合结果呢？dsl语句如下： "aggregations": { "statistics_assets": { "terms": { "field": "one_account.one_account_no", "size": https://blog.csdn.net/qq_33697094/article/details/109820024