Q&A BY TAG 'View'

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

Unable to rename a derived view
answered 20-12-2016 08:05:23 -0500

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

Answers: 2

view derived view

Do we need to generate the statistics for Interface views
answered 07-12-2016 05:41:51 -0500

Generating statistics for base view is enough or generating statistic for interface views will also improve performance

Answers: 1

view VDP query optimisation interface Generate stats

How to add new columns to existing base view?
answered 22-08-2016 11:31:32 -0400

Hi Denodo team, I have created a view couple of days ago. Now, I want to add new fields to that existing base view. Can i do this? If any solution to this please let me know

Answers: 2

view v

Input parameter for view
answered 08-07-2016 09:10:53 -0400

Is it possible to set a input parameter in a selection view? We know that it is posible for a derived and base view. But we want to set a input parameter in our selection view. tnx in advanced

Answers: 1

view parameter

How to connect data source by using ODBC and how to create views on VDP adminstration tool.
answered 08-07-2016 08:07:58 -0400

Hi Denodo team, I have installed denodo vdp client 6.0 . i have one goal that to create view from database. I done the all pre requests for ODBC. 1. i installed ODBC drivers. 2. I configured server and database in ODBC data source in A...

Answers: 5

view VDP

How to create a views from database table?
answered 05-07-2016 11:34:53 -0400

Hi denodo guys, I want to know how to create views and start with queries on them. Before this i need some more information about data source i.e., How to connect a Microsoft sql server database from this data source and after that ...

Answers: 1

view VDP

Evaluate a formula present in a text field
answered 26-05-2016 11:05:56 -0400

I have a table where I have a formula as a text attribute. I want to query this table and get an output with an addition derived attribute where I want to capture the execution result of the formula. Sample in input data : Select 1 Num,'0+ 1(3)' Exp...

Answers: 1

Formula View

Catalog metadata file not found null
answered 02-03-2016 12:27:54 -0500

Hi, I have connected to a hive datasource and imported a table using "Create selected base views". I can see the table on the left hand side panel. But when I execute the view, the following error pops up : TABLE [BASE] [ERROR] TABLE [JDBC WRAPPER] [...

Answers: 4

VQL meta data view VDP query

Only first 10000 row by execute view available!!!
answered 14-01-2016 11:04:18 -0500

I received only first 10000 rows from execute view, but my source contains 2000000!

Answers: 1

view

using view in where clause
answered 21-10-2014 16:36:16 -0400

Can I access a view in a where clause as follows: where clause ========== view1.id in ( select id from view2 ) where view2 is a cached base view with query

Answers: 1

view