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.