Distributed Map Clean-Up

When we are performing a distributed map clean-up, rows are deleted when their expiry is reached.

Manual clean-up queries

To disable the out-of-the-box clean-up, set distributedMap.cleanupWait to 0. Select the rows to delete with:

SELECT DMAP_KEY as v1, DMAP_PARTITION as v2
FROM DMAP_ENTRIES
WHERE DMAP_EXPIRY < CURRENT_TIME_MILLIS

Variables that must be populated: CURRENT_TIME_MILLIS is an integer representing the current time in milliseconds. Delete the rows with:

DELETE FROM DMAP_ENTRIES
WHERE DMAP_KEY = v1 and DMAP_PARTITION = v2

In the DELETE query above, the following variables must be substituted:
• v1 corresponds to the DMAP_KEY that is selected in the previous query.
• v2 corresponds to the DMAP_PARTITION that is selected in the previous query.

Parent topic: Manual database clean-up