Modifying Memory Table Settings with ALTER MODIFY SETTING Supported

Why it matters

This feature allows users to change runtime parameters of Memory tables such as min_rows_to_keep and max_rows_to_keep without recreating the table, providing greater flexibility and control over in-memory data retention.

How to use it

Use the ALTER TABLE <table_name> MODIFY SETTING statement to change memory table settings. For example:

ALTER TABLE memory MODIFY SETTING min_rows_to_keep = 100, max_rows_to_keep = 1000;