Latest Activity


Error Saving View When Joining to Same Table Multiple Times

I'm trying to create a derived view using the Denodo Design Studio web app. Let's say I have two views: DERIVED_VIEW and BASE_VIEW. These two views have a one-to-many relationship (DV-to-BV). I'm trying to create a new derived view which uses DV as the...

derived view join


Aggregation of derived views delegating search methods to base view

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation


Same Query Returns different number of records in Baseview and Derivedview

Hello Team, I have created 2 baseview(bv_studies, bv_results) of dfferent sources in Denodo. After that, I have created one derived view(dv_final) from these baseview with Inner Join. I am passing 2 parameters to bv_studies. Now the problem is, while ...

Quary execution Baseview derived view


Associations Vs Joins

I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Please explain in ...

association derived view aasociations vs joins


Simulating an Update statement in Denodo

How do we simulate below statement in a derived view in Denodo update fw_denodo_table a set a.column1 = b.column2 from denodo_table2 b where a.column2 = b.column3 and a.column5 = b.column6 and a.year=2019; Please advise

joins update derived view


joining multiple base view error via custom wrapper parquet file in S3.

Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...

S3 parquet file DENODO AWS S3 derived view custom wrapper


Create a Selection View and get only the first 2 records

Hello I want to create a selection view of a derived view that has a column "date" (localdate), and in this selection view I waht to order by date desc, and I only need the first 2 records. How can I do that in denodo? I have this record: 2019-12-01 ...

select derived view


To add a parameter to a derived view

I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...

Parameter View Parameter entry derived view


Delegate SQL Sentence as Sub Query not passing to source

Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...

subquery Execution plans Stored Procedure derived view


How to query on different View?

I have 3 derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denodo ??

REST Webservice derived view Interface