v.21.11New Features
Add Compression Support for INTO OUTFILE and FROM INFILE
Add support for compression and decompression forINTO OUTFILEandFROM INFILE(with autodetect or with additional optional parameter). #27135 (Filatenkov Artur).
Why it matters
This feature enables users to efficiently export and import compressed data files directly with ClickHouse, reducing storage and network overhead. It simplifies workflows by handling compression and decompression transparently, improving data management and transfer performance.How to use it
When usingINTO OUTFILE or FROM INFILE, users can now specify an optional parameter to define the compression format, or rely on ClickHouse to autodetect the compression based on the file. This allows seamless import/export of compressed files without manual decompression steps.