Latest Activity

code

Catalog metadata file not found null

Hi, I have connected to a hive datasource and imported a table using "Create selected base views". I can see the table on the left hand side panel. But when I execute the view, the following error pops up : TABLE [BASE] [ERROR] TABLE [JDBC WRAPPER] [...

VQL meta data view VDP query

code

where to put VQL in Multi cluster environment?

I have to connect multiple database and create multi cluster environment, I want to know where to put VQL for multi cluster environment and which would be the best way to control configure VQL. Is it require multiple VQL or single VQL can control all?

VQL

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