InfluxDB 2.x: Delete data: Unterschied zwischen den Versionen
Aus Wiki-WebPerfect
Admin (Diskussion | Beiträge) K (Admin verschob die Seite InfluxDB: 2.x: Delete data nach InfluxDB 2.x: Delete data, ohne dabei eine Weiterleitung anzulegen) |
Admin (Diskussion | Beiträge) |
||
(Eine dazwischenliegende Version des gleichen Benutzers werden nicht angezeigt) | |||
Zeile 19: | Zeile 19: | ||
$Header = @{Authorization = "Token <YOUR_TOKEN>"} | $Header = @{Authorization = "Token <YOUR_TOKEN>"} | ||
$Body = '{ | $Body = '{ | ||
− | "start": "1970-01-01T00:00: | + | "start": "1970-01-01T00:00:00Z", |
− | "stop": " | + | "stop": "2023-01-01T00:00:00Z", |
"predicate": "_measurement=\"<MEASUREMENT>\" and <MORE_FILTERS>" | "predicate": "_measurement=\"<MEASUREMENT>\" and <MORE_FILTERS>" | ||
}' | }' | ||
Zeile 28: | Zeile 28: | ||
− | + | '''Note:''' If your InfluxDB organisation contains whitespaces, then you have replace the whitespace with "'''+'''". | |
Aktuelle Version vom 5. November 2021, 14:37 Uhr
"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 "+".