Elasticsearch get documents where a property is not empty

Question

If I want to return all the documents which have an empty property (IMG) I can do something like that:

GET something/_search/?
{
  "query": {
    "term": {"IMG": ""}
  }
}

It works because IMG is a keyword. If I want the exact inverse, which means get all the documents where IMG is not null, what should I type? Is there an "inverse" of term query?

In other words, is there a way with Elasticsearch to get documents where a property is not empty?

this answer should help: stackoverflow.com/questions/32949321/… — Val
– Val, Commented Sep 14, 2018 at 14:06
Thanks you for your comment. It does not really help, because these answers check for existence, not emptiness. — rap-2-h
– rap-2-h, Commented Sep 14, 2018 at 14:09
@Val Yes. BTW I just found a solution and posted an answer right below. Feel free to comment, edit, or post your own answer! — rap-2-h
– rap-2-h, Commented Sep 14, 2018 at 14:13

Val · Accepted Answer · 2018-09-14 14:15:19Z

8

Your solution above would also return documents where the field is null, which you don't want I guess. So the correct solution would be this one:

GET memoire/_search/?
{
  "query": {
    "bool": {
      "filter": {
        "exists": {
          "field": "test"
        }
      },
      "must_not": {
        "term": {
          "test.keyword": ""
        }
      }
    }
  }
}

answered Sep 14, 2018 at 14:15

Val

218k14 gold badges377 silver badges384 bronze badges

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

Comments

rap-2-h · Accepted Answer · 2018-09-14 14:13:37Z

2

Here is a solution. Use must_not with term query. This should work:

GET memoire/_search/?
{
  "query": {
    "bool": {
      "must_not": {
        "term": {"IMG.keyword": ""}
      }
    }
  }
}

edited Sep 14, 2018 at 14:13

answered Sep 14, 2018 at 14:12

rap-2-h

32.3k49 gold badges190 silver badges281 bronze badges

3 Comments

Val Over a year ago

you have must instead of must_not

rap-2-h Over a year ago

@Val Woops! +1 thank you! (I was just checking with kibana the must_not then the must to be sure, and I posted the wrong one!). Edited, fixed!

Val Over a year ago

See my solution in order to make sure that you don't return docs with IMG: null.

Collectives™ on Stack Overflow

Elasticsearch get documents where a property is not empty

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related