Q&A BY TAG 'vql'

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

Is there a way to force a dependency check?
answered 26-10-2015 06:54:44 -0400

Hi, We've been merging various Denodo branches in SVN and also importing VQL into our database and I'm not 100% confident we didn't break something. Is there a way to force a dependency check, such that every derived view is validated to make sure th...

Answers: 1

VQL

String Processing to array to last item in 1 swoop
answered 30-06-2015 01:35:20 -0400

I have a data source with multiple columns being a uri. I need to process it to get the last "item". We can simply create one for the sake of this question & try it out using the VQL shell. select split('/', 'http://server:9090/denodo-restfulws/tutori...

Answers: 2

VQL ARRAY

UNION of Derived Views coming from a single query to the source data
answered 21-06-2015 22:21:47 -0400

I have a data source where due to it's hierarchical nature that I need to flatten it & output as a list (with hierarchy level no. being just another column) my approach is as follows. Say we have 3 levels of hierarchy, I would set the first view, view_...

Answers: 2

VQL UNION

multiple flattened view or working with cursors
answered 21-06-2015 22:19:22 -0400

Because the object returned is a huge hierarchical xml, it is expensive to make multiple calls. So is there a way I can have multiple flattened views as columns? In the advanced vql guide, there is a select list((author).contractaddress[0].mail) but i...

Answers: 9

VQL

How can I close incoming JDBC connections to my Denodo VDP server?
answered 09-06-2015 11:04:06 -0400

Hi, Is it possible to close all incoming JDBC connections using VQL statements? Or is there another command I can use to kill/close all incoming JDBC connections? Here's why I'm asking: 1) When I run deployments, my script automatically removes a d...

Answers: 2

VQL JDBC

Denodo VQL Server on linux & VDP Admin Tool from local computer has connection time out
answered 09-06-2015 04:48:11 -0400

Just installed and started up a denodo vdp server on a linux ec2 instance. Was using on local win desktop so semi understand the features and workflow. The vdp server is running on the linux box, appropriate ports are open and being listened on. No ...

Answers: 3

VQL vdp connection