Please provide the followings so that we I can help you:

1. Doris version
2. You cluster info, cpu, mem, number of BE/FE nodes, etc.
3. you can also try analyzing the table before query, see: 
https://doris.apache.org/docs/query-acceleration/statistics







--

Best Regards
Mingyu Chen

Email:
morning...@apache.org





At 2023-12-12 18:39:11, "Phadke, Trushna" 
<trushna.dipak.pa...@accenture.com.INVALID> wrote:
>Hello Team,
>
>Good afternoon. I am Trushna, and for our team, I am doing a POC on Apache 
>Doris, we are kind of checking if it provides us expected performance.
>During this POC , I pushed some of the data(141 GB) to Doris and was trying to 
>execute one complex query, where I am getting below error:
>
>Execution failed: Error Failed to execute sql: java.sql.SQLException: errCode 
>= 2, detailMessage = (172.18.2.11)[CANCELLED]Process has no memory available, 
>cancel top memory usage query: query memory tracker 
><Query#Id=fbae8e88030b43f9-95bac64a06eb90bd> consumption 10.01 GB, backend 
>172.18.2.11 process memory used 12.11 GB exceed limit 12.45 GB or sys mem 
>available 1.52 GB less than low water mark 1.56 GB. Execute again after enough 
>memory, details see be.INFO.
>
>
>On searching this, I got few suggestions to put some parameters in be.conf and 
>fe.config file (parameters like be_mem_limit, be_low_water_mark), which I did 
>try, but I am still stuck at same issue.
>Can you guys help me to understand which config parameters can settle this 
>issue,  or any other method you suggest, Please guide me.
>
>
>Thank you,
>Trushna Phadke.
>
>
>
>
>
>________________________________
>
>This message is for the designated recipient only and may contain privileged, 
>proprietary, or otherwise confidential information. If you have received it in 
>error, please notify the sender immediately and delete the original. Any other 
>use of the e-mail by you is prohibited. Where allowed by local law, electronic 
>communications with Accenture and its affiliates, including e-mail and instant 
>messaging (including content), may be scanned by our systems for the purposes 
>of information security, AI-powered support capabilities, and assessment of 
>internal compliance with Accenture policy. Your privacy is important to us. 
>Accenture uses your personal data only in compliance with data protection 
>laws. For further information on how Accenture processes your personal data, 
>please see our privacy statement at 
>https://www.accenture.com/us-en/privacy-policy.
>______________________________________________________________________________________
>
>www.accenture.com

Reply via email to