clickhouse 数据导入 导出（DML）

数据插入

sql

insert + values

insert into t1 ('sku_id','pay_money')
values ('sku_001', 123.00),
       ('sku_002', 345.11);

insert into t1
values ('sku_001', 123.00),
       ('sku_002', 345.11);

insert + select

insert into t1 select * from t2;

本地文件

clickhouse-client -q

cat /opt/module/inputData/ck/word.txt | clickhouse-client -q 'insert into learn_db.test_insert format CSV'  --format_csv_delimiter=':' 

数据导出