Error executing view: Memory usage restrictions prevent the execution of the query

I am using nearly 30 views and in that i have 3 unions,when i execute the last view I am getting below error: Finished with error: Error executing view: Memory usage restrictions prevent the execution of the query Please help me to resolve this issue
user
11-07-2019 10:47:19 -0400

1 Answer

Hi, The 'Error executing view: Memory usage restrictions prevent the execution of the query' occurs when the executing query consumes more memory than the configured memory limit. To resolve this, I would open the Memory Usage tab by navigating to Administration > Server Configuration dialog for increasing the value of “Maximum query size (MB)” parameter and execute the view again. I would refer to the section [Configuring the Memory Usage and Swapping Policy](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#configuring-the-memory-usage-and-swapping-policy) of Virtual DataPort Administration guide for more information on configuring memory usage. You can also refer to the community Q&A which answers the similar issue: [Get rows with a minimum value from a column](https://community.denodo.com/answers/question/details?questionId=9060g000000XeEsAAK&title=Get+rows+with+a+minimum+value+from+a+column) Hope this helps!
Denodo Team
12-07-2019 02:58:39 -0400
You must sign in to add an answer. If you do not have an account, you can register here