clickhouse更新语句
alter table company update deleted = 1 where cid = '3217683755'
clickhouse删除语句
alter table company delete where cid = '3217683755'
当执行了update或者delete操作后,数据未发生变化,查询已提交未执行操作。
select * from system.mutations where is_done = 0;
终止未执行mutations
KILL MUTATION WHERE database = 'databaseName' AND table = 'tableName';