文章目录
docker安装clickhouse并data grip连接
docker安装clickhouse
拉取clickhouse镜像
docker pull yandex/clickhouse-server
启动server端
docker run -d --name clickhouse-server --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 yandex/clickhouse-server
进入容器
docker exec -it clickhouse-server /bin/bash
进入clickhouse命令行
clickhouse-client
查看数据库
show databases
选择数据库
use default
显示表
show tables
创建表
CREATE TABLE IF NOT EXISTS test_tables
(
branch String COMMENT '分支',
ten_id Nullable(String) COMMENT '租户Id',
sys_id Nullable(String) COMMENT '系统Id'
) ENGINE = MergeTree() PARTITION BY branch
ORDER BY (branch)
PRIMARY KEY (branch) SETTINGS index_granularity=8192;
插入数据
insert into test_tables (branch,ten_id,sys_id)
values('test','租户1','666');
查询
select * from test_tables;
data grip连接clickhouse
修改配置
vim /etc/clickhouse-server/config.xml
如出现:vim: command not found
解决方法:
apt-get update
apt-get install vim
如图下:<listen_host>::</listen_host> 添加到指定位置
重启容器
systemctl restart clickhouse-server.service
保存后重启服务,再重新用data grip连接可成功