一. 集群操作

1. 添加字段

alter table ailpha_security_alarm_data ON CLUSTER clickhouse_cluster add column srcexpose;

2.删除字段

 alter table ailpha_security_alarm_data ON CLUSTER clickhouse_cluster drop column srcexpose;

二. 通用操作

1. 导入数据

clickhouse-client -h 1.clickhouse1  -d securityAlarm -q " insert into ailpha_security_alarm  FORMAT CSVWithNames" --format_csv_delimiter='|' < /data/surface_ip.csv 

2. 导出数据

clickhouse-client -d securityAlarm -q "select * from ailpha_security_alarm where  endTime between '2024-01-17 13:30:00' and  '2024-01-17 14:00:00' FORMAT CSVWithNames " --format_csv_delimiter='|' > /data/zhangjie/20240117133000-1400ck.csv

3.执行sql文件

 clickhouse-client --query "$(cat V20221008111500__create_table_ailpha_security_alarm.sql)"