Distributed Map Clean-Up

Edit online

When you 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.