clikchouse

官方文档

https://clickhouse.tech/docs/en/operations/system-tables/tables/

一、关于建表

CREATE TABLE [IF NOT EXISTS] [db.]table_name [ON CLUSTER cluster]
(
    name1 [type1] [NULL|NOT NULL] [DEFAULT|MATERIALIZED|ALIAS expr1] [compression_codec] [TTL expr1],
    name2 [type2] [NULL|NOT NULL] [DEFAULT|MATERIALIZED|ALIAS expr2] [compression_codec] [TTL expr2],
    ...
) ENGINE = engine

https://www.cnblogs.com/uestc2007/p/11022918.html
CLUSTER在SELECT * FROM system.clusters 中取不为system clusters的

https://blog.csdn.net/helunqu2017/article/details/113564324
posted @ 2021-04-02 14:32  巴啦啦大魔王  阅读(158)  评论(0编辑  收藏  举报