docker安装clickhouse并data grip连接

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连接可成功