# 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