Q&A BY TAG 'subquery'

You must sign in to ask a question. If you do not have an account, you can register here

A subquery is not delegated to the source and facing a timeout
answered 22-07-2021 18:31:52 -0400

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...

Answers: 1

denodo7 subquery

Building derived views that originally have subqueries in them
answered 16-02-2021 10:07:04 -0500

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...

Answers: 2

Denodo 8.0 Derived views Subquery

FETCH or LIMIT in a Subquery
answered 20-04-2020 15:00:05 -0400

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...

Answers: 1

FETCH LIMIT Subquery

Subquery giving an error
answered 14-10-2019 07:13:30 -0400

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...

Answers: 3

subquery

Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

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...

Answers: 1

subquery Execution plans Stored Procedure derived view

Subqueries cannot be included in a SELECT clause
answered 08-03-2017 13:45:30 -0500

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

Answers: 1

subquery

SELECT DISTINCT Doesn't work in subquery
answered 14-02-2017 06:51:00 -0500

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...

Answers: 1

subquery Distinct

Search methods and subquery
answered 24-06-2016 16:12:22 -0400

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...

Answers: 1

subquery search methods parameter

can subquery be used in join condition?
answered 25-08-2015 04:41:05 -0400

I'm trying to get the row from table1 with the max effective_date less than or equal to table2.effective_date select blah from table1, table2 where table1.effective_date <= (select max(effective_date) from table1b where table1b.key = table1.key and ta...

Answers: 1

subquery alias