Does DELETE_BY_QUERY work with Index Sorting in ES 6.0?

Hi,

I am migrating an entity centric index from ES 2.3 to ES 6.0 and in ES 6.0, _ttl is deprecated. I originally was planning on using rolling indices but it won't work for us well since routing logic is complex for my use case.

So the question here is this: if I am using a single index with DELETE_BY_QUERY/force merge operations to handle deleting old documents, will it work with index sorting where I sort by a field lastUpdateTime and then delete if lastUpdateTime is past a certain time? In particular, will the DELETE_BY_QUERY operation come to early termination?

And does anybody have actual benchmarks for searching on rolling indices vs a single index?

Index sorting: https://www.elastic.co/blog/index-sorting-elasticsearch-6-0

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