| <!doctype html> |
| <html lang="en" dir="ltr" class="docs-wrapper plugin-docs plugin-id-default docs-version-current docs-doc-page docs-doc-id-tutorials/tutorial-delete-data" data-has-hydrated="false"> |
| <head> |
| <meta charset="UTF-8"> |
| <meta name="generator" content="Docusaurus v3.7.0"> |
| <title data-rh="true">Tutorial: Deleting data | Apache® Druid</title><meta data-rh="true" name="viewport" content="width=device-width,initial-scale=1"><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:image" content="https://druid.apache.org/img/druid_nav.png"><meta data-rh="true" name="twitter:image" content="https://druid.apache.org/img/druid_nav.png"><meta data-rh="true" property="og:url" content="https://druid.apache.org/docs/34.0.0/tutorials/tutorial-delete-data"><meta data-rh="true" property="og:locale" content="en"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><meta data-rh="true" name="docusaurus_version" content="current"><meta data-rh="true" name="docusaurus_tag" content="docs-default-current"><meta data-rh="true" name="docsearch:version" content="current"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-current"><meta data-rh="true" property="og:title" content="Tutorial: Deleting data | Apache® Druid"><meta data-rh="true" name="description" content="<!--"><meta data-rh="true" property="og:description" content="<!--"><link data-rh="true" rel="icon" href="/img/favicon.png"><link data-rh="true" rel="canonical" href="https://druid.apache.org/docs/34.0.0/tutorials/tutorial-delete-data"><link data-rh="true" rel="alternate" href="https://druid.apache.org/docs/34.0.0/tutorials/tutorial-delete-data" hreflang="en"><link data-rh="true" rel="alternate" href="https://druid.apache.org/docs/34.0.0/tutorials/tutorial-delete-data" hreflang="x-default"><link rel="stylesheet" href="/css/all.css"> |
| <script src="/js/clipboard.min.js"></script><link rel="stylesheet" href="/assets/css/styles.f3140859.css"> |
| <script src="/assets/js/runtime~main.3a1a03a2.js" defer="defer"></script> |
| <script src="/assets/js/main.6815ddec.js" defer="defer"></script> |
| </head> |
| <body class="navigation-with-keyboard"> |
| <script>!function(){function t(t){document.documentElement.setAttribute("data-theme",t)}var e=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return window.localStorage.getItem("theme")}catch(t){}}();t(null!==e?e:"light")}(),function(){try{const n=new URLSearchParams(window.location.search).entries();for(var[t,e]of n)if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id="__docusaurus"><div role="region" aria-label="Skip to main content"><a class="skipToContent_fXgn" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><nav aria-label="Main" class="navbar navbar--fixed-top navbar--dark"><div class="navbar__inner"><div class="navbar__items"><button aria-label="Toggle navigation bar" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="/img/druid_nav.png" alt="Apache® Druid" class="themedComponent_mlkZ themedComponent--light_NVdE"><img src="/img/druid_nav.png" alt="Apache® Druid" class="themedComponent_mlkZ themedComponent--dark_xIcU"></div></a></div><div class="navbar__items navbar__items--right"><a class="navbar__item navbar__link" href="/technology">Technology</a><a class="navbar__item navbar__link" href="/use-cases">Use Cases</a><a class="navbar__item navbar__link" href="/druid-powered">Powered By</a><a class="navbar__item navbar__link" href="/docs/34.0.0/design/">Docs</a><a class="navbar__item navbar__link" href="/community/">Community</a><div class="navbar__item dropdown dropdown--hoverable dropdown--right"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link">Apache®</a><ul class="dropdown__menu"><li><a href="https://www.apache.org/" target="_blank" rel="noopener noreferrer" class="dropdown__link">Foundation<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://apachecon.com/?ref=druid.apache.org" target="_blank" rel="noopener noreferrer" class="dropdown__link">Events<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/licenses/" target="_blank" rel="noopener noreferrer" class="dropdown__link">License<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/foundation/thanks.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Thanks<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/security/" target="_blank" rel="noopener noreferrer" class="dropdown__link">Security<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li><a href="https://www.apache.org/foundation/sponsorship.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Sponsorship<svg width="12" height="12" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div><a class="navbar__item navbar__link" href="/downloads/">Download</a><div class="navbarSearchContainer_Bca1"><div class="navbar__search"><span aria-label="expand searchbar" role="button" class="search-icon" tabindex="0"></span><input id="search_input_react" type="search" placeholder="Loading..." aria-label="Search" class="navbar__search-input search-bar" disabled=""></div></div></div></div><div role="presentation" class="navbar-sidebar__backdrop"></div></nav><div id="__docusaurus_skipToContent_fallback" class="main-wrapper mainWrapper_z2l0"><div class="docsWrapper_hBAB"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type="button"></button><div class="docRoot_UBD9"><aside class="theme-doc-sidebar-container docSidebarContainer_YfHR"><div class="sidebarViewport_aRkj"><div class="sidebar_njMd"><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/34.0.0/design/">Introduction to Apache Druid</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--active" href="/docs/34.0.0/tutorials/">Getting started</a><button aria-label="Collapse sidebar category 'Getting started'" aria-expanded="true" type="button" class="clean-btn menu__caret"></button></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/operations/single-server">Single server deployment</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/docker">Run with Docker</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/cluster">Clustered deployment</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-msq-extern">Ingestion tutorials</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" role="button" aria-expanded="true" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-retention">Data management tutorials</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-retention">Configure data retention</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-append-data">Append data</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-update-data">Update data</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-compaction">Compact segments</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-delete-data">Deleting data</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-latest-by">Query for latest data</a></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-query">Querying tutorials</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-sketches-theta">Theta sketches tutorial</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-jdbc">JDBC connector tutorial</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" tabindex="0" href="/docs/34.0.0/tutorials/tutorial-batch-hadoop">Hadoop tutorials</a></div></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/34.0.0/design/architecture">Design</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist" href="/docs/34.0.0/ingestion/">Ingestion</a><button aria-label="Expand sidebar category 'Ingestion'" aria-expanded="false" type="button" class="clean-btn menu__caret"></button></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist" href="/docs/34.0.0/data-management/">Data management</a><button aria-label="Expand sidebar category 'Data management'" aria-expanded="false" type="button" class="clean-btn menu__caret"></button></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/34.0.0/querying/sql">Querying</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist" href="/docs/34.0.0/api-reference/">API reference</a><button aria-label="Expand sidebar category 'API reference'" aria-expanded="false" type="button" class="clean-btn menu__caret"></button></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist" href="/docs/34.0.0/configuration/">Configuration</a><button aria-label="Expand sidebar category 'Configuration'" aria-expanded="false" type="button" class="clean-btn menu__caret"></button></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/34.0.0/api-reference/automatic-compaction-api">Operations</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist" href="/docs/34.0.0/development/overview">Development</a><button aria-label="Expand sidebar category 'Development'" aria-expanded="false" type="button" class="clean-btn menu__caret"></button></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/34.0.0/release-info/release-notes">Release info</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/34.0.0/misc/papers-and-talks">Papers</a></li></ul></nav></div></div></aside><main class="docMainContainer_TBSr"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_VOVn"><div class="docItemContainer_Djhp"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label="Breadcrumbs"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_YNFT"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item"><a class="breadcrumbs__link" itemprop="item" href="/docs/34.0.0/tutorials/"><span itemprop="name">Getting started</span></a><meta itemprop="position" content="1"></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Data management tutorials</span><meta itemprop="position" content="2"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">Deleting data</span><meta itemprop="position" content="3"></li></ul></nav><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type="button" class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>Tutorial: Deleting data</h1></header><p>This tutorial demonstrates how to delete existing data.</p> |
| <p>This tutorial requires the following:</p> |
| <ul> |
| <li>A running Apache Druid instance. If you don't have Druid, see the <a href="/docs/34.0.0/tutorials/">single-machine quickstart</a> to get started.</li> |
| <li>The command-line JSON processor, <a href="https://stedolan.github.io/jq/download/" target="_blank" rel="noopener noreferrer">jq</a>.</li> |
| </ul> |
| <h2 class="anchor anchorWithStickyNavbar_LWe7" id="load-initial-data">Load initial data<a href="#load-initial-data" class="hash-link" aria-label="Direct link to Load initial data" title="Direct link to Load initial data"></a></h2> |
| <p>In this tutorial, we will use the Wikipedia edits data, with an indexing spec that creates hourly segments. This spec is located at <code>quickstart/tutorial/deletion-index.json</code>, and it creates a datasource called <code>deletion-tutorial</code>.</p> |
| <p>Let's load this initial data:</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">bin/post-index-task --file quickstart/tutorial/deletion-index.json --url http://localhost:8081</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <p>When the load finishes, open <a href="http://localhost:8888/unified-console.html#datasources" target="_blank" rel="noopener noreferrer">http://localhost:8888/unified-console.md#datasources</a> in a browser.</p> |
| <h2 class="anchor anchorWithStickyNavbar_LWe7" id="how-to-permanently-delete-data">How to permanently delete data<a href="#how-to-permanently-delete-data" class="hash-link" aria-label="Direct link to How to permanently delete data" title="Direct link to How to permanently delete data"></a></h2> |
| <p>Permanent deletion of a Druid segment has two steps:</p> |
| <ol> |
| <li>The segment must first be marked as "unused". This occurs when a user manually disables a segment through the Coordinator API.</li> |
| <li>After segments have been marked as "unused", a Kill Task will delete any "unused" segments from Druid's metadata store as well as deep storage.</li> |
| </ol> |
| <p>Let's drop some segments now, by using the coordinator API to drop data by interval and segmentIds.</p> |
| <h2 class="anchor anchorWithStickyNavbar_LWe7" id="disable-segments-by-interval">Disable segments by interval<a href="#disable-segments-by-interval" class="hash-link" aria-label="Direct link to Disable segments by interval" title="Direct link to Disable segments by interval"></a></h2> |
| <p>Let's disable segments in a specified interval. This will mark all segments in the interval as "unused", but not remove them from deep storage. |
| Let's disable segments in interval <code>2015-09-12T18:00:00.000Z/2015-09-12T20:00:00.000Z</code> i.e. between hour 18 and 20.</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">curl -X 'POST' -H 'Content-Type:application/json' -d '{ "interval" : "2015-09-12T18:00:00.000Z/2015-09-12T20:00:00.000Z" }' http://localhost:8081/druid/coordinator/v1/datasources/deletion-tutorial/markUnused</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <p>When the request completes, the Segments view of the web console no longer displays the segments for hours 18 and 19. |
| <img decoding="async" loading="lazy" alt="Segments 1" src="/assets/images/tutorial-deletion-01-891729c30511abdcc26da807fd50122f.png" title="Segments 1" width="1250" height="640" class="img_ev3q"></p> |
| <p>Note that the hour 18 and 19 segments are still present in deep storage:</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">$ ls -l1 var/druid/segments/deletion-tutorial/</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T00:00:00.000Z_2015-09-12T01:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T01:00:00.000Z_2015-09-12T02:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T02:00:00.000Z_2015-09-12T03:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T03:00:00.000Z_2015-09-12T04:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T04:00:00.000Z_2015-09-12T05:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T05:00:00.000Z_2015-09-12T06:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T06:00:00.000Z_2015-09-12T07:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T07:00:00.000Z_2015-09-12T08:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T08:00:00.000Z_2015-09-12T09:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T09:00:00.000Z_2015-09-12T10:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T10:00:00.000Z_2015-09-12T11:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T11:00:00.000Z_2015-09-12T12:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T12:00:00.000Z_2015-09-12T13:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T13:00:00.000Z_2015-09-12T14:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T14:00:00.000Z_2015-09-12T15:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T15:00:00.000Z_2015-09-12T16:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T16:00:00.000Z_2015-09-12T17:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T17:00:00.000Z_2015-09-12T18:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T18:00:00.000Z_2015-09-12T19:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T19:00:00.000Z_2015-09-12T20:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T20:00:00.000Z_2015-09-12T21:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T21:00:00.000Z_2015-09-12T22:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T22:00:00.000Z_2015-09-12T23:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T23:00:00.000Z_2015-09-13T00:00:00.000Z</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <h2 class="anchor anchorWithStickyNavbar_LWe7" id="disable-segments-by-segment-ids">Disable segments by segment IDs<a href="#disable-segments-by-segment-ids" class="hash-link" aria-label="Direct link to Disable segments by segment IDs" title="Direct link to Disable segments by segment IDs"></a></h2> |
| <p>Let's disable some segments by their segmentID. This will again mark the segments as "unused", but not remove them from deep storage. You can see the full segmentID for a segment using the web console.</p> |
| <p>In the <a href="http://localhost:8888/unified-console.html#segments" target="_blank" rel="noopener noreferrer">segments view</a>, click one of the segment rows to open the segment metadata dialog:</p> |
| <p><img decoding="async" loading="lazy" alt="Segments_2" src="/assets/images/tutorial-deletion-02-178ae7a7beae527951d67c5b79412e3d.png" title="Segments 2" width="1250" height="640" class="img_ev3q"></p> |
| <p>The <code>identifier</code> field in the metadata dialog shows the full segment ID. For example, the hour 23 segment has segment ID <code>deletion-tutorial_2015-09-12T23:00:00.000Z_2015-09-13T00:00:00.000Z_2023-05-16T00:04:12.091Z</code>.</p> |
| <p>Disable the last two segments, hour 22 and 23 segments, by sending a POST request to the Coordinator with the corresponding segment IDs. |
| The following command queries the Coordinator for segment IDs and uses <code>jq</code> to parse and extract the IDs of the last two segments. |
| The segment IDs are stored in an environment variable named <code>unusedSegmentIds</code>.</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">unusedSegmentIds=$(curl -X 'GET' -H 'Content-Type:application/json' http://localhost:8081/druid/coordinator/v1/datasources/deletion-tutorial/segments | jq '.[-2:]')</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <p>The following request marks the segments unused:</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">curl -X 'POST' -H 'Content-Type:application/json' -d "{\"segmentIds\": $unusedSegmentIds}" http://localhost:8081/druid/coordinator/v1/datasources/deletion-tutorial/markUnused</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <p>When the request completes, the Segments view of the web console no longer displays the segments for hours 22 and 23.</p> |
| <p><img decoding="async" loading="lazy" alt="Segments 3" src="/assets/images/tutorial-deletion-03-09b79439abe874b5e8d765b249b28d89.png" title="Segments 3" width="1250" height="640" class="img_ev3q"></p> |
| <p>Note that the hour 22 and 23 segments are still in deep storage:</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">$ ls -l1 var/druid/segments/deletion-tutorial/</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T00:00:00.000Z_2015-09-12T01:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T01:00:00.000Z_2015-09-12T02:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T02:00:00.000Z_2015-09-12T03:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T03:00:00.000Z_2015-09-12T04:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T04:00:00.000Z_2015-09-12T05:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T05:00:00.000Z_2015-09-12T06:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T06:00:00.000Z_2015-09-12T07:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T07:00:00.000Z_2015-09-12T08:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T08:00:00.000Z_2015-09-12T09:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T09:00:00.000Z_2015-09-12T10:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T10:00:00.000Z_2015-09-12T11:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T11:00:00.000Z_2015-09-12T12:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T12:00:00.000Z_2015-09-12T13:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T13:00:00.000Z_2015-09-12T14:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T14:00:00.000Z_2015-09-12T15:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T15:00:00.000Z_2015-09-12T16:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T16:00:00.000Z_2015-09-12T17:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T17:00:00.000Z_2015-09-12T18:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T18:00:00.000Z_2015-09-12T19:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T19:00:00.000Z_2015-09-12T20:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T20:00:00.000Z_2015-09-12T21:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T21:00:00.000Z_2015-09-12T22:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T22:00:00.000Z_2015-09-12T23:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T23:00:00.000Z_2015-09-13T00:00:00.000Z</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <h2 class="anchor anchorWithStickyNavbar_LWe7" id="run-a-kill-task">Run a kill task<a href="#run-a-kill-task" class="hash-link" aria-label="Direct link to Run a kill task" title="Direct link to Run a kill task"></a></h2> |
| <p>Now that we have disabled some segments, we can submit a Kill Task, which will delete the disabled segments from metadata and deep storage.</p> |
| <p>A Kill Task spec has been provided at <code>quickstart/tutorial/deletion-kill.json</code>. Submit this task to the Overlord with the following command:</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">curl -X 'POST' -H 'Content-Type:application/json' -d @quickstart/tutorial/deletion-kill.json http://localhost:8081/druid/indexer/v1/task</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div> |
| <p>When the task finishes, note that Druid deleted the disabled segments from deep storage.</p> |
| <div class="language-bash codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#bfc7d5;--prism-background-color:#292d3e"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-bash codeBlock_bY9V thin-scrollbar" style="color:#bfc7d5;background-color:#292d3e"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#bfc7d5"><span class="token plain">$ ls -l1 var/druid/segments/deletion-tutorial/</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T00:00:00.000Z_2015-09-12T01:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T01:00:00.000Z_2015-09-12T02:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T02:00:00.000Z_2015-09-12T03:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T03:00:00.000Z_2015-09-12T04:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T04:00:00.000Z_2015-09-12T05:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T05:00:00.000Z_2015-09-12T06:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T06:00:00.000Z_2015-09-12T07:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T07:00:00.000Z_2015-09-12T08:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T08:00:00.000Z_2015-09-12T09:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T09:00:00.000Z_2015-09-12T10:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T10:00:00.000Z_2015-09-12T11:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T11:00:00.000Z_2015-09-12T12:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T12:00:00.000Z_2015-09-12T13:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T13:00:00.000Z_2015-09-12T14:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T14:00:00.000Z_2015-09-12T15:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T15:00:00.000Z_2015-09-12T16:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T16:00:00.000Z_2015-09-12T17:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T17:00:00.000Z_2015-09-12T18:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T20:00:00.000Z_2015-09-12T21:00:00.000Z</span><br></span><span class="token-line" style="color:#bfc7d5"><span class="token plain">2015-09-12T21:00:00.000Z_2015-09-12T22:00:00.000Z</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div></div></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/34.0.0/tutorials/tutorial-compaction"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">Compact segments</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/34.0.0/tutorials/tutorial-latest-by"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">Query for latest data</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href="#load-initial-data" class="table-of-contents__link toc-highlight">Load initial data</a></li><li><a href="#how-to-permanently-delete-data" class="table-of-contents__link toc-highlight">How to permanently delete data</a></li><li><a href="#disable-segments-by-interval" class="table-of-contents__link toc-highlight">Disable segments by interval</a></li><li><a href="#disable-segments-by-segment-ids" class="table-of-contents__link toc-highlight">Disable segments by segment IDs</a></li><li><a href="#run-a-kill-task" class="table-of-contents__link toc-highlight">Run a kill task</a></li></ul></div></div></div></div></main></div></div></div><footer class="footer"><div class="container container-fluid"><div class="footer__bottom text--center"><div class="margin-bottom--sm"><img src="/img/favicon.png" class="footer__logo themedComponent_mlkZ themedComponent--light_NVdE"><img src="/img/favicon.png" class="footer__logo themedComponent_mlkZ themedComponent--dark_xIcU"></div><div class="footer__copyright">Copyright © 2025 Apache Software Foundation. Except where otherwise noted, licensed under CC BY-SA 4.0. Apache Druid, Druid, and the Druid logo are either registered trademarks or trademarks of The Apache Software Foundation in the United States and other countries.</div></div></div></footer></div> |
| </body> |
| </html> |
