Hi Colin, Thank you, that works perfectly!
Is there any way to limit the key-value pairs by a certain parameter, in the example below: to limit the aggregation to "datum_uitspraak_ymd" keys that start with "2014"? Or does that require the combination of a filter and an aggregation? Many thanks, Diederik Op Jul 7, 2014, om 2:47 PM heeft Colin Goodheart-Smithe <[email protected]> het volgende geschreven: > Diederik, > > To increase the number of terms returned by the terms aggregation you will > need to add the 'size' parameter to your aggregation. The below curl command > will return you the top 200 terms (ordered by decending doc_count). > > curl -XGET 'http://localhost:9200/_search?pretty=true' -d '{ "size": 0, > "aggs": { "datum_uitspraak_ymd": { "terms": { "field": "datum_uitspraak_ymd", > "size" : 200 } } } }' > > You may also find the following link to the documentation useful regarding > the size parameter of the terms aggregation. > > http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_size_amp_shard_size > > > Hope this helps, > > Colin > > On Monday, 7 July 2014 13:09:52 UTC+1, Diederik Meijer wrote: > Dear list, > > I need to create an aggregation by a specific field, named > "datum_uitspraak_ymd'. I am using the below curl command and it works fine in > a sense that it returns the aggregation listed below. While this result seems > OK enough, it seems that the keys listed in the aggregation are limited to > those listed in 10 records. > > As the number of unique values for this key is much higher than 10, it seems > that the aggregation's scope is global as far as it searches for documents > with a value identical to one of the 10 listed, but it is limited as far as > the key values used in the aggregation is concerned. > > How do I need to set up my curl command in order for the aggregation to > return more key-value pairs? > > Many thanks, > Diederik > > > Command: > curl -XGET 'http://localhost:9200/_search?pretty=true' -d '{ "size": 0, > "aggs": { "datum_uitspraak_ymd": { "terms": { "field": "datum_uitspraak_ymd" > } } } }' > > Returns: > "aggregations" : { "datum_uitspraak_ymd" : { "buckets" : [ { "key" : > "20121219", "doc_count" : 612 }, { "key" : "20120516", "doc_count" : 526 }, { > "key" : "20110601", "doc_count" : 472 }, { "key" : "20121218", "doc_count" : > 468 }, { "key" : "20090520", "doc_count" : 349 }, { "key" : "20101222", > "doc_count" : 274 }, { "key" : "20120711", "doc_count" : 272 }, { "key" : > "20090429", "doc_count" : 246 }, { "key" : "20120718", "doc_count" : 230 }, { > "key" : "20120425", "doc_count" : 226 } ] } } > > > -- > You received this message because you are subscribed to a topic in the Google > Groups "elasticsearch" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/elasticsearch/wCkb_xHaUmQ/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/9f0cb2af-fa2d-40b0-9930-b884141f2969%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/2CC2403E-C358-4405-AA70-3ECDE29BF9D2%40tenhorses.com. For more options, visit https://groups.google.com/d/optout.
