influxdb 查询语法

分页查询

from (bucket: "testdata" ) //buckets 数据库

|> range(start:2022-07-14T11:55:00Z, stop:2022-07-16T11:05:00Z)

|> filter(fn: (r) => r._measurement == "Data_Info" and r.InfoGuid == "d339d9f2-5f5c-eb11-a223-98ac5e6c6524")

|> pivot(rowKey: [ "_time" ], columnKey: [ "_field" ], valueColumn: "_value" )

|> group(columns: [ "Data_Info"], mode: "by")

|> map(fn: (r) => ({r with _remaindervalue: float(v:(int(v: r._time)- int(v:r._start)))%180000000000.0}))

|> filter(fn: (r) => r._ remaindervalue == 0 )

|> sort(columns: ["_time"], desc: true)

|> limit(n:" + pagesize + ", offset: " + (page - 1) * pagesize + ")

|> yield()

分组

group有个参数mode，2个值

• by: 默认值，根据前面的参数排序
• except: 除了前面的参数，剩下的都参与group

from(bucket: "trial_bucket")
  |> range(start: -15m)
  |> filter(fn: (r) => r._measurement == "http_api_request_duration_seconds")
  |> group(columns: ["_time"])
  |> mean()
  |> group(columns: ["_time", "_value"], mode: "except")