CODEWITHSUNDEEP
mysqlgrafanagrafana-templatinggrafana-variable
meallhour
meallhour

Reputation: 15581

Grafana select query throwing error - "Found no column named time or time_sec"

I am using Grafana mysql data connector and trying to write a select query. The select query is throwing an error - "Found no column named time or time_sec"

Here is the query
SELECT main_id, ipaddress FROM table1;

Upvotes: 2

Views: 13223

Answers (1)

droidbot
droidbot

Reputation: 997

This happens when you are using a "Graph" visualisation, with X-Axis mode set to "Time" like this, because grafana is trying to find what time series to map the graph against:

graph-visualisation-with-time-mode

From your query, it seems like you're looking to visualise a data that does not have a time series.

Depending on the data you are playing with & your goal, either:

  • Change the X-Axis mode to "Series" and pick the relevant numeric column to map the X-Axis against
  • Or choose a more apt Visualization other than "Graph"
  • Or change the query to have a "time" column

Upvotes: 5

Related Questions