ES Delete Data by Query Guide

1 year ago
Emily Johnson
2 minutes

Elasticsearch (ES) is an open-source distributed search and analytics engine that allows for efficient data storage and retrieval. To delete data based on certain conditions, the delete API in ES can be utilized.

In Elasticsearch, you can use the Delete By Query API to delete data based on specified conditions. This API allows you to delete documents that match the specified query criteria.

Here is an example of using the Delete By Query API to remove data:

POST /<index>/_delete_by_query
{
  "query": {
    "bool": {
      "filter": {
        "term": {
          "<field>": "<value>"
        }
      }
    }
  }
}

In this case, refers to the index name from which data needs to be deleted, is the name of the field to match, and is the value the field should match.

For example, to delete a document in the “products” index with the category field value of “electronics”, you can use the following request:

POST /products/_delete_by_query
{
  "query": {
    "bool": {
      "filter": {
        "term": {
          "category": "electronics"
        }
      }
    }
  }
}

After executing the request, the data that meets the conditions will be deleted.

Please note that the delete operation is irreversible, so please use it carefully. Before performing the delete operation, make sure you have backed up the data or confirmed that you no longer need it.

bannerAds