Geo_point field extraction with Logstash


(M. Alsioufi) #1

I am inserting data from mysql to Elasticsearch using Logstash. Onw of the fields I am inserting is "geoCoordinates". This field is stored in Mysql in the format "lon;lat" I want to insert this field in my elasticsearch as geo_point field so I have the following filter:

    filter {
	mutate {
		split => ["geoCoordinates", ";"]
		add_field => {
					"[geoCoordinates][lon]" => "%{geoCoordinates[0]}"
				    "[geoCoordinates][lat]" => "%{geoCoordinates[1]}"
				}
		convert => {
				"[geoCoordinates][lon]" => "float"
				"[geoCoordinates][lat]" => "float"
			}
	}
}

however Elasticsearch shows the values like this

"geoCoordinates": {
  "lon": "%{geoCoordinates[0]}",
  "lat": "%{geoCoordinates[1]}"
},

and another field has the acutal values as string
"geoCoordinates": "35.5277933233856;-121.04542218833"

Any help?


(system) #2

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