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..