We are getting below error, can any one please help me how i can debug the problem and identify root course of error Presto
Query Error: Query exceeded max memory size of 50GB, Also i know the simple approach is to increase the ram
allocation from 50GB but there are some concerns 1. How we can come to know what is optimum size of memory/ram allocation. 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. 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.) Thanks, Bhupesh Khanna
... View more
