blocks|key|147770|text|如果您使用的是默认分析器(standard)，那么如果它是空字符串，就没有什么可分析的了。因此，您需要逐字索引该字段(而不是分析)。下面是一个示例：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|147771|添加一个映射，该映射将索引未标记化的字段，如果还需要索引的字段的标记化副本，则可以使用Multi+Field类型。|147772|PUT+http://localhost:9200/test/_mapping/demo
{
++"demo":+{
++++"properties":+{
++++++"_content":+{
++++++++"type":+"string",
++++++++"index":+"not_analyzed"
++++++}
++++}
++}
}|code-block|syntax|javascript|147773|接下来，为几个文档建立索引。|147774|/POST+http://localhost:9200/test/demo/1/
{
++"_content":+""
}

/POST+http://localhost:9200/test/demo/2
{
++"_content":+"some+content"
}|147775|执行搜索：|147776|POST+http://localhost:9200/test/demo/_search
{
++"query":+{
++++"filtered":+{
++++++"filter":+{
++++++++"term":+{
++++++++++"_content":+""
++++++++}
++++++}
++++}
++}
}|147777|返回包含空字符串的文档。|147778|{
++++took:+2,
++++timed_out:+false,
++++_shards:+{
++++++++total:+5,
++++++++successful:+5,
++++++++failed:+0
++++},
++++hits:+{
++++++++total:+1,
++++++++max_score:+0.30685282,
++++++++hits:+[
++++++++++++{
++++++++++++++++_index:+test,
++++++++++++++++_type:+demo,
++++++++++++++++_id:+1,
++++++++++++++++_score:+0.30685282,
++++++++++++++++_source:+{
++++++++++++++++++++_content:+""
++++++++++++++++}
++++++++++++}
++++++++]
++++}
}|147779|entityMap|0|LINK|mutability|MUTABLE|url|http://www.elasticsearch.org/guide/en/elasticsearch/reference/0.90/mapping-multi-field-type.html^0|D|8|0|17|B|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|19|8|@]|D|@$9|1A|A|1B|1|1C]]|E|$]]|$1|H|3|I|5|J|7|1D|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1E|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1F|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1G|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|1H|8|@]|D|@]|E|$K|L]]|$1|U|3|V|5|6|7|1I|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|1J|8|@]|D|@]|E|$K|L]]|$1|Y|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]]|Z|$10|$5|11|12|13|E|$14|15]]]]

If you are using the default analyzer (<code>standard</code>) there is nothing for it to analyze if it is an empty string. So you need to index the field verbatim (not analyzed). Here is an example:

Add a mapping that will index the field untokenized, if you need a tokenized copy of the field indexed as well you can use a <a href="http://www.elasticsearch.org/guide/en/elasticsearch/reference/0.90/mapping-multi-field-type.html" rel="noreferrer">Multi Field</a> type. 

<pre><code>PUT http://localhost:9200/test/_mapping/demo
{
 "demo": {
 "properties": {
 "_content": {
 "type": "string",
 "index": "not_analyzed"
 }
 }
 }
}
</code></pre>

Next, index a couple of documents. 

<pre><code>/POST http://localhost:9200/test/demo/1/
{
 "_content": ""
}

/POST http://localhost:9200/test/demo/2
{
 "_content": "some content"
}
</code></pre>

Execute a search:

<pre><code>POST http://localhost:9200/test/demo/_search
{
 "query": {
 "filtered": {
 "filter": {
 "term": {
 "_content": ""
 }
 }
 }
 }
}
</code></pre>

Returns the document with the empty string.

<pre><code>{
 took: 2,
 timed_out: false,
 _shards: {
 total: 5,
 successful: 5,
 failed: 0
 },
 hits: {
 total: 1,
 max_score: 0.30685282,
 hits: [
 {
 _index: test,
 _type: demo,
 _id: 1,
 _score: 0.30685282,
 _source: {
 _content: ""
 }
 }
 ]
 }
}
</code></pre>

blocks|key|2730847|text|为了查找文档中某个字段的空字符串，它与该字段的映射密切相关，换句话说，就是它的index/analyzer设置。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2730848|如果它的索引是not_analyzed，这意味着令牌只是一个空字符串，您可以使用term查询来查找它，如下所示：|2730849|{"from":+0,+"size":+100,+"query":{"term":+{"name":""}}}|2730850|否则，如果index设置为analyzed，我相信大多数分析器都会将空字符串视为空值，这样您就可以使用过滤器来查找空字符串。|2730851|{"filter":+{"missing":+{"existence":+true,+"field":+"name",+"null_value":+true}},+"query":+{"match_all":+{}}}|2730852|下面是您可以参考的要点脚本：https://gist.github.com/hxuanji/35b982b86b3601cb5571|2730853|顺便说一句，我检查了你提供的命令，看起来你不想要空的字符串文档。而我上面的所有命令都只是为了找到它们，所以只要把它放到bool查询的must_not部分就可以了。我的ES是1.0.1。|2730854|2730855|对于ES+1.3.0，目前我提供的gist找不到空字符串。似乎已经有报道了：https://github.com/elasticsearch/elasticsearch/issues/7348。让我们拭目以待吧。|2730856|无论如何，它还提供了另一个命令来查找|2730857|2730858|+{“查询”：{“已过滤”：{“过滤”：{“不”：{“过滤”：{“范围”：{“名称”：{}}|blockquote|2730859|2730860|2730861|name是用于查找空字符串的字段名称。我已经在ES+1.3.2上测试过了。|2730862|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/hxuanji/35b982b86b3601cb5571|1|https://github.com/elasticsearch/elasticsearch/issues/7348^0|13|5|19|8|0|7|C|14|4|0|0|1J|0|5|5|D|8|0|0|31|0|E|1G|0|0|1N|4|1U|8|0|0|12|1M|1|0|0|0|0|0|0|0|4|0^^$0|@$1|2|3|4|5|6|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1J|8|@$9|1K|A|1L|B|C]|$9|1M|A|1N|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1O|8|@$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1R|8|@$9|1S|A|1T|B|C]|$9|1U|A|1V|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|1W|8|@$9|1X|A|1Y|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|1Z|8|@]|D|@$9|20|A|21|1|22]]|E|$]]|$1|P|3|Q|5|6|7|23|8|@$9|24|A|25|B|C]|$9|26|A|27|B|C]]|D|@]|E|$]]|$1|R|3|-4|5|6|7|28|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|29|8|@]|D|@$9|2A|A|2B|1|2C]]|E|$]]|$1|U|3|V|5|6|7|2D|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|2E|8|@]|D|@]|E|$]]|$1|X|3|Y|5|Z|7|2F|8|@]|D|@]|E|$]]|$1|10|3|-4|5|6|7|2G|8|@]|D|@]|E|$]]|$1|11|3|-4|5|6|7|2H|8|@]|D|@]|E|$]]|$1|12|3|13|5|6|7|2I|8|@$9|2J|A|2K|B|C]]|D|@]|E|$]]|$1|14|3|-4|5|6|7|2L|8|@]|D|@]|E|$]]]|15|$16|$5|17|18|19|E|$1A|1B]]|1C|$5|17|18|19|E|$1A|1D]]]]

in order to find the empty string of one field in your document, it's highly relevant to the field's mapping, in other word, its <code>index</code>/<code>analyzer</code> setting .

If its index is <code>not_analyzed</code>, which means the token is just the empty string, you can just use <code>term</code> query to find it, as follows:

<code>{"from": 0, "size": 100, "query":{"term": {"name":""}}}</code>

Otherwise, if the <code>index</code> setting is <code>analyzed</code> and I believe most analyzer will treat empty string as null value So
you can use the filter to find the empty string.

<code>{"filter": {"missing": {"existence": true, "field": "name", "null_value": true}}, "query": {"match_all": {}}}</code>

here is the gist script you can reference: <a href="https://gist.github.com/hxuanji/35b982b86b3601cb5571" rel="nofollow">https://gist.github.com/hxuanji/35b982b86b3601cb5571</a>

BTW, I check the commands you provided, it seems you DON'T want the empty string document.
And all my above command are just to find these, so just put it into <code>must_not</code> part of <code>bool</code> query would be fine.
My ES is 1.0.1.

<hr>

For ES 1.3.0, currently the gist I provided cannot find the empty string. It seems it has been reported: <a href="https://github.com/elasticsearch/elasticsearch/issues/7348" rel="nofollow">https://github.com/elasticsearch/elasticsearch/issues/7348</a> . Let's wait and see how it go.

Anyway, it also provides another command to find

<blockquote>
 { "query": {
 "filtered": {
 "filter": {
 "not": {
 "filter": {
 "range": {
 "name": {
 }
 }
 }
 }
 }
 } } }
</blockquote>

<code>name</code> is the field name to find the empty-string. I've tested it on ES 1.3.2.

blocks|key|147800|text|即使使用默认分析器，您也可以执行这种搜索:使用script+filter，它速度较慢，但可以处理空字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|147801|curl+-XPOST+'http://localhost:9200/test/demo/_search'+-d+'
{
+"query":+{
+++"filtered":+{
+++++"filter":+{
+++++++"script":+{
+++++++++"script":+"_source._content.length()+==+0"
+++++++}
+++++}
+++}
+}
}'|code-block|syntax|javascript|147802|它将返回没有特殊映射的_content形式的空字符串文档|147803|正如@js_gandalf所指出的，对于ES>5.0，这是不推荐使用的。相反，您应该像在https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html中那样使用:+query->bool->filter->script|147804|entityMap|0|LINK|mutability|MUTABLE|url|http://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-script-filter.html|1|https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html^0|N|D|0|0|0|0|18|2H|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

Even with the default analyzer you can do this kind of search: use a <a href="http://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-script-filter.html" rel="nofollow noreferrer">script filter</a>, which is slower but can handle the empty string:

<pre><code>curl -XPOST 'http://localhost:9200/test/demo/_search' -d '
{
 "query": {
 "filtered": {
 "filter": {
 "script": {
 "script": "_source._content.length() == 0"
 }
 }
 }
 }
}'
</code></pre>

It will return the document with empty string as _content without a special mapping

As pointed by @js_gandalf, this is deprecated for ES>5.0. Instead you should use: query->bool->filter->script as in <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html" rel="nofollow noreferrer">https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html</a>

blocks|key|150590|text|对于那些使用elastic+search+5.2或更高版本的用户，仍然卡住了。最简单的方法是使用关键字类型正确地重新索引您的数据。然后，所有对空值的搜索都起作用了。如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150591|"query":+{
++++"term":+{"MY_FIELD_TO_SEARCH":+""}
}|code-block|syntax|javascript|150592|实际上，当我重新索引我的数据库并重新运行查询时。它成功了=)|150593|问题是我的字段是type:+text，而不是关键字。已将索引更改为关键字并已重新编制索引：|150594|curl+-X+PUT+https://username:password@host.io:9200/mycoolindex

curl+-X+PUT+https://user:pass@host.io:9200/mycoolindex/_mapping/mycooltype+-d+'{
++"properties":+{
++++++++++++"MY_FIELD_TO_SEARCH":+{
++++++++++++++++++++"type":+"keyword"
++++++++++++++++},
}'

curl+-X+PUT+https://username:password@host.io:9200/_reindex+-d+'{
+"source":+{
+++"index":+"oldindex"
+},
+"dest":+{
++++"index":+"mycoolindex"
+}
}'|150595|我希望这能帮助像我一样陷入困境的人找到那些空值。|150596|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For those of you using elastic search 5.2 or above, and still stuck. Easiest way is to reindex your data correctly with the keyword type. Then all the searches for empty values worked. Like this:

<pre><code>"query": {
 "term": {"MY_FIELD_TO_SEARCH": ""}
}
</code></pre>

Actually, when I reindex my database and rerun the query. It worked =)

The problem was that my field was type: text and NOT a keyword. Changed the index to keyword and reindexed:

<pre><code>curl -X PUT https://username:password@host.io:9200/mycoolindex

curl -X PUT https://user:pass@host.io:9200/mycoolindex/_mapping/mycooltype -d '{
 "properties": {
 "MY_FIELD_TO_SEARCH": {
 "type": "keyword"
 },
}'

curl -X PUT https://username:password@host.io:9200/_reindex -d '{
 "source": {
 "index": "oldindex"
 },
 "dest": {
 "index": "mycoolindex"
 }
}'
</code></pre>

I hope this helps someone who was as stuck as I was finding those empty values.

blocks|key|2943148|text|我正在使用Elasticsearch+5.3，在回答上面的一些问题时遇到了问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2943149|下面的代码对我很有效。|2943150|+{
++++"query":+{
++++++++"bool"+:+{
++++++++++++"must"+:+{
++++++++++++++++"script"+:+{
++++++++++++++++++++"script"+:+{
++++++++++++++++++++++++"inline":+"doc['city'].empty",
++++++++++++++++++++++++"lang":+"painless"
+++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++}
++++}
}|code-block|syntax|javascript|2943151|备注:您可能需要为文本字段启用fielddata，它在缺省情况下处于禁用状态。尽管我会在这样做之前先读一读：https://www.elastic.co/guide/en/elasticsearch/reference/current/fielddata.html。|offset|length|style|BOLD|2943152|要为类型名为'record‘的索引’‘上的字段'city’启用记录字段数据，您需要：|2943153|PUT+business/_mapping/record
{
++++"properties":+{
++++++++"city":+{
++++++++++"type":+"text",
++++++++++"fielddata":+true
++++++++}
++++++}
}|2943154|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/current/fielddata.html^0|0|0|0|F|9|1I|26|0|0|I|J|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@$K|14|L|15|M|N]]|9|@$K|16|L|17|1|18]]|A|$]]|$1|O|3|P|5|6|7|19|8|@$K|1A|L|1B|M|N]]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

I'm using Elasticsearch 5.3 and was having trouble with some of the above answers.

The following body worked for me.

<pre><code> {
 "query": {
 "bool" : {
 "must" : {
 "script" : {
 "script" : {
 "inline": "doc['city'].empty",
 "lang": "painless"
 }
 }
 }
 }
 }
}
</code></pre>

Note: you might need to enable the fielddata for text fields, it is disabled by default. Although I would read this: <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/fielddata.html" rel="nofollow noreferrer">https://www.elastic.co/guide/en/elasticsearch/reference/current/fielddata.html</a> before doing so.

To enable the fielddata for a field e.g. 'city' on index 'business' with type name 'record' you need:

<pre><code>PUT business/_mapping/record
{
 "properties": {
 "city": {
 "type": "text",
 "fielddata": true
 }
 }
}
</code></pre>

blocks|key|2943176|text|对于嵌套字段，请使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2943177|curl+-XGET+"http://localhost:9200/city/_search?pretty=true"+-d+'{
+++++"query"+:+{
+++++++++"nested"+:+{
+++++++++++++"path"+:+"country",
+++++++++++++"score_mode"+:+"avg",
+++++++++++++"query"+:+{
+++++++++++++++++"bool":+{
++++++++++++++++++++"must_not":+{
++++++++++++++++++++++++"exists":+{
++++++++++++++++++++++++++++"field":+"country.name"+
++++++++++++++++++++++++}
++++++++++++++++++++}
+++++++++++++++++}
+++++++++++++}
+++++++++}
+++++}
}'|code-block|syntax|javascript|2943178|说明：路径和字段一起构成搜索。根据需要进行更改以使您正常工作。|offset|length|style|BOLD|2943179|对于常规字段：|2943180|curl+-XGET+'http://localhost:9200/city/_search?pretty=true'+-d'{
++++"query":+{
++++++++"bool":+{
++++++++++++"must_not":+{
++++++++++++++++"exists":+{
++++++++++++++++++++"field":+"name"
++++++++++++++++}+
++++++++++++}+
++++++++}+
++++}+
}'|2943181|entityMap^0|0|0|0|3|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

For nested fields use:

<pre><code>curl -XGET "http://localhost:9200/city/_search?pretty=true" -d '{
 "query" : {
 "nested" : {
 "path" : "country",
 "score_mode" : "avg",
 "query" : {
 "bool": {
 "must_not": {
 "exists": {
 "field": "country.name" 
 }
 }
 }
 }
 }
 }
}'
</code></pre>

NOTE: path and field together constitute for search. Change as required for you to work.

For regular fields:

<pre><code>curl -XGET 'http://localhost:9200/city/_search?pretty=true' -d'{
 "query": {
 "bool": {
 "must_not": {
 "exists": {
 "field": "name"
 } 
 } 
 } 
 } 
}'
</code></pre>

blocks|key|149114|text|我无法在文本字段中搜索空字符串。但是，它似乎适用于类型为关键字的字段。因此，我建议如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|149115|++++delete+/test_idx

++++put+test_idx
++++{
++++++"mappings"+:+{
++++++++"testMapping":+{
++++++++++"properties"+:+{
++++++++++++"tag"+:+{"type":"text"},
++++++++++++"content"+:+{"type":"text",
+++++++++++++++++++++++++"fields"+:+{
+++++++++++++++++++++++++++"x"+:+{"type"+:+"keyword"}
+++++++++++++++++++++++++}
++++++++++++}
++++++++++}
++++++++}
++++++}
++++}

put+/test_idx/testMapping/1
{
++"tag":+"null"
}

put+/test_idx/testMapping/2
{
++"tag":+"empty",
++"content":+""
}

GET+/test_idx/testMapping/_search
{
+++"query"+:+{
+++++"match"+:+{"content.x"+:+""}}}
+++++++++++++}
}|code-block|syntax|javascript|149116|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|$]]

I didn't manage to search for empty strings in a text field. However it seems to work with a field of type keyword. So I suggest the following:

<pre><code> delete /test_idx

 put test_idx
 {
 "mappings" : {
 "testMapping": {
 "properties" : {
 "tag" : {"type":"text"},
 "content" : {"type":"text",
 "fields" : {
 "x" : {"type" : "keyword"}
 }
 }
 }
 }
 }
 }

put /test_idx/testMapping/1
{
 "tag": "null"
}

put /test_idx/testMapping/2
{
 "tag": "empty",
 "content": ""
}

GET /test_idx/testMapping/_search
{
 "query" : {
 "match" : {"content.x" : ""}}}
 }
}
</code></pre>

blocks|key|2730994|text|您需要通过在字段名中添加.content来触发关键字索引器。根据原始索引是如何设置的，下面的内容对我来说使用亚马逊网络服务ElasticSearch+v6.x“就行了”。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2730995|获取/my_idx/_search?q=my_field.content:""的|2730996|blockquote|2730997|2730998|entityMap^0|C|8|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|P|8|@]|D|@]|E|$]]|$1|H|3|-4|5|I|7|Q|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|R|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

You need to trigger the keyword indexer by adding .content to your field name. Depending on how the original index was set up, the following "just works" for me using AWS ElasticSearch v6.x.

<blockquote>
 GET /my_idx/_search?q=my_field.content:""
</blockquote>

blocks|key|2731007|text|如果你不想或者不能重新建立索引，还有另一种方法。:-)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731008|可以使用求反运算符和通配符匹配任何非空字符串*|2731009|GET+/my_index/_search?q=!(fieldToLookFor:*)|code-block|syntax|javascript|2731010|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you don't want to or can't re-index there is another way. :-)

You can use the negation operator and a wildcard to match any non-blank string *

<pre><code>GET /my_index/_search?q=!(fieldToLookFor:*)
</code></pre>

blocks|key|2731027|text|或使用lucene查询字符串语法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731028|2731029|+q=yourfield.keyword:"“|blockquote|2731030|2731031|2731032|请参阅弹性搜索参考https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-query-string-query.html#query-string-syntax|offset|length|2731033|entityMap|0|LINK|mutability|MUTABLE|url|https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-query-string-query.html#query-string-syntax^0|0|0|0|0|0|9|35|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|V|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@$J|Z|K|10|1|11]]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

OR using lucene query string syntax
<blockquote>
q=yourfield.keyword:&quot;&quot;
</blockquote>
See Elastic Search Reference <a href="https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-query-string-query.html#query-string-syntax" rel="nofollow noreferrer">https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-query-string-query.html#query-string-syntax</a>

blocks|key|147887|text|在这里找到解决方案https://github.com/elastic/elasticsearch/issues/7515它不需要重新索引就能工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|147888|PUT+t/t/1
{
++"textContent":+""
}

PUT+t/t/2
{
++"textContent":+"foo"
}

GET+t/t/_search
{
++"query":+{
++++"bool":+{
++++++"must":+[
++++++++{
++++++++++"exists":+{
++++++++++++"field":+"textContent"
++++++++++}
++++++++}
++++++],
++++++"must_not":+[
++++++++{
++++++++++"wildcard":+{
++++++++++++"textContent":+"*"
++++++++++}
++++++++}
++++++]
++++}
++}
}|code-block|syntax|javascript|147889|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/elastic/elasticsearch/issues/7515^0|9|1G|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Found solution here <a href="https://github.com/elastic/elasticsearch/issues/7515" rel="noreferrer">https://github.com/elastic/elasticsearch/issues/7515</a>
It works without reindex.

<pre><code>PUT t/t/1
{
 "textContent": ""
}

PUT t/t/2
{
 "textContent": "foo"
}

GET t/t/_search
{
 "query": {
 "bool": {
 "must": [
 {
 "exists": {
 "field": "textContent"
 }
 }
 ],
 "must_not": [
 {
 "wildcard": {
 "textContent": "*"
 }
 }
 ]
 }
 }
}
</code></pre>

blocks|key|151829|text|我正在尝试查找空字段(在具有动态映射的索引中)，并将它们设置为默认值，下面的方法对我有效|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151830|151831|注意这是elastic+7.x版本|blockquote|151832|151833|151834|POST+<index_name%7Cpattern>/_update_by_query
{
++"script":+{
++++"lang":+"painless",
++++"source":+"""
++++++if+(ctx._source.<field+name>==+"")+{
++++++++ctx._source.<field_name>=+"0";
++++++}+else+{
++++++++ctx.op+=+"noop";
++++++}
++++"""
++}
}|code-block|syntax|javascript|151835|我跟随帖子中的一个回复，想出了下面的答案，它也会这样做|151836|GET+index_pattern*/_update_by_query
{
++"script":+{
++++"source":+"ctx._source.field_name='0'",
++++"lang":+"painless"
++},
++"query":+{
++++"bool":+{
++++++"must":+[
++++++++{
++++++++++"exists":+{
++++++++++++"field":+"field_name"
++++++++++}
++++++++}
++++++],
++++++"must_not":+[
++++++++{
++++++++++"wildcard":+{
++++++++++++"field_name":+"*"
++++++++++}
++++++++}
++++++]
++++}
++}++
}|151837|我还试图在索引中找到没有该字段的文档，并为它们添加一个值|151838|这个帖子的其中一个回复帮助我想出了下面的想法|151839|GET+index_pattern*/_update_by_query
{
++"script":+{
++++"source":+"ctx._source.field_name='0'",
++++"lang":+"painless"
++},
++"query":+{
++++"bool":+{
++++++"must_not":+[
++++++++{
++++++++++"exists":+{
++++++++++++"field":+"field_name"
++++++++++}
++++++++}
++++++]
++++}
++}
}|151840|感谢每一个为这个帖子做贡献的人，我能够解决我的问题。|151841|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|12|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|15|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|16|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|17|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|18|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|19|8|@]|9|@]|A|$]]|$1|U|3|V|5|J|7|1A|8|@]|9|@]|A|$K|L]]|$1|W|3|X|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|Z|$]]

I am trying to find the empty fields (in indexes with dynamic mapping) and set them to a default value and the below worked for me 

<blockquote>
 Note this is in elastic 7.x
</blockquote>

<pre><code>POST &lt;index_name|pattern&gt;/_update_by_query
{
 "script": {
 "lang": "painless",
 "source": """
 if (ctx._source.&lt;field name&gt;== "") {
 ctx._source.&lt;field_name&gt;= "0";
 } else {
 ctx.op = "noop";
 }
 """
 }
}
</code></pre>

I followed one of the responses from the thread and came up with below it will do the same 

<pre><code>GET index_pattern*/_update_by_query
{
 "script": {
 "source": "ctx._source.field_name='0'",
 "lang": "painless"
 },
 "query": {
 "bool": {
 "must": [
 {
 "exists": {
 "field": "field_name"
 }
 }
 ],
 "must_not": [
 {
 "wildcard": {
 "field_name": "*"
 }
 }
 ]
 }
 } 
}
</code></pre>

I am also trying to find the documents in the index that dont have the field and add them with a value 

one of the responses from this thread helped me to come up with below 

<pre><code>GET index_pattern*/_update_by_query
{
 "script": {
 "source": "ctx._source.field_name='0'",
 "lang": "painless"
 },
 "query": {
 "bool": {
 "must_not": [
 {
 "exists": {
 "field": "field_name"
 }
 }
 ]
 }
 }
}
</code></pre>

Thanks to every one who contributed to this thread I am able to solve my problem

I've been trying to filter with elasticsearch only those documents that contains an empty string in its body. So far I'm having no luck. 

Before I go on, I should mention that I've already tried the many "solutions" spread around the Interwebz and StackOverflow.

So, below is the query that I'm trying to run, followed by its counterparts:

<pre><code>{
 "query": {
 "filtered":{
 "filter": {
 "bool": {
 "must_not": [
 {
 "missing":{
 "field":"_textContent"
 }
 }
 ]
 }
 }
 }
 }
}
</code></pre>

I've also tried the following:

<pre><code> {
 "query": {
 "filtered":{
 "filter": {
 "bool": {
 "must_not": [
 {
 "missing":{
 "field":"_textContent",
 "existence":true,
 "null_value":true
 }
 }
 ]
 }
 }
 }
 }
}
</code></pre>

And the following:

<pre><code> {
 "query": {
 "filtered":{
 "filter": {
 "missing": {"field": "_textContent"}
 }
 }
 }
}
</code></pre>

None of the above worked. I get an empty result set when I know for sure that there are records that contains an empty string field.

If anyone can provide me with any help at all, I'll be very grateful.

Thanks!

Find documents with empty string value on elasticsearch

Elasticsearch 

数据库

我一直在尝试用elasticsearch过滤那些正文中包含空字符串的文档。到目前为止，我没有任何运气。在我继续之前，我应该提到，我已经尝试了分布在Interwebz和StackOverflow上的许多“解决方案”。因此，下面是我尝试运行的查询，后面是对应的查询：{    "query": {        "filte...

问在elasticsearch上查找具有空字符串值的文档
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在elasticsearch上查找具有空字符串值的文档EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在elasticsearch上查找具有空字符串值的文档
EN