Query on array fields with null value

Elastic Stack Elasticsearch
1

Hello all,

we have in our index fields with arrays, each containing only one element, which is NULL:

"field": [
    null
]

I would like to filter on just these records, however I can't find a query that will do this. ELS somehow does not like 'null' in this constellation.

Can anyone help?

Many thanks and greetings
Daniel

2

Hi @dhggw!

While a null value cannot be indexed or searched, there is a null_value parameter which allows you to replace explicit null values with the specified value so that it can be indexed and searched.

Check out this documentation.