elasticsearch聚合搜索

1 select count(*) as num from tableName groupby class_id having num > 50000

{
  "query": {
    "bool": {
      "must": [],
      "must_not": [],
      "should": []
    }
  },
  "aggs": {
    "AsClassName": {
      "terms": {
        "field": "class_id",
        "order": {
          "_count": "desc"
        },
        "min_doc_count": 40000
      }
    }
  },
  "from": 0,
  "size": 20,
  "sort": [],
  "facets": {}
}