Clickhouse基础笔记-安装篇

Clickhouse

基本安装

centos7系统为例

1
2
3
4
5
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
sudo /etc/init.d/clickhouse-server start
sudo /etc/init.d/clickhouse-server start

image-20220705161531256

简单配置

开放其他ip地址连接

如果仅在本机进行连接可以无需进行操作

编辑/etc/clickhouse-server/config.xml

<listen_host>::</listen_host>这行注释给删掉即可

客户端连接

clickhouse-client

1
clickhouse-client
1
2
3
ClickHouse client version 22.6.2.12 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 22.6.2 revision 54455.

我们可以看到官方客户端默认使用localhost:9000和用户default

进入后即可对Clickhouse进行操作

image-20220705161957244

datagrip

官方支持多种第三方客户端操作, 以常用的datagrip为例

image-20220705162245084

先安装Clickhouse的驱动

image-20220705162346323

填入相关信息后即可连接

1
2
3
4
5
6
需要关闭掉SELinux和防火墙
# systemctl stop firewalld.service
# systemctl disable firewalld.service
# cat /etc/selinux/config
SELINUX=disabled
SELINUXTYPE=targeted

image-20220705162421389