Hello folks,
I am using the latest stable version of Grafana with MySQL as a data source. I have a Table panel on my dashboard that is supposed to be filled by a very simple query:
SELECT
url AS metric,
COUNT(*) AS value
FROM downloads
WHERE
$__timeFilter(timestamp)
GROUP BY metric
ORDER BY value DESC
LIMIT 10
It works just fine from the MySQL console (if I expand the $__timeFilter macro, of course). However, Grafana reports a “Database type BLOB not supported” error. What is this supposed to mean and how to fix it? It can’t be anything wrong with the database, since other, much more complex queries (querying from other tables in the same database, though) work just fine.
If it’s of any help, the structure of the table downloads is like this:
CREATE TABLE IF NOT EXISTS `downloads` (
`id` int(11) NOT NULL auto_increment,
`session` CHAR(32) NOT NULL,
`timestamp` datetime NOT NULL,
`url` text NOT NULL,
`outfile` text NOT NULL,
`shasum` varchar(64) default NULL,
PRIMARY KEY (`id`),
KEY `session` (`session`,`timestamp`)
);