You can translate the question and the replies:

Maximum number of fields

Hello what is the maximum number of fields that allows a view in denodo?
user
22-03-2018 12:11:31 -0400

4 Answers

Hi, Denodo Platform does not have any limitations for columns to be defined in a view and it depends on the underlying data sources. Each underlying sources will have a specific column limit while creating a view and that will be propagated to Virtual DataPort. Hope this helps.
Denodo Team
27-03-2018 08:29:25 -0400
but adding the 230 aggreated rows its giving the memory issue
user
08-09-2020 23:56:43 -0400
Hi, In order to overcome the memory issues, I would review the "JVM Configuration" section of the [Denodo Admin and Development Best Practices](https://community.denodo.com/kb/view/document/Denodo%20Admin%20and%20Development%20Best%20Practices?category=Best+practices) article. Based on that, I would increase the memory of the Virtual DataPort Server or the Virtual DataPort Administration Tool. Besides, if you have memory issue with the query then I recommend you to refer to the following documentations * [Memory Management](https://community.denodo.com/docs/html/browse/latest/vdp/administration/memory_management/memory_management#memory-management) * [Configuring the Memory Usage and Swapping Policy](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_configuration/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#configuring-the-memory-usage-and-swapping-policy) Hope this helps!
Denodo Team
22-09-2020 08:32:40 -0400
Hello, Yes Denodo Platform does not have any limitations for columns to be defined in a view. If you want to create View then I added detail s below. A join view executes the relational algebra operation JOIN on a series of input views. These views can belong to different databases. To create a join view, click Join on the File > New menu or, right-click the Server Explorer and click Join on the menu New. For more information please go through this link: [https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_derived_views/creating_join_views](http://) I hope this link will help you alot. Thanks & Regards, Anita
user
 Edited on: 06-10-2020 07:16:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here