Search for null and values (but not for non exists) in elasticsearch

Question

I have three documents, first: I have an empty images object, second: I have a null in images.front, and third: I have object in images.front.

As follows:

[{
  "images": {}
}, {
  "images": {
    "front": null
  }
}, { 
  "images": {
    "front": {
      "id": 1
    }
  }
}]

How can I search only for the documents that have front image (documents two and three, but not first)?

Many thanks :)

user3775217 · Accepted Answer · 2016-07-27 17:00:19Z

1

As far i know(i worked only till 1.7.2), document 1 and 2 will have same json structure in _source document of the elastic.As elasticsearch doesn't support null values.

So if you want to search for documents which have images , do a exists filters in the must bool filter.

elastic null values

Exists filter in elasticsearch

answered Jul 27, 2016 at 17:00

user3775217

4,8231 gold badge26 silver badges33 bronze badges

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

4 Comments

Leibale Eidelman Over a year ago

so you say there is nothing i can do?

user3775217 Over a year ago

try to model your data in a different way , with array of image objects along with the count .

Leibale Eidelman Over a year ago

what is the difference? empty array will be the same as null and not exists.. elastic.co/guide/en/elasticsearch/reference/2.1/…

Leibale Eidelman Over a year ago

i'm know that i can change the model, but it's dirty.. if there is no other option i will change my model :( thanks

Collectives™ on Stack Overflow

Search for null and values (but not for non exists) in elasticsearch

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related