I'm facing this error while executing a query. can you help me?
If you don't need to consider the concurrency, please try to run that query with concurrency = 1;
=> CREATE RESOURCE POOL trial PLANNEDCONCURRENCY 1 MAXCONCURRENCY 1;
=> SET SESSION RESOURCE POOL TO trial;
=> <run the query>
If you still hit the same error, you may need to do the query optimization to reduce the necessary memory.
Thank you for your support. I will try it.
Setting plannedconcurrency and maxconcurrency to 1 isn't really a good solution, except maybe for a resource pool that is only using a small percentage of the overall memory.
Better to make sure that you're following best practices regarding statistics and joins involving larger tables.
See this thread for some existing discussion on this topic: