clickhouse默认无法实时删除表中的数据
clickhouse默认是不支持实时删除表中的数据,数据的删除通常是异步进行。若是在同写同读的场景,有可能会查询到已经被删除的数据,这可能会导致一些逻辑上的错误,或者误解。
来看下面的示例,可以看出,虽然执行了删除语句,但数据实际没有被删除。
是什么原因导致数据没及时删除呢?
ALTER TABLE … DELETE Statement
ALTER TABLE [db.]table [ON CLUSTER cluster] DELETE WHERE filter_expr
Allows to delete data matching the specified filtering expression. Implemented as amutation.
Note:
TheALTER TABLEprefix makes this syntax different from most other systems supporting SQL. It is intended to signify that unlike similar queries in OLTP databases this