Posts

Showing posts with the label export

clickhouse export or import data

Export data from clickhouse into csv file: :) SELECT * FROM table INTO OUTFILE 'file' Import data from csv file: clickhouse-client -q "INSERT INTO database.tablename FORMAT CSV" < tablename.csv