becustom domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home4/joyplace/public_html/wp-includes/functions.php on line 6114wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home4/joyplace/public_html/wp-includes/functions.php on line 6114Deleting a single document is pretty straightforward in Elasticsearch. We can simply issue a DELETE on the document id and the document will be deleted from the index.<\/p>\n\n\n\n
$ curl -XDELETE localhost:9200\/account\/_doc\/10?pretty\n {\n \u00a0\u00a0\"_index\" : \"account\",\n \u00a0\u00a0\"_type\" : \"_doc\",\n \u00a0\u00a0\"_id\" : \"10\",\n \u00a0\u00a0\"_version\" : 2,\n \u00a0\u00a0\"result\" : \"deleted\",\n \u00a0\u00a0\"_shards\" : {\n \u00a0\u00a0\u00a0\u00a0\"total\" : 2,\n \u00a0\u00a0\u00a0\u00a0\"successful\" : 1,\n \u00a0\u00a0\u00a0\u00a0\"failed\" : 0\n \u00a0\u00a0},\n \u00a0\u00a0\"_seq_no\" : 1000,\n \u00a0\u00a0\"_primary_term\" : 1\n }\n $ curl -X GET localhost:9200\/account\/_doc\/10?pretty\n {\n \u00a0\u00a0\"_index\" : \"account\",\n \u00a0\u00a0\"_type\" : \"_doc\",\n \u00a0\u00a0\"_id\" : \"10\",\n \u00a0\u00a0\"found\" : false\n } <\/pre>\n\n\n\nWhat if we want to delete all documents from account index matching account_number greater than or equal to 15 and less than or equal to 20.<\/p>\n\n\n\n
Delete by query<\/h2>\n\n\n\n
We have a total of 6 documents in the account index with account_number greater than or equal to 15 and less than or equal to 20.<\/p>\n\n\n\n
curl -X GET \"localhost:9200\/account\/_search?pretty\" -H 'Content-Type: application\/json' -d'\n {\n \u00a0\u00a0\"query\": {\n \u00a0\u00a0\u00a0\u00a0\"range\": {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"account_number\": {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"gte\": 15,\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lte\": 20\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n \u00a0\u00a0\u00a0\u00a0}\n \u00a0\u00a0}\n }'\n {\n \u00a0\u00a0\"took\" : 3,\n \u00a0\u00a0\"timed_out\" : false,\n \u00a0\u00a0\"_shards\" : {\n \u00a0\u00a0\u00a0\u00a0\"total\" : 1,\n \u00a0\u00a0\u00a0\u00a0\"successful\" : 1,\n \u00a0\u00a0\u00a0\u00a0\"skipped\" : 0,\n \u00a0\u00a0\u00a0\u00a0\"failed\" : 0\n \u00a0\u00a0},\n \u00a0\u00a0\"hits\" : {\n \u00a0\u00a0\u00a0\u00a0\"total\" : {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"value\" : 6,<\/strong>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"relation\" : \"eq\"\n \u00a0\u00a0\u00a0\u00a0} <\/pre>\n\n\n\nWe will issue a POST on _delete_by_query API with the query and range indicating\u00a0 account_number greater than or equal to 15 and less than or equal to 20. And we can see from the output that matching 6 documents were deleted from index.<\/p>\n\n\n\n
curl -X POST \"localhost:9200\/account\/_delete_by_query?pretty\" -H 'Content-Type: application\/json' -d'\n {\n \u00a0\u00a0\"query\": {\n \u00a0\u00a0\u00a0\u00a0\"range\": {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"account_number\": {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"gte\": 15,\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lte\": 20\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n \u00a0\u00a0\u00a0\u00a0}\n \u00a0\u00a0}\n }'\n {\n \u00a0\u00a0\"took\" : 80,\n \u00a0\u00a0\"timed_out\" : false,\n \u00a0\u00a0\"total\" : 6,\n \u00a0\u00a0\"deleted\" : 6,<\/strong>\n \u00a0\u00a0\"batches\" : 1,\n \u00a0\u00a0\"version_conflicts\" : 0,\n \u00a0\u00a0\"noops\" : 0,\n \u00a0\u00a0\"retries\" : {\n \u00a0\u00a0\u00a0\u00a0\"bulk\" : 0,\n \u00a0\u00a0\u00a0\u00a0\"search\" : 0\n \u00a0\u00a0},\n \u00a0\u00a0\"throttled_millis\" : 0,\n \u00a0\u00a0\"requests_per_second\" : -1.0,\n \u00a0\u00a0\"throttled_until_millis\" : 0,\n \u00a0\u00a0\"failures\" : [ ]\n } <\/pre>\n\n\n\nLet\u2019s make sure the documents are truly gone by issuing the same initial search again and this time we see 0 hits which is what we expect to see.<\/p>\n\n\n\n
curl -X GET \"localhost:9200\/account\/_search?pretty\" -H 'Content-Type: application\/json' -d'\n {\n \u00a0\u00a0\"query\": {\n \u00a0\u00a0\u00a0\u00a0\"range\": {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"account_number\": {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"gte\": 15,\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"lte\": 20\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n \u00a0\u00a0\u00a0\u00a0}\n \u00a0\u00a0}\n }'\n {\n \u00a0\u00a0\"took\" : 3,\n \u00a0\u00a0\"timed_out\" : false,\n \u00a0\u00a0\"_shards\" : {\n \u00a0\u00a0\u00a0\u00a0\"total\" : 1,\n \u00a0\u00a0\u00a0\u00a0\"successful\" : 1,\n \u00a0\u00a0\u00a0\u00a0\"skipped\" : 0,\n \u00a0\u00a0\u00a0\u00a0\"failed\" : 0\n \u00a0\u00a0},\n \u00a0\u00a0\"hits\" : {\n \u00a0\u00a0\u00a0\u00a0\"total\" : {\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"value\" : 0,<\/strong>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"relation\" : \"eq\"\n \u00a0\u00a0\u00a0\u00a0},\n \u00a0\u00a0\u00a0\u00a0\"max_score\" : null,\n \u00a0\u00a0\u00a0\u00a0\"hits\" : [ ]\n \u00a0\u00a0}\n } <\/pre>\n","protected":false},"excerpt":{"rendered":"Deleting a single document is pretty straightforward in Elasticsearch. We can simply issue a DELETE on the document id and the document will be deleted from [\u2026]<\/span><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-2150","post","type-post","status-publish","format-standard","hentry","category-elasticsearch"],"yoast_head":"\nHow to delete multiple documents that match a specific condition in Elasticsearch? - Big Data In Real World<\/title>\n<meta name=\"description\" content=\"Quick post describing how to delete multiple documents that match a specific condition in Elasticsearch\" \/>\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.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to delete multiple documents that match a specific condition in Elasticsearch? - Big Data In Real World\" \/>\n<meta property=\"og:description\" content=\"Quick post describing how to delete multiple documents that match a specific condition in Elasticsearch\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\" \/>\n<meta property=\"og:site_name\" content=\"Big Data In Real World\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bigdatainrealworld\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-13T11:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-19T13:30:50+00:00\" \/>\n<meta name=\"author\" content=\"Big Data In Real World\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Big Data In Real World\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\"},\"author\":{\"name\":\"Big Data In Real World\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67\"},\"headline\":\"How to delete multiple documents that match a specific condition in Elasticsearch?\",\"datePublished\":\"2022-04-13T11:00:00+00:00\",\"dateModified\":\"2023-02-19T13:30:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\"},\"wordCount\":164,\"publisher\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#organization\"},\"articleSection\":[\"Elasticsearch\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\",\"name\":\"How to delete multiple documents that match a specific condition in Elasticsearch? - Big Data In Real World\",\"isPartOf\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#website\"},\"datePublished\":\"2022-04-13T11:00:00+00:00\",\"dateModified\":\"2023-02-19T13:30:50+00:00\",\"description\":\"Quick post describing how to delete multiple documents that match a specific condition in Elasticsearch\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bigdatainrealworld.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to delete multiple documents that match a specific condition in Elasticsearch?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#website\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/\",\"name\":\"Big Data In Real World\",\"description\":\"Learn Big Data from experts!\",\"publisher\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bigdatainrealworld.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#organization\",\"name\":\"Big Data In Real World\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png\",\"contentUrl\":\"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png\",\"width\":500,\"height\":500,\"caption\":\"Big Data In Real World\"},\"image\":{\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/bigdatainrealworld\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67\",\"name\":\"Big Data In Real World\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g\",\"caption\":\"Big Data In Real World\"},\"description\":\"We are a group of Big Data engineers who are passionate about Big Data and related Big Data technologies. We have designed, developed, deployed and maintained Big Data applications ranging from batch to real time streaming big data platforms. We have seen a wide range of real world big data problems, implemented some innovative and complex (or simple, depending on how you look at it) solutions.\",\"sameAs\":[\"https:\/\/www.bigdatainrealworld.com\/\"],\"url\":\"https:\/\/www.bigdatainrealworld.com\/author\/bigdatainrealworld\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to delete multiple documents that match a specific condition in Elasticsearch? - Big Data In Real World","description":"Quick post describing how to delete multiple documents that match a specific condition in Elasticsearch","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.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/","og_locale":"en_US","og_type":"article","og_title":"How to delete multiple documents that match a specific condition in Elasticsearch? - Big Data In Real World","og_description":"Quick post describing how to delete multiple documents that match a specific condition in Elasticsearch","og_url":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/","og_site_name":"Big Data In Real World","article_publisher":"https:\/\/www.facebook.com\/bigdatainrealworld","article_published_time":"2022-04-13T11:00:00+00:00","article_modified_time":"2023-02-19T13:30:50+00:00","author":"Big Data In Real World","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Big Data In Real World","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/#article","isPartOf":{"@id":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/"},"author":{"name":"Big Data In Real World","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67"},"headline":"How to delete multiple documents that match a specific condition in Elasticsearch?","datePublished":"2022-04-13T11:00:00+00:00","dateModified":"2023-02-19T13:30:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/"},"wordCount":164,"publisher":{"@id":"https:\/\/www.bigdatainrealworld.com\/#organization"},"articleSection":["Elasticsearch"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/","url":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/","name":"How to delete multiple documents that match a specific condition in Elasticsearch? - Big Data In Real World","isPartOf":{"@id":"https:\/\/www.bigdatainrealworld.com\/#website"},"datePublished":"2022-04-13T11:00:00+00:00","dateModified":"2023-02-19T13:30:50+00:00","description":"Quick post describing how to delete multiple documents that match a specific condition in Elasticsearch","breadcrumb":{"@id":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bigdatainrealworld.com\/how-to-delete-multiple-documents-that-match-a-specific-condition-in-elasticsearch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bigdatainrealworld.com\/"},{"@type":"ListItem","position":2,"name":"How to delete multiple documents that match a specific condition in Elasticsearch?"}]},{"@type":"WebSite","@id":"https:\/\/www.bigdatainrealworld.com\/#website","url":"https:\/\/www.bigdatainrealworld.com\/","name":"Big Data In Real World","description":"Learn Big Data from experts!","publisher":{"@id":"https:\/\/www.bigdatainrealworld.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bigdatainrealworld.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bigdatainrealworld.com\/#organization","name":"Big Data In Real World","url":"https:\/\/www.bigdatainrealworld.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png","contentUrl":"https:\/\/www.bigdatainrealworld.com\/wp-content\/uploads\/2023\/02\/black.png","width":500,"height":500,"caption":"Big Data In Real World"},"image":{"@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/bigdatainrealworld"]},{"@type":"Person","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/24cab2292ef49c73053440c86515ef67","name":"Big Data In Real World","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bigdatainrealworld.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d332bc24fe9b3182f0a22135f163ac4e?s=96&d=retro&r=g","caption":"Big Data In Real World"},"description":"We are a group of Big Data engineers who are passionate about Big Data and related Big Data technologies. We have designed, developed, deployed and maintained Big Data applications ranging from batch to real time streaming big data platforms. We have seen a wide range of real world big data problems, implemented some innovative and complex (or simple, depending on how you look at it) solutions.","sameAs":["https:\/\/www.bigdatainrealworld.com\/"],"url":"https:\/\/www.bigdatainrealworld.com\/author\/bigdatainrealworld\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts\/2150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/comments?post=2150"}],"version-history":[{"count":2,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts\/2150\/revisions"}],"predecessor-version":[{"id":2152,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/posts\/2150\/revisions\/2152"}],"wp:attachment":[{"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/media?parent=2150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/categories?post=2150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigdatainrealworld.com\/wp-json\/wp\/v2\/tags?post=2150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}