mac上无法裸部署click house,需要借助docker安装click house。
# 客户端
docker pull yandex/clickhouse-client
# 服务端
docker pull yandex/clickhouse-server
# 创建用于clickhouse的网络给docker用
docker network create ck_net
# 查看网络
docker network ls
# 运行
docker run -d --name clickhouse-server --network=ck_net --ulimit nofile=262144:262144 --volume=/Users/${username}/Documents/workspace/software/clickhouse-database:/var/lib/clickhouse yandex/clickhouse-server
docker exec -it clickhouse-server /bin/bash
clickhouse-client
show databases;
CREATE TABLE default.user_table(id UInt16, name String, age UInt16 ) ENGINE = TinyLog();
SELECT * FROM default.user_table;
# 宿主机连接docker中的clickhouse
docker cp clickhouse-server:/etc/clickhouse-server/ /Users/woxingwosu0100/clickhouse/etc
# 修改配置 65行 注释去掉<listen_host>::</listen_host>
vim /etc/clickhouse-server/config.xml
docker run -d --name clickhouse-server --network=ck_net --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 --volume=/Users/${username}/Documents/workspace/software/clickhouse-database:/var/lib/clickhouse -v /Users/${username}/Documents/workspace/software/clickhouse/etc/config.xml:/etc/clickhouse-server/config.xml yandex/clickhouse-server