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

find base view from query
answered 11-06-2019 13:26:06 -0400

Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.

Answers: 3

Base view Query

When running as admin, receiving "Error storing wrapper: Error accessing the metadata" when attempting to create base view
answered 08-03-2019 00:52:31 -0500

Hi, I'm currently attempting to create base views in VDP Administration Tool and receiving the following error message: Unable to create base view: error creating 'json' wrapper: Error storing wrapper 'WRAPPER': Error accessing the metadata while lo...

Answers: 1

Base view VDP Administration Tool

Java Heap space error while running query
answered 13-02-2019 00:07:14 -0500

Hello, while executing select on a view, I am getting the error- "Finished with error: Error occurred in server thread; nested exception is: java.lang.OutOfMemoryError: Java heap space" Can you please help me on the issue, where I can increase the hea...

Answers: 1

Base view java Select Query 'Java heap space'

List all Derived views using a specific Base view
answered 20-09-2018 19:46:31 -0400

Hi, In Denodo , how can we list out all Derived views which are using a specific Base view ? In Denodo VDP admin tool, it is easy to find using option "Used by" .We are looking for the same option using some Denodo stored proc/command.

Answers: 1

base view

Denodo Views
answered 03-07-2018 08:12:42 -0400

Hi Denodo community, I have the following: Data Source: JSON * Name: HTTP CLIENT * Configure: Post * URL: Rest Call The source currently has nested elements, some fields either appear as a register or arrays. I do not want to...

Answers: 4

post Json Base view JSON

Refreshing a service
answered 22-06-2018 12:41:02 -0400

I have a SOAP service as a data source. We created a base view for one of the the data providers of that service and then we created an Interface to publish our data. We now modified the service and added some more columns that we would like to publish...

Answers: 1

Base view SOAP Interface

info about view settings in metadata
answered 25-05-2018 12:09:45 -0400

Hi, I found this: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures to get information about a lot of metadata. As denodo has a lot of parameters and settings for eac...

Answers: 1

metadata Base view Views

Using CTE WITH clause for creating base view from query
answered 12-04-2018 09:19:08 -0400

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Answers: 3

Base view quer cte MSSQL

How to populate a column in the base view which is not present in the Datasource?
answered 28-02-2018 05:55:50 -0500

I am trying to populate a column in the base view with same value. For example I have manually added "Year" column in the base view which is not present in the Datasource. I would like to populate the Year column with 2018 for all records. How can I do...

Answers: 1

Base view DataSource

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