使用
- 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)
共同入门大数据
