Hi, when we have a single index elasticsearch updates the existing document if a new db row comes in from logstash jdbc for a document_id that already exists in elasticsearch, otherwise inserts. That is great but now we want that between multiple indices. We started creating a new index each day for purging reasons like this:
We want to know if it's possible to use the same alias for each index and have the alias be used when storing new documents into the indices. Our situation is that we want to update the existing document when a new oracle row comes in that matches the document_id of an existing index instead of making new document in the next days index.
For example , if search-05-25-2017 contains document_id 1, and it is now the 26th, we want to add to elasticsearch through the alias and it automatically update the document if it exists in any of the indices of that alias, otherwise insert into todays index. So if another row with id 1 comes in, we want it to update search-05-25-2017 instead of adding to today's index.
Is that possible?