springboot集成clickhouse

一、安装

我是安装在linux上, 步骤如下。

1、添加yum源

下面展示一些 内联代码片。

 yum-config-manager --add-repo http://repo.red-soft.biz/repos/clickhouse/repo/clickhouse-el6.repo 
 

2、安装

 yum install clickhouse-server clickhouse-client clickhouse-server-common clickhouse-compressor 

3、启动服务

 /etc/init.d/clickhouse-server start 
 

4、登录测试

[root@VM_XXX_229_centos ~/tool]# clickhouse-client 
ClickHouse client version 20.8.3.18.
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.8.3 revision 54438.

VM_XXX_229_centos :) 

二、springboot集成

1、初始化

• 工程
  使用 https://start.spring.io/ 快速生成一个脚手架工程
• db

CREATE TABLE cs_user_info (
                              `id` UInt64,
                              `user_name` String,
                              `pass_word` String,
                              `phone` String,
                              `email` String,
                              `create_day` Date DEFAULT CAST(now(),'Date')
) ENGINE = MergeTree(create_day, intHash32(id), 8192)

INSERT INTO cs_user_info
(id,user_name,pass_word,phone,email)
VALUES
(1,'cicada','123','13923456789','cicada@com'),
(2,'smile','234','13922226789','smile@com'),
(3,'spring','345','13966666789','spring@com');

2、pom 依赖

		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.38</version>
		</dependency>

		<!--升级 druid驱动 1.1.10支持ClickHouse-->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.13</version>
		</dependency