CODEWITHSUNDEEP
influxdbgrafana
AlexD
AlexD

Reputation: 4310

Select from multiple measurements

I have a bunch of measurements, all starting with task_runtime. i.e.

task_runtime.task_a task_runtime.task_b task_runtime.task_c

Is there a way to select all of them by a partial measurement name?

I'm using grafana on top of influxdb and I want to display all of these measurements in a single graph, but I don't have a closed list of these measurements.

I thought about something like

select * from (select table_name from all_tables where table_name like "task_runtime.*")

But not sure on the influxdb syntax for this

Upvotes: 2

Views: 8783

Answers (1)

peterdn
peterdn

Reputation: 2476

You can use a regular expression when specifying measurements in the FROM clause as described in the InfluxDB documentation.

For example, in your case:

SELECT * FROM /^task_runtime.*/

Grafana also supports this and will display all measurements separately.

Upvotes: 7

Related Questions