ClickHouse列式数据库入门

一、安装ClickHouse：添加官方yum源，yum install clickhouse-server clickhouse-client安装，配置/etc/clickhouse-server/config.xml，启动systemctl start clickhouse-server，客户端连接clickhouse-client。二、创建表：CREATE DATABASE analytics创建数据库，MergeTree引擎是最常用的表引擎，ORDER BY指定排序键，PARTITION BY指定分区键通常按日期，CREATE TABLE events (date Date, event String, count UInt64) ENGINE = MergeTree() PARTITION BY toYYYYMM(date) ORDER BY date。三、数据导入：INSERT INTO events VALUES插入少量数据，clickhouse-client --query=INSERT INTO events FORMAT CSV从CSV导入，远程数据INSERT INTO events SELECT从其他表导入。四、查询优化：利用分区裁剪减少扫描数据量，主键索引加速点查询，物化视图预聚合常用查询，SKIP INDEX跳数索引加速过滤。