InfluxDB 2.x: Delete data

Aus Wiki-WebPerfect
Version vom 5. November 2021, 14:37 Uhr von Admin (Diskussion | Beiträge)

(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

"Delete data" was first implemented on InfluxDB 2.0.3 and higher!
If you have an older release then 2.0.3 then following error occures: Error: Failed to delete data: Not implemented.


Influx CLI

influx delete \
  --bucket <YOUR_BUCKET> \
  --org <YOUR_ORGANISATION> \
  --token '<YOUR_TOKEN>' \
  --start 1970-01-01T00:00:00Z \
  --stop $(date +"%Y-%m-%dT%H:%M:%SZ") \
  --predicate '_measurement="<MEASUREMENT>" and <MORE_FILTERS>'


PowerShell

$Header = @{Authorization = "Token <YOUR_TOKEN>"}
$Body = '{
        "start": "1970-01-01T00:00:00Z",
        "stop": "2023-01-01T00:00:00Z",
        "predicate": "_measurement=\"<MEASUREMENT>\" and <MORE_FILTERS>"
}'
 
Invoke-WebRequest -Uri 'http://<YOUR_INFLUXDB>:<INFLUXDB_PORT>/api/v2/delete?org=<YOUR_ORG>&bucket=<YOUR_BUCKET>' -Header $Header -Method POST -Body $Body -ContentType "application/json"


Note: If your InfluxDB organisation contains whitespaces, then you have replace the whitespace with "+".