https://community.cloudera.com/t5/Support-Questions/Urgent-Presto-Query-Error-Query-exceeded-max-memory-size-of/m-p/167418#M129750 <P>We are getting below error, can any one please help me how i can debug the problem and identify root course of error </P><P>Presto Query Error: Query exceeded max memory size of 50GB,</P><P>Also i know the simple approach is to increase the ram allocation from 50GB but there are some concerns</P><P>1. How we can come to know what is optimum size of memory/ram allocation.</P><P>2. Suppose even if we increase it to 100GB then there is no guarantee that the user will not receive the error again of out of memory.</P><P>3. Is there any way to restrict user from launching such a huge query or any other preventive approach. OR (limit to end user that we cannot process any query which require more than 100GB or 150GB.)</P><P>Thanks,</P><P>Bhupesh Khanna </P> Thu, 09 Feb 2017 14:37:39 GMT bkhanna 2017-02-09T14:37:39Z