- influxdb查询语句
- from(bucket:”kulipa”)
- |> range(start: 2022-09-01, stop: 2022-09-02)
- |> filter(fn: (r) => r._measurement ==”C109″)
- |> filter(fn: (r) => r.device == “KL-3”)
- |> filter(fn: (r) => r.EnterPassengerFlow != 0)
- |> filter(fn: (r) => r._field ==”result” or r._field == “table” or r._field == “_start” or r._field == “_stop” or r._field == “_time” or r._field == “_measurement” or r._field == “area” or r._field == “device” or r._field == “EnterPassengerFlow” or r._field == “Holding” or r._field == “OutPassengerFlow” or r._field == “sumPeoples” )
- |> pivot(rowKey: [“_time”], columnKey: [“_field”], valueColumn: “_value”)
作者 admin
张宴银，大数据开发工程师