clickhouse 常用命令

连接数据库：

clickhouse-client -h 127.0.0.1 -u uts --port 9100 --password ~Uts2020db

清楚表的数据：

clickhouse-client -u uts --port=9100 --password=~Uts2020db -d uts

truncate table storage_session;

查询数据表：

select name from system.tables where database like 'uts';

select * from uts.storage_http;

select * from uts.storage_ics;

clickhouse-client --port=9100 --password=~Uts2020db -u uts -d uts -q " insert into storage_others FORMAT CSVWithNames" < /root//work/tftp.csv

pg导出数据

pg_dump -U uts -d uts -h 127.0.0.1 -p 5432 -t tb_ds_asset -f tb_ds_asset.sql

select * from storage_threat prewhere timestamp >= 1691638027 and timestamp <= 1691724427 and msgtype in (31489, 100) order by timestamp desc limit 10 offset 0

select sip,dip,ruleid,toUnixTimestamp(begin_time),toUnixTimestamp(end_time) as end_time_m,threat_total,direct,msg from (select sip,dip,ruleid,begin_time,end_time,threat_total,direct,msg from threat_merger_tmp prewhere end_time>=1691657024 and end_time<=1691743424 and r_code = 20 order by end_time desc limit 200000 union all select sip,dip,ruleid,begin_time,end_time,threat_total,direct,msg from threat_merger_h prewhere end_time>=1691657024 and end_time<=1691743424 and r_code = 20 order by end_time desc limit 200000 union all select sip,dip,ruleid,begin_time,end_time,threat_total,direct,msg from threat_merger_d prewhere end_time>=1691657024 and end_time<=1691743424 and r_code = 20 order by end_time desc limit 200000) order by end_time_m desc