ck数据导出到csv文件
clickhouse-client -h 127.0.0.1 --databases="db" --query="select * from db.test_table FORMAT CSV" > test.csv
csv文件导入到ck数据库
clickhouse-client -h 127.0.0.1 --databases="db" --query="insert into db.test_table FORMAT CSV" < ./test.csv
2024-02-26 15:01:52
clickhouse-client -h 127.0.0.1 --databases="db" --query="select * from db.test_table FORMAT CSV" > test.csv
clickhouse-client -h 127.0.0.1 --databases="db" --query="insert into db.test_table FORMAT CSV" < ./test.csv