clickhouse with docker-compose running

How to run

docker-compose up -d

access address

http interface http://hostip:8123
for native client connect port 9000

how to Connect server

with docker client

docker run -it yandex/clickhouse-client --host ${serverip|hostip}

import data

• create table

CREATE TABLE wikistat
(
    project String,
    subproject String,
    hits UInt64,
    size UInt64
) ENGINE = Log;

• insert data

docker run -i yandex/clickhouse-client  --format_csv_delimiter="|" --host ${serverhost} --query="INSERT INTO d
efault.wikistat3 FORMAT CSV" < ./data/info.csv

• select result

use ui tools HouseOps https://github.com/HouseOps/HouseOps

select * from default.wikistat;

some images