Hello,
I am using the logstash JDBC plugin to import the data in oracle table to elasticsearch index and using the modified time stamp as sql last run and using the primary key of oracle table as elasticsearch document id to make sure when ever the same record comes it will go and get updated in elassticsearch instead of creating as new record. This is fine if i dont rotate the ES index but how can i achieve this with index rotation and update the record in old index if the same record is coming from oracle table.Any ideas would be appreciated.
Thanks