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.comhttps://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+unsubscribe@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.