Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Le6688 opened this issue May 16, 2024 · 4 comments
Open

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

Le6688 opened this issue May 16, 2024 · 4 comments

Comments

@Le6688
Copy link

Le6688 commented May 16, 2024

报错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
Copy link
Collaborator

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

@likorlis
Copy link

likorlis commented May 20, 2024

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

@YenchangChan
Copy link
Collaborator

我也是,我是创建的集群 但是报错这个 数据查询失败: : 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
Copy link

likorlis commented May 21, 2024

我也是,我是创建的集群 但是报错这个 数据查询失败: : 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的地方

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants