Storage Log Family Support for Setting Storage Policy

Why it matters

This feature allows users to specify a storage_policy for tables using the Log family of storage engines. It enhances data management flexibility by enabling data placement and lifecycle control according to user-defined storage policies, which was previously unavailable for these engines.

How to use it

When creating or altering a table that uses a Log family engine, users can set the storage_policy parameter in the table definition. For example:

CREATE TABLE example (
    ...
) ENGINE = Log()
SETTINGS storage_policy = 'your_policy_name';