You can translate the question and the replies:

How to limit the records while creating the derived view in denodo with Hive as the source

Hi Team, I have a limitation from Hive source that more than 1 GB data cannot be fetched from Denodo. If the data is more than 1 GB will throw error in Denodo saying more than 1 GB data cannot be retrieved. Now I need to create a derived view on top of base view setting limitation below 1 GB. The limit function is working only for select statement and cannot use for create view as below for example: Create or replace view <<derived_view>> as select * from <<base_view>> limit 10000 The other approach if I use temporary column with identity as rownum and can create the derived view with rownum<=10000 but the problem I am getting the function rownum cannot be delegated to the database. Please help me how to restrict the records below 1 GB without delegation and able to create the derived view. Can anyone please reply to my question.
user
04-05-2018 08:05:39 -0400

1 Answer

Hi, What I would do is [to create a base view from query](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/jdbc_sources#creating-base-views-from-sql-queries) so you could use the limit. However, take into account that 10000 rows could occupy more than 1Gb, so you could have the problem again. Finally, regarding the rownum, although it can't be delegated to the source, it isn't a problem because Denodo retrieves the results in an asynchronous way. Hope this helps!
Denodo Team
07-05-2018 08:17:13 -0400
You must sign in to add an answer. If you do not have an account, you can register here