这里仅仅介绍离线 rpm安装
1.首先下载安装包
第三方:https://packagecloud.io/Altinity/clickhouse/
官方:https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
2.上传linux 某个目录下:
3.安装:只需4个包就行,尽量按照以下顺序
sudo rpm -ivh clickhouse-common-static-20.8.3.18-1.el7.x86_64.rpm
sudo rpm -ivh clickhouse-server-common-20.8.3.18-1.el7.x86_64.rpm
sudo rpm -ivh clickhouse-server-20.8.3.18-1.el7.x86_64.rpm
sudo rpm -ivh clickhouse-client-20.8.3.18-1.el7.x86_64.rpm
4.检测安装好的安装包
rpm -qa|grep clickhouse
5.修改配置
sudo vim /etc/clickhouse-server/config.xml
主要修改开 放外网访问 的配置:
6.重新启动
sudo clickhouse restart #新版命令
7.进入客户端
在客户端里操作: clickhouse-client -m # -m 保证命令可以换行
或者不进入客户端操作 : clickhouse-client --query "show databases";
8、建表
create table t_order_mt(
id UInt32,
sku_id String,
total_amount Decimal(16,2),
create_time Datetime
)engine =MergeTree
partition by toYYYYMMDD(create_time)
primary key(id)
order by(id,sku_id);
9、插入数据
insert into t_order_mt values
(101,'sku_01',1000.00,'2021-06-01 12:00:00'),
(102,'sku_02',2000.00,'2021-06-01 11:00:00'),
(102,'sku_04',2500.00,'2021-06-01 12:00:00'),
(102,'sku_02',2000.00,'2021-06-01 13:00:00'),
(102,'sku_02',12000.00,'2021-06-01 13:00:00'),
(102,'sku_02',600.00,'2021-06-01 12:00:00'),
(102,'sku_02',600.00,'2021-06-02 12:00:00');
10、查询
select * from t_order_mt e;