Q&A

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

Result of LIST VIEWSTATSUMMARIES in GET_STATS_FOR_FIELD
answered 06-05-2022 07:41:19 -0400

Hi there I want to refresh the statistics (at the end via scheduler) for those views which have the stats enabled. The refresh can be done with the new GETSTATSFORFIELD like call GETSTATSFORFIELDS ( 'ATSOURCETHROUGHVDPONLY' ,'myDB' , 'myView' ,null, t...

Answers: 3

Statistics

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

How to restrict results returned in PowerBI using a parameter?
answered 04-05-2022 12:25:18 -0400

we have a table in denodo with a time dimension, can we restrict the number of results using a parameter in PowerBI?

Answers: 1

Power BI Parameter

Is it possible to CUD (Insert/Update/Delete) in denodo query editor ?
answered 04-05-2022 08:24:27 -0400

Hi, there I want you to let me know this question. Is it possible to CUD (Insert/Update/Delete) in denodo query editor ? especially impala. I've tested this in denodo express. insert ok update, delete now allowed how about denodo platform v...

Answers: 1

Impala

How to implement bitwise operator '&' ?
answered 04-05-2022 06:50:28 -0400

How do you implement the following sql in vql? select 14 & power(2,2)

Answers: 1

Bitwise operator Logical Operator

Performance of a view based on a MongoDB data source
answered 03-05-2022 11:03:08 -0400

Hello dear Denodo team, I have a question regarding the performance of a view based on a MongoDB data source. The base view in question has about 2.6 million records and 256 columns. Running the query Select max(date) from ... on Base View level re...

Answers: 1

mongo Base view Base View configuration mongodb

Metric Calculations
answered 03-05-2022 06:18:09 -0400

Would the desired metrics for our dashboard be caclculated in Denodo or would they be caclculated by Tableau? Where would it be most efficient, and what topic in the knowledge base would I look for to read about this?

Answers: 2

Metric Calculations

Storing Denodo Monitor logs in an external Database
answered 02-05-2022 10:04:19 -0400

I have followed this video https://www.youtube.com/watch?v=y4Lo6iwcKD0&t=36s and try to configure our Denodo Monitor to store the information generated by the queries monitor and/or the cache monitor in a MS SQL SERVER database. I get following er...

Answers: 3

Denodo Monitor external database

Alis names in VQL
answered 29-04-2022 09:06:23 -0400

Hi Team, How can we give alias name with spaces to view columns For example I would like to call Source_date as [Source Created Date - Study]

Answers: 1

alias