Q&A BY TAG 'Base view'
vql to invalidate cache (base views, derived views)
answered
26-11-2020 16:11:49 -0500
Hi team, I want to find out vql to invalidate cache, I run below for a base views, but it has error "selected view: 'base_view_name' is a base view": ALTER VIEW base_view_name CACHE INVALIDATE it cna only run for derived view: ALTER VIEW derived_view_...
Answers:
1
For base view vql, what does "ESCAPE" mean?
answered
05-11-2020 04:35:49 -0500
I just observer the vql of the base view (data source is Hadoop Dremio), for the columns whose sourcetypename='CHARACTER VARYING', some has the attribute "ESCAPE NOT SORTABLE" , some has the attribute "NOT SORTABLE", why for the same data type, they ha...
Answers:
4
Fetching View's underlying query
answered
16-10-2020 08:53:59 -0400
Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...
Answers:
1
VQL for updating the Base View
answered
24-09-2020 06:38:12 -0400
Hi, I know we can detect the changes in the underlying data source using GET_SOURCE_CHANGES and GET_VIEWS stored procedures. However, once we detect the changes, is there any way to refresh the base view (VQL commands?) once we detect the changes?
Answers:
3
Need help creating a Base View from a SQL Server Stored Procedure
answered
18-08-2020 08:14:29 -0400
I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...
Answers:
3
Creating A Base View On Snowflake Stored Proc/ Multiple Statements
answered
22-07-2020 18:04:16 -0400
Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...
Answers:
1
Duplicate views are getting created while creating base views
answered
07-07-2020 14:18:41 -0400
Hi Team - I am creating base views on a delimited data source(CSV). For this I created a base view under this data source object in the server explorer pane of VDP Admin client. I also see another base view (with the same name) also getting created aut...
Answers:
2
Optional interpolation variables
answered
17-06-2020 08:14:12 -0400
Each time I create a base view over a JSON data source with interpolation variables, denodo asks me to provide all of the variables. But what if the API does not support the combination of all the variables together? E.g. there is external_id and local...
Answers:
3
SQL Server date datatypes error in conversion for base views
answered
15-06-2020 04:04:07 -0400
¡Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...
Answers:
1
SQL Server date conversion error in BaseView
answered
15-06-2020 04:02:11 -0400
Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...
Answers:
1