ClickHouse安装部署

百度网盘下载链接：https://pan.baidu.com/s/1YdGmhGND5qA3qzBpRQaI1w
提取码：sybk

clickhouse-common-static-21.9.4.35.tgz
clickhouse-common-static-dbg-21.9.4.35.tgz 
clickhouse-server-21.9.4.35.tgz
clickhouse-client-21.9.4.35.tgz

------------------------------------------------------------
# 解压,运行doinst.sh 
tar -zxvf clickhouse-common-static-21.9.4.35.tgz
./clickhouse-common-static-21.9.4.35/install/doinst.sh

------------------------------------------------------------
tar -zxvf clickhouse-common-static-dbg-21.9.4.35.tgz 
./clickhouse-common-static-dbg-21.9.4.35/install/doinst.sh
 
------------------------------------------------------------
tar -zxvf clickhouse-server-21.9.4.35.tgz
./clickhouse-server-21.9.4.35/install/doinst.sh
 
 设置默认用户(default)的密码
------------------------------------------------------------
tar -zxvf clickhouse-client-21.9.4.35.tgz
./clickhouse-client-21.9.4.35/install/doinst.sh

ClickHouse相关目录

命令目录
/usr/bin
ll |grep clickhouse

配置文件目录
cd /etc/clickhouse-server/

<!-- vi /etc/clickhouse-server/config.xml 			
大约在82行，修改clickhouse默认通信地址9000，与hadoop3.x版本的rpc通信端口冲突（如有需要可修改）-->
<tcp_port>9001</tcp_port>

日志目录
cd /var/log/clickhouse-server/

数据文件目录
cd /var/lib/clickhouse/

启动

# clickhouse-server-21.9.4.35.tg解压并运行安装程序后，即可启动
clickhouse start 

# 解压并安装clickhouse-client-21.9.4.35.tgz 后, 可连接
clickhouse-client --port 9000 -h 主机名 -d 数据库名 -m -u 用户名 --password 密码

运行远程访问

clickhouse默认不允许远程访问外部访问，需要修改配置文件

vim /etc/clickhouse-server/config.xml
 
把listen 注释打开

强制保存wq!

重启clickhouse  : clickhouse restart
在浏览器输入服务器ip:8123验证一下

ClickHouse服务启停

systemctl start clickhouse-server
systemctl status clickhouse-server
systemctl restart clickhouse-server

ClickHouse建表语句

create table my_db1.base_region(id UInt32, region_name String) 
ENGINE=MergeTree() 
ORDER BY id;

clickhouse（使用MergeTree引擎）建表语句必须进行order by，Log和Memery引擎不需要order by

使用Memery引擎即基于内存，clickhouse数据表不会写入到磁盘，机器重启即数据丢失。