Q&A

Hi All, I am getting "LISTAGG is not executable funtion" while using the fucntion to combine the data into single row using below query in denodo 8 . query: SELECT LISTAGG(NAME,'|') WITHIN GROUP (ORDER BY NAME) FROM ( SELECT 'A' NAME UNION SELECT 'B'...

I can see some inactive sessions through get_sessions() but how we can kill that old inactive sessions or active sessions, since these sessions still showing at the source end as well.

HOw do I install the scheduler on my training instance of denodo?

Hi team, May I check if Denodo platform 8 is support the elasticsearch 8.5?

we are migrating a view from development to test . How can we find a revision that is created by someone else in solution manager ?

Hi Team, We have setup cache DB on Snowflake, and then cached on of the view and used it in our implementation. (Cache Type being Full.) On joining this cache view with another view, which is also built entirely on Snowflake, the query is not getting...

In the presentation I find at some point "Verify return results: i.e. Estimated row count. Check if base views return results (with limit clause)." As far as I can understand, the Denodo Testing Tool can perform exact match, or subset/superset match b...

Related to: Testing in Denodo

In the sample table below, I'd like my query to return only the rows for the records where ThingA has the status of C as updated on 15December2022 (most recent update) and ThingB as the status of B as updated on 21November2022 (most recent update). I w...

Hello. I have created a derived view named 'dv_1' based on a base view named bv_1. I need to create a new column named 'new_col' in the derived view 'db_1' using conditional logic. The values in the new column 'new_col' depend on the values of two a...

in the " Lab Use Denodo GraphQL Service to query views " DEN80EDU13DS02LAB03 after using the URL provided in the LAB guide i got this message " Server cannot be reached " then i changed it to the http://<host>:<port>/denodo-graphql-service/...