自学Clickhouse时,两个表相交后后排序报内存不够,应该怎么处理呢? set max_memory_usage=2000000000 配置最大内存使用2G也不行
SELECT L.URLDomain, L.RefererDomain FROM tutorial.hits_v1 AS L ALL INNER JOIN tutorial.hits_v2 AS R ON L.UserID = R.UserID ORDER BY L.UserID ASC LIMIT 10
Query id: 187f2f62-ef29-4e33-9c0d-5cd4d449fbd6
→ Progress: 8.92 million rows, 73.54 MB (27.59 million rows/s., 227.40 MB/s.) 49% Received exception from server (version 20.12.3): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for query) exceeded: would use 2.08 GiB (attempt to allocate chunk of 268435456 bytes), maximum: 1.86 GiB.
0 rows in set. Elapsed: 0.736 sec. Processed 8.92 million rows, 73.54 MB (12.13 million rows/s., 99.93 MB/s.)