Latest Activity
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
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...
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...
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...
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...
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...
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...
Hello, Denodo isn't allowing a subquery to be included in the SELECT clause. Is there any alternative for this? Thanks, Hemant
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...
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...