ClickHouse docker compose容器启动

docker compose

目录结构

├── conf
│   ├── config.xml
│   └── users.xml
└── docker-compose.yml

docker-compose.yml

#version: '3.8'

services:
  clickhouse:
    image: clickhouse/clickhouse-server:latest
    container_name: ck
    ports:
      - "8123:8123"
      - "9000:9000"
    environment:
      - CLICKHOUSE_USER=root
      - CLICKHOUSE_PASSWORD=123456
    volumes:
      - ./conf/config.xml:/etc/clickhouse-server/config.xml
      - ./conf/users.xml:/etc/clickhouse-server/users.xml
      - ./data:/var/lib/clickhouse
    networks:
      - clickhouse
    restart: always

networks:
  clickhouse:
    driver: bridge

conf/config.xml

config.xml

conf/users.xml

users.xml

启动

docker compose up -d

访问

浏览器打开：http://localhost:8123/

选择Web SQL UI

执行SQL

1. 输入密码为上面配置的：123456

2. 输入SQL

3. 点击Run