How to get latest values for each group with an Elasticsearch query?

by

You can use a top_hits aggregation that groups on the country field, returns 1 doc per group, and orders the docs by the collected date descending:

POST /test/_search?search_type=count
{
    "aggs": {
        "group": {
            "terms": {
                "field": "country"
            },
            "aggs": {
                "group_docs": {
                    "top_hits": {
                        "size": 1,
                        "sort": [
                            {
                                "collected": {
                                    "order": "desc"
                                }
                            }
                        ]
                    }
                }
            }
        }
    }
}

More Related Contents:

  1. Elasticsearch replication of other system data?
  2. Shards and replicas in Elasticsearch
  3. elasticsearch bool query combine must with OR
  4. ElasticSearch – Return Unique Values
  5. Elasticsearch: Failed to connect to localhost port 9200 – Connection refused
  6. Aggregation + sorting +pagination in elastic search
  7. Elasticsearch: Difference between “Term”, “Match Phrase”, and “Query String”
  8. Join query in ElasticSearch
  9. Max limit on the number of values I can specify in the ids filter or generally query clause?
  10. UTF8 encoding is longer than the max length 32766
  11. How to update multiple documents that match a query in elasticsearch
  12. Queries vs. Filters
  13. Change default mapping of string to “not analyzed” in Elasticsearch
  14. Find distinct values, not distinct counts in elasticsearch
  15. elasticsearch match vs term query
  16. elasticsearch – what to do with unassigned shards
  17. Elasticsearch vs Cassandra vs Elasticsearch with Cassandra
  18. Elasticsearch difference between MUST and SHOULD bool query
  19. Find documents with empty string value on elasticsearch
  20. What is the maximum Elasticsearch document size?
  21. How to create unique constraint in Elasticsearch database?
  22. How to iterate through a nested array in elasticsearch with filter script?
  23. ElasticSearch: Unassigned Shards, how to fix?
  24. Content-Type header [application/x-www-form-urlencoded] is not supported on Elasticsearch
  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