search

housepower / ckman

This is a tool which used to manage and monitor ClickHouse database
Apache License 2.0
429 stars 108 forks source link

x86 ckman-v3.1.0 版本 表管理页面报错 #294

Open Le6688 opened 3 months ago

Le6688 commented 3 months ago

报错sql

SELECT table, uniqExact(partition) AS partitions, count(*) AS parts, sum(data_compressed_bytes) AS compressed, sum(data_uncompressed_bytes) AS uncompressed, sum(rows) AS rows, database FROM cluster('{cluster}', system.parts) WHERE (database in ('data_test')) AND (active = '1') GROUP BY table, database;

DB::Exception: No macro 'cluster' in config while processing substitutions in '{cluster}' at '1' or macro is not supported here. (NO_ELEMENTS_IN_CONFIG)

ck里面是不是这样查询集群名 我的ck 版本时 ClickHouse版本: 23.12.3.40

YenchangChan commented 3 months ago

导入的集群需要增加一个cluster的宏

likorlis commented 3 months ago

我也是，我是创建的集群 但是报错这个 数据查询失败: : clickhouse [execute]:: 500 code: Code: 170, e.displayText() = DB::Exception: Requested cluster '{cluster}' not found (version 21.8.15.7)

YenchangChan commented 3 months ago

我也是，我是创建的集群 但是报错这个 数据查询失败: : clickhouse [execute]:: 500 code: Code: 170, e.displayText() = DB::Exception: Requested cluster '{cluster}' not found (version 21.8.15.7)

ckman 创建的集群会自己增加这个macro的，查一下 /etc/clickhouse-server/config.d/host.xml

likorlis commented 3 months ago

我也是，我是创建的集群 但是报错这个 数据查询失败: : clickhouse [execute]:: 500 code: Code: 170, e.displayText() = DB::Exception: Requested cluster '{cluster}' not found (version 21.8.15.7)

ckman 创建的集群会自己增加这个macro的，查一下 /etc/clickhouse-server/config.d/host.xml

检查了，host.xml里面是有一个macro的 是不是和填了default为用户名有关，我创建时找不到能更改Cluster Username的地方