Can i delete a single data point in OpenTSDB

Question

I am using OpenTSDB to store my time series data, but if I want to delete any data point, I am not able to find a right solution, if I go according to their documentation, the data for that whole hour also gets deleted, which is not exactly serving the purpose, Do anyone know of any other way.

If you can't delete the sample, can you override its value with NaN by inserting NaN with the same timestamp? — Sergei Rodionov, Aug 18 '16 at 08:16
You can insert some other value with the same timestamp to check that value overwrite is supported at all. — Sergei Rodionov, Aug 18 '16 at 17:10

score 4 · Accepted Answer · answered Jun 05 '19 at 01:27

I believe you can do so via a /query and instruct OpenTSDB to delete the queried data.

According to OpenTSDB latest documentation:

delete  Boolean Optional    Can be passed to the JSON with a POST to delete any data points that match the given query. false       W   true

To do so, either:

query but using verb DELETE
POST with a delete=true in your json body

Examples

{
    "start": 1356998400,
    "end": 1356998460,
    "delete": true,
    "queries": [
        {
            "aggregator": "sum",
            "metric": "sys.cpu.0",
            "rate": "true",
            "tags": {
                "host": "*",
                "dc": "lga"
            }
        },
    ]
}

Reference: http://opentsdb.net/docs/build/html/api_http/query/index.html

This question aged well, this was not there when I asked. However, thanks for answering, might help other people looking for same. — Dark Lord, Jun 05 '19 at 08:08

Can i delete a single data point in OpenTSDB

1 Answers1