Query runs from Console but not from Client - Memory issue ?
I am new to vertica (7.2.x) and working on POC. When we tried to run Query from vertica Console it comes immediately but when we run the same query from the client tools like SQLuirrel SQL Client Version 3.7 or Aquastudio it throws some memory exception after timeout.
We also tried to change resource pool , session settings but nothing is working. It looks like client doesn’t have enough memory to render output back to client screen so we tried to increase memory on client side but still its same issue. We are now clueless so your help will be appreciated.
Error: [Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 1280241, Free = 25856 (Limit = 4476676, Used = 4450820) (queueing threshold)]