Find distinct values, not distinct counts in elasticsearch

by

Use a terms aggregation on the color field. And you need to pay attention to how that field you want to get distinct values on is analyzed, meaning you need to make sure you’re not tokenizing it while indexing, otherwise every entry in the aggregation will be a different term that is part of the field content.

If you still want tokenization AND to use the terms aggregation you might want to look at not_analyzed type of indexing for that field, and maybe use multi fields.

Terms aggregation for cars:

GET /cars/transactions/_search?search_type=count
{
  "aggs": {
    "distinct_colors": {
      "terms": {
        "field": "color",
        "size": 1000
      }
    }
  }
}

More Related Contents:

  1. Shards and replicas in Elasticsearch
  2. no [query] registered for [filtered]
  3. ES keeps returning every document
  4. Elasticsearch: Failed to connect to localhost port 9200 – Connection refused
  5. Calculating time between events
  6. Aggregation + sorting +pagination in elastic search
  7. Make elasticsearch only return certain fields?
  8. Elasticsearch: Difference between “Term”, “Match Phrase”, and “Query String”
  9. Join query in ElasticSearch
  10. Elasticsearch searchable synthetic fields
  11. Queries vs. Filters
  12. Save Spark Dataframe into Elasticsearch – Can’t handle type exception
  13. elasticsearch match vs term query
  14. How to retrieve unique count of a field using Kibana + Elastic Search
  15. Elasticsearch difference between MUST and SHOULD bool query
  16. How to change Elasticsearch max memory size
  17. Can We Retrieve Previous _source Docs with Elastic Search Versions
  18. How to get latest values for each group with an Elasticsearch query?
  19. What is the maximum Elasticsearch document size?
  20. How to create unique constraint in Elasticsearch database?
  21. How to iterate through a nested array in elasticsearch with filter script?
  22. ElasticSearch: Unassigned Shards, how to fix?
  23. Content-Type header [application/x-www-form-urlencoded] is not supported on Elasticsearch
  24. Elasticsearch, Failed to obtain node lock, is the following location writable
  25. low disk watermark [??%] exceeded on
  26. Elasticsearch – set max_clause_count
  27. How to bind Elasticsearch 2.0 on both Loopback and Non-Loopback interfaces?
  28. How to use the official docker elasticsearch container?
  29. Remove a field from a Elasticsearch document
  30. How to create multiple indexes in logstash.conf file?

Leave a Comment