I tried to return 13 million rows and i see below error.
ERROR: TEIID31261 Max estimated size 53,219,612,589 for a single operation/table id 120 has been exceeded. The server may need to increase the amount of disk or memory available, or decrease the number of max active plans.; Error fetching next row .
i have increased jvm and reduced max active plan to 1. I have tried max active plan from 20 to 1 but none worked. we also increased cpu and that helped too.
I have set Max Active Plans = 1 and increased JVM to 26GB however I am still getting this error. While monitoring via JConsole I can see that the data returned seems to be batching but not sure what is causing the failure. Are there any buffer memory settings that need to be set? Basically, my query is returning 92 columns with 14 million rows.
Any help will be very much appreciated. Thank you in advance.