Latest Activity

code

Data Type conversion in filter condition

Hi , one of the base view is having date column but with type as text . To query the view based on the date column , i would like to covert the column to date data type before applying filter condition , i tried with the below syntax which is very cl...

code

Denodo Testing Tool Declaring Global Variables

Hello, We are exploring Denodo Testing Tool. Not sure how to declare Global Variables on configuration.properties file. Based on the example provided in Testing Tool Documentation , I understand while consuming global variables it should as below ${pw...

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