ElasticSearch _update_by_query filter elements of array

Question

Problem: I need to remove numbers > 25000000 from array in elasticsearch using _update_by_query.

curl -XPOST 'http://127.0.0.1:9200/mydb/_update_by_query' --header 'Content-Type: application/json'  --data '
{"query": {
 "range": {
 "multiAccounts": { "gte": 25000000 } } },
 "script": {"source": "ctx._source.multiAccounts = ctx._source.multiAccounts;"}
}'

Insted of ctx._source.multiAccounts = ctx._source.multiAccounts; I need somethig like:

ctx._source.multiAccounts = ctx._source.multiAccounts.filter(el < 25000000);

Can you show a sample document please?

Val
– Val

2022-02-02 17:06:32 +00:00
Commented Feb 2, 2022 at 17:06 — Val
– Val, Commented Feb 2, 2022 at 17:06

Val · Accepted Answer · 2022-02-02 17:09:21Z

1

Since Painless relies on Java (and if multiAccounts is an array in your source document), then you can use streams, like this:

ctx._source.multiAccounts = ctx._source.multiAccounts.stream().filter(el -> el > 25000000).collect(Collectors.toList());

answered Feb 2, 2022 at 17:09

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

homeboy Over a year ago

Yeah, but el < 25000000 in my case. Big thanks!

Collectives™ on Stack Overflow

ElasticSearch _update_by_query filter elements of array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related