How to add new element to the existing array field in Elasticsearch

Question

Hi Below is my document

 "catid": [
           514500
          ],
 "studentid": 5282439,

In this catid field , I want to add new element 543 , where studentid = 5282439

I am trying the below query but it's giving me an exception

POST /parts/_update_by_query
{
  "query": {
     "match": {
        "studentid": 5282439
     }
  },
  "script" : "ctx._source.catid+= [543 ]"
}

I am getting the below exception:

"root_cause": [
   {
      "type": "class_cast_exception",
      "reason": "java.lang.String cannot be cast to java.util.Map"
    }
 ]

prasad kp · Accepted Answer · 2017-04-27 06:26:44Z

5

--> If the above answer doesn't work try this one

POST /parts/_update_by_query
    {
      "query": {
        "match": {
          "studentid": 5282439
        }
      },
      "script" : {
          "lang":"painless",
         "inline": "ctx._source.catid.add(params.newsupp)",
         "params":{
             "newsupp":5302
      }
    }
    }

edited Apr 27, 2017 at 6:26

answered Apr 26, 2017 at 14:49

prasad kp

8611 gold badge13 silver badges32 bronze badges

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

1 Comment

David L Over a year ago

Please consider adding an explanation as to why this is the answer.

Val · Accepted Answer · 2017-04-26 14:25:19Z

4

The script part is not correct, change it to this instead (i.e. move the script to the script.inline property):

POST /parts/_update_by_query
{
  "query": {
    "match": {
      "studentid": 5282439
    }
  },
  "script" : {
     "inline": "ctx._source.catid += [543 ]"
  }
}

answered Apr 26, 2017 at 14:25

Val

218k14 gold badges377 silver badges384 bronze badges

4 Comments

prasad kp Over a year ago

Hi Val , Thanks , but when I ran the above query m getting the following exception

prasad kp Over a year ago

"type": "class_cast_exception", "reason": "Cannot apply [+] operation to types [java.util.ArrayList] and [java.util.ArrayList]."

prasad kp Over a year ago

I'm using ES 5.2.2 Version

Val Over a year ago

Remove the square brackets

Collectives™ on Stack Overflow

How to add new element to the existing array field in Elasticsearch

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related