InfluxDB

CREATE USER polyU_HK WITH PASSWORD '***'
GRANT READ ON "telegraf" TO "***"
SHOW DATABASES
USE database
SHOW measurements
SELECT * FROM measurements
create retention policy "rp_f26" on "telegraf" duration 3w replication 1 default
drop retention policy "auto_gen"

SELECT LAST("tag_value") FROM "kafka_consumer" WHERE ("host"='f26dht') AND ("tag_code"='v5678')