I am seeing some very odd aggregation results - where the sum of the
sub-aggregations is more than the parent bucket.
Results:
"CSSX" : {
"doc_count" : *24*,
"intentDate" : {
"buckets" : [ {
"key" : "Overdue",
"to" : 1.3981248E12,
"to_as_string" : "2014-04-22",
"doc_count" : *1*,
"ME" : {
"doc_count" : *0*
},
"NOT_ME" : {
"doc_count" : *24*
}
}, {
"key" : "May",
"from" : 1.3981248E12,
"from_as_string" : "2014-04-22",
"to" : 1.4006304E12,
"to_as_string" : "2014-05-21",
"doc_count" : *23*,
"ME" : {
"doc_count" : 0
},
"NOT_ME" : {
"doc_count" : *24*
}
}, {
"key" : "June",
"from" : 1.4006304E12,
"from_as_string" : "2014-05-21",
"to" : 1.4033088E12,
"to_as_string" : "2014-06-21",
"doc_count" : *0*,
"ME" : {
"doc_count" : *0*
},
"NOT_ME" : {
"doc_count" : *24*
}
} ]
}
},
I wouldn't have thought that to be possible at all.
Here is the request that generated the dodgy results.
"CSSX" : {
"filter" : {
"and" : {
"filters" : [ {
"type" : {
"value" : "inventory"
}
}, {
"term" : {
"isAllocated" : false
}
}, {
"term" : {
"intentMarketCode" : "CSSX"
}
}, {
"terms" : {
"groupCompanyId" : [ "0D13EF2D0E114D43BFE362F5024D8873",
"0D593DE0CFBE49BEA3BF5AD7CD965782", "1E9C36CC45C64FCAACDEE0AF4FB91FBA",
"33A946DC2B0E494EB371993D345F52E4", "6471AA50DFCF4192B8DD1C2E72A032C7",
"9FB2FFDC0FF0797FE04014AC6F0616B6", "9FB2FFDC0FF1797FE04014AC6F0616B6",
"9FB2FFDC0FF2797FE04014AC6F0616B6", "9FB2FFDC0FF3797FE04014AC6F0616B6",
"9FB2FFDC0FF5797FE04014AC6F0616B6", "9FB2FFDC0FF6797FE04014AC6F0616B6",
"AFE0FED33F06AFB6E04015AC5E060AA3" ]
}
}, {
"not" : {
"filter" : {
"terms" : {
"status" : [ "Cancelled", "Completed" ]
}
}
}
} ]
}
},
"aggregations" : {
"intentDate" : {
"date_range" : {
"field" : "intentDate",
"ranges" : [ {
"key" : "Overdue",
"to" : "2014-04-22"
}, {
"key" : "May",
"from" : "2014-04-22",
"to" : "2014-05-21"
}, {
"key" : "June",
"from" : "2014-05-21",
"to" : "2014-06-21"
} ]
},
"aggregations" : {
"ME" : {
"filter" : {
"term" : {
"trafficOperatorSid" : "S-1-5-21-20xxxxxx"
}
}
},
"NOT_ME" : {
"filter" : {
"not" : {
"filter" : {
"term" : {
"trafficOperatorSid" : "S-1-5-21-20xxxxxx"
}
}
}
}
}
}
}
}
},
--
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/edc64188-0d1a-423f-9cc8-ec13842ec970%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
