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
> <[email protected]<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 <[email protected]>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 [email protected].
>>>>
>>>> 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 [email protected] <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 [email protected].
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.
