A Presto query fails with an 'Out of memory' error in watsonx.data. What is the most appropriate first response?
Select an answer to reveal the explanation.
Short Explanation and Infographic
OOM errors in Presto are typically caused by queries that generate large intermediate result sets — often from data skew; large hash joins; or missing partition filters; the fix is query optimization or engine resizing.
Full explanation below image
Full Explanation
OOM errors in Presto are typically caused by queries that generate large intermediate result sets — often from data skew; large hash joins; or missing partition filters; the fix is query optimization or engine resizing. The incorrect options ("Increase the object storage bucket size to provide more I/O bandwidth", "Convert the underlying data files from Parquet to ORC format", "Add more schemas to the metastore to distribute metadata load") are distractors that don't fully capture the concept described.