Float type rounding issues

[stephenb (Stephen Brown)]

(please try not to paste text as images... hard to see, help, debug etc...etc. paste as formatted text)

But YUP You need to use a double as the type not float as you are exceeding the significant digits of a single precision float

Also you are confusing the _source (what comes in the source json) and the fields what is index stored and showed in the Discover, Visualizations.. etc

Here follow along

What you have now

PUT discuss-test/
{
  "mappings" : {
  "properties": {
    "@timestamp": {
      "type": "date"
    },
    "balance": {
      "type": "float"
    }
  }
  }
}
POST discuss-test/_doc
{
 "@timestamp" : "2022-12-22T17:44:11.891Z",
 "balance" : 11555.7125 
}

POST discuss-test/_doc
{
 "@timestamp" : "2022-12-22T17:45:11.891Z",
 "balance" : 11666.7725 
}

GET discuss-test/_search
{
  "fields": [
    "*"
  ]
}

#Results Notice the difference between the `_source` and the `fields`

{
  "took": 0,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 2,
      "relation": "eq"
    },
    "max_score": 1,
    "hits": [
      {
        "_index": "discuss-test",
        "_id": "xkOxPIUBrWRX1Zc6vqbo",
        "_score": 1,
        "_source": {
          "@timestamp": "2022-12-22T17:44:11.891Z",
          "balance": 11555.7125 <!------ _source what you sent
        },
        "fields": {
          "@timestamp": [
            "2022-12-22T17:44:11.891Z"
          ],
          "balance": [
            11555.713 <!- Single Precision Float :( what was stored and used
          ]
        }
      },
      {
        "_index": "discuss-test",
        "_id": "x0OxPIUBrWRX1Zc6vqb5",
        "_score": 1,
        "_source": {
          "@timestamp": "2022-12-22T17:45:11.891Z",
          "balance": 11666.7725
        },
        "fields": {
          "@timestamp": [
            "2022-12-22T17:45:11.891Z"
          ],
          "balance": [
            11666.772
          ]
        }
      }
    ]
  }
}

Now lets do it with a double

DELETE discuss-test

PUT discuss-test/
{
  "mappings" : {
  "properties": {
    "@timestamp": {
      "type": "date"
    },
    "balance": {
      "type": "double"
    }
  }
  }
}

POST discuss-test/_doc
{
 "@timestamp" : "2022-12-22T17:44:11.891Z",
 "balance" : 11555.7125 
}

POST discuss-test/_doc
{
 "@timestamp" : "2022-12-22T17:45:11.891Z",
 "balance" : 11666.7725 
}

GET discuss-test/_search
{
  "fields": [
    "*"
  ]
}


# Results Happy Days!

{
  "took": 0,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 2,
      "relation": "eq"
    },
    "max_score": 1,
    "hits": [
      {
        "_index": "discuss-test",
        "_id": "ykOzPIUBrWRX1Zc6kaYi",
        "_score": 1,
        "_source": {
          "@timestamp": "2022-12-22T17:44:11.891Z",
          "balance": 11555.7125 <!--- Source
        },
        "fields": {
          "@timestamp": [
            "2022-12-22T17:44:11.891Z"
          ],
          "balance": [
            11555.7125 <!--- Stored Field 
          ]
        }
      },
      {
        "_index": "discuss-test",
        "_id": "y0OzPIUBrWRX1Zc6kaYu",
        "_score": 1,
        "_source": {
          "@timestamp": "2022-12-22T17:45:11.891Z",
          "balance": 11666.7725 
        },
        "fields": {
          "@timestamp": [
            "2022-12-22T17:45:11.891Z"
          ],
          "balance": [
            11666.7725
          ]
        }
      }
    ]
  }
}

And Discover