Clickhouse 中的最大表列数

本文介绍了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

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