Grafana mariadb worldmap

Grafana
1

hi,

i try to test worldmap with this value

 CREATE TABLE `worldmap_latlng` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lat` FLOAT NOT NULL,
  `lng` FLOAT NOT NULL,
  `name` VARCHAR(20) NOT NULL,
  `value` FLOAT NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `testdb`.`worldmap_latlng`
(`lat`,
 `lng`,
 `name`,
`value`,
`timestamp`)
VALUES
(50.72213159,
 12.45680043,
'RZ5',
1.0,
now());

Worldmap Panel → Metrics:

SELECT
  UNIX_TIMESTAMP(`timestamp`) as time_sec,
  `value` as value,
  `lat` as latitude,
  `lng` as longitude,
  `name` as name
FROM worldmap_latlng
WHERE $__timeFilter(`timestamp`)
ORDER BY `timestamp` ASC

Worldmap Panel → Worldmap:

  • Table Query Format = coordinates

and this value

CREATE TABLE test_map (
time int,
geohash char,
host char,
location char,
value int
) ENGINE=InnoDB CHARSET=latin1;

INSERT INTO test_map
(time, geohash, host, location, value)
VALUES
(1490699614650281185, “dr5rsgyct32n”, “Luv-Inspiron”, “Bangalore”, 19);

SELECT
time as time,
geohash as geohash,
value as value
FROM test_map
ORDER BY time

image
image1365×629 65.7 KB

image
image1350×264 16.2 KB

but i have not value, can you help me please