My Index Mapping:
"total"{
"type": :"double"
"ignore_malformaed": "true"
}
when i perform sum on this field i am getting the scientific notation.
Query i triggered:
POST /_sql {
"query": "select sum(total) from "testindex"
}
Result i am getting is: 178264528827E8
Result i Need is: 17826452882767927828
Can you guide me how i can remove the scientific notation on the result.