下载：https://packagecloud.io/Altinity/clickhouse
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
yum install clickhouse-server-common-20.8.3.18-1.el7.x86_64
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
yum install clickhouse-common-static-20.8.3.18-1.el7.x86_64
wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-20.8.3.18-1.el7.x86_64.rpm/download.rpm
yum install clickhouse-server-20.8.3.18-1.el7.x86_64
wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-client-20.8.3.18-1.el7.x86_64.rpm/download.rpm
yum install clickhouse-client-20.8.3.18-1.el7.x86_64
安装包后到对应目录中，进行安装：
安装命令：rpm -ivh ./clickhouse-*.rpm
全部安装完无错误信息即可，在过程中可能会出现缺少安装包的情况，此时需要将缺失的依赖补齐即可
1. /etc/clickhouse-server : 服务端的配置文件目录，包括全局配置config.xml 和用户配置users.xml，其中如需要外网访问则需要打开config.xml中更改配置：
其中需要放开<listen_host>::</listen_host>的注释即可
2. /var/lib/clickhouse : 默认的数据存储目录，通常会修改，将数据保存到大容量磁盘路径中
3. /var/log/cllckhouse-server : 默认保存日志的目录，通常会修改，将数据保存到大容量磁盘路径中
启动服务：
启动：service clickhouse-server start
重启：service clickhouse-server restart
systemctl start clickhouse-server
systemctl status clickhouse-server
systemctl stop clickhouse-server
[root@localhost clickhouse-server]#
service clickhouse-server start
start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
DONE
可以在/var/log/clickhouse-server/目录中查看日志。
如果服务没有启动，请检查配置文件 /etc/clickhouse-server/config.xml
手动从控制台启动服务器:
clickhouse-server --config-file=/etc/clickhouse-server/config.xml
sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml
连接：
clickhouse-client
测试：select 1
API：https://clickhouse.com/docs/zh/getting-started/install/
【错误1】：Effective user of the process (root) does not match the owner of the data (clickhouse). Run under 'sudo -u clickhouse'.
解决：更改目录权限：chown -R clickhouse:clickhouse /etc/clickhouse-server /var/log/clickhouse-server
#添加关方存储库：
sudo yum install -y yum-utils
sudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo
sudo yum install -y clickhouse-server clickhouse-client
#如果没有service，可以运行如下命令在后台启动服务：
sudo /etc/init.d/clickhouse-server start
#使用命令行客户端连接
clickhouse-client # or "clickhouse-client --password" if you set up a password.
【错误2】：DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another server instance in same directory is already running.
解决：ps -ef | grep clickhouse-server
kill -9 $pid
可能不起作用，可使用 ps -ef 查到所有进程再删除
【】<Error> Application: DNS error: EAI: -9
解决：本机没有开放ipv6，只能对ipv4生效。可以考虑在config.xml中，把<listen_host>::</listen_host> 改成<listen_host>0.0.0.0</listen_host>
【】:Memory limit (for query) exceeded: would use 9.31 GiB (attempt to allocate chunk of 1048576 bytes), maximum: 9.31 GiB
解决：修改user.xml里max_memory_usage 值，把他改大一些，默认是953M，不到1G，可以改到2G
【】Include not found: clickhouse_remote_servers
Include not found: clickhouse_compression
Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = Exception: Cannot set max size of core file to 1073741824, e.what() = Exception
解决：没有开放core文件写入，使用命令： ulimit -c 1073741824， 开放即可。
【】Access to file denied: /var/log/clickhouse-server/clickhouse-server.err.log
解决：到目录下删除 clickhouse-server.err.log 文件