Latest Activity

code

Facing error : The following fields cannot be projected: count(DISTINCT

Hi Team, I am executing the following query and am facing an error like " The following fields cannot be projected: count(DISTINCT(col_1)) SELECT MAX("q"."COL_1"), MIN("q"."COL_1"), COUNT(DISTINCT ("q"."Col_1")) FROM ( SELECT SUM("TC_1"."inventory_da...

code

How to find out whether we have implemented SSL in any of our Denodo Environment .

Hi Team, 1.How to find out whether we have implemented SSL in any of our Denodo Environment. 2.Is there any query to find the whether SSL enabled to our Denodo environment. 3.Is there any properties present in any property file to know whether SSL ena...

code

Teradata 17.10 support in Denodo 8

Does Denodo 8 support Teradata 17.10 JDBC? If not now, when will it be supported? Thanks!

code

Communications link failure in denodo even though data sources are working fine

Hi Team We were getting following error in denodo scheduler while refreshing a view. 'Communications link failure due to underlying exception: BEGIN NESTED EXCEPTION java.net.SocketException MESSAGE: Connection timed out (Read failed) STACKTRACE: j...

code

How to use group_concat and order by functions for same column in denodo.

Hi , We are converting below string aggregation and within group (order by ) function to run in denodo. For that we have used group_concat function , If we use group_concat function for particular column then we are not able use order by function . s...

code

EXTERNAL DB DATA LINEAGE

Hi everyone, I would know if there's a way to retrieve the data lineage of views when you use an external DB for the data catalog metadata. If it is not possible, there's at least a fast and easy way to create and store a view with these information...

code

multiple ec2 instances

Hi Team, Denodo 8.0 Approach 1- Ec2 instance 1: VDP Ec2 instance 2: Scheduler Ec2 instance 3: DC Approach 2- Ec2 instance 1: VDP, Scheduler, DC what are the pros and cons of both approaches ? Thanks

code

create view using psycopg2

trying to create view in denodo but getting error : 'dict' object has no attribute 'name' I tried to create using cloud function but not working sample code: denodoserver_name = "xxxx" denodoserver_odbc_port = "9996" denodoserver_database = "xxxx" de...

code

Denodo JDBC Driver Issue

We are trying to connect Denodo with Tableau and Databricks with JDBC driver "denodo-vdp-jdbcdriver-8.0-update-20220815" and also the previous version of driver. Our current version of Denodo Installation is also the same "Denodo 8.0-20220815". But whi...

code

"Regular" users see "No Application Available" under Solution Manager.

What is the minimum role/privilege grants to allow a "regular" user to have the option to see and run Data Catalog or Design Studio from Solution Manager? Current users cannot choose any of these, but can go directly to the URL of these 2 applications.