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

How to add by default values in the base view?
answered 26-02-2018 07:48:38 -0500

I have added 2 extra columns in the base view in addition to the datasource. I would like to populate these columns with the same default value. For. e.g. Let's say there are 1000 records in the datasource. I have added "Year" column and I would like t...

Answers: 1

Base view

Edit query when creating a BASE VIEW
answered 22-12-2017 04:52:40 -0500

Hi Community: I'm new using the tool and when creating a base view I used he option create from query. I'm trying to edit the query used for a base view created is this possible? If yes please let me know which are the steps Thanks for your help

Answers: 2

Base view

Denodo base views not accessible
answered 14-11-2017 04:30:51 -0500

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

Answers: 1

Missing Base view

Views not accessible
answered 14-11-2017 04:27:26 -0500

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

Answers: 1

Missing Base view

How to create base view which accepts parameter
answered 05-10-2017 05:32:10 -0400

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

Answers: 1

base view

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