Using a basic query to build a time series and am receiving the following error:
“MySQL response parsing error sql: Scan error on column index 2: unsupported Scan, storing
driver.Value type time.Time into type *sql.RawBytes”
SELECT UNIX_TIMESTAMP(day) as time_sec, sum(sent) as value, day as metric FROM stats WHERE day >= FROM_UNIXTIME(1483228800) AND day <= FROM_UNIXTIME(1509494400) GROUP BY day LIMIT 10
Query runs fine outside of Grafana and works inside as a table. Date field is ‘date’.
Edit: Google has led me to need “?parseTime=true” in the connection string. How can I use this in Grafana?