import "regexp"
from(bucket: "fluxDB")
|> range(start:2022-06-27T00:00:00Z, stop:2022-06-27T01:00:00Z)
|> filter(fn: (r) => r["_measurement"] == "DataInfo")
|> filter(fn: (r) => regexp.matchRegexpString(r: /^1([36])[0-9]+/, v: r.Tel))
|> pivot(rowKey: [ "_time" ], columnKey: [ "_field" ], valueColumn: "_value" )
|> group(columns: [ "DataInfo"])
|> sort(columns: [ "_time" ], desc: false)
|> yield()
influxdb2.0运用flux语法实现正则模糊查询
于 2022-08-22 09:48:05 首次发布