Empty string is not being matched in elasticsearch

Question

I have many documents with uID:. To query those documents, I am querying as below -

'query': {
           'term':  {
               'uID': ''
             }
    }

But it is fetching no documents. Why it is not throwing any document? Is there any other way to do this?

You have to make sure that ,your uID is indexed as keyword ,otherwise elastic will do a full text search — Shubham Dixit
– Shubham Dixit, Commented Nov 1, 2019 at 11:38
@Shubh Thanks, is there other way to query if uID isn't indexed as keyword? — Mr. Sigma.
– Mr. Sigma., Commented Nov 1, 2019 at 11:43
See this -discuss.elastic.co/t/query-for-an-empty-string/83070 — Shubham Dixit
– Shubham Dixit, Commented Nov 1, 2019 at 11:44

Pooja JaJal · Accepted Answer · 2019-11-01 12:55:53Z

1

Even with the default analyzer you can do this kind of search: use a script filter, which is slower but can handle the empty string:

curl -XPOST 'http://localhost:3000/_search' -d 
{
 "query": {
   "filtered": {
     "filter": {
       "script": {
         "script": "term. uID.length() == 0"
       }
     }
   }
 }
}

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 https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html

q=!(yourfield.keyword:"")

Please refer below link for more information. https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-query-string-query.html#query-string-syntax

edited Nov 1, 2019 at 12:55

answered Nov 1, 2019 at 11:58

Pooja JaJal

3031 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr. Sigma. Over a year ago

Thanks. And I checked with query->...->script but no avail. BTW, where did @js_gandalf point this?

Pooja JaJal Over a year ago

elastic.co/guide/en/elasticsearch/reference/6.5/… Please refer this link for more information. I've updated my answer, please refer again.

Collectives™ on Stack Overflow

Empty string is not being matched in elasticsearch

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related