Error: query exceeded local memory limit of xxxx GB

Symptom

While running a query in Presto an error is returned which contains the following phrase:

query exceeded local memory limit of xxxx GB

Cause

This error can occur because the amount of memory allocated to the query is less than required for execution

Action

Increase the value of query.max-memory-per-node equal to 40% of slave instance memory at the cluster level and retry the query. 

Have more questions? Submit a request

Comments

Powered by Zendesk