v.22.1Improvement

LineAsString Output Format Added

Official CH changelog text
LineAsString can be used as output format. This closes #30919. #33331 (Sergei Trifonov).
LineAsString is a new output format in ClickHouse that allows query results to be returned as plain text lines.

Why it matters

This feature addresses the need for a simple, line-oriented output format, enabling easier integration with tools or scripts that process plain text line by line. It simplifies extraction and readability when complex structured formats are unnecessary.

How to use it

To use this feature, specify the output format LineAsString in your query by appending FORMAT LineAsString at the end of your SQL query. For example:

SELECT * FROM table_name FORMAT LineAsString

Related resources

PreviousNext