v.19.1New Features

Support for Write in HDFS Tables and Hdfs Table Function

Support for write in HDFS tables and hdfs table function. #4084 (alesapin)
Adds support for writing data into HDFS tables and introduces the hdfs table function in ClickHouse.

Why it matters

This feature enables users to write data directly into HDFS storage from ClickHouse, facilitating seamless integration with Hadoop ecosystems. It solves the problem of ClickHouse's lack of native write capabilities to HDFS, allowing for easier data exchange, persistence, and processing in environments leveraging HDFS.

How to use it

Users can create tables using the HDFS engine to enable writing data to HDFS. Additionally, the hdfs table function can be utilized to read from HDFS paths in queries. Data insertion can be performed using standard INSERT INTO syntax targeting HDFS tables.