Mysql: Column metric must be of type CHAR, VARCHAR

[kevink00]

How can I get the correct type to create a pie chart?

I have the following in my database:

Value    varchar(100)
datetime datetime 

In Grafana I get the following errors when trying to CAST or CONVERT ‘Value’

SELECT
  datetime AS "time",
  CONVERT(Value, UNSIGNED) AS metric
FROM myTable

SELECT datetime AS "time", CAST(Value AS UNSIGNED) AS metric FROM myTable

Column metric must be of type CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT. metric column name: metric type: BIGINT but datatype is *uint64

[rich36]

I would also love to know the answer to this… Getting same error and my datatype is BIGINT