# How delete data from elasticsearch according to index time

**URL:** <https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064>\
**Category:** Elasticsearch\
**Created:** [March 1, 2016, 2:04am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064 "2016-03-01T02:04:52Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![lizhenmxcz](https://avatars.discourse-cdn.com/v4/letter/l/a88e57/32.png) [@lizhenmxcz](https://discuss.elastic.co/u/lizhenmxcz)\
**Post date:** [March 1, 2016, 2:04am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/1 "2016-03-01T02:04:53Z")

</div>

hi all:  
I index data use spark, but the job failed after ran few hours, so the data is incomplete. I want to delete them that indexed in that few hours. How can I do it? Thanks.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 1, 2016, 2:27am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/2 "2016-03-01T02:27:28Z")

</div>

Is all the data in one single index?  
Is is mixed with other data?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 1, 2016, 2:23am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/3 "2016-03-01T02:23:28Z")

</div>

If you set the document ids in your job, you can just reindex again. It will overwrite existing docs.

If you have a timestamp or a range of ids, you can use the delete by query plugin.

David.

---

<div class="post-metadata">

**Author:** ![lizhenmxcz](https://avatars.discourse-cdn.com/v4/letter/l/a88e57/32.png) [@lizhenmxcz](https://discuss.elastic.co/u/lizhenmxcz)\
**Post date:** [March 1, 2016, 2:34am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/4 "2016-03-01T02:34:19Z")

</div>

all data in one single index

---

<div class="post-metadata">

**Author:** ![lizhenmxcz](https://avatars.discourse-cdn.com/v4/letter/l/a88e57/32.png) [@lizhenmxcz](https://discuss.elastic.co/u/lizhenmxcz)\
**Post date:** [March 1, 2016, 2:39am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/5 "2016-03-01T02:39:42Z")

</div>

hi David, I use automatic ID, and has no timestamp in the data, so i don't no how to filter the data use query plugin.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 1, 2016, 2:40am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/6 "2016-03-01T02:40:01Z")

</div>

Is there other data in the same index? If not then just delete the index.

---

<div class="post-metadata">

**Author:** ![lizhenmxcz](https://avatars.discourse-cdn.com/v4/letter/l/a88e57/32.png) [@lizhenmxcz](https://discuss.elastic.co/u/lizhenmxcz)\
**Post date:** [March 1, 2016, 2:41am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/7 "2016-03-01T02:41:54Z")

</div>

yes, there are much other data in the index

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 1, 2016, 2:42am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/8 "2016-03-01T02:42:35Z")

</div>

You are probably better of putting it into it's own index then.

For this, you will need to use the delete-by-query plugin.

---

<div class="post-metadata">

**Author:** ![lizhenmxcz](https://avatars.discourse-cdn.com/v4/letter/l/a88e57/32.png) [@lizhenmxcz](https://discuss.elastic.co/u/lizhenmxcz)\
**Post date:** [March 1, 2016, 2:47am UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/9 "2016-03-01T02:47:33Z")

</div>

Mark, thanks for your reply , but i don't know how to use the query plugin, the data has no unique feature except indexed time

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:12pm UTC](https://discuss.elastic.co/t/how-delete-data-from-elasticsearch-according-to-index-time/43064/10 "2017-07-05T23:12:42Z")

</div>


