We have this usecase:
- Create Application with fields A (text), B (text), C (text). Application is more of a UI term but we have say for each application a collection in mongoDB to store the metadata of the application.
- Create some records. records are like instances of the application created where we can put values for each of these A, B, C text fields. This is stored in a collection named Records.
- We are ingesting this records collection data to elastic for search capability.
Expectation at this stage is that Elastic will have A, B, C in records index for search for all inserted records - Delete field C in the Application Builder.
- Expectation is that only A and B will be there for search in Elastic.
Step 5 is the challenge, as we need to find a way to delete/invalidate field C from all existing records in Elastic. What is the best way to achieve this? Elasticsearch will still retain that field unless you explicitly reindex them to remove it??