ClickHouse中表的操作

1、删视图表与本地表

DROP table db.视图表 ON CLUSTER cluster_name;
DROP table db.本地表 ON CLUSTER cluster_name;

2、删表的列

ALTER TABLE db.视图表 ON CLUSTER cluster_name DROP COLUMN column_name1, DROP COLUMN column_name2;
ALTER TABLE db.本地表 ON CLUSTER cluster_name DROP COLUMN column_name1, DROP COLUMN column_name2;

3、增加表的列

ALTER TABLE db.视图表 ON CLUSTER cluster_name ADD COLUMN column_name1, ADD COLUMN column_name2;
ALTER TABLE db.本地表 ON CLUSTER cluster_name ADD COLUMN column_name1, ADD COLUMN column_name2;

4、删表的行

DELETE FROM db.表 ON CLUSTER cluster_name WHERE 要删除行的条件;