influxQL查问measurement中的指标时,可应用含糊查问。
查问measurement中字段蕴含特定字符串:
select * from cpu_used_percent where endpoint=~/192.168.0.1/ and time > '2021-09-11T00:00:00Z' order by time desc limit 10;
查问measurement中字段以某个字符串起始:
select * from cpu_used_percent where endpoint=~/^datacenter/ and time > '2021-09-11T00:00:00Z' order by time desc limit 10;
查问meaurement中字段以某个字符串完结:
select * from cpu_used_percent where endpoint=~/vm-$/ and time > '2021-09-11T00:00:00Z' order by time desc limit 10;
//查问以Datacenter结尾、vm-40完结的时序数据select * from cpu_used_percent where endpoint=~/^Datacenter.*vm-40$/ order by time desc limit 10;