Currently, when you delete some rows, they are deleted in nodes db, but the metadata of this rows in master is not deleted.
So we have to:
Coordinator node has to look for the rowIDs that is going to delete that query. It has to run a select in all nodes that have the table, with the where that the delete query has.
It has to send them to master in DeleteMetadataRequest.
Master has to delete the metadata of those rowIDs.
DELETE FROM Customers
WHERE City IN ('Paris','London');
SELECT row_id FROM Customers
WHERE City IN ('Paris','London');
Currently, when you delete some rows, they are deleted in nodes db, but the metadata of this rows in master is not deleted.
So we have to: