clickhouse安装(单机版)—服务安装

1、添加hadoop账号
2、设置hadoop账号具有sudo权限

#切换root账号，执行visudo
[root@bigdata-k-01 ~]# visudo
#在visudo 中root    ALL=(ALL)       ALL下添加一行hadoop
......
## Allow root to run any commands anywhere
root    ALL=(ALL)       ALL
hadoop  ALL=(ALL)       ALL
.....

3、校验cpu是否支持sse 4.2

[hadoop@bigdata-k-01 ~]$  grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
SSE 4.2 supported

4、安装
https://clickhouse.tech/docs/en/getting_started/install/

#添加rpm repository
[hadoop@bigdata-k-01 ~]$ sudo yum install yum-utils
[hadoop@bigdata-k-01 ~]$ sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
[hadoop@bigdata-k-01 ~]$ sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64

#安装
[hadoop@bigdata-k-01 ~]$ sudo yum install clickhouse-server clickhouse-client

#启动
[hadoop@bigdata-k-01 ~]$ sudo service clickhouse-server start
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
Creating directory /var/lib/clickhouse/
Changing owner of [/var/lib/clickhouse/] to [clickhouse:clickhouse]
DONE
#日志文件在
[hadoop@bigdata-k-01 ~]$ ll /var/log/clickhouse-server/
total 24
-rw-r----- 1 clickhouse clickhouse  2172 Apr 14 15:51 clickhouse-server.err.log
-rw-r----- 1 clickhouse clickhouse 12377 Apr 14 15:52 clickhouse-server.log
-rw-r----- 1 clickhouse clickhouse   568 Apr 14 15:51 stderr.log
-rw-r----- 1 clickhouse clickhouse     0 Apr 14 15:51 stdout.log

5、执行

[hadoop@bigdata-k-01 ~]$  clickhouse-client
ClickHouse client version 20.3.5.21 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.3.5 revision 54433.

bigdata-k-01 :) select 1;

SELECT 1

┌─1─┐
│ 1 │
└───┘

1 rows in set. Elapsed: 0.015 sec.

bigdata-k-01 :)

安装完成。
接下来进行数据导入：clickhouse 数据导入

6、启动的时候可能会包数据目录或日志目录没有权限

[root@bigdata-k-01 0]# service clickhouse-server start
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /mnt/disk/0/clickhouse/
Changing owner of [/var/log/clickhouse-server/*] to [clickhouse:clickhouse]
chown: cannot access '/var/log/clickhouse-server/*': No such file or directory
Changing owner of [/var/log/clickhouse-server] to [root:clickhouse]

[root@bigdata-k-01 clickhouse-server]# service clickhouse-server start
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /mnt/disk/0/clickhouse/
Changing owner of [/var/log/clickhouse-server/*] to [clickhouse:clickhouse]
Changing owner of [/var/log/clickhouse-server] to [root:clickhouse]
UNKNOWN

解决：可以指定有权限的目录或者将目录的权限修改为clickhouse:clickhouse

[root@ip-10-130-68-178 0]# cat /etc/clickhouse-server/config.xml | grep "/var/lib/clickhouse"
    <path>/var/lib/clickhouse/</path>
    <tmp_path>/var/lib/clickhouse/tmp/</tmp_path>
    <user_files_path>/var/lib/clickhouse/user_files/</user_files_path>
    <access_control_path>/var/lib/clickhouse/access/</access_control_path>
    <format_schema_path>/var/lib/clickhouse/format_schemas/</format_schema_path>

[root@ip-10-130-68-178 log]# pwd
/var/log
[root@ip-10-130-68-178 log]# chown clickhouse:clickhouse clickhouse-server

#启动前一定要把日志目录和数据目录提前创建好切必须把用户和组更新为clickhouse
[root@ip-10-130-68-178 log]# service clickhouse-server status
clickhouse-server service is running
[root@ip-10-130-68-178 0]# cat /etc/clickhouse-server/config.xml | grep "/var/lib/clickhouse"
    <path>/var/lib/clickhouse/</path>
    <tmp_path>/var/lib/clickhouse/tmp/</tmp_path>
    <user_files_path>/var/lib/clickhouse/user_files/</user_files_path>
    <access_control_path>/var/lib/clickhouse/access/</access_control_path>
    <format_schema_path>/var/lib/clickhouse/format_schemas/</format_schema_path>

#将数据目录修改为/mnt/disk/0/clickhouse目录
[root@ip-10-130-68-178 log]# sed -i "s/\/var\/lib\/clickhouse/\/mnt\/disk\/0\/clickhouse/g" /etc/clickhouse-server/config.xml

[root@ip-10-130-68-178 log]# pwd
/var/log
#在/var/log下创建clickhouse-server 和 clickhouse-lient目录，并将目录权限改为clickhouse:clickhouse
[root@ip-10-130-68-178 log]# mkdir dir clickhouse-server  clickhouse-lient
[root@ip-10-130-68-178 log]# chown clickhouse:clickhouse clickhouse-server

[root@ip-10-130-68-178 log]# chown clickhouse:clickhouse clickhouse-client

#然后重新启动即可