I'm having an index created in `elasticsearch 5.0`

, where it contains data from my `MySQL`

db. There's a field which is a `string`

in my table, which I need it as a `double`

in ES.

So what I did was added the mapping when I created the index for the appropriate field using a `PUT`

:

```
{
"mappings": {
"my_type": {
"properties": {
"chargeamount": {
"type": "double"
}
}
}
}
}
```

After I did this, a value which contains numbers after the decimal (ie: 23.23) returns the value properly as a double but where as numbers which has zeros after the decimal (ie: 23.00) returns it as a string itself (ie: 2300).

Where am I going wrong? Any help could be appreciated.