v.20.1New Feature

Added Distributed Format for File Engine and File Table Function to Read .bin Files

Added Distributed format for File engine and file table function which allows to read from .bin files generated by asynchronous inserts into Distributed table. #8535 (Nikolai Kochetov)
Added Distributed format support for the File engine and file table function to enable reading from .bin files produced by asynchronous Distributed table inserts.

Why it matters

This feature solves the problem of efficiently accessing .bin files generated by asynchronous inserts into Distributed tables. It allows users to easily read and process distributed binary data stored in files, improving workflow flexibility and integration with distributed data ingestion.

How to use it

Use the Distributed format in conjunction with the File table engine or the file table function. For example, to read a .bin file created by a Distributed table insert, specify FORMAT Distributed when reading the file, enabling ClickHouse to interpret the distributed binary format correctly.