# clickhouse入门
# 安装
docker run -d \
-p 8123:8123 \
-p 9000:9000 \
--restart=always \
--name clickhouse-server \
-v /etc/localtime:/etc/localtime \
-v /etc/timezone:/etc/timezone \
-v /home/docker/conf/clickhouse-server:/etc/clickhouse-server \
-v /home/docker/data/clickhouse:/var/lib/clickhouse \
-v /home/docker/logs/clickhouse-server:/var/log/clickhouse-server \
--ulimit nofile=262144:262144 \
yandex/clickhouse-server:latest \
8123是http方式访问
9000是tcp方式访问
# 命令行访问
clickhouse-client --user default --password 123456
# sql语句(example)
show databases;
show tables from xxxdb;
describe table xxxtb;
show create table xxxtb;
select * from xxxtb limit 100;
# yaml配置
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
clickhouse:
driver-class-name: ru.yandex.clickhouse.ClickHouseDriver
url: jdbc:clickhouse://192.168.100.202:8123/default
username: default
password: 123456
initial-size: 10
max-active: 100
min-idle: 10
max-wait: 6000