聚合某个字段，后获取其发帖天数最多的前两个

PUT my_index_009

{

  "mappings": {

    "properties": {

      "name": {

        "type": "text",

        "fields": {

          "keyword": {

            "type": "keyword"

          }

        }

      },

      "publish_time": {

        "type": "date"

      }

    }

  }

}



POST my_index09/_bulk

{"index":{"_id":1}}

{"name":"张三","publish_time":"2020-05-01" }

{"index":{"_id":2}}

{"name":"李四","publish_time":"2020-05-02" }

{"index":{"_id":3}}

{"name":"王五","publish_time":"2020-05-03" }

{"index":{"_id":4}}

{"name":"张三","publish_time":"2015-05-02" }

{"index":{"_id":5}}

{"name":"张三","publish_time":"2015-05-03" }

{"index":{"_id":6}}

{"name":"李四","publish_time":"2015-05-04" }

{"index":{"_id":7}}

{"name":"王五","publish_time":"2015-05-05" }

{"index":{"_id":8}}

{"name":"张三","publish_time":"2015-05-04" }



POST my_index09/_search

{

  "size": 0,

  "aggs": {

    "name_aggs": {

      "terms": {

        "field": "name.keyword",

        "shard_size":10,

        "size": 2

      },

      "aggs": {

        "date_aggs": {

          "value_count": {

            "field": "publish_time"

          }

        }

      }

    }

  }

}