elasticsearch painless script to add object field into document

Question

I have a rather basic requirement, I would like to add an object to a document with painless within a query for update.

This is the object I would like to add

"memoire": {
      "codeActe": "C",
      "docType": "M",
      "uuid": "added ",
      "nonFacturable": false,
      "published": false
    },

I tried

    POST /csa_encounters/_update_by_query
{
  "script":
{ "source": """

  ctx._source.memoire.codeActe = "C";
  ctx._source.memoire.docType= "M";
  ctx._source.memoire.uuid = "added ";
  ctx._source.memoire.nonFacturable = false;
  ctx._source.memoire.published =false
""",
"lang": "painless"
},
    "query": {
        "bool" : {
            "must" : [
                { "query_string" : { "query" : "140c7646", "fields" : [ "_id" ] } }
            ]
        }
    }
}

But I get the message null pointer exception as the field does not exist of course

"type": "script_exception",
    "reason": "runtime error",
    "script_stack": [
      "ctx._source.memoire.codeActe = \"C\";\n  ",
      "                   ^---- HERE"
    ],
 ...
    "lang": "painless",
    "caused_by": {
      "type": "null_pointer_exception",
      "reason": null
    }
  },
  "status": 400

I am not able to figure out how to create the object as a new field if it does not exist already.

Val · Accepted Answer · 2020-11-03 14:36:12Z

2

It's because the field memoire doesn't exist in your document. So just add the following lines at the beginning of your script:

if (ctx._source.memoire == null) {
    ctx._source.memoire = [:];
}

answered Nov 3, 2020 at 14:36

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Harold L. Brown Over a year ago

Unfortunately, I get the error type=no_viable_alt_exception, reason=null when doing this.

Val Over a year ago

@HaroldL.Brown please create a new question possibly referencing this one but explaining the context of your issue

Collectives™ on Stack Overflow

elasticsearch painless script to add object field into document

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related