Support for Disabling Persistency in StorageJoin and StorageSet

Why it matters

This feature addresses the need to control and optionally disable the persistency of data in StorageJoin and StorageSet. Disabling persistency can improve performance and resource usage in scenarios where persistence is unnecessary, providing users with more flexibility in managing temporary or ephemeral data.

How to use it

To disable persistency for StorageJoin and StorageSet, set the configuration option disable_set_and_join_persistency to true in the ClickHouse server configuration file or via session settings.