GET /bank/_search { "size": 0, "aggs": { "group_by_state": { "terms": { "field": "state.keyword" } } } }
SQLでは、上記の集約は次の考え方と類似しています。
SELECT state, COUNT(*) FROM bank GROUP BY state ORDER BY COUNT(*) DESC
GET /bank/_search { "size": 0, "aggs": { "group_by_state": { "terms": { "field": "state.keyword" } } } }
SQLでは、上記の集約は次の考え方と類似しています。
SELECT state, COUNT(*) FROM bank GROUP BY state ORDER BY COUNT(*) DESC