概述
在使用ck清洗数据的时候报内存不足:
Progress: 1.83 billion rows, 85.31 GB (68.80 million rows/s., 3.21 GB/s.) 6%Received exception from server:
Code: 241. DB::Exception: Received from localhost:9000, 127.0.0.1.
DB::Exception: Memory limit (for query) exceeded: would use 9.31 GiB (attempt to allocate chunk of 1048576 bytes), maximum: 9.31 GiB:
(while reading column hits):
默认情况下,ClickHouse会限制group by使用的内存量,默认设置为9.31GB,由users.xml文件中max_memory_usage参数控制,可以分别为每个用户设置不同的内存量。
解决办法
-
临时设置
在运行任务前增加配置,当然前提是你有足够的内存。增加这个参数:SET max_memory_usage = 128000000000; #128G