CK表操作

1.修改表名

RENAME TABLE T1 TO T2 on cluster my_cluster;

2.修改字段

ALTER TABLE T1 UPDATE A = 1 WHERE A = 2;

3.删除数据

ALTER TABLE T1 DELETE WHERE A = 2;

4.CK数据库修改是异步的，立刻更新

OPTIMIZE TABLE T1 FINAL;

5.创建集群表时在建表语句表名后面增加 ON CLUSTER '{cluster}'

6.复制表

CREATE TABLE new_table AS old_table ENGINE = Log

插入数据

INSERT INTO new_table SELECT * FROM old_table;

7.清空表

TRUNCATE TABLE  T1 on cluster my_cluster;

8.删除表

DROP TABLE [IF EXISTS] table_name on cluster my_cluster