Integer is not recognized

Elastic Stack Logstash
1

Hi

Here is my sample data

Madhya Pradesh;22.9734;78.6569;57766;764338;7558
Maharashtra;19.7515;75.7139;351005;5579897;88620
Manipur;24.6637;93.9063;6534;44089;688

Logstash considered the text and float but it doesn't recognize the integer (last 3 values in a row)

image

and here is my lsdp.conf

input {
file {
path => "/home/noname/Desktop/lsdp.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
csv {
separator => ";"
columns => ["State", "latitude", "longitude", "ActiveCases", "TotalPositive", "TotalDeath"]
}
mutate {
convert => {
"latitude" => "float"
"longitude" => "float"
"Cases" => "integer"
"Recovered" => "integer"
"Death" => "integer"
}
}
mutate {
rename => {
"longitude" => "[location][lon]"
"latitude" => "[location][lat]"
}
}
}
output {
elasticsearch {
hosts => "http://192.168.0.102:9200"
index => "lsdp"
}
stdout {codec => rubydebug}
}

and the index

PUT lsdp
{
"mappings": {
"properties": {
"location": {
"type": "geo_point"
}
}
}
}

can anyone help me out

Thanks in advance

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.