Latest Activity

code

Delegate SQL Sentence as Sub Query Option

I'm creating a base view from query that contains a CTE and getting 'Incorrect syntax near the keyword 'WITH'.' The statement runs fine in SQL, so I know it's valid. I believe I found the fix (steps below) in this Q&A https://community.denodo.com/a...

CTE Delegate

code

Joining CTE using a LEFT JOIN in Postgres throw error

When using a left join to join a CTE in Postgres, we receive a column "does not exist" error. This error occurs when one or several of the columns in the CTE are not used in the joined query. When inspecting the Execution Trace and reviewing the Postgr...

CTE PostgreSQL left join

code

Common Table Expression (CTE) and Recursion

I see there is support of WITH statements allowing CTE work. Does Denodo support recursion in CTE's? I have tried to get it working, but the error back is that the name of the CTE does not exist. When I remove the recursion piece of the query, it wo...

CTE Recursion

code

Disadvantage of using multiple CTEs in Denodo

We are using many level of CTEs in our architeture.Also joining them with other integrated views.Please let me know what are the disadvantages of using CTEs in Denodo considering performance side.

CTE

code

Using CTE WITH clause for creating base view from query

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Base view quer cte MSSQL

code

Multiple created values in a CTE

Good afternoon, I am trying to use a CTE with multiple values. ie: ;with pd as ( select '12345' ) But I need a large amount of values, and am not sure of the syntax needed to do multiple select's in a CTE in this manner. So I would need 12345, 1234...

CTE

code

Limit inside Denodo common table expression

Is it possible to limit VQL query output inside common table expressions? I mean something like that: "DenodoTable" hh order by "holding" desc **--LIMIT 10** ) select * from cte If uncomment "LIMIT 10', above VQL gives "Syntax error: Exception par...

Top N CTE Limit

code

WITH (COMMON TABLE EXPRESSIONS) Denodo Express 6.0

According to your VDP Conformance with Standard SQL document: COMMON TABLE EXPRESSIONS are supported in Denodo 6. Does this apply to Denodo Express as well? My base view fails with the following error: ICTE_TEST_SECOND [BASE] [ERROR] CTE_TEST_SECOND [J...

Related to: VDP Conformance with Standard SQL

CTE