Windows下Docker安装ClickHouse

小灰灰 2022-11-26 07:46 432阅读 0赞

### 1、查询ClickHouse镜像 ###

docker search clickHouse

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70]

### 2、 拉取镜像 ###

docker pull yandex/clickhouse-client
    docker pull yandex/clickhouse-server

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 1]

### 3、启动server端容器 ###

D盘下新建数据文件目录clickhouse

D:\Users\chengyq>docker run -d --name clickhouse-server --ulimit nofile=262144:262144 --volume=//D/clickhouse:/var/lib/clickhouse yandex/clickhouse-server
    c1760937eac6d9838fa356daa30a03acd16c7c7709eeb9c6677b18b98ff19abc
    
    D:\Users\chengyq>

单击”Share it“按钮  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 2]

### 4、连接clickhouse-server ###

docker run -it --rm --link clickhouse-server:clickhouse-server yandex/clickhouse-client --host clickhouse-server

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 3]

### 5、简单应用 ###

#### 5.1 数据库操作 ####

c1760937eac6 :) show databases;
    
    SHOW DATABASES
    
    ┌─name───────────────────────────┐
    │ _temporary_and_external_tables │
    │ default                        │
    │ system                         │
    └────────────────────────────────┘
    
    3 rows in set. Elapsed: 0.055 sec.
    
    c1760937eac6 :) create database test;
    
    CREATE DATABASE test
    
    Ok.
    
    0 rows in set. Elapsed: 0.022 sec.
    
    c1760937eac6 :)

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 4]

#### 5.2 表操作 ####

c1760937eac6 :) create table T_test(id Int8,name String) engine=TinyLog;
    
    CREATE TABLE T_test
    (
        `id` Int8,
        `name` String
    )
    ENGINE = TinyLog
    
    Ok.
    
    0 rows in set. Elapsed: 0.016 sec.
    
    c1760937eac6 :) insert into T_test values(1,'hadron');
    
    INSERT INTO T_test VALUES
    
    Ok.
    
    1 rows in set. Elapsed: 0.051 sec.
    
    c1760937eac6 :) select * from T_test;
    
    SELECT *
    FROM T_test
    
    ┌─id─┬─name───┐
    │  1 │ hadron │
    └────┴────────┘
    
    1 rows in set. Elapsed: 0.026 sec.
    
    c1760937eac6 :)

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70]: /images/20221124/ee3a712b340246b9b72b0ef84a512cce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 1]: /images/20221124/19d274eae07b4625ad853cfec7724068.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 2]: /images/20221124/0e5f225d42d448c5a4a86bfa274533fc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 3]: /images/20221124/1e4986f32d564f068dc2771518a6d6c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 4]: /images/20221124/e74341dded984616b148d360b6a54fe4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5neXVxaWFuZw_size_16_color_FFFFFF_t_70 5]: /images/20221124/20cfa425f78f4fa99f0a1618c0f001d6.png