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

Grafana MySQL
,
1

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

2

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?

3

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