Can't push decimal numbers

[tomer (tomer zaks)]

Hi,
I am having a problem getting decimal numbers in the ES

as shown below:

I have an "ASR" that is 0.9, but when I use the following query:
GET filebeat-*/log/_search
{
"query": {

   "bool":{ 

      "must": [
        { "match": { "ASR": "0.9"}}
        
        ]
  
     
   }
  }
}

I get:

> {
>   "took": 1,
>   "timed_out": false,
>   "_shards": {
>     "total": 2,
>     "successful": 2,
>     "failed": 0
>   },
>   "hits": {
>     "total": 0,
>     "max_score": null,
>     "hits": []
>   }
> } 

The log its self is as following:

"{"eventTimestamp":1505760179999,"asrFrom":1505759776499,"ASR":0.9}"

Help will be great I am gravely under pressure on this subject.

[jogoinar10 (Jonar B)]

Did you try to remove the qoutes?

[tomer (tomer zaks)]

Hi,
Yes, I tried
Also in the visualization, it shows as if there is only 0 or 1

[Christian_Dahlqvist]

What is the mapping for that field?

[tomer (tomer zaks)]

I actually solved this by pushing in percentage instead of decimal such as instead of .5 => 50, but I am still interested why is this happening, so here is my mapping:

"ASR": {
"type": "long"
},

[jogoinar10 (Jonar B)]

Sorry, i'm not used to mapping.
I just always index the data directly

[Christian_Dahlqvist]

In order to store floats, you need to map the field as float or double instead of long. This will require reindexing.