Delete first value


If I run:

SELECT first("value") FROM "metrics" WHERE ("host" = 'SERVER' AND "performanceLabel" = 'D: used')

I get:

name: metrics
time                first
----                -----
1533189725000000000 170.25544

I want to delete that line only. How do I do that?
I tried various DELETE commands but can’t figure out what I should do.


According to the documentation, you can definitely delete data points that include a FROM clause and/or a WHERE clause (scoped only by tags or time), but I don’t believe you can run an InfluxQL function on the field value that you’d like to drop.


You could delete that specific data point by the timestamp though.