Updating documents with nested fields

The other day I needed to add an additional field to all documents in one of our indexes.
The documents look something like this

{
  "field1": "foo",
  "field2": "bar",
  "nested": [
    {
      "field1": "foo",
      "field2": "bar",
    },
    ...
  ]
}

I needed to add an extra field to all the nested fields so the normal partial update does not work here. I had to put on my painless cap for this one. This is what I dreamed up.

POST test-index/_update_by_query
{
  "script": {
    "source": """
    for (int i=0; i<ctx._source.nested.size();i++) {
      ctx._source.nested[i].test = "blaa" 
    }
    """,
    "lang": "painless"
  },
  "query": {
    "match_all": {}
  }
}

Author:

Leave a Reply

Your email address will not be published. Required fields are marked *