CleverCloud / erlenmeyer

Erlenmeyer is a proxy used to parse common Open Source TimeSeries DataBase query endpoints like OpenTSDB, Prometheus/PromQL, InfluxQL or Graphite. Parsed queries are translated into WarpScript to produce native Warp 10 queries.
BSD 3-Clause "New" or "Revised" License
3 stars 2 forks source link

InfluxQL WHERE from Grafana #4

Open jtalbourdet opened 9 months ago

jtalbourdet commented 9 months ago

Hello,

I have a little problem with Erlenmeyer when I query the influxQL protocol from Grafana. At first glance the function works but when I try to do a WHERE according to the value of a label, I no longer have any results. Below is a screenshot. the grafana datasource found the label as well as all its values, however the filtering is not done.

image

Below is the generated influxQL query:

SELECT mean("salon") FROM "autogen"."gtb" WHERE ("#type"::tag = 'consignes') AND $timeFilter GROUP BY time($__interval) fill(null)

aurrelhebert commented 9 months ago

Hello thanks for your issue, I will check it

jtalbourdet commented 9 months ago

FYI, I just found what is blocking it.

https://docs.influxdata.com/influxdb/v1/query_language/explore-data/#select-specific-tags-and-fields-from-a-single-measurement-and-provide-their-identifier-type

aurrelhebert commented 8 months ago

Hi @jtalbourdet

I opened a new PR to solve this issue could you tell me if #6 is working for you?

jtalbourdet commented 7 months ago

Hello @aurrelhebert

It's working like a charm