Latest Activity

code

Denodo base views not accessible

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Missing Base view

code

Views not accessible

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Missing Base view

code

How to create base view which accepts parameter

Hi Team, How to create base view which accepts input parameter? If you can share sample VQL then it will be helpful.

base view

code

SQL queries ran on native Data source in VDP

Hello there, I just a few questions, I was wondering if you could provide me with an answer. How can I edit a SQL query that I created directly on the Data Source(Hadoop)? How should the SQL query be written, names the datasource, table, and fiel...

base view Hadoop Sql performance derived view

code

Error obtaining VQL in base views. Missing read privilege on the wrapper

Hi, I have read and write privilege on a virtual database. For the base views when I click the VQL tab to see the VQL associated with the view I am getting an error as below: Error obtaining vql: The user does not have READ privileges on the wrappe...

base view VQL Wrapper

code

Alter on Base View - Add Trim

I would like to add Trim() function to the column in the base view to remove the default spaces for CHAR data type. Can I do this by running an alter statement? I need to do this across all the coulumn in the Source, Is there any setting to do trim by ...

base view DENODO

code

Unable to see tables VDP when connecting to a SQL Server

I'm currently able to connect to SQL server databases in my environement using the JDBC connector, when I want to create base views I expand the data source where it's only displaying SQL security roles and not any orther objects like tables and views ...

base view JDBC Data Sources SQL Server

code

Base views - Importing tables with same names

We have the following structure Databases : Year2014, Year2015, Year2016.... Tables in each YearDDDD database : abc, mno, xyz... We are able to create base views with the first YearDDDD database that we try. However we are not able to import subseque...

base view

code

Slowest views in denodo

Hi, Is there any way to find out the the bad performing views or top slowest views ??

denodo 6.0 base view

code

Denodo 6 "Create base view from query" vs Denodo 5.5 "Create base view from query"

Hi, In Denodo 5.5, when I create a base view from a query Denodo doesn't seem to ever delegate that query to the data source, even when I include a restrictive where clause... and thus the query takes a long time to run. In Denodo 6, it appears the d...

base view