使用

• clickhouse server 启动

./clickHouse server --config=/apps/clickhouse/config.xml

• clickhouse client 启动

./clickHouse client -h 127.0.0.1 -u zhangsan --password 123456

异常

异常一

2021.11.18 11:39:28.062478 [ 546636 ] {} <Warning> Application: Cannot set max number of file descriptors to 4294967295. Try to specify max_open_files according to your system limits. error: Invalid argument

解决：

sudo launchctl limit maxfiles 65536 200000

参考：https://wilsonmar.github.io/maximum-limits/

异常二

2021.11.18 11:24:16.142384 [ 533636 ] {} <Warning> Access(local directory): File /Users/home/apps/clickhouse/var/lib/clickhouse/access/ledzeppelin/users.list doesn't exist
2021.11.18 11:24:16.142418 [ 533636 ] {} <Warning> Access(local directory): Recovering lists in directory /Users/home/apps/clickhouse/var/lib/clickhouse/access/ledzeppelin/

找不到文件夹，mkdir -p 创建

异常三

scala代码jdbc连接clickhouse。

ClickHouse exception, code: 1002, host: 127.0.0.1, port: 8123; Code: 516. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name. (AUTHENTICATION_FAILED) (version 21.9.1.7770)

ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 127.0.0.1, port: 8123; Code: 516. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name. (AUTHENTICATION_FAILED) (version 21.9.1.7770)

共同入门大数据