How to update a field with null using NEST and the Update API

Elastic Stack Elasticsearch
1

We are using the NEST library with Elasticsearch versions 7.14.
Lets say we have assigned a field Greeting with a value of "hello World".
The filed is mapped as a Keyword type and Not Indexed.

If you update that document using the Update API with the same field having a null value, Elasticsearch ignores that assignement and keeps what was originally there i.e. "Hello World". In order to get rid of the fields value you have to assign it something like an empty string which classes in .NET with string properties normally have a default value of NULL.

var result = client.Update<object>(id, u => u
                 .Index("services")
                 .Doc(new
                 {
                    Greeting=null
                     
                 })

So when a user updates a field by removing its value in the UI, the index does not take that change and keeps the old value.

So you actually have a completely different data in the index than what you think you have after an update.

2

Hi,

it will not allow to add null value as it is not indexable in lucene. You can handle null values using specifing null_values attributes in index mapping (it will set default values).

Please check #5152 and comments on #3930 issue for handling null value in NEST. They have gievn example for date field but same will work for keyword field as well.

3

Hi
Thanks for your response.
But you can actually insert null using a script.
So why can you do that with a script but not a partial document?

4

Sorry for late response. Can you please tell me how you are updating field with NULL using script.

Because when you try updating field with NULL using below script, it will throw below error:

Script

POST my-index-000001/_update_by_query
{
  "query": {
    "match_all": {}
  }, 
  "script": {
    "source": "ctx._source['name'] = NULL",
    "lang": "painless"
  }
}

ERROR

 "caused_by" : {
      "type" : "illegal_argument_exception",
      "reason" : "cannot resolve symbol [NULL]"
    }

If you provide NULL as string value with single quotes, it will add NULL as string for specific field. so you are still have string or text value for that specific field and not null value.

Script

POST my-index-000001/_update_by_query
{
  "query": {
    "match_all": {}
  }, 
  "script": {
    "source": "ctx._source['name'] = 'NULL'",
    "lang": "painless"
  }
}

Output Document

"hits" : [
      {
        "_index" : "my-index-000001",
        "_type" : "_doc",
        "_id" : "1",
        "_score" : 1.0,
        "_source" : {
          "name" : "NULL"
        }
      }
    ]
5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.