I am getting below error while executing a query in vertica.
Error: [Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool sysquery [Timedout waiting for resource request:
General cannot supply required overflow resources: Memory(KB) Exceeded: Requested = 32290, Free = 0 (Limit = 25556576, Used = 25556576) (queueing threshold)]
I have done some steps to resolve this but that didn't help.
1.alter RESOURCE POOL general PLANNEDCONCURRENCY 16
2.alter RESOURCE POOL sysquery PLANNEDCONCURRENCY 10
3.alter RESOURCE POOL general maxmemorysize '20GB'
4.ALTER USER verticadba MEMORYCAP '10G';
Note : The system configuration is 32 GB RAM & 8 core.