Latest Activity

Summary Table Acceleration is not being Utilized

We are facing a senario where Summary Table Acceleration is not being considered as best plan for execution. We have followed the exact steps available in the Denodo Guide where we are creating a summary table on agreegated transformation. First case,...

I want to copy column value of above row to below rows (which have value 0) until a greater value is found in the same table. How this can be achieved?

I want to copy column value of above row to below rows (which have value 0) until a greater value is found in the same table. How this can be achieved? date duration26-oct 2 27-oct 0 28-oct 0 29-oct 4 expected reuslt date duration26-oct 2 27-oct 2 28...

unable to login denodo path

Hi team, Unable to login Denodo path. showing as below error Request to please help. error during JRMP connection establishment;nested exception is:javax.net.ssl.SSLHandshakeException:sun.security.validator.ValidatorException:PKIX path validation fa...

Denodo Scheduler - Deadlock issue in Derby DB

Saw Denodo Scheduler Job failure because of the locking issue. Any workaround or Denod updates available to address this issue? Error: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, SCHED_ELEMENTS, (253,8) W...

query timeout after certain input values.

Hi , I have a 3 way joined view - 1 impala source , 2 azure sources , which is supposed to accept input parameters at runtime , if i enter input values more than 30 , it starts giving me this query timeout error message . [JDBC ROUTE] [CONNECTION_ERRO...

I use case when function, I got error message below

I am tring to create a new column using: case when MAR_ADDL_INFO.LINE = 1 then MAR_ADDL_INFO.ERX_ID else null end then I got error maessage: com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: The following...

input parameter at run time

Hi , I want one input parameter field to be provided at the run time of a base view . I'm using this query in create from base view option in data source tab. select * from edl_cs_space_plan_analysis.v_lab_building_floor_space_org_alllocation where spa...

interpolation variables

Hi team can someone please help me for how to take input parameter values in base views?

input parameter in base view

Hi , I m creating a base view using create from query command which is a result of 4 join operation and i want to know if we can use input parameter fields in where condition which already has 3 more where conditions? where s.space_classification_curr...

Remote data connection

How can I connect to a data source that resides on another machine? Denodo and the other machine are both on-prem.