Latest Activity

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

code

To check logs

How to check which user is accesing server

code

Restart the servers

How to restart denodo and solution manager servers. on which condition which services need to stop.

code

Azure custom Wrapper, getSchemaParametrs error.

We are trying to connect Denodo toAzure using custom wrpper. we are using denodo-class name:-com.denodo.connect.hadoop.hfds.wrapper.HDFSParquetFileWrapper whenever we try to create a base view we get an error "Error while executing custom wrapper met...