Latest Activity

code

Connection error with the VDP server when authenticating

Hi, When I want to run the denodo scheduler and try to login, I get the following error: "Connection error with VDP server during authentication" After I checked in the log file "223350 [RMI TCP Connection(21)-192.168.28.1] ERROR 2023-10-13T19:57:03....

code

auto create base_view , auto union them

As I'm french speaking with I bad english, I write in french and include an english translation (by GGTranslate). Voici le scénario que je voudrais mettre en oeuvre. Partie 1 Je veux réaliser une union view qui reprend ce qui se trouve dans des base...

code

Hard limit on number of allowed values for the IN operator

Dear Denodo Team, with update 20230914 of Denodo 8 it's possible to define a hard limit of allowed number of values for the IN operator. (Added enhancement #71524. Added support for setting a hard limit on the number of values allowed for the IN opera...

code

Salesforce object name from denodo base view -Stored procedure

Which stored procedure can be used to get the source object name for salesforce baseviews .I cannot use GET_SOURCE_TABLE as it gives the result only for jdbc connections?

code

Use MPP engine for FLATTEN operations

Dear Denodo Team, we noticed that flattening operations could produce high CPU workload. Do to this we want to outsource this operation to another system. Is there a way in place to perform the flattening operations on the MPP engine instead of Denod...

code

Incompatible License while creating extension

Hi team, I am trying to use java based custom function by creating extension in Eclipse. It is giving error when I am deploying the custom function to VDP server - "Creation of extension is not allowed by the license." I am currently using Denodod Ex...

code

facing error : 'The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.'

Hi team, I have tried by executing the below query and it works. SELECT FLOOR("TC_1"."inventory_days" / (NULLIF(5,0.0)* 1.0)) "COL_1", COUNT("TC_1"."inventory_days") "COL_2" FROM "storesales" "TC_1" group by 1 But if i am adding the group by column ...

code

facing error : Field 'TC_1.inventory_days' is not a group by field

Hi team, While executing the below query i am getting an error "Field 'TC_1.inventory_days' is not a group by field" .Kindly help me on this SELECT FLOOR("TC_1"."inventory_days" / (NULLIF(5,0.0)* 1.0)) "COL_1", COUNT("TC_1"."inventory_days") "COL_2" ...

code

Facing Problem with interpolation variable use

Hi Team, -Source is Oracle, using this JDBC source Requirement: I want to paraterized the base view with a date column in it, when anyone tries to run that bv it should ask them date before it runs Date column name is start_date and its in timesta...

code

$Count parameter, slow perfomance

Hello Team, My service contains huge amount of data. Under the hood it uses base view plus few joins. It’s basically a lot of simple columns plus few computed. When I want to do API call with $count=1 parameter this operation takes around 40-50s to f...