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
