2022-06-10 ： 查询clickhouse分区并删除

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

alter table um_dmp_business_intelligence_olap_db.fee_detail drop partition ('F4965983337060211A1001',202205);