Q&A BY TAG 'vql'

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

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

base view vql invalidate cache

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

base view vql ESCAPE

How to do the cache load for a view
answered 18-08-2020 08:50:38 -0400

How to load cache load for a view, we have kinds of cacje mode, full, partial, waht is the exact command? do we have artical to introduce it? Thank you.

Answers: 1

vql cache data preload

Dynamic JDBC source query parameter
answered 01-07-2020 06:38:37 -0400

How can I force dynamic filter on query to be executed against datasource? Example: SELECT name, surname FROM table WHERE id = GETSESSION('user') this does,not work. SELECT name, surname FROM table WHERE id = 'john' works but I would like to use sessio...

Answers: 5

VQL

import.sh run vql, which vql contained parameter, how to make it?
answered 26-05-2020 17:41:43 -0400

We have linux machine with denodo client installed, we use import.sh to run some vql file, I have a question, if my vql file wants to have a parameter such as where filters contain some parameter, can import.sh run that vql with parameter contained in ...

Answers: 3

vql vql parameter import.sh

vql for Import roles from LDAP data source
answered 21-04-2020 17:50:35 -0400

Hi all, I understand in VDP we can use “Import Roles from LDAP” wizard to import roles from LDAP data scouce, and I can see ldap data source defined in VDP database, if that do we have vql to import roles, which can does the same thing as the Import Ro...

Answers: 1

vql import ldap roles

VQL Required to add a data movement plan using Alter?
answered 01-04-2020 15:37:11 -0400

What is the VQL required to Alter a data movement plan? Here is the context from the CREATE statement: CREATE OR REPLACE VIEW sv_basespace_rundata as field1 field2 field3 CONTEXT (DATAMOVEMENTPLAN = iv_getsession_roles : JDBC datasources."ds_BaseSpace...

Answers: 1

VQL 7.0

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 30-03-2020 11:50:34 -0400

Hello Denodo Support Team, I understand that Denodo VQL supports TVFs (Table Value Functions) regarding the unpivoting of multiple columns in a view and joining to other sources. However, the most recent proposed solution for addressing the powerful UN...

Answers: 1

VQL unpivot cross apply

[SQL0401] Comparison operator = operands not compatible.
answered 24-02-2020 07:58:57 -0500

Error : [SQL0401] Comparison operator = operands not compatible. DataSource is DB2. and data type of DATE_TRANSACTION IS date(deprecated) None of the below query works. Queries: SELECT FROM "Discovery_FiservODS"."EFT_TRANS_HISTORY" WHERE "DATE_TRAN...

Answers: 1

VQL

How to get VQL command metadata response message using JDBC connection.
answered 14-02-2020 07:18:59 -0500

Hi Team, I am using JDBC connection to execute the VQL commands from my application. Let's say I want to create a role or modify the description of the role using 'Create /Alter command query' as shown in example below For example: Create role testro...

Answers: 3

VQL VQL Role