Q&A BY TAG 'Base view'

You must sign in to ask a question. If you do not have an account, you can register here

SQL queries ran on native Data source in VDP
answered 29-08-2017 10:30:36 -0400

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

Answers: 1

base view Hadoop Sql performance derived view

Error obtaining VQL in base views. Missing read privilege on the wrapper
answered 23-08-2017 08:37:10 -0400

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

Answers: 1

base view VQL Wrapper

Alter on Base View - Add Trim
answered 10-08-2017 12:24:32 -0400

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

Answers: 2

base view DENODO

Unable to see tables VDP when connecting to a SQL Server
answered 31-03-2017 09:42:22 -0400

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

Answers: 2

base view JDBC Data Sources SQL Server

Base views - Importing tables with same names
answered 14-02-2017 23:16:38 -0500

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

Answers: 2

base view

Slowest views in denodo
answered 15-11-2016 03:54:40 -0500

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

Answers: 1

denodo 6.0 base view

Denodo 6 "Create base view from query" vs Denodo 5.5 "Create base view from query"
answered 13-07-2016 09:15:00 -0400

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

Answers: 1

base view