Latest Activity


On base views created from query with parameters-how can we pass the parameters from a subquery in where statement

I have created a base view from query which contains parameters that I need to pass in order to get the result set. Base view name is bv_root_table. Parameter for the base view that is required that we pass is AccountID field. I am trying to execute a...

Invalid query in create base view from query View without search methods baseview created from query Parameter Subquery


Subqueries in the WHERE Clause of the Query unable to find the table

Hello, I have added multiple tables in the view and joined all those tables. In the WHERE CONDITIONS, I have written something similar to this: A IN (select A from TABLEA where TABLEA.A=TABLEB.A ). It has been validated successfully, but when I want t...



A subquery is not delegated to the source and facing a timeout

In this, the subquery is not delegated to the source because it is executed from dual(). when we execute this full query, it is loading more than 2ml records first (Reason for query timeout) and then it applies the subquery logic in where conditi...

denodo7 subquery


Building derived views that originally have subqueries in them

I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...

Denodo 8.0 Subquery Derived views


FETCH or LIMIT in a Subquery

Are you not able to use FETCH and/or LIMIT in a subquery? This query throws an error - Syntax error: Exception parsing query near 'LIMIT' SELECT a.* FROM view1 INNER JOIN (SELECT joinval from view2 ORDER BY joinval DESC FETCH FIRST 3 ROWS ONLY) AS vie...



Subquery giving an error

Hi I have a VQL query as follows: SELECT * FROM bv_getlistdata WHERE sessionhandle = '123456' and token = (SELECT requesttoken FROM bv_request) The view bv_getlistdata has 2 parameters sessionhandle and token and the bv_request view has a single ou...



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


Subqueries cannot be included in a SELECT clause

Hello, Denodo isn't allowing a subquery to be included in the SELECT clause. Is there any alternative for this? Thanks, Hemant



SELECT DISTINCT Doesn't work in subquery

Hello, Whenever I try running a subquery with SELECT DISTINCT I get the following error message: Query Execution failed Reason: SQL ERROR -50006 [HY000]: Error executing view: Functions min, rank are not executable I'm not sure why this is hap...

subquery Distinct


Search methods and subquery

I am using a webservice source in which I have a parameter in the connection definition. I would like to obtain value(s) for this parameter from another view using a subquery. However during excecuting the whole query an error mesage pops up indicating...

subquery search methods parameter