Hi All, I would like to remove or delete certain records in Apache Pinot schema or table. Can you share us the procedure to delete. The schema carries certain columns named ID, Timestamp, values -> where ID would be a number. I would like to delete the data with ID as an input. For example delete from demotable where id='1234' or id in (1234, 145,345,133)?

You will need to write a minion purge task that can perform the identification and purging of those records.

Thanks Mayank, Can you provide more details on this approach?