It looks like a bug to me - but if its user error, then obviously I can fix
it a lot quicker :)
On Tuesday, 29 April 2014 13:04:53 UTC+1, mooky wrote:
>
> 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"<span
> style="color: #000;" class="styled-by
> ...
--
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/4ceceaaf-4fb8-4e54-97f4-c49fcbf9493d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
