InfluxDBで特定期間のデータを削除する
$ influx
code:sql
show databases
name: databases
name
----
_internal
GMOCOIN
use GMOCOIN
Using database GMOCOIN
show MEASUREMENTS
name: measurements
name
----
balance
show retention policies
name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
autogen 0s 168h0m0s 1 true
assets_policy 8736h0m0s 168h0m0s 1 false
SELECT * FROM "assets_policy"."balance" WHERE ("account" = 'account1' AND "symbol" = 'JPY' AND time>='2021-11-04T09:10:00+09:00' AND time<='2021-11-05T07:21:00+09:00')
DELETE FROM "balance" WHERE ("account" = 'account1' AND "symbol" = 'JPY' AND time>='2021-11-04T09:10:00+09:00' AND time<='2021-11-05T07:21:00+09:00')
SELECTで削除する期間のデータが正しいかよく確認しておくと良い。
DELETEする時ポリシーを指定しない。