Hi, That's closer but I would get all the possible values and counts for 'fieldA' and the total sum of 'size' for my result set, but I need the sum of sizes for each value of 'fieldA', so it's a combination of both terms and sum, but none seems to give me exactly what I need...
Thanks, Jose. On Friday, 2 May 2014 15:18:37 UTC+1, Adrien Grand wrote: > > Oh, I'm sorry, I completely missed your question, I thought you wanted to > merge the counts for different fields. > > Would this aggregation do what you are looking for? > { > "terms": { > "field": "fieldA" > }, > "aggs": { > "size_sum": { > "sum": { > "field": "size" > } > } > } > } > > See > http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-metrics-sum-aggregation.htmlfor > the documentation of the sum aggregation. I hope I got your question > right this time! > > > > > On Fri, May 2, 2014 at 4:08 PM, Jose A. Garcia > <argan...@gmail.com<javascript:> > > wrote: > >> Hi Adrien, >> >> Thanks for your answer, but I have a question. Wouldn't that give me the >> different sums of the values of those fields? >> >> What I need is, using the example from before: >> >> Doc1 : { field1 : A, field2: B, field3: C, size: 1, } >> Doc2: { field1 : A, field2: B2, field3: C2, size: 2} >> Doc3: { field1 : Z, field2: B3, field3: C3, size: 99 } >> >> If I search in my index and those three documents match my query I want a >> list of the possible values that 'field1' can take and the sum of the >> 'size' fields for all documents with each value in my result set. So in >> this case I would expect: >> >> field1: { >> {value: 'A', sum_of_sizes: 3} >> {value: 'Z', sum_of_sizes: 99} >> } >> >> Thanks, >> Jose. >> >> On Friday, 2 May 2014 14:51:36 UTC+1, Adrien Grand wrote: >> >>> Hi Jose, >>> >>> There are two ways to do so: either with a script (slow because term >>> ordinals can't be used): >>> >>> "terms" : { >>> "script": "doc['A'].values + doc['B'].values + doc['C'].values" >>> } >>> >>> Or by having all values in a single field at indexing time (potentially >>> using `copy_to`[1]). >>> >>> [1] http://www.elasticsearch.org/guide/en/elasticsearch/ >>> reference/current/mapping-core-types.html#copy-to >>> >>> >>> >>> On Fri, May 2, 2014 at 11:44 AM, Jose A. Garcia <argan...@gmail.com>wrote: >>> >>>> Hi, >>>> >>>> I have a question about Aggregations. I have documents with several >>>> fields: >>>> >>>> { >>>> field1 : A, >>>> field2: B, >>>> field3: C, >>>> size: 1, >>>> } >>>> >>>> { >>>> field1 : A, >>>> field2: B2, >>>> field3: C2, >>>> size: 2, >>>> } >>>> >>>> { >>>> field1 : Z, >>>> field2: B3, >>>> field3: C3, >>>> size: 99, >>>> } >>>> >>>> And I need to be able to calculate aggregations for each one of those >>>> fields, and get the sum of the sizes for each field, so for example, >>>> aggregating by field1 should get me { A, size = 3 }, {Z, size = 99}. >>>> >>>> Looking at the documentation for aggregations I can see how to get the >>>> sum for a field and how to get the terms and their counts, but I need a >>>> combination of both, what is the best way to do this? >>>> >>>> Thanks in advance, >>>> Jose. >>>> >>>> -- >>>> 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 elasticsearc...@googlegroups.com. >>>> >>>> To view this discussion on the web visit https://groups.google.com/d/ >>>> msgid/elasticsearch/1deb1eb1-a5dc-40cb-8689-c5518869f40a% >>>> 40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/1deb1eb1-a5dc-40cb-8689-c5518869f40a%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Adrien Grand >>> >> -- >> 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 elasticsearc...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/ec381c10-45cd-4406-8aac-2e542097cf49%40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/ec381c10-45cd-4406-8aac-2e542097cf49%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Adrien Grand > -- 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 elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/146e90a8-48de-4bad-b5ce-6685ea4563ca%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.