Input Format ORC

Why it matters

This feature enables ClickHouse to directly read and import data stored in the ORC file format, a popular columnar storage format used in big data systems. It simplifies integration with ecosystems producing ORC files, eliminates the need for external conversion tools, and improves data ingestion efficiency.

How to use it

Users can enable the ORC input format by specifying FORMAT ORC in their INSERT statements or when reading data from files, for example:

INSERT INTO table_name FORMAT ORC

or

SELECT * FROM table_name FORMAT ORC

ClickHouse will then parse the ORC data accordingly.