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