FINAL DEDUPLICATE
>
> Query id: e96deea6-b91d-4814-9267-9b37f84f30fc
>
>
> Timeout exceeded while receiving data from server. Waited for 300 seconds, timeout is 300 seconds.
> Cancelling query.
> Query was cancelled.
>
> 0 rows in set. Elapsed: 365.841 sec.
>
> Received exception from server (version 22.2.3):
> Code: 241. DB::Exception: Received from 23.88.:9000. DB::Exception: Memory limit (for query) exceeded: would use 12.13 GiB (attempt to allocate chunk of 6442972898 bytes), maximum: 9.31 GiB. (MEMORY_LIMIT_EXCEEDED)
Попробуйте не всю таблицу, а по партициям
или добавить в конце запроса ... SETTINGS max_memory_usage = побольше памяти
Тогда не надо вроде в конфиг лезть ?
Спасибо по пробуем
Обсуждают сегодня