v.21.9New Feature

Add Auto-Selecting Compression for INTO OUTFILE

Add compression for INTO OUTFILE that automatically choose compression algorithm. Closes #3473. #27134 (Filatenkov Artur).
Adds automatic compression support for INTO OUTFILE, enabling ClickHouse to choose the compression algorithm automatically when exporting data.

Why it matters

This feature enhances data export by applying compression directly during the INTO OUTFILE operation, reducing file size and improving storage and transfer efficiency without manual intervention.

How to use it

When using INTO OUTFILE, ClickHouse will automatically select and apply an appropriate compression algorithm to the output file. Users do not need to specify compression parameters explicitly.