Presto query error : Query exceeded max memory size of 148 GB

Presto
Teradata Employee

Re: Presto query error : Query exceeded max memory size of 148 GB

Hi,

 

I am not sure if there is a mechanism for specifying Presto session variables from TD when foreign server is used.

Though, even if that is possible you cannot increase memory limit in Presto using session variable on per-query basis.

Session variable only allow you to decrease the limit.

 

So only option you have is to change configuration of Presto cluster and restart it.