Windows下Docker安装ClickHouse

docker search clickHouse

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

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>

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

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

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