clickhouse查询并删除分区

查询分区

SELECT
      partition
FROM
      system.parts
WHERE
      (database = '库')
      and (table = '表名')
GROUP BY
      partition
order by
      partition desc;

删除分区

alter table 库.表名 drop partition 'partition';