Sorry to keep on with this, but if I do that I get an error:
Parse Failure [Found two aggregation type definitions in
[field1_top_terms]: [terms] and [field1_count]. Only one type is allowed.]
If I take the 'field1_count' from inside 'field1_top_terms' like this:
GET /summary/row/_search
{
"query": {
"match": {
"file3": 1
}
},
"aggs": {
"field1_top_terms": {
"terms": {
"field": "field1"
}
},
"field1_count": {
"sum": {
"field": "count"
}
}
}
}
I get the two independent aggregations.
Thanks again for you patience...
Jose.
On Friday, 2 May 2014 16:28:08 UTC+1, Adrien Grand wrote:
>
> Your aggregation has no name, and unfortunately this causes undefined
> behavior because the parsing is too lenient in 1.1 and previous versions
> (will be fixed in 1.2.0). Please try the following request:
>
> GET /summary/row/_search
> {
> "query": {
> "match": {
> "field3": 1
> }
> },
> "aggs": {
> "field1_top_terms": {
> "terms": {
> "field": "field1"
> },
> "field1_count": {
> "sum": {
> "field": "count"
> }
> }
> }
> }
> }
>
>
>
> On Fri, May 2, 2014 at 5:22 PM, Jose A. Garcia
> <[email protected]<javascript:>
> > wrote:
>
>> Sorry, I think I must be misunderstanding something, if I do:
>>
>> GET /summary/row/_search
>> {
>> "query": {
>> "match": {
>> "field3": 1
>> }
>> },
>> "aggs": {
>> "terms": {
>> "field": "field1"
>> },
>> "field1_count": {
>> "sum": {
>> "field": "count"
>> }
>> }
>> }
>> }
>>
>> I just get this in the response:
>>
>> "aggregations": {
>> "file1_count": {
>> "value": 75000
>> }
>> }
>>
>> It's just ignoring all the values of 'file1' and adding all the sizes
>> from the response. Am I doing something wrong?
>>
>> Thanks,
>> Jose.
>>
>> On Friday, 2 May 2014 15:55:50 UTC+1, Adrien Grand wrote:
>>
>>> On Fri, May 2, 2014 at 4:47 PM, Jose A. Garcia <[email protected]>wrote:
>>>
>>>> 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...
>>>>
>>>
>>> This should work: The sum aggregation is _under_ the terms aggregation,
>>> so sums would be computed for each unique value of 'fieldA'.
>>>
>>> --
>>> 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/3e7e30bd-2482-4c99-9643-679adef5610d%40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/3e7e30bd-2482-4c99-9643-679adef5610d%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/2d1225aa-827a-4ae7-8f39-0edd0f8b7f18%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
