Average seems to be wrong

[bigl0af]

I seem to be getting the wrong result when performing average aggregations via Kibana 4. As you can see, the values being returned for the are steadily right around 8,500,000,000.

Yet, somehow, I get an average around 4,755,736,842,123,345,920!

Running ES 1.7.2, JVM 1.8.0_31

[clintongormley]

Hi @bigl0af

It looks like you have an index which has conflicting mappings between shards. In other words, the same field has been mapped differently on different shards, resulting in this weird calculation. The only thing to do here is to reindex the data with the correct mappings.

This issue has been fixed (along with many others) in the great mapping cleanup in 2.0 (see #8870)