Unsigned_long value is not precise

Elastic Stack Elasticsearch
1

We are using elasticsearch v.8.12.2.
We defined in some of our fields with type of unsigned_long.

In large numbers we see that the number we want to store is not the number actually stored in elastic.
For example: We are saving the number 9178199893404114494, elastic store it as 9178199893404115000.

Is there a way to fix this?

2

Does the behaviour change if you send the number formatted as a string? Elasticsearch will still store it in the format defined in the mapping, but I have seen this technique used to avoid precision limitation in JSON parsers.

1 Like