We have an index with fields iss_id, cntry_cde, financial_inst, create_dt, update_date, exp_dt.
And we are receiving a data file from other team with values for the fields iss_id, cntry_cde, financial_inst only.
So our requirement is to insert the records if they are not already exists in ElasticSearch including other fields like create_dt, update_date, exp_dt where create_dt and update_dt holds sysdate and exp_dt as 12-12-9999 00:00:000
If record already exists then we have update the record with the values from data file and also only update update_dt to sysdate not touching create_dt and exp_dt.
We tried to use script and upsert but it didn't work. So we need help in implementing this requirement.
If you strictly want to update existing documents but never create documents you probably have to use an elasticsearch filter to obtain the current document (if it exists), update its contents, and send it back with an elasticsearch output. I haven't tried anything like that myself.