How to delete all documents that a field have specific length?

Elastic Stack Elasticsearch
1

for example I have following documents
{
term: "bo"
},
{
term: "book"
}

I want to delete all documents that "term" field length is less than 3

2

A few approaches I can think of are:

*Highly recommended that you query first and confirm that the results of your query yield the desired hits.

  1. Utilize delete_by_query API in combination with a script query.

  2. Reindex your data such that the field you're interested in becomes a multi-field, using a token_count with appropriate analyzer for your data. Then delete by query using the token_count field directly with no script.

  3. Reindex using an ingest pipeline with drop processor that filters out docs where the field of interest is less than 3 chars long.

3

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