Loading
null_value
ServerlessStack
Anull value cannot be indexed or searched. When a field is set tonull, (or an empty array or an array ofnull values) it is treated as though that field has no values.
Thenull_value parameter allows you to replace explicitnull values with the specified value so that it can be indexed and searched. For instance:
PUT my-index-000001{ "mappings": { "properties": { "status_code": { "type": "keyword", "null_value": "NULL" } } }}PUT my-index-000001/_doc/1{ "status_code": null}PUT my-index-000001/_doc/2{ "status_code": []}GET my-index-000001/_search{ "query": { "term": { "status_code": "NULL" } }}
- Replace explicit
nullvalues with the termNULL. - An empty array does not contain an explicit
null, and so won’t be replaced with thenull_value. - A query for
NULLreturns document 1, but not document 2.
Important
Thenull_value needs to be the same data type as the field. For instance, along field cannot have a stringnull_value.
Note
Thenull_value only influences how data is indexed, it doesn’t modify the_source document.