v.21.9New Feature

Add INSERT ... FROM INFILE feature to match SELECT ... INTO OUTFILE

Official CH changelog text
Add INSERT ... FROM INFILE similarly to SELECT ... INTO OUTFILE. #27655 (Filatenkov Artur).
Introduces the INSERT ... FROM INFILE syntax in ClickHouse, allowing users to import data directly from files into tables, analogous to the existing SELECT ... INTO OUTFILE functionality.

Why it matters

This feature solves the problem of importing data efficiently by enabling direct insertion from files, simplifying data ingestion workflows and enhancing usability by providing a symmetrical counterpart to exporting data with SELECT ... INTO OUTFILE.

How to use it

Users can enable this feature by using the INSERT ... FROM INFILE 'filename' statement, specifying the file path to import data directly into a ClickHouse table. The syntax and file formats align with existing data import conventions in ClickHouse.

Related resources

PreviousNext