#Springboot ClickHouse Daemon
docker pull yandex/clickhouse-server
docker pull yandex/clickhouse-client
docker run -d --name chs.192.168.0.40 --net nexus --ip 192.168.0.40 --ulimit nofile=262144:262144 yandex/clickhouse-server
docker run -it --rm --network nexus --ip 192.168.0.41 --link chs.192.168.0.40:clickhouse-server yandex/clickhouse-client --host clickhouse-server
curl https://clickhouse-datasets.s3.yandex.net/hits/tsv/hits_v1.tsv.xz | unxz --threads=`nproc` > hits_v1.tsv
curl https://clickhouse-datasets.s3.yandex.net/visits/tsv/visits_v1.tsv.xz | unxz --threads=`nproc` > visits_v1.tsv
docker cp ./hits_v1.tsv chs.192.168.0.40:/tmp
docker cp ./visits_v1.tsv chs.192.168.0.40:/tmp
clickhouse-client --query "CREATE DATABASE IF NOT EXISTS tutorial"
Flow the guide in the tutorial to create db and initialize data
https://clickhouse.tech/docs/en/getting_started/tutorial/
docker build -t clickhouse-daemon .
docker run -it --rm -p 8080:8080 -d clickhouse-daemon
http://localhost:32773/query?sql=SELECT COUNT(*) FROM tutorial.hits_v1
SELECT COUNT(*) FROM tutorial.hits_v1
SELECT COUNT(*) FROM tutorial.visits_v1
SELECT
StartURL AS URL,
AVG(Duration) AS AvgDuration
FROM tutorial.visits_v1
WHERE StartDate BETWEEN '2014-03-23' AND '2014-03-30'
GROUP BY URL
ORDER BY AvgDuration DESC
LIMIT 10
CREATE DATABASE IF NOT EXISTS tutorial;
CREATE TABLE tutorial.table_a (
`id` UInt64,
`dbName` String,
`tableName` String,
`name` UInt8,
`desc` String
)ENGINE = MergeTree()ORDER BY (intHash32(id))SAMPLE BY intHash32(id)SETTINGS index_granularity = 8192;
CREATE TABLE tutorial.table_b (
`id` UInt64,
`dbName` String,
`tableName` String,
`name` UInt8,
`desc` String
)ENGINE = MergeTree()ORDER BY (intHash32(id))SAMPLE BY intHash32(id)SETTINGS index_granularity = 8192;
CREATE TABLE tutorial.table_c (
`id` UInt64,
`dbName` String,
`tableName` String,
`name` UInt8,
`desc` String
)ENGINE = MergeTree()ORDER BY (intHash32(id))SAMPLE BY intHash32(id)SETTINGS index_granularity = 8192