v.20.1New Feature

Added support for reading and writing gzip files in file-related table engines and functions

Added feature for file-related table engines and table functions (File, S3, URL, HDFS) which allows to read and write gzip files based on additional engine parameter or file extension. #7840 (Andrey Bodrov)
Added support for reading and writing gzip compressed files in file-related table engines and table functions such as File, S3, URL, and HDFS.

Why it matters

This feature enables users to seamlessly work with compressed gzip files directly through ClickHouse table engines and table functions. It solves the problem of handling compressed input and output without manual decompression or compression, improving efficiency and simplifying workflows when dealing with large compressed datasets.

How to use it

Users can enable gzip support by specifying an additional engine parameter indicating compression, or by using file names with the .gz extension. This allows the respective table engine or function to automatically detect and handle gzip compressed files when reading or writing data.