v.19.3New Features

Added Rowbinarywithnamesandtypes Format

Added RowBinaryWithNamesAndTypes format. #4200 (Oleg V. Kozlyuk)
Added support for the RowBinaryWithNamesAndTypes data format in ClickHouse.

Why it matters

This new format provides a binary serialization of data rows that includes column names and their types, enabling more self-describing and efficient data exchange. It solves the problem of needing explicit schema information alongside binary data, improving interoperability and ease of data handling.

How to use it

Users can enable this format by specifying RowBinaryWithNamesAndTypes in the format clause of input/output operations, for example:

SELECT * FROM table FORMAT RowBinaryWithNamesAndTypes

or when inserting data:

INSERT INTO table FORMAT RowBinaryWithNamesAndTypes