Q&A BY TAG 'vql'

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

Create VQL that will generate a list of all views and fields and descriptons
answered 26-02-2021 04:03:57 -0500

Is there a simple way to write a VQL script that not only shows all of the views -- i.e. LIST VIEWS on [database] but also would show the view and the columns, and field type from that view... (as well as description if possible). We are trying to g...

Answers: 2

VQL list

Setting CONTEXT ('formatted' = 'yes') as default?
answered 24-02-2021 07:44:43 -0500

Is there a way I can have the system, by defult, add "CONTEXT ('formatted' = 'yes')" to the end of a derived view when I use the VQL Shell to create views, instead of having to write it out at the end of every script?

Answers: 1

VQL vql shell context formatting

vql to get only the exact database URI for data source in Denodo
answered 23-02-2021 00:23:51 -0500

HI team, do we have some system table, or vql command, which get only the exact database URI for a Denodo data source, for example we only want to get below kind of information: jdbc:oracle:thin:@aassddcc.compant.com:6566/aassddcc I understand we have...

Answers: 3

vql database URI

VQL Parser for Python
answered 19-02-2021 07:17:32 -0500

Hi, I would like to parse a VQL in Python in order to retrieve all elements of a VQL in a correct AST. Could you please tell me if such kind of parser already exists or if there is a way to get the VQL grammar somewhere ? I already found some fragment...

Answers: 3

VQL parsing Python

How to pick the last record from duplicates?
answered 29-01-2021 15:03:02 -0500

Say I have a table with 3 columns: A, B, C. See below. Column A Column B Column C 1 11 21 1 12 22 2 13 23 2 12 24 3 14 25 ...

Answers: 2


Fetching Column issue in VQL
answered 05-01-2021 05:39:50 -0500

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwin...

Answers: 1


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