InfluxDB 명령어

https://docs.influxdata.com/influxdb/v2.1/

InfluxDB OSS 2.1 Documentation

접속

docker exec -it 컨테이너 bash

데이터 삭제

influx delete --token 토큰 --org 조직 --bucket 버킷 --start '1970-01-01T00:00:00Z' --stop '2022-01-01T00:00:00Z'

서로 다른 measurement의 field와 tag 동시 조회하기

from(bucket: "nbminer")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mining_pool_pub" or r["_measurement"] == "mining")
  |> filter(fn: (r) => r["_field"] == "recent_credits_24hours" or r["_field"] == "hashrate")
  |> filter(fn: (r) => r["_field"] == "total" or r["currency"] == "ETH")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")