centos7安装clickhouse和图形客户端

安装clickhouse服务

参考：https://blog.csdn.net/wbl381/article/details/106995351/

下载页面：https://packagecloud.io/Altinity/clickhouse

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-20.8.3.18-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-common-20.8.3.18-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-common-static-20.8.3.18-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-client-20.8.3.18-1.el7.x86_64.rpm/download.rpm

安装

rpm -ivh clickhouse-common-static-20.8.3.18-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-common-20.8.3.18-1.el7.x86_64.rpm
rpm -ivh clickhouse-server-20.8.3.18-1.el7.x86_64.rpm
rpm -ivh clickhouse-client-20.8.3.18-1.el7.x86_64.rpm

关闭防火墙，开启服务

systemctl stop firewalld.service 
systemctl disable firewalld.service
service clickhouse-server start


clickhouse-client

能看到笑脸就对了！

图形客户端

DBeaver

1） dbeaver 有个社区版，在windows store就可以搜索安装，
2）https://dbeaver.io/ 官网下载，
3）我搜了一个企业版，注册后总是提示授权找不到，所以放弃了

Tabix 开源

使用docker直接运行比较简单，安装docker麻烦些
https://tabix.io/doc/Install/#variant-5-from-docker

docker run -d -p 8080:80 spoonest/clickhouse-tabix-web-client

会自动下载容器镜像，启动后

docker ps

本地打开浏览器

http://127.0.0.1:8123

添写服务器名称，用户名为default， 口令为空，点登录按钮就好了。