Update by query in elasticsearch

Question

I am trying to run update by query on my elasticsearch index using the method provided in this answer. This is the query that I've been trying to run:

curl -XPOST 'localhost:9200/my_index/_update_by_query' -d '
{
  "query":{
    "match":{
      "latest_uuid":"d56ffe2095f511e6bcdd0acbdf0298e3"
    }
  },
  "script" : "ctx._source.is_in_stock = \"false\";"
}'

But I keep getting the following error:

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

What am I doing wrong here?

try "_update_by_query?is_in_stock=false" and delete script line to see if problem is script — user6839326
– user6839326, Commented Oct 26, 2016 at 10:56

Keshav Agarwal · Accepted Answer · 2016-10-26 11:03:53Z

1

Found the solution.

Turns out that I had to use the following as script:

"script":{"inline":"ctx._source.is_in_stock = false"}

answered Oct 26, 2016 at 11:03

Keshav Agarwal

8411 gold badge11 silver badges29 bronze badges

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

1 Comment

Imaduddin Aug 27 at 2:38

This is the answer. OMG, it's so weird that for single document _update, you can straight away pass a string script, but for _update_by_query you need to use the Map version

user6839326 · Accepted Answer · 2016-10-26 11:04:03Z

1

I think problem can be the \"false\" (String value) who no want to be cast.

curl -XPOST 'localhost:9200/my_index/_update_by_query' -d '
{
  "query":{
    "match":{
      "latest_uuid":"d56ffe2095f511e6bcdd0acbdf0298e3"
    }
  },
  "script" : "ctx._source.is_in_stock = false;"
}'

You can first try it. Waiting your feedback ! :)

answered Oct 26, 2016 at 11:04

user6839326

2 Comments

Keshav Agarwal Over a year ago

Hi, I found the problem and have added an answer corresponding to that. Thanks for the help! :)

user6839326 Over a year ago

Yes I see, we post in the same time, GGWP !

Collectives™ on Stack Overflow

Update by query in elasticsearch

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related