Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

PRESTO Memory issue

avatar
Contributor

Dear Members,

 

I am plagued with Presto errors . need help in configuring paramters.


[Teradata][Presto](100050) Query failed: Query exceeded max user memory size of 250GB. [SQL State=HY000, DB Errorcode=100050]

 

repeatedly, and no matter how much we increase Presto memory per job , like query.max-memory=200GB to query.max-memory=220GB and tried uptil 400 GB. the queries keep failing with the above errors, Could you please provide guidance on what exactly should be the tuning parameters to make these jobs run smoothly.. FYI - these daily jobs  were running fine until the recent Presto upgrade we made to 0.208 version, some tuning parameters are missing.. 

 

Could you please suggest the recommended steps in order to tune presto to run smoothly.. This is a critical issue we are trying to figure out a solution.. @jsensharma @nsabharwal and community folks please help..

2 REPLIES 2

avatar

@vendevu While we welcome your question, you would be much more likely to get a prompt and useful response by posting this to the relevant Teradata community

 

 

Bill Brooks, Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
Contributor

Hi Bill, This issue has nothing to do with Teradata , it’s more Presto related..

Thank you for your support..