Delete docs by date

[Jose_Manuel_Tirado (José Manuel Tirado Vélez)]

HI!

In the following index I have several days of data

I want to delete the data from the 29th and 30th of the 5th of 2021

But when I launch the following command I obtain this messages:

How cai I delete the data of this dates??

Thanks!!

[Stratoula_Kalafateli]

Hey @Jose_Manuel_Tirado, the delete_by_query doesn't work for you? Something like:

POST discuss/_delete_by_query
{
"query": {
"range" : {
"timestamp" : {
"gte" : "18/01/2020",
"lte" : "20/02/2020",
"format": "dd/MM/yyyy"
}
}
}
}

[Jose_Manuel_Tirado (José Manuel Tirado Vélez)]

Sorry I don´t show the command

I launch this

And I obtain the error

[Stratoula_Kalafateli]

I see, this is an ES error so maybe it would be better to address it there but maybe it works if you also add ?conflicts=proceed&refresh=wait_for. Do you want to also try this?

The problem is that you have conflicted versions in your index.

[Jose_Manuel_Tirado (José Manuel Tirado Vélez)]

Hi again!
When I launch this

I obtain this

Thanks!

[Stratoula_Kalafateli]

I think this is normal if your index has a substantial size. Can you check if they are deleted, even though you get this error?

[Jose_Manuel_Tirado (José Manuel Tirado Vélez)]

Hi!!

Now, I launch this

And obtain this:

And don´t delete nothing!

Why?

Thanks

[Stratoula_Kalafateli]

The field that contains the timefield is @timestamp or nuanceTimestamp ?

[Jose_Manuel_Tirado (José Manuel Tirado Vélez)]

Sorry!! Silly mistake on my part

When I launch

Delete what we wanted! And only we have data of the remaining days

Thanks very much!!

Best regards!!

[Stratoula_Kalafateli]

Nice, I am really happy that we solved it!