## 数据导入方式 cd /var/lib/clickhouse/data 下的数据库的表文件夹  \-- 方式1 ~~~ create table tb_test3 as tb_test2 ; Insert into tb_test3 select * from tb_test2 ; ~~~ \-- 方式2 ~~~ cat user.txt | clickhouse-client -q 'insert into datatest1.tb_test2 format CSV ~~~ \-- 方式3 ~~~ clickhouse-client -q 'insert into datatest1.tb_test2 format CSV' < user.txt ~~~ \-- 指定分隔符 ~~~ clickhouse-client --format_csv_delimiter=',' -q 'insert into datatest1.tb_test2 format CSV' < user.txt ~~~ 支持的文件格式： [https://clickhouse.tech/docs/zh/interfaces/formats/](https://clickhouse.tech/docs/zh/interfaces/formats/)