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