How do I use an Elasticsearch data source?

[azizbodal]

I'm looking to use this plugin in an Elasticsearch data source. How do construct my query? I have my longitude and latitude as separate fields. I've tried to create two queries, one with latitudes and another with longitudes but that crashed the plugin. Any help would be appreciated.

[pR0Ps]

In #3 , someone was having a very similar issue with MariaDB. If you haven't already, take a read through there and see if any of the advice in it helps. The comment in there about logging out the data that's received by the plugin might help you as you play around with your queries.

I don't have any experience with Elasticsearch (or it's integration with Grafana) so I don't really have any specific advice for you, sorry. If you end up figuring it out, let me know as I'd like to put an example of it in the README for the next person.

[danielcardinha]

Hi, I m having the same issues as @azizbodal . Did you guys find any solution? Thanks

[peterjbrammer]

Hi PR0Ps, just wondering if anyone has managed to display a position from Elasticsearch yet? Best Regards

[arirobinson]

It seems to work for me if you create 2 queries (one for lat and one for lon). Set the alias to "lat" and "lon" and it should work.

[myplatox]

Hi,

sadly, this solition is not working for me (see my settings below). I actually suggest a route-map based on the docs/points in the datasource. Query is fine and replys two dataframes.

i also tried with a geo_point field.

Do you have any ideas how to solve this problem?

elastic index is about 20k docs.

elastic mapping: "position_lat" : { "type" : "long" }, "position_long" : { "type" : "long" }, "route_point" : { "type" : "geo_point" }

where data is for example: "position_lat" : "xx.xxxxxxx", "position_long" : "xx.xxxxxxx", "route_point" : { "lat": xx.xxxxxxx, "lon": xx.xxxxxxx }

thanks in advance