Windows下Docker安装ClickHouse

1、查询ClickHouse镜像

docker search clickHouse

2、 拉取镜像

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

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“按钮

4、连接clickhouse-server

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

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 :)

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 :)