Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

PRESTO Memory issue

PRESTO Memory issue

Explorer

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
Highlighted

Re: PRESTO Memory issue

Community Manager

@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 Manager
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.
Highlighted

Re: PRESTO Memory issue

Explorer

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

Thank you for your support.. 

Don't have an account?
Coming from Hortonworks? Activate your account here