Clickhouse 中的最大表列数 [英] Maximum number of table columns in Clickhouse

问题描述

我尝试测试边界并注意到如果表中有 5K 列，即使我尝试仅插入 2 列值，我也会得到从 127.0.0.1:9000 接收.DB::Exception: 超出内存限制(用于查询):将使用 9.31 GiB

I've tried to test the boundries and noticed that if I have 5K columns in the table, even when I try to insert only 2 columns values, I get a Received from 127.0.0.1:9000. DB::Exception: Memory limit (for query) exceeded: would use 9.31 GiB

有没有办法处理大量的指标?

is there a way to handle extremely large number of metrics?

单个表中列数的实际限制是多少?

what's the actual limit for the number of columns in a single table?

推荐答案

我认为没有限制(除了您的硬件限制).尝试增加查询的最大内存使用量

I think the limit is none (except your hardware limitations). Try to increase max memory usage for your query

https://clickhouse.yandex/docs/en/operations/设置/query_complexity/#settings_max_memory_usage

这篇关于Clickhouse 中的最大表列数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！