如果是数据表为分布式表,直接执行如下语句会报错

 

ALTER TABLE db.table DELETE WHERE date like '%2022%';

正确的方式为在各个节点上分别删除数据

ALTER TABLE db.table on cluster cluster_name DELETE WHERE date like '%2022%';