# Cannot assign numeric values in script on update by query **URL:** \ **Category:** Elasticsearch\ **Created:** [April 27, 2018, 9:48am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802 "2018-04-27T09:48:33Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![OlivierPetri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierpetri/32/30551_2.png) [@OlivierPetri](https://discuss.elastic.co/u/OlivierPetri)\ **Post date:** [April 27, 2018, 9:48am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/1 "2018-04-27T09:48:33Z")
Hi there, I am using Elasticsearch 6.2 and am trying to assign a nummeric value in a scripted update by query like so: ``` POST aarhuis/_update_by_query { "script" : { "source" : "doc['SUMAB'] = doc['CNTA'] + doc['CNTB']", "lang": "painless" }, "query": { "match_all": {} } } ``` All three fields are defined as being nummeric ( "CNTA": { "type": "integer" } and so on). But using the doc notation, with, or without .value extension, I keep getting errors, null\_pointer\_exception to be precise. ![example-update-query-and-response](https://us1.discourse-cdn.com/elastic/original/3X/d/6/d67dbeaf4e71c0174e6433cc7b6bc7c0751fbbc6.png) I have tried all sorts of combinations, and the npx is signalled at different places: ``` "doc['SUMBA'].value = doc['CNTA'].value + doc['CNTB'].value", " ^---- HERE" "doc['SUMBA'] = doc['CNTA'] + doc['CNTB']", " ^---- HERE" ``` If I try checking for null, I'll get npx in the null check: ``` if(doc['CNTA'] != null && doc['CNTB'] != null) {doc['SUMAB'] = doc['CNTA'] + doc['CNTB'];} "if(doc['CNTA'] != null && doc['CNTB'] != null) {", " ^---- HERE" ``` But the best is yet to come! First, when i use the expression `doc['CNTA'].value + doc['CNTB'].value` in a scripted field, it just works as expected! But worst, when I change for `ctx._source.SUMAB = ctx._source.CNTA + ctx._source.CNTB` in the update query, the query will pass without failure, but it will treat both fields as text and concatenate them instead of calculating, giving me 33 for 3 + 3 and not 6. I feel I'm making some stupid mistake somewhere (or the documentation is missing some elementary hint), so I do not file this as a bug report for now. But having spend more than a full day on this I am pretty close to madness. "Help! I need somebody..." ---
**Author:** ![val](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/val/32/138203_2.png) [@val](https://discuss.elastic.co/u/val)\ **Post date:** [April 27, 2018, 11:36am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/2 "2018-04-27T11:36:00Z")
Are you sure that all documents have the `CNTA` and `CNTB` fields? > in a scripted field, it just works as expected! Yes, because the 10 first documents that come back probably have both the `CNTA` and `CNTB` fields, hence the script works. The update-by-query, however, will work on the full document set. > But worst, when I change for > ctx.\_source.SUMAB = ctx.\_source.CNTA + ctx.\_source.CNTB Since you're accessing the source document, that means that in your source document those fields were specified using a string instead of an integer value. What you could do is ``` ctx._source.SUMAB = Integer.parseInt(ctx._source.CNTA) + Integer.parseInt(ctx._source.CNTB) ``` ---
**Author:** ![OlivierPetri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierpetri/32/30551_2.png) [@OlivierPetri](https://discuss.elastic.co/u/OlivierPetri)\ **Post date:** [April 27, 2018, 11:44am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/3 "2018-04-27T11:44:55Z")
Yes, I am. And all are set to values \> 0. When I do somehting like ``` POST aarhuis/_update_by_query { "script" : { "source" : "try {ctx._source.SUMBA = doc['CNTA'].values + doc['CNTB'].values;} catch(Exception x){ctx._source.SUMBA = 0;}", "lang": "painless" }, "query": { "match_all": {} } } ``` Then SUMBA will be set to zero on every document. So maybe it IS a bug? But I want to make sure I did not have some obvious syntax mistake in my code. The variations ``` doc['CNTA'] doc['CNTA'].value ctx.CNTA ctx._source.CNTA ``` Are not very well explained in the documentation and quite confusing. It appears not all are valid in the context of an update by query, but at least one should work. Or some other. ---
**Author:** ![val](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/val/32/138203_2.png) [@val](https://discuss.elastic.co/u/val)\ **Post date:** [April 27, 2018, 11:48am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/4 "2018-04-27T11:48:39Z")
If your `CNTA` and `CNTB` fields are indeed integers disguised as strings, have you tried my last suggestion? ---
**Author:** ![OlivierPetri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierpetri/32/30551_2.png) [@OlivierPetri](https://discuss.elastic.co/u/OlivierPetri)\ **Post date:** [April 27, 2018, 11:53am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/5 "2018-04-27T11:53:27Z")
Thank you for your response, I was a bit fast on my first reply. Your workaround solved my problem. What I do not understand is, the > in your source document those fields were specified using a string instead of an integer value part. I defined the mapping beforehand as `"CNTA" : { "type" : "integer" }` and so on, then imported a CSV file via logstash. When I query the mapping of my index, it will be displayed as integer, so i somewhat naivly expect it to indeed be an integer. And: Shouldn't the doc notation work anyway? ---
**Author:** ![val](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/val/32/138203_2.png) [@val](https://discuss.elastic.co/u/val)\ **Post date:** [April 27, 2018, 11:56am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/6 "2018-04-27T11:56:17Z")
Specifying this in your mapping > "CNTA" : { "type" : "integer" } Simply tells Elasticsearch to treat whatever comes in the `CNTA` field as an integer. However, if your source document contains this: ``` { "CNTA": "100" } ``` then it is a valid integer and ES will treat it as such. But what ES won't do is transform `"100"` (a string) into `100` (an integer) inside the source document. That's why when you access `ctx._source.CNTA` you get a string, i.e. because that's what your source document contained when it was indexed into ES. So you need to check inside your CSV file whether the `CNTA` field is enclosed within double quotes or not, if that's the case, you need to modify your `csv` Logstash filter to convert that value to an `integer` before the document reaches ES. ---
**Author:** ![OlivierPetri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/olivierpetri/32/30551_2.png) [@OlivierPetri](https://discuss.elastic.co/u/OlivierPetri)\ **Post date:** [April 27, 2018, 11:59am UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/7 "2018-04-27T11:59:26Z")
Ok, thank you very much. This was very helfpul. ---
**Author:** ![val](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/val/32/138203_2.png) [@val](https://discuss.elastic.co/u/val)\ **Post date:** [April 27, 2018, 12:02pm UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/8 "2018-04-27T12:02:00Z")
Awesome, I'm glad this helped. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 25, 2018, 12:02pm UTC](https://discuss.elastic.co/t/cannot-assign-numeric-values-in-script-on-update-by-query/129802/9 "2018-05-25T12:02:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.