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