Grafana table chart issue, show duplicated big int value when pull data from the MySQL

Grafana table chart issue, show duplicated big int value when pull data from the MySQL.

Grafana OSS Ver 8.5.14
Everthing is in the video:

Looks like grafana will transfer it to the in value by default,

THANK YOU!!

~ the grafana team

Hi @ddrizzt,

Welcome to the :grafana: community support forums !!

What happens when you run the same query in the MySQL command console? does it also show duplicated id’s?

What happens if you alias the id with

select id as jumbo_sana, store_code from your.table

what data type is id column?

1 Like