Delete docs by date

Elastic Stack Kibana
1

HI!

In the following index I have several days of data

image

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:

image
image783Ă—474 13 KB

How cai I delete the data of this dates??

Thanks!!

2

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"
}
}
}
}
3

Sorry I don´t show the command

I launch this

image
And I obtain the error

4

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.

5

Hi again!
When I launch this

image

I obtain this

image

Thanks!

6

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?

7

Hi!!

Now, I launch this

image
And obtain this:

image

And don´t delete nothing!

Why?

Thanks

8

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

9

Sorry!! Silly mistake on my part

When I launch

image

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

image

Thanks very much!!

Best regards!!

1 Like
10

Nice, I am really happy that we solved it!

11

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.