hi guys,
im attempting to run the following but received the error below not sure what is wrong, can someone shed some light?
input {
file {
path => "c:\users\administrator\downloads\chicago-food-inspection\food-inspection.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
csv {
separator => ","
columns => [ "Inspection ID", "DBA Name", "AKA Name", "License #", "Facility Type", "Risk, Address", "City", "State", "Zip", "Inspection Date","Inspection Type", "Results", "Violations", "Latitude", "Longitude", "Location",
}
mutate {convert => ["Inspection ID", "integer"] }
mutate {convert => ["License #", "integer"] }
mutate {convert => ["Latitude", "float"] }
mutate {convert => ["Longitude", "float"] }
mutate {
rename => {
"Latitude" => [location][lon]"
"Longitude" => [location] [lat]"
}
}
output {
elasticsearch {
hosts => "locahost:9200"
index => "food-inspections"
}
ES Mapping:
Post/food-inspections
{
"settings":{
number_of_shards":1
},
},
"mappings" : {
"food-inspections": {
"properties" : {
"location" : { "type": "geo_point"},
"city":{"type":"string"},
"country":{"type":"string"}
}
}
}