Q&A

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

Scheduling a VQL in denodo
answered 22-10-2020 01:32:02 -0400

I want to create a caching for a particular view and schedule this VQL. Any document could help

Answers: 1

Denodo 7 VQL Shell save query to local file
answered 21-10-2020 08:47:28 -0400

Hi - I am running a VQL query via Denodo Admin Tool and wish to query a MySql view and save the result to disk programmatically. Here is the query: select * from my_base_view.my_campaign; INTO OUTFILE '/tmp/output.txt' When I run it I get error: St...

Answers: 2

Denodo 8.0 in free trial?
answered 21-10-2020 08:40:58 -0400

I'm doing a BYOL free trial on AWS. The AMI I used to create the instance has Denodo 7.0 loaded on it, so when I'm going through the tutorials and whatnot, I feel like I'm behind. How would I go about getting 8.0 in my instance?

Answers: 3

Denodo 8.0 AWS DENODO EVALUATION LICENSE

Grant create Privileges but not Create data sources and folders.
answered 21-10-2020 08:31:12 -0400

Is there a option to grant user create privilege to a database but not create data sources and folders. Without create privilege the user cannot save the associations.

Answers: 1

Joins in Derived Views (VS) Associations
answered 21-10-2020 07:57:58 -0400

Hello Team, I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Plea...

Answers: 1

joins Associations Derived views

Associations Vs Joins
answered 21-10-2020 07:50:44 -0400

I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Please explain in ...

Answers: 1

association derived view aasociations vs joins

Received Error 500 when logging in
answered 21-10-2020 07:09:31 -0400

I received the following error when logging into the Denodo community website... Error 500 SOMETHING'S NOT RIGHT BUT WE'RE LOOKING INTO IT An internal server error has happened but our support team is working on it. Please be patient while we fix it.

Answers: 3

Creating Base View using Delimited files
answered 20-10-2020 10:39:04 -0400

Hi Team, I have one requirement: There is one folder on FTP path which contains text files(many text files) having record like Name:Neetu Age:34 Department:IT ContactDetails: Mob:123456 Phone:56778 Address:xyz EducationDetail: HighestQualification:...

Answers: 1

Delimited file data source

Need to extract the second row of a duplicate in a table
answered 20-10-2020 08:03:34 -0400

Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...

Answers: 1

row number select derived views

Using com.denodo.scheduler
answered 20-10-2020 04:06:40 -0400

Hi, I'm using Denodo 7.0 update 20200803 and attempting to use the scheduler api via Python/Jpype. Is there a particular jar file I need for the Scheduler? The code below is my attempt. import jpype import jpype.imports from jpype.types import * jp...

Answers: 1

Denodo Scheduler 7.0 API Python