Update a single field in every document in an Engine

Elastic Search
1

Hello, I need to set a new value in a single value of all the documents on an Engine.
In SQL it would like UPDATE <field>=123 FROM <table>

Since the PATCH operation needs the ID to be sent, the only way i found is use the API to make multiple LIST requests (every LIST can return 10k documents and I have more), and then make several PATCH requests.

Logstash is discarded since it can't make PATCH requests (I made a topic with that issue and had no answer: How to generate PATCH requests using the AppSearch output plugin?)

Is there a more straightforward way to do this massive updates in all the engine?

2

Not to my knowledge, unfortunately.

I would typically recommend explicitly setting the ids of documents in app search to match the ids from your system to make updates like this easier, so that you could skip the list step and just iterate over all ids from your source system.

1 Like
3

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