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
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
Comments
Post a Comment