Elasticsearch query to remove an delete value from inconsistent array of comma-separated values

Question

Recently, I posted the following about adding a string to existing (inconsistent) arrays in documents: ElasticSearch query to populate or append a value to a field

The marked solution is working perfectly.

But now I need to understand how to delete one of the 5-character codes from the arrays. Assuming I now need to delete the code 'ABCDE' from the documents, while leaving the other codes in the array untouched, what would that query look like?

jaspreet chahal · Accepted Answer · 2019-10-30 03:29:07Z

1

In below script I am looping through array and creating a list by removing the given value.

Please test before running on actual data.

{
  "script": {
    "source": "ctx._source.customCategories.removeAll(Collections.singleton(params.catg))",
    "lang": "painless",
    "params": {
      "catg": "c"
    }
  }
}

edited Oct 30, 2019 at 3:29

answered Oct 29, 2019 at 3:53

jaspreet chahal

9,1392 gold badges14 silver badges30 bronze badges

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

15 Comments

Stpete111 Over a year ago

Hi Jaspreet. Good to see you again. I will try this after my morning meeting. In the meantime, can you suggest some online documentation or video tutorial for me to learn the painless language and syntax for ES?

jaspreet chahal Over a year ago

This is official documentation elastic.co/guide/en/elasticsearch/reference/current/index.html

Stpete111 Over a year ago

Hi Jaspreet. I've run your query on some test sources. The query does remove the custom category value as intended, but, it's doing that thing again where the fields are displayed out of order for any documents which I've run the query against. You were able to somehow address this in the other post. Can you please advise?

Stpete111 Over a year ago

Just FYI, sample document and mapping are identical to the other thread. Thanks.

jaspreet chahal Over a year ago

I have updated the answer. I think this should work fine

|

Collectives™ on Stack Overflow

Elasticsearch query to remove an delete value from inconsistent array of comma-separated values

1 Answer 1

15 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

15 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related