{"id":12526,"date":"2024-03-14T16:03:13","date_gmt":"2024-03-14T16:03:13","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/"},"modified":"2025-08-05T02:41:33","modified_gmt":"2025-08-05T02:41:33","slug":"how-can-data-be-deleted-based-on-conditions-in-es","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/","title":{"rendered":"ES Delete Data by Query Guide"},"content":{"rendered":"<p>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.<\/p>\n<p>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.<\/p>\n<p>Here is an example of using the Delete By Query API to remove data:<\/p>\n<pre class=\"post-pre\"><code>POST \/&lt;index&gt;\/_delete_by_query\r\n{\r\n  \"query\": {\r\n    \"bool\": {\r\n      \"filter\": {\r\n        \"term\": {\r\n          \"&lt;field&gt;\": \"&lt;value&gt;\"\r\n        }\r\n      }\r\n    }\r\n  }\r\n}\r\n<\/code><\/pre>\n<p>In this case, <index> refers to the index name from which data needs to be deleted, <field> is the name of the field to match, and <value> is the value the field should match.<\/p>\n<p>For example, to delete a document in the &#8220;products&#8221; index with the category field value of &#8220;electronics&#8221;, you can use the following request:<\/p>\n<pre class=\"post-pre\"><code>POST \/products\/_delete_by_query\r\n{\r\n  \"query\": {\r\n    \"bool\": {\r\n      \"filter\": {\r\n        \"term\": {\r\n          \"category\": \"electronics\"\r\n        }\r\n      }\r\n    }\r\n  }\r\n}\r\n<\/code><\/pre>\n<p>After executing the request, the data that meets the conditions will be deleted.<\/p>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[16436,671,16434,706,16435],"class_list":["post-12526","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-conditional-deletion","tag-data-management","tag-delete-by-query","tag-elasticsearch","tag-es-api"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ES Delete Data by Query Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to efficiently delete data in Elasticsearch based on conditions using the Delete By Query API.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ES Delete Data by Query Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to efficiently delete data in Elasticsearch based on conditions using the Delete By Query API.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T16:03:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T02:41:33+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"ES Delete Data by Query Guide\",\"datePublished\":\"2024-03-14T16:03:13+00:00\",\"dateModified\":\"2025-08-05T02:41:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\"},\"wordCount\":184,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Conditional Deletion\",\"data management\",\"Delete By Query\",\"Elasticsearch\",\"ES API\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\",\"name\":\"ES Delete Data by Query Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T16:03:13+00:00\",\"dateModified\":\"2025-08-05T02:41:33+00:00\",\"description\":\"Learn how to efficiently delete data in Elasticsearch based on conditions using the Delete By Query API.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ES Delete Data by Query Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ES Delete Data by Query Guide - Blog - Silicon Cloud","description":"Learn how to efficiently delete data in Elasticsearch based on conditions using the Delete By Query API.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/","og_locale":"en_US","og_type":"article","og_title":"ES Delete Data by Query Guide","og_description":"Learn how to efficiently delete data in Elasticsearch based on conditions using the Delete By Query API.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T16:03:13+00:00","article_modified_time":"2025-08-05T02:41:33+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"ES Delete Data by Query Guide","datePublished":"2024-03-14T16:03:13+00:00","dateModified":"2025-08-05T02:41:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/"},"wordCount":184,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Conditional Deletion","data management","Delete By Query","Elasticsearch","ES API"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/","name":"ES Delete Data by Query Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T16:03:13+00:00","dateModified":"2025-08-05T02:41:33+00:00","description":"Learn how to efficiently delete data in Elasticsearch based on conditions using the Delete By Query API.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-data-be-deleted-based-on-conditions-in-es\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ES Delete Data by Query Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12526"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12526\/revisions"}],"predecessor-version":[{"id":156320,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12526\/revisions\/156320"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}