# \_update\_by\_query column.column

**URL:** <https://discuss.elastic.co/t/update-by-query-column-column/261605>\
**Category:** Elasticsearch\
**Created:** [January 19, 2021, 11:47pm UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605 "2021-01-19T23:47:56Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcornejo](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jcornejo](https://discuss.elastic.co/u/jcornejo)\
**Post date:** [January 19, 2021, 11:47pm UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/1 "2021-01-19T23:47:56Z")

</div>

I have this example mapping.  
I need to update the field " **shirt.color**"

> mapping  
> `{`  
> `"shirts" : {`  
> ` "mappings" : {`  
> `"properties" : {`  
> `"shirt" : {`  
> ` "properties" : {`  
> ` "brand" : {`  
> `"type" : "keyword"`  
> `},`  
> ` "color" : {`  
> ` "type" : "keyword"`  
> ` },`  
> ` "model" : {`  
> ` "type" : "keyword"`  
> ` }`  
> `} ` },` ` "tienda" : {` ` "type" : "keyword"` ` }` ` }` `}` ` }` `}`

> data  
> `{`  
> ` "_index" : "shirts",`  
> `"_type" : "_doc",`  
> `"_id" : "1",`  
> `"_score" : 1.0,`  
> `"_source" : {`  
> ` "tienda" : "mall",`  
> ` "shirt.brand" : "gucci",`  
> ` "shirt.color" : "red",`  
> ` "shirt.model" : "slim"`  
> ` }`  
> ` }`

I have tried this way

> POST shirts/\_update\_by\_query  
> `POST shirts/_update_by_query?conflicts=proceed`  
> `{`  
> ` "script": {`  
> `"inline": "ctx._source.shirt.color = params",`  
> `"lang": "painless",`  
> `"params": {"shirt.color" : "blue"}`  
> ` },`  
> `"query": {`  
> ` "bool": {`  
> ` `"filter": [` { "term": { "tienda": "mall" }}`  
> `]`  
> ` }`  
> `}`  
> `}`

but it does not work

> error  
> ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/7/37ca9e334dee5382fbfdba5854dd2baf41c70af6.png)

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [January 20, 2021, 12:18am UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/2 "2021-01-20T00:18:25Z")

</div>

Can you try replacing `inline` to `source`?

---

<div class="post-metadata">

**Author:** ![jcornejo](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jcornejo](https://discuss.elastic.co/u/jcornejo)\
**Post date:** [January 20, 2021, 12:25am UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/3 "2021-01-20T00:25:21Z")

</div>

> [@AClerk](#):
>
> Can you try replacing `inline` to `source` ?

yes, I have the same error

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [January 20, 2021, 12:29am UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/4 "2021-01-20T00:29:02Z")

</div>

Need to troubleshoot...

Try removing the params and update with the value directly.  
`"inline": "ctx._source.shirt.color = 'blue'"`

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [January 20, 2021, 12:32am UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/5 "2021-01-20T00:32:15Z")

</div>

Even better

```auto
{
 "query": ...
 "script": {
   "source": "ctx._source[params.field] = params.value;",
   "params": {
      "field": field,
      "value": value
      }
   }
 }

```

From [here](https://stackoverflow.com/questions/45725273/select-document-field-with-parameter-in-elasticsearch-update-by-query-api)

---

<div class="post-metadata">

**Author:** ![jcornejo](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jcornejo](https://discuss.elastic.co/u/jcornejo)\
**Post date:** [January 20, 2021, 12:41am UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/6 "2021-01-20T00:41:12Z")

</div>

it's working, thanks 🙂

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/1/81da0776804ebc1cdd3488d83596453bddc58477.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 17, 2021, 12:41am UTC](https://discuss.elastic.co/t/update-by-query-column-column/261605/7 "2021-02-17T00:41:14Z")

</div>

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