Request exceeded high limit : error in vertica
There is a query (report) which used to run fine several days ago is now failing due to this reason "Request exceeded high limit" .
I believe it is asking for more resources (memory) and getting failed.
I have checked that data has not increased by then.
Stats are also fine.
Below are the details of the resource_pool to which user is assigned and running the report.
(memorysize, maxmemorysize, executionparallelism, priority, runtimepriority, runtimeprioritythreshold, queuetimeout, plannedconcurrency, maxconcurrency, runtimecap, singleinitiator) VALUES
('0%', '', 'AUTO', 11, 'LOW', 2, 1800, 'AUTO', NULL, NULL, 'f')
What should be my approach on this?
Shall i run DBD on that?