Elasticsearch aggs分类统计汇总

PUT cars 
POST _bulk
{"index":{"_index":"cars","_id":"1"}}
{"model":"A","color":"red"}
{"index":{"_index":"cars","_id":"2"}}
{"model":"A","color":"white"}
{"index":{"_index":"cars","_id":"3"}}
{"model":"A","color":"black"}
{"index":{"_index":"cars","_id":"4"}}
{"model":"A","color":"yellow"}
{"index":{"_index":"cars","_id":"5"}}
{"model":"B","color":"red"}
{"index":{"_index":"cars","_id":"6"}}
{"model":"B","color":"white"}
{"index":{"_index":"cars","_id":"7"}}
{"model":"C","color":"black"}
{"index":{"_index":"cars","_id":"8"}}
{"model":"C","color":"red"}
{"index":{"_index":"cars","_id":"9"}}
{"model":"C","color":"white"}
{"index":{"_index":"cars","_id":"10"}}
{"model":"C","color":"yellow"}
{"index":{"_index":"cars","_id":"11"}}
{"model":"C","color":"blue"}
{"index":{"_index":"cars","_id":"12"}}
{"model":"D","color":"red"}
{"index":{"_index":"cars","_id":"13"}}
{"model":"A","color":"red"}

SELECT model,COUNT(DISTINCT color) color_count 
FROM cars 
GROUP BY model 
HAVING color_count > 1 
ORDER BY color_count desc LIMIT 2;

GET cars/_search
{
  "size": 0,
  "aggs": {
    "aggmodels": {
      "terms": {
        "field": "model.keyword"
      },
      "aggs": {
        "color_count": {
          "cardinality": {
            "field": "color.keyword"
          }
        },
        "color_count_filter": {
          "bucket_selector": {
            "buckets_path": {
              "colorcount": "color_count"
            },
            "script": "params.colorcount>1"
          }
        },
        "color_count_sort": {
          "bucket_sort": {
            "sort": {
              "color_count": "desc"
            },
            "size": 2
          }
        }
      }
    }
  }
}