Latest Activity

code

Extracting text from a field using delimiter

Hi I have a field which contains text. Id like to extract a certain part of that text field which being "Model: 123 Customer ABC" I would like to extract only the "123" part of this field Any help would appreciated Thanks D

VQL string conversion

code

How can get all database URL in denodo

Hi Denodo Community , Please , I need your help , How can get database URL in denodo , using VQL or any other solution Thank you a lot .

VQL GET_VIEWS VQL Base view database URI GET_SOURCE_TABLE GET_ELEMENTS URL

code

Query a field in a register in denodo

Hi, Can we query a subfield from a register in vql shell without knowing the exact path of the subfield. is there a query like : select [subfield name] from xxview. So if the subfield is under register1.register2..registerN, we dont have to specify th...

vql register

code

Transform text to data

HI everyone, I have a task to transform a text field to a timestamp field. The content of the initial field looks like this: "2017007", so it's like "YYYY0MM". I was trying aroudn with totimestamptz, but I don't know how to deal with this 0 in the ...

VQL

code

VQL to identify obligatory parameters/search methods via VQL

How do you determine the mandatory parameters/search methods given a view using VQL?

VQL Parameter

code

VQL - Identifying non fully-delegated queries

Is there a way to determine which queries Denodo will not delegate in full to source via VQL or otherwise ?

VQL

code

Convert time in seconds to time format HH:MM:SS

Hello, I have a field that contains the time in seconds, type int. And I need to represent it in the final view as time. So for example: 54107 should be 15 hours 1 minute and 40 seconds, or 15:01:40 in the final view. Is there any easy way to do it,...

VQL

code

Using VQL to DROP or DELETE a derived view

Is there a way to DELETE or DROP a derived view using VQL? I would like to programatically do this in python but there doesn't seem to be a VQL command (that I can find) that would allow me to have a list of views to run through and delete. Thanks!

Delete VQL Derived views

code

Can we variabilize the connection string of jdbc and use to other query ?

Hello, I have some database ( more than 100 ) with different name but the same table name. I would like to have into my column after each base view created a database "unique id" on each base view. For my use case, I would like to union all my base ...

VQL variable

code

How can I select random rows from a table (without replacement) with VQL?

For example, how do I select 10 random rows from a table, foo? I would expect this to work select *, rand() as rank from foo order by rank limit 10 but rand() generates a single random value which it then maps to every record in foo. So, this query ...

VQL