Aggregation on nested type


(qvin.net) #1

Hello,
I am new to elasticsearch and I am running into issues doing aggregations
on nested documents. I have an index that uses nested types. The code I
used to set up my test data set is given here

  • https://gist.github.com/qvin/9911e904c1d127c28dc7
    I want to perform bucket aggregations on the nested documents based on
    filters set on the top level documents properties. Here is the query (along
    with the result) that I came up with
  • https://gist.github.com/qvin/a40bd96d6df25d1b31c3
    In the output if you notice that the aggregated value is the same (1026)
    for all buckets. I am interested in aggregations per bucket. Please see the
    expected value listed in the gist. Can someone please help me figure this
    out? I also tried using the "nested" aggregation type as shown below but
    this throws an error.
    Any help is appreciated. I would like to solve this without making changes
    to the document schema if possible.
    Thanks!

curl -XGET 'http://localhost:9200/testdb/testtable/_search -d '{
"size": 0,
"aggs": {
"report_aggs": {
"filter": {
"and": [
{
"term": {
"prop1": "1"
}
},
{
"term": {
"prop2": "2"
}
},
{
"term": {
"checkflag": "true"
}
}
]
},
"aggs": {
"report_aggs_nested": {
"nested": {
"path": "nesteddocs"
},
"aggs": {
"aggs_sum": {
"terms": {
"field": "nesteddocs.dockey"
},
"aggs": {
"docvalsum": {
"avg": {
"field": "nesteddocs.docvalue"
}
}
}
}
}
}
}
}
}
}'

--
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/60646a0c-b3c8-404a-aa3f-34457a779ef6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #2