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 show all cached sources and when it was last refreshed?
answered 01-06-2021 17:37:03 -0400

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

Answers: 1

vql query LASTCACHEREFRESH Cache

Help rewriting REGEXP_LIKE Query to VQL
answered 16-04-2021 05:39:36 -0400

We are needing some assistance/suggestions in rewriting the following Oracle query. Query is basically creating a list(listagg) of a list of regions gathered from abc.table123 (security config table, each row is different region), and then needs to be ...

Answers: 1

VQL REGEXP_LIKE regexp_like Oracle SQL to VQL Converter SQL to VQL to_char

Aggregation of derived views delegating search methods to base view
answered 02-04-2021 07:46:17 -0400

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

Answers: 3

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 01-04-2021 08:46:28 -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: 3

unpivot VQL cross apply

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

Denodo 7.0 VQL search methods join Derived views

an alternative to UNION of three separate views
answered 16-03-2021 08:13:45 -0400

I am able to execute 3 different baseviews against our LDAP data. But when I try to union them together I am getting an exception error. exception = java.security.PrivilegedActionException LDAP URI = ldaps://<ldap url>:3269/DC=mycompany,DC=com?...

Answers: 1

vql query error timeout union

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