Latest Activity

code

LISTAGG function error denodo 8

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

code

how to kill old inactive and active sessions in denodo

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.

code

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

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

code

Denodo to Elasticsearch

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

code

finding a view in migration

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

code

Why the query is not delegating completely to source when my main data source and and cache datasource , both are on Snowflake ?

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

code

Verify return results: i.e. Estimated row count. Check if base views return results (with limit clause)

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

code

How to select the records with the most recently updated status from duplicate records?

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

code

Creating new field in derived view using conditional logic

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

code

Server cannot be reached in Graphgl

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