Could influxdb omit time column in select statement's result?

,
1

when I using select f1 from measurement, influxdb will give such result with an additional time column:

time f1
xxxxx xxxxx
xxxxx xxxxx

But in grafana templating, I just want to a result with f1, so could influxdb omit time column in result?

2

@leafonsword Have you tried SHOW TAG KEYS?

3

show tag keys works for a tag field, but what if the column is just a normal field?

4

@leafonsword You would need to store that string as a tag. You aren’t going to be able to get your desired output in Grafana unless that is the case.

1 Like