Latest Activity

code

An error occurred while communicating with Denodo

An error occurred while communicating with Denodo Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. Error Code:06DA155A timeout expired Unable to connect to the Denodo serve...

code

Connection from GitHub to Denodo solution manager

Hello team, How to connect to denodo solution manager(available in AWS EC2) from GitHub to automate the CI process. Thanks

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