Q&A BY TAG 'VQL'

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

Transform text to data
answered 18-11-2022 18:12:36 -0500

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

Answers: 4

VQL

VQL to identify obligatory parameters/search methods via VQL
answered 02-11-2022 04:58:39 -0400

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

Answers: 1

VQL Parameter

VQL - Identifying non fully-delegated queries
answered 01-11-2022 08:59:43 -0400

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

Answers: 1

VQL

Convert time in seconds to time format HH:MM:SS
answered 11-08-2022 04:38:27 -0400

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

Answers: 2

VQL

Using VQL to DROP or DELETE a derived view
answered 21-07-2022 02:03:29 -0400

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!

Answers: 3

Delete VQL Derived views

Can we variabilize the connection string of jdbc and use to other query ?
answered 06-05-2022 04:14:37 -0400

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

Answers: 3

VQL variable

How can I select random rows from a table (without replacement) with VQL?
answered 05-05-2022 04:12:20 -0400

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

Answers: 3

VQL

Getting folders and subfolders using VQL
answered 29-04-2022 04:38:05 -0400

Hi all, Is it possible to execute a VQL query to get all folders with their full paths? For example, if I have a folder called 1. Base Views and in that folder I have a folder called Archive is it possible to query and get: Base Views Base Views...

Answers: 1

VQL folders

Rename a column in a view using VQL
answered 25-02-2022 07:30:36 -0500

Is it possible to rename a column in a view using vql? For instance, if I have a view that has the columns id, firstName, lastName - is there a way to use VQL to rename id to person_id? I know there is documentation for modifying a view: https://com...

Answers: 1

VQL column name Rename

Getting a stored procedure via VQL
answered 24-02-2022 06:52:29 -0500

Is there a way to get the stored procedure for a view / table created in Denodo via VQL? For example, I have a view called 'p_raw_data' that is created using the following procedure: CREATE OR REPLACE VIEW p_raw_data FOLDER = '/0. raw data' AS SELECT ...

Answers: 1

VQL Denodo stored procedure