Validation for batch ingestion

Hi

I have a question related to data validation. I currently have a batch ingestion job that loaded three files in druid.

  1. Is there any way I can add validation on the data that I am ingesting e.g. if I do batch ingestion from three JSON files and all the three files have an id column and I want to make sure that the id from file 1 and file 2 matches with the id from file 3. Is there anything I can do while ingestion process?

  2. If not can I do anything later to filter out the data (that does not have matching id’s) from querying?

Thanks