Latest Activity

code

Is there a way to force a dependency check?

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...

VQL

code

String Processing to array to last item in 1 swoop

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...

VQL ARRAY

code

UNION of Derived Views coming from a single query to the source data

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_...

VQL UNION

code

multiple flattened view or working with cursors

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...

VQL

code

How can I close incoming JDBC connections to my Denodo VDP server?

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...

VQL JDBC

code

Denodo VQL Server on linux & VDP Admin Tool from local computer has connection time out

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 ...

VQL vdp connection