How Do I Export Data from ClickHouse to a File? 

Using INTO OUTFILE Clause 

Add an INTO OUTFILE clause to your query.

For example:

SELECT * FROM table INTO OUTFILE 'file'

By default, ClickHouse uses the TabSeparated format for output data. To select the data format, use the FORMAT clause.

For example:

SELECT * FROM table INTO OUTFILE 'file' FORMAT CSV

Using a File-Engine Table 

See File table engine.

Using Command-Line Redirection 

$ clickhouse-client --query "SELECT * from table" --format FormatName > result.txt

See clickhouse-client.

Rating: 5 - 3 votes

Was this content helpful?
★★★★★