v.20.6New Feature

Support ORC format for output in ClickHouse

Official CH changelog text
Support format ORC for output (was supported only for input). #11662 (Kruglov Pavel).
Added support for the ORC format as an output format in ClickHouse, previously supported only for input.

Why it matters

This feature enables users to export query results directly in the ORC format, a popular columnar storage format widely used for efficient data storage and interchange. It simplifies data workflows by allowing seamless integration with systems that consume ORC files, improving interoperability and usability.

How to use it

To use the ORC output format, specify FORMAT ORC at the end of your query. For example:

SELECT * FROM table_name FORMAT ORC

Related resources

PreviousNext