Latest Activity

code

splunk cloud connection

Hi Team, Using CData JDBC JAR driver we are connecting to splunk cloud to fetch information in Denodo 7.0 20210224, but are unable to. error while running query on existing base view and also if new base view is tried to be created: Error executing s...

code

function delegation: mysql data source

Hi I am not able to add "nest" scalar funtion in mysql jdbc data source in denodo. Error updatig data source : Function nest not found Thanks & Regards,

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'