Latest Activity

code

Solution Manager deployment in 2 different Solution manager in different GCP Projects

Hi Denodo Team, Hoping all are doing well. I have a situation like this, We have 2 different Solution Manager for 2 different GCP Projects. GCP Project 1: 1 SM, 1 Dev VDP and 1 Test VDP GCP Project 2: 1 SM, 1 Preprod VDP and 1 Prod VDP Deployment pro...

code

Denodo VCS gets stuck when trying to do a PULL

Hello, Since a few weeks now, when trying to do a VCS pull, Denodo gets stuck in the step 5/7 "Updating database" and stays there forever. The only workaround we found is to restart the service and to try again, until it works. This causes us to lose ...

code

Can we define a column at a derived view level as nullable 'false'

I have a requirement, where I need to define a column of a derived view as not nullable even if it is not a primary key. I made it at the base view level but when I checked the derived view using the stored procedure 'get_view_columns' it is showing nu...

code

Substring_index caculation in denodo

Hi Team, How to find the substring_index in denodo? Kindly help me on this For eg : substring_index('wwww.abcd','w',-3) expected output is 'ww.abcd'

code

Facing error while using trunc

Hi Team, When i am tried to use to trunc function for the following case, it throws an error like this 'Invalid parameter types of function 'subtract(timestampcolumn, '1')' trunc(timestampcolumn - (interval '1' day)) But when i tried the same in or...

code

Add description to Base View

hi, for a base view i'm using query : ALTER TABLE "Table Name" DESCRIPTION = 'description_enter_by_me' but its giving me parsing error. can anyone help please

code

Stored VQL procedure executing dynamic VQL

I'm trying to build a VQL procedure that can accept parameters to dynamically run GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW () to extract the creation_vql of whatever base view I pass in the parameters for. The purpose is to be able to schedule jobs to r...

code

substring_index in denodo

Hi Team, How to find the substring_index in denodo? For eg : substring_index('wwww.abcd','w',-3) expected output is 'ww.abcd'

code

denodo monitor 8.0 error

Hi Team, I configured Denodo monitor for windows on Denodo express 8.0. The files are generated but data is not getting written to them. Please help. Also there is an error while starting Denodo monitor as below: "D:\Denodo_8\tools\monitor\denodo-mon...

code

LDAP User on where clause

Hi everyone, I´ve been searching for a few hours before writing this post but unfortunatelly had no luck, most likely cause it´s not posible or use case it´s so rare but would like the hear the opinion of the community which has more experience. . Wha...