0%

ClickHouse-Trial

发表于 2022-07-18 更新于 2024-03-18 分类于 Database 阅读次数： Valine：

阅读更多

1 Tips

1.1 如何创建分布式表

Distributed Table Engine

首先，在每个节点创建本地表

CREATE TABLE IF NOT EXISTS t0_local (fn_int UInt32,fn_int_null UInt32, par_int_low UInt32, par_int_high UInt32, par_str_low LowCardinality(String), par_str_high String) ENGINE = MergeTree() PRIMARY KEY (fn_int)

然后，在任意一个节点，创建分布式表

CREATE TABLE IF NOT EXISTS t0 (fn_int UInt32,fn_int_null UInt32, par_int_low UInt32, par_int_high UInt32, par_str_low LowCardinality(String), par_str_high String) ENGINE = Distributed('perftest_3shards_1replicas', 'analytic_1M', 't0_local', fn_int)

这流程，属实一言难尽😢

1.2 如何查看配置

1	select * from system.settings;

1.3 如何删除数据

TRUNCATE Statement

1.4 clickhouse-client

-m：多行模式，以;作为SQL结束标识符，默认以换行作为结束标识符

1	clickhouse-client -h 172.26.194.221 --password sr -m

livere
valine