解决clickhouse时间相差8个小时的问题

1. docker容器跟宿主机操作系统时间保持一致

docker rm -f clickhouse-server&&docker run -d -p 8123:8123 -p 9000:9000 -e CLICKHOUSE_PASSWORD=123456 -e CLICKHOUSE_USER=default  -v /newData3T/docker_data/clickhouse/data/clickhouse/:/var/lib/clickhouse -v /newData3T/docker_data/clickhouse/etc/clickhouse-server/:/etc/clickhouse-server/ -v /etc/localtime:/etc/localtime -v /newData3T/docker_data/clickhouse/log/:/var/log/clickhouse-server --privileged=true --name clickhouse-server --ulimit nofile=262144:262144 clickhouse/clickhouse-server

1. 使用DBeaver时，启用server_time_zone

3、jdbc的url设置serverTimezone=GMT+8

jdbc:clickhouse://192.168.4.199:8123/rural_house_manager?socket_timeout=300000&serverTimezone=GMT+8