Double Multi-field Loses Precision

Elastic Stack Elasticsearch
3

On ES9 the output is missing the scientific notation. But I cut and paste exactly what you gave into kibana 9's DevTools and I get

  "aggregations": {
    "float": {
      "value": 3424999936
    },
    "float.d": {
      "value": 3425000000
    }

This looks correct to me.

double precision is able to maintain all the precision, and clearly 4* 856250000 is indeed 3425000000.

The single precision is unable to retain the precision of "856250000", usually get 7/8 significant digits, so the IEEE bit representation of "856250000" is the same as the IEEE bit representation of 856249984 (and a range of other integers/floats around that point on the number line). sum of 4 856249984s (in single or double precision) is 3424999936, which is what is given.

So, ES9 seems to give right answer. Which specific 8.x version are you (@dna01) using ?

see also similar discussion in this thread.