Q&A BY TAG 'VQL'

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

get_view_columns
answered 01-10-2019 06:44:41 -0400

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...

Answers: 1

Microstrategy VQL get_view_columns

In view row_number() is not working expected.
answered 01-10-2019 06:13:59 -0400

In view row_number() is not working expected. but same query from VQL Shell giving me expected results. What is the issue ? I pass same where clause. From VQL shell which is need row_number 1 1 2 3 4 From View row_number 49 50 51 52 115 What caus...

Answers: 3

VQL Vql shell row number

Not able to import a view and execute VQL's in VQL shell in Denodo 7.0 express edition
answered 03-06-2019 12:08:23 -0400

Hi Team, Good Day! I was trying to export and import the entire database that I have created within my local to another local machine and it works. I could move my entire DB to another system. But after sometime, I thought of moving some edited view to...

Answers: 1

VQL Import Export

vql
answered 29-05-2019 06:15:41 -0400

Hi Team, Denodo 5.5 I have a requirement to find all the views which uses 'In' or 'Between'. How can this be know. Thanks.

Answers: 3

VQL Denodo 5.5

Make Server Configuration Changes VIA VQL
answered 23-04-2019 18:17:48 -0400

Is it possible to make to server configuration changes using VQL? For example, is it possible to alter kerberos settings, like adding User Base values?

Answers: 1

VQL Server Configuration Changes

Example Denodo Stored Procedure to interact with SQL Server Stored Procedure
answered 27-12-2018 16:37:43 -0500

Hi, Denodo Where can I find some example denodo stored procedures to takes some input parameters to feed into an MS SQL server stored procedure(not regular SQL scripts) that does some analysis and returns a table, for joining with other denodo base vi...

Answers: 3

VQL Denodo stored procedure

Strange syntax error when attempting to add a column to a derived view
answered 27-11-2018 15:14:03 -0500

I have an existing derived view that I"d like to add a column to but I'm getting an unexpected error. The sourve view has 3 columns: source_id (int datatype) timestamp (int datatype) value (int datatype) The timestamp field is an Epoch timestamp that...

Answers: 1

VQL addsecond

Create a Comma Seperated List (CSV) as part of query resultsL
answered 28-08-2018 03:55:24 -0400

Is it possible to convert a list of values into a csv string as part of query result? Ex: Customer | Item John | Glove John | Bat Desired output: Customer | Items John | Glove, Bat In SQL Server, i would use syntax like shown in this article. https:...

Answers: 1

VQL CSV

cache refresh info
answered 07-08-2018 02:22:08 -0400

Hi Guys, is it possible to get a list of views having caching enabled, to check their latest cache refresh using VQL? If not using VQL, does Denodo have other ways to check for caching info about views?

Answers: 1

VQL VDP Cache

DESC VQL
answered 21-12-2017 19:42:03 -0500

Is there way can we export DESC VQL FOLDER '/02_base_views' ('includecontents'='yes') to csv file or expose as any other table ? Bascially we need to apply some filter after the export Thanks in Advance

Answers: 1

VQL