Latest Activity


Creating a new column in derived view

Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column existing column street: value: 'streetname123' I want to create a...

Data Quality derived view


Field expressions guide

I'm trying to find a good guide on writing field expressions for new fields in derived views. I've looked through the admin, developer and advanced VQL guide and still can't find what I'm looking for. What I basically want to do is create a new field ...

Expression derived view Regular Expressions


View Parameters and Aggregation

I am fairly new to Denodo and I have read through the Advanced VQL and VDP Administration Guide but I am not able to resolve the following issue: Sample Base View For the sake of this issue, let's consider a base with student, months and rank. ...

parameter derived view Aggregate


Unable to rename a derived view

Hi, I am trying to rename a derived view "06_derived" to "05_derived" but im unable to do so howeveve im able to rename it with other name like "07_derived" etc.... Please let me know what can be the issue not much info on logs

view derived view


Access Metadata for a Derived View other than the tree View

Hi I am using Denodo VDP 5.5. I have a very complex Derived View to understand. I am able to get Tree View of the View. But since it is very BIG, it is very hard to understand it. Is there a way to access metadata for that VIEW or get the tree structur...

derived view


Getting error with un-clear error messagge in VDP

Hi, While I am adding a view and corresponding join into a derived view, its giving following error while saving the changes. "Unexpected error executing operation: Index:3, Size: 3" Can someone help me to interprete the error better and get it respo...

VDP join derived view


Records missing in a derived view, but the data exists in those base views or the source tables even after applying the same join conditions which are being used in derived view.

Hi All, I am encountering this wierd scenario in denodo. 3 records are not displaying when I query based on the name, and 3 records are being displayed when I query based on the id from the derived view. Denodo version: denodo platform 5.5 I have ta...

hash join missing records resultset derived view sort merge not same with different where conditions