一、clickhouse表的创建
客户端连接工具建议使用:DBeaver
CREATE TABLE IF NOT EXISTS temp.xxxx_user_behaviors_url_log (
`transfer_date` Date,
`record_time` String,
`user` String,
`group` String,
`host_ip` String,
`dst_ip` String,
`serv` String,
`app` String,
`site` String,
`tm_type` String,
`net_action` String,
`url` String,
`dns` String,
`title` String,
`snapshot` String
) ENGINE = MergeTree() PARTITION BY toYYYYMMDD(transfer_date) ORDER BY transfer_date SETTINGS index_granularity = 8192
二、mybatis、clickhouse相关maven依赖
<dependency>
<groupId>ru.yandex.clickhouse</groupId>
<artifactId