You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by "Yuntao.Wu" <wu...@163.com> on 2022/08/11 02:43:46 UTC

when exectue SQL BE node encounter OMM

when i execute a SQL like this, i get the following problem:
SQL:
select version,b,c
from (select version from A)
left join (select event_id from B union select B)
left join C
left join D;


ERROR:
1105 - errCode = 2, detailMessage = PartitionedHashTableCtx::ExprValuesCache failed to allocate 56448 bytes.ExecNode:Exprs:AGGREGATION_NODE (id=24):99dddc178a8b4ff6-aa61c10715436305 could not allocate 55.12 KB without exceeding limit.Error occurred on backend 10.10.0.1 by fragment