Allows external aggregation and sorting operations in ClickHouse to use any storage policy, including object storage systems like S3.
Why it matters
This feature enables users to leverage cheaper and scalable storage options such as object storage for external aggregation and sorting processes. It improves resource utilization, reduces local disk usage, and enhances flexibility in managing large data operations that exceed local storage capacity.How to use it
Users can specify any storage policy in the ClickHouse configuration for external aggregation and sorting. By setting the desired storage policy (including those pointing to object storage like S3) in relevant settings or configuration files, external operations will use the specified storage for temporary data.