需求：項目中要使用ClickHouse做數據庫。
具體實現：
1，在pom.xml中添加clickhouse依賴

<!-- https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc -->
<dependency><groupId>com.clickhouse</groupId><artifactId>clickhouse-jdbc</artifactId><version>0.3.2</version>
</dependency>

2, 配置文件中添加clickhouse的配置屬性：

spring:datasource:clickhouse:driverClassName: ru.yandex.clickhouse.ClickHouseDirverurl: jdbc:clickhouse:IP:端口號/數據庫user: 用戶名password: 密碼#這部分配置用于kerberos認證
clickhouse:security:enabled: trueisMachineUser: false

3，配置Clickhouse連接

@Configuration
public class ClickHouseConfig {@Value(“{spring.datasource.clickhouse.url}”)private String clickhouseUrl;@Value(“{spring.datasource.clickhouse.user}”)private String clickhouseUser;@Value(“{spring.datasource.clickhouse.password}”)private String clickhousePassword;@Value(“{clickhouse.seurity.enabled}”)private Boolean isSecurity;@Value(“{clickhouse.isMachineUser}”)private Boolean isMachineUser;@Beanpublic DataSource dataSource() {ClickHouseProperties clickHouseProperties = new ClickHouseProperties();clickHouseProperties .setSocketTimeout(60000);//下面三行用于開啟kerberos認證if(isSecurity & isMachineUser) {clickHouseProperties.setMachineUser(true);clickHouseProperties.setMachineUserKeytabPath(System.getProperty("user.dir") + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator + "user.keytab");}clickHouseProperties.setSsl(true);clickHouseProperties.setSslMode("none");clickHouseProperties.setUser(clickhouseUser);clickHouseProperties.setPassword(clickhousePassword);ClickHouseDataSource clickHouseDataSource = new ClickHouseDataSource (clickhouseUrl, clickHouseProperties);return clickHouseDataSource;}
}

4,實現具體的Mapper。
其他的操作就跟mysql的操作一致了。
注意：clickhouse跟mysql的SQL語法不一致。