clickhouse修改時區

clickhouse時區設定

sudo vim /etc/clickhouse-server/config.xml

<timezone>Asia/Shanghai</timezone>

儲存，重新開機服務

sudo service clickhouse-server restart

測試：

bigdata@server01:~$ clickhouse-client

ClickHouse client version 18.14.13.

Connecting to localhost:9000.

Connected to ClickHouse server version 18.14.13 revision 54409.

server01 :) select Now();

SELECT Now()

┌───────────────Now()─┐

│ 2018-11-09 14:08:21 │

└─────────────────────┘

1 rows in set. Elapsed: 0.010 sec.