Count distinct values using elasticsearch Count distinct values using elasticsearch elasticsearch elasticsearch

Count distinct values using elasticsearch


You have to use cardinality option as mentioned by @coder that you can find in the doc

$ curl -XGET "http://localhost:9200/store/item/_search" -d'{"aggs" : {    "restaurant_count" : {        "cardinality" : {            "field" : "RestaurantName",            "precision_threshold": 100,             "rehash": false             }          }         }}'

This worked for me ...


There's no support for distinct counting in ElasticSearch, although non-deterministic counting exists. Use "terms" aggregation and count buckets in result. See Count distinct on elastic search question.