clickhouse的sql语法功能1-创建库，创建表等

create database my_clickhouse;

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

create table test.test_summergetree (
  id Int32 comment 'id',
  name String comment '名称',
  money Decimal32(2) COMMENT '工资',
  create_at DateTime comment '创建时间'
) engine = SummingMergeTree()
order by
  id partition by toYYYYMM(create_at) primary key id sample by id TTL create_at + INTERVAL 1 MONTH DELETE;

CREATE TABLE IF NOT EXISTS all_hits ON CLUSTER cluster (p Date, i Int32) ENGINE = Distributed(cluster, database,table, sharding_key)

CREATE TABLE test_summergetree_distributed (
  `float` Nullable(Float64),
  `str` Nullable(String),
  `test` Nullable(Int64),
  `create_at` DateTime
) ENGINE = Distributed('default', 'test', 'test_summergetree', rand())

INSERT INTO [db.]table [(c1, c2, c3)] VALUES (v11, v12, v13), (v21, v22, v23), ...

INSERT INTO [db.]table [(c1, c2, c3)] SELECT ...