ClickHouse
ClickHouse
RayBreslin
大数据开发、设计企业应用
展开
-
waterdrop将hive导入clickhouse报错:Too many partitions for single INSERT block (more than 100).
一、问题描述使用waterdrop导入数据进入clickhouse,然后日志报错:Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 252, host: 10.252.32.26, port: 8123; Code: 252, e.displayText() = DB::Exception: Too many partitions for single INSERT block原创 2021-12-17 15:31:48 · 1712 阅读 · 0 评论 -
Clickhouse报错:DB::Exception: Cannot lock file /var/lib/clickhouse/status
一、问题描述clickhouse启动后,本身也可以访问没有问题,而且外部也可以访问,但是查看其error日志,发现一直有报错tail -f clickhouse-server/clickhouse-server.err.log结果:2020.10.07 19:05:32.720350 [ 8150 ] {} <Error> Application: DB::Exception: Cannot lock file /var/lib/clickhouse/status. Another se原创 2021-12-07 19:21:51 · 6401 阅读 · 2 评论 -
clickhouse报错:Code: 210. DB::NetException: Connection refused (localhost:9000)
一、问题描述clickhouse客户端登录服务器报错# clickhouse-client -mClickHouse client version 20.8.3.18.Connecting to localhost:9000 as user default.Code: 210. DB::NetException: Connection refused (localhost:9000)关键,这个登录命令之前是可以的,但是,现在却一直是失败的。二、问题原因参考其他文章,发现其他人是因为cli原创 2021-11-19 18:57:27 · 6013 阅读 · 0 评论