How to get the geo_point from database by using logstash


(yessica chen) #1

I have the longtitude and latitude in database ,and the type is float.
I want to use kibana to draw coordinate Map,
how can I get the right form with the data.

 filter {
      mutate {
        add_field => {
          "[location][lon]" => "%{RDC_lon}"
          "[location][lat]" => "%{RDC_lat}"
        } 
      } 
      #logstash mutate {
      # convert => { "[location][lat]" => "float" }
      # convert => { "[location][lon]" => "float" }
    # }
     #mutate {
        # convert => {"location" => "geo_point"}
     #}
 }

in elasticsearch, the location is "%{RDC_lon}", how can I get the true value in "RDC_lon" which is a column in database


(system) #2

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