Latest Activity

code

dynamic parameters value in where condition

Hi team, Does denodo has the function to suport dynamic paramters input in where condition, e.g. where (case when parameter_flag = 'A' then date_column = baseview.date_col_a when parameter_flag = 'B' then date_column = baseview.date_col_b else '190001...

code

Mix Optional and Non-Optional Interpolation Variables in Base View from Query

Hi Denodo Team, Please let me know how to set up a mix of Optional and Non-Optional parameters for the base view query in Denodo. Example: SELECT * FROM Offchain.Movement M WHERE M.OPERATIONALDATE BETWEEN ''@START_DATE'' AND ''@END_DATE'' AND M.NAM...

code

Create field from an array

In Denodo 8.0 I have a json source. It has a feature array with a bbox array inside it. I would like to create a new field that has the text of the bbox array. I can't figure out how to do it. The original json from the url is: { "features": [ { ... ...

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