Delete measurements without specified tag

InfluxDB 2
#1

I can delete data via InfluxDB API /api/v2/delete by using the predicate section in the POST body:

{
    "start": "2021-09-23T13:00:00.000Z",
    "stop": "2021-10-10T13:00:00.000Z",
    "predicate": "_measurement=\"ping\" AND my_tag=\"foo\""
}

How can I delete data which don’t have the tag ‘my_tag’? my_tag=\"null\" or my_tag=\"\" seams doesn’t work.

#2

Hi @AdolarMezga ,
Can you try the delete command using the body:

{
    "start": "2021-09-23T13:00:00.000Z",
    "stop": "2021-10-10T13:00:00.000Z",
    "predicate": "_measurement=\"ping\""
}

I belive the AND functionality is optional.

#3

Hi @Jay_Clifford ,
I believe than I lose my tagged data too.

#4

Ah, my apologies I now see your trouble. Sadly there are some limitations around the delete functionality. Does the non tagged data belong to the same field as the tagged data? If not you can use that as part of your predicate. I will raise this issue internally as a limitation of the delete function.

#5

Another workaround would be as follows (only if you plan to not upload more non tagged data):
Migrate the tagged data to a new bucket using Flux. Delete the non-tagged data. Migrate back or continue to use the new bucket.

@Anaisdg do you have any other ideas on what to do here? I just want to make sure I am not overlooking anything simple.

#6

Yes, unfortunately the untagged data belong to the same field as the tagged data, because I tagged data later to distinguish from other ping inputs. As workaround I can delete the time frame. Thank you!

#7

Hello @AdolarMezga,
Yes @Jay_Clifford is correct. There isn’t a way to delete values without the existence of tag other than to work around the time frame.