ElasticSearch - query to append a string to an existing string in a document field

Question

All of our ElasticSearch documents contain a field called Categories which contains a string of comma-separated values. The length of each value between the commas is 5 characters, and the field can be anywhere from 1 to 12 5-character values.

I need to run a query against the index which says append ,ABCDE to the end of Categories field of all documents, unless the field already contains the value ABCDE in it, in which case do not append anything to the field.

Ashraful Islam · Accepted Answer · 2019-07-09 03:39:39Z

2

You can use ElasticSearch _update_by_query like below

POST my_index/my_type/_update_by_query
{
  "query": {
    "bool": {
      "must_not": [
        {
          "match": {
            "Categories": "ABCDE"
          }
        }
      ]
    }
  },
  "script": {
    "inline": "ctx._source.Categories += ', ABCDE'",
    "lang": "painless"
  }
}

The above query will append string ', ABCDE' to Categories if Categories doesn't contains the term ABCDE

edited Jul 9, 2019 at 3:39

answered Jul 8, 2019 at 18:21

Ashraful Islam

12.9k4 gold badges35 silver badges55 bronze badges

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

8 Comments

Stpete111 Over a year ago

Many thanks Ashraful. Just to be sure I understand, the first part of the query syntax will look for Categories to contain 12345 anywhere in the string, and not just for where Categories = 12345?

Ashraful Islam Over a year ago

@Stpete111 match query will look if the term 12345 contains in the Categories and since match is inside must_not, it will look for must not contains the term 12345 in Categories

Stpete111 Over a year ago

Ashraful, just to verify the results, I have run just the search part of your query, but I changed must_not to must as I wanted to confirm that results which contain ABCDE are included in the results. However, when I run it, it only brings back results where Categories equal ABCDE exactly. Is this expected behavior?

Ashraful Islam Over a year ago

@Stpete111 what is field type of Categories ? text or keyword ?

Ashraful Islam Over a year ago

@Stpete111 text type uses standard tokenizer which provides grammar based tokenization (based on the Unicode Text Segmentation algorithm. i.e if categories contains text The 2 QUICK Brown-Foxes jumped over the lazy dog's bone it will be tokenized into [The, 2, QUICK, Brown, Foxes, jumpe, d, over, the, lazy, dog's, bone] So this catgories will be match if any of the tokens provided in the match query

|

Collectives™ on Stack Overflow

ElasticSearch - query to append a string to an existing string in a document field

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related