blocks|key|4620693|text|我相信，如果您将delete+by查询与匹配所有查询组合在一起，它应该会执行您正在寻找的操作，如下所示(使用您的示例)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4620694|curl+-XDELETE+'http://localhost:9200/twitter/tweet/_query'+-d+'{
++++"query"+:+{+
++++++++"match_all"+:+{}
++++}
}'|code-block|syntax|javascript|4620695|或者您可以直接删除该类型：|4620696|curl+-XDELETE+http://localhost:9200/twitter/tweet|4620697|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I believe if you combine the delete by query with a match all it should do what you are looking for, something like this (using your example):

<pre><code>curl -XDELETE 'http://localhost:9200/twitter/tweet/_query' -d '{
 "query" : { 
 "match_all" : {}
 }
}'
</code></pre>

Or you could just delete the type:

<pre><code>curl -XDELETE http://localhost:9200/twitter/tweet
</code></pre>

blocks|key|115001|text|从ElasticSearch+5.x开始，delete_by_query+API默认存在|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115002|POST:+http://localhost:9200/index/type/_delete_by_query|offset|length|style|CODE|115003|{
++++"query":+{+
++++++++"match_all":+{}
++++}
}|code-block|syntax|javascript|115004|entityMap^0|0|0|1J|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

From ElasticSearch 5.x, delete_by_query API is there by default

<code>POST: http://localhost:9200/index/type/_delete_by_query</code>

<pre><code>{
 "query": { 
 "match_all": {}
 }
}
</code></pre>

blocks|key|4620838|text|您可以使用以下查询从类型中删除单据：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4620839|POST+/index/type/_delete_by_query
{
++++"query"+:+{+
++++++++"match_all"+:+{}
++++}
}|code-block|syntax|javascript|4620840|我在Kibana和Elastic+5.5.2中测试了这个查询|4620841|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can delete documents from type with following query:

<pre><code>POST /index/type/_delete_by_query
{
 "query" : { 
 "match_all" : {}
 }
}
</code></pre>

I tested this query in Kibana and Elastic 5.5.2

blocks|key|114897|text|Torsten+Engelbrecht在John+Petrones+answer中的评论扩展了：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|114898|curl+-XDELETE+'http://localhost:9200/twitter/tweet/_query'+-d+
++'{
++++++"query":+
++++++{
++++++++++"match_all":+{}
++++++}
+++}'|code-block|syntax|javascript|114899|(我不想编辑John的回复，因为它得到了支持并被设置为答案，而且我可能引入了一个错误)|114900|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Torsten Engelbrecht's comment in John Petrones answer expanded:

<pre><code>curl -XDELETE 'http://localhost:9200/twitter/tweet/_query' -d 
 '{
 "query": 
 {
 "match_all": {}
 }
 }'
</code></pre>

(I did not want to edit John's reply, since it got upvotes and is set as answer, and I might have introduced an error)

blocks|key|4620743|text|从Elasticsearch+2.x开始，不再允许delete，因为文档仍然保留在索引中，从而导致索引损坏。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4620744|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Starting from Elasticsearch 2.x delete is not anymore allowed, since documents remain in the index causing index corruption.

blocks|key|4620897|text|由于Strict+Content-Type+Checking+for+Elasticsearch+REST+Requests，上述答案不再适用于ES+6.2.2。我最终使用的curl命令如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4620898|curl+-H'Content-Type:+application/json'+-XPOST+'localhost:9200/yourindex/_doc/_delete_by_query?conflicts=proceed'+-d'+{+"query":+{+"match_all":+{}+}}'|code-block|syntax|javascript|4620899|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/blog/strict-content-type-checking-for-elasticsearch-rest-requests^0|2F|4|2|1O|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

The above answers no longer work with ES 6.2.2 because of <a href="https://www.elastic.co/blog/strict-content-type-checking-for-elasticsearch-rest-requests" rel="noreferrer">Strict Content-Type Checking for Elasticsearch REST Requests</a>. The <code>curl</code> command which I ended up using is this:

<pre><code>curl -H'Content-Type: application/json' -XPOST 'localhost:9200/yourindex/_doc/_delete_by_query?conflicts=proceed' -d' { "query": { "match_all": {} }}'
</code></pre>

blocks|key|4620945|text|我使用的是elasticsearch+7.5，当我使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4620946|curl+-XPOST+'localhost:9200/materials/_delete_by_query?conflicts=proceed&pretty'+-d'
{
++++"query":+{
++++++++"match_all":+{}
++++}
}'|code-block|syntax|javascript|4620947|这将抛出以下错误。|4620948|{
++"error"+:+"Content-Type+header+[application/x-www-form-urlencoded]+is+not+supported",
++"status"+:+406
}|4620949|我还需要在请求中添加额外的-H+'Content-Type:+application/json'头以使其正常工作。|offset|length|style|CODE|4620950|curl+-XPOST+'localhost:9200/materials/_delete_by_query?conflicts=proceed&pretty'++-H+'Content-Type:+application/json'+-d'
{
++++"query":+{
++++++++"match_all":+{}
++++}
}'
{
++"took"+:+465,
++"timed_out"+:+false,
++"total"+:+2275,
++"deleted"+:+2275,
++"batches"+:+3,
++"version_conflicts"+:+0,
++"noops"+:+0,
++"retries"+:+{
++++"bulk"+:+0,
++++"search"+:+0
++},
++"throttled_millis"+:+0,
++"requests_per_second"+:+-1.0,
++"throttled_until_millis"+:+0,
++"failures"+:+[+]
}|4620951|entityMap^0|0|0|0|0|D|Z|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I'm using elasticsearch 7.5 and when I use

<pre><code>curl -XPOST 'localhost:9200/materials/_delete_by_query?conflicts=proceed&amp;pretty' -d'
{
 "query": {
 "match_all": {}
 }
}'
</code></pre>

which will throw below error.

<pre><code>{
 "error" : "Content-Type header [application/x-www-form-urlencoded] is not supported",
 "status" : 406
}
</code></pre>

I also need to add extra <code>-H 'Content-Type: application/json'</code> header in the request to make it works.

<pre><code>curl -XPOST 'localhost:9200/materials/_delete_by_query?conflicts=proceed&amp;pretty' -H 'Content-Type: application/json' -d'
{
 "query": {
 "match_all": {}
 }
}'
{
 "took" : 465,
 "timed_out" : false,
 "total" : 2275,
 "deleted" : 2275,
 "batches" : 3,
 "version_conflicts" : 0,
 "noops" : 0,
 "retries" : {
 "bulk" : 0,
 "search" : 0
 },
 "throttled_millis" : 0,
 "requests_per_second" : -1.0,
 "throttled_until_millis" : 0,
 "failures" : [ ]
}
</code></pre>

blocks|key|4620785|text|只是为了补充几分钱。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4620786|上面提到的"delete_by_query"在elasticsearch+2.x中仍然是一个插件。|offset|length|4620787|尽管在即将发布的最新版本5.x中，它将被"delete+by+query+api"所取代|4620788|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/plugins/current/delete-by-query-usage.html|1|https://www.elastic.co/guide/en/elasticsearch/reference/master/docs-delete-by-query.html^0|0|5|H|0|0|K|L|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

Just to add couple cents to this. 

The <a href="https://www.elastic.co/guide/en/elasticsearch/plugins/current/delete-by-query-usage.html" rel="nofollow">"delete_by_query"</a> mentioned at the top is still available as a plugin in elasticsearch 2.x. 

Although in the latest upcoming version 5.x it will be replaced by 
<a href="https://www.elastic.co/guide/en/elasticsearch/reference/master/docs-delete-by-query.html" rel="nofollow">"delete by query api"</a>

blocks|key|4620766|text|Elasticsearch+2.3选项|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4620767|++++action.destructive_requires_name:+true|code-block|syntax|javascript|4620768|在elasticsearch.yml中进行旅行|4620769|++++curl+-XDELETE+http://localhost:9200/twitter/tweet|4620770|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Elasticsearch 2.3 the option

<pre><code> action.destructive_requires_name: true
</code></pre>

in elasticsearch.yml do the trip

<pre><code> curl -XDELETE http://localhost:9200/twitter/tweet
</code></pre>

blocks|key|115060|text|如果您想要按日期删除单据。您可以使用kibana控制台(v.6.1.2)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115061|POST+index_name/_delete_by_query
{
++++++"query"+:+{
++++++++++++++"range"+:+{
+++++++++++++++++"sendDate"+:+{
+++++++++++++++++++++"lte"+:+"2018-03-06"
++++++++++++++++++++++++++++++}
++++++++++++++++++++++++}
++++++++++++++++++}
}|code-block|syntax|javascript|115062|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you want to delete document according to a date.
You can use kibana console (v.6.1.2)

<pre><code>POST index_name/_delete_by_query
{
 "query" : {
 "range" : {
 "sendDate" : {
 "lte" : "2018-03-06"
 }
 }
 }
}
</code></pre>

I know one can delete all documents from a certain type via deleteByQuery.

Example:

<pre><code>curl -XDELETE 'http://localhost:9200/twitter/tweet/_query' -d '{
 "query" : {
 "term" : { "user" : "kimchy" }
 }
}'
</code></pre>

But i have NO term and simply want to delete all documents from that type, no matter what term. What is best practice to achieve this? Empty term does not work.

<a href="http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/docs-delete-by-query.html">Link to deleteByQuery</a>

Delete all documents from index/type without deleting type

Elasticsearch 

我知道可以通过deleteByQuery删除特定类型的所有文档。示例：curl -XDELETE 'http://localhost:9200/twitter/tweet/_query' -d '{    "query" : {        "term" : { "user" : "kimchy" }    }}'但我没有术语，只是想删除该类型的所有文档，无论是什么术语。实现这一目标的最佳实践是

问从索引/类型中删除所有文档而不删除类型
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从索引/类型中删除所有文档而不删除类型EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从索引/类型中删除所有文档而不删除类型
EN