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<javascript:>
> > 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 <javascript:>.
>> 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 elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/ec381c10-45cd-4406-8aac-2e542097cf49%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
