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
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
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
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:
1
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
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
Hi, is there a way to list the denodo folders for a particular denodo database via VQL? so for example: sandbox (database) - 0. Raw Data (folder) - 1. Interfaces (folder) - 2. Derived Views (folder) - 3. Final Views (folder) So i want to be able t...
Answers:
2
Hi, From Virtual Data Port Server with JDBC driver , I can execute the following VQL query to retrieve view information : DESC VIEW <view_name> I would like execute this VQL query from public datacatalog REST API (http://vhost1:9090/denodo-dat...
Answers:
1
Hi all, How do I find a view in a folder based on a partial name of the folder? For example: SELECT name FROM GET_VIEWS WHERE input_database_name = 'database' AND folder='/%derived%' Some of my databases have views stored in say: Derived Views ...
Answers:
1
Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...
Answers:
1