# Delete some data in index **URL:** \ **Category:** Elasticsearch\ **Created:** [July 17, 2016, 8:30pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701 "2016-07-17T20:30:11Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![pittoch](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@pittoch](https://discuss.elastic.co/u/pittoch)\ **Post date:** [July 17, 2016, 8:30pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/1 "2016-07-17T20:30:11Z")
Hello, With Curl, how is it possible to remove a portion of an index data : - 1st case : any recording \> on a date (use @timestamp column) - 2nd case : delete all records where the column test have the value "ok". Thanks. ---
**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:** [July 17, 2016, 8:51pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/2 "2016-07-17T20:51:03Z")
Depending on your version: delete by query plugin/feature could help. ---
**Author:** ![pittoch](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@pittoch](https://discuss.elastic.co/u/pittoch)\ **Post date:** [July 19, 2016, 9:30am UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/3 "2016-07-19T09:30:02Z")
Where can I download this plugin for offline installation ? Thanks ---
**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:** [July 19, 2016, 10:02am UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/4 "2016-07-19T10:02:46Z")
As I said it depends on your version. ---
**Author:** ![pittoch](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@pittoch](https://discuss.elastic.co/u/pittoch)\ **Post date:** [July 19, 2016, 11:01am UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/5 "2016-07-19T11:01:35Z")
I have elasticsearch 2.3.2 ---
**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:** [July 19, 2016, 11:13am UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/6 "2016-07-19T11:13:57Z")
Doc is here: [https://www.elastic.co/guide/en/elasticsearch/plugins/current/plugins-delete-by-query.html](https://www.elastic.co/guide/en/elasticsearch/plugins/current/plugins-delete-by-query.html) If you need to install it offline, try the online mode with verbose option. It will print the URL which is used. Use this URL to download the ZIP file. Then install it using: ```auto bin/plugin install file:///path/to/zip ``` ---
**Author:** ![pittoch](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@pittoch](https://discuss.elastic.co/u/pittoch)\ **Post date:** [July 19, 2016, 11:52am UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/7 "2016-07-19T11:52:38Z")
thanks! ---
**Author:** ![Ravi\_Shanker\_Reddy](https://avatars.discourse-cdn.com/v4/letter/r/a5b964/32.png) [@Ravi\_Shanker\_Reddy](https://discuss.elastic.co/u/Ravi_Shanker_Reddy)\ **Post date:** [July 19, 2016, 1:14pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/8 "2016-07-19T13:14:25Z")
How to install that plugin without down time of ES ??? ---
**Author:** ![pittoch](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@pittoch](https://discuss.elastic.co/u/pittoch)\ **Post date:** [July 19, 2016, 3:11pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/9 "2016-07-19T15:11:04Z")
In the doc, I don't understand the example. ``` DELETE /twitter/tweet/_query?q=user:kimchy ``` In my case, i have an index called "index\_baie1" with a column called "prediction". This column have some values : "yes", "no" . I need to delete all records of the index where prediction=yes. How can do it ? I test: DELETE /index\_baie1/prediction/\_query?q=prediction:yes ---
**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:** [July 19, 2016, 4:29pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/10 "2016-07-19T16:29:10Z")
May be install it on one node. Start the node. Let shards replicate. Then close the old node. Install the plugin. Start the node... And so on for all nodes. Like a rolling upgrade. ---
**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:** [July 19, 2016, 4:30pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/11 "2016-07-19T16:30:32Z")
```auto DELETE /index_baie1/prediction/_query?q=prediction:yes ``` Yes. Probably. I'd prefer using the Query DSL though. Something like: ```auto DELETE /index_baie1/prediction/_query { "query": { // Your query here } } ``` ---
**Author:** ![pittoch](https://avatars.discourse-cdn.com/v4/letter/p/df788c/32.png) [@pittoch](https://discuss.elastic.co/u/pittoch)\ **Post date:** [July 20, 2016, 4:29pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/12 "2016-07-20T16:29:37Z")
It's work with core2 instead of tweet ---
**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, 10:33pm UTC](https://discuss.elastic.co/t/delete-some-data-in-index/55701/13 "2017-07-05T22:33:59Z")