Hi
I am using kibana 5.6.3 and i am facing problem while creating coordinate map after loading index. I am getting error as
No Compatible Fields: The "geo4-*" index pattern does not contain any of the following field types: geo_point
i am having csv file with city, lat , long columns and values as below
city lat lon
London 51.5073509 -0.1277583
and i created logstash.conf as below
input {
file {
path => "D:\Projects\Level3-kibana\DataSet\Test.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
csv {
separator => ","
columns => ["city","lat","lon"]
}
mutate {
convert => { "lat" => "float" }
convert => { "lon" => "float" }
add_field => {
"[geoip][location]" => [ "%{lon}", "%{lat}" ]
"[geoip][latitude]" => "%{lat}"
"[geoip][longitude]" => "%{lon}"
}
}
mutate {convert =>["city","string"]}
mutate {
remove_field => [ "message", "host", "@timestamp", "@version" ]
}
}
output {
elasticsearch {
hosts => "http://localhost:9200"
index => 'geo4-point'
}
stdout{}
}
can someone help me to load this coordinates in map