Q&A

Hi, You've answered like this https://community.denodo.com/answers/question/details?questionId=9064u000000wkIHAAY&title=Is+it+possible+to+CUD+%28Insert%2FUpdate%2FDelete%29+in+denodo+query+editor+%3F I'd tested CUD in Impala with Kudu Table. but...

Here we are having 1 functional account of519143, and part of onecdp_dev vdb, whenever we were trying to connect with VDP admin tool or web services, we were getting 1 error, and from the logs we extracted the error, can anyone help on this to understa...

Hi Team, We are to read Denodo data from Grafana. We have datasource postgresql configured in denodo where we have created base view on top of it. After creating data source in grafana as Denodo(postgresql) we are not getting data in the Grafana. Belo...

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

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

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

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

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

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

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