Q&A

Not able to view Denodo Learnings
answered 22-11-2019 08:19:52 -0500

Hi Denodo Team, I am not able to see the below learnings/Training in my Learning dashboard. Data Virtualization Developer Introduction Data Virtualization Developer Basics - On-demand Advanced Data Virtualization Developer - On-demand Coul...

Answers: 1

Subtracting a no from a date DATEDIFF(dd,0,b.pymt_run)
answered 21-11-2019 16:05:22 -0500

Can you please help me to convert following statement in denodo DATEADD(dd, CASE WHEN DATEDIFF(dd,0,b.pymt_run)%7 > 4 THEN 7-DATEDIFF(dd,0,b.pymt_run)%7 ELSE 0 END,b.pymt_run) as fin_pymt_run Here b.pymt_run is of date datatype. Thank you!

Answers: 3

#date #datedifference

Create a folder dinamically in Scheduler
answered 21-11-2019 16:03:22 -0500

I need to create a CSV exporter and I need that this exporter create a folder with the date. Is this possible? Example: /output/20191120/extract.csv /output/20191122/extract.csv ...

Answers: 1

folders Job scheduler CSV

Adding a data source
answered 21-11-2019 05:37:54 -0500

I am following along the Denodo tutorial but have encountered issues when attempting to add a new data source. I followed the download instructions but they are not very clear so i am obviously missing something. I am from a non-technical background so...

Answers: 2

Tutorial Data Source

Executing Dynamic VQL generated from view output
answered 20-11-2019 18:54:48 -0500

Hi, We have a list of report views that are cached for which we need to generate the report which shows the count or records for all those views. There is a view we have which could give the names of these views that we have to get the counts on. Is ...

Answers: 1

Dynamic

"The join requires generating too many search methods" Error
answered 20-11-2019 13:32:16 -0500

Hi Denodo team, We have facing below issue while creating a Join between two views: Finished with error: The join requires generating too many search methods. Reduce the number of obligatory fields/parameters in the join conditions. The same join is...

Answers: 1

Denodo Scheduler - UTC Time
answered 20-11-2019 11:16:51 -0500

Hi, I have an issue where our scheduler jobs are associated with UTC as opposed to local time. Our server is set to local time. How can I change the scheduler to use local time?

Answers: 1

Python JDBC access to Denodo
answered 20-11-2019 06:50:00 -0500

Hi, I have been trying connect our Denodo Server via python, I have been trying from windows and now from MacOs Mojave. I have read other JAYDEBE API posts, which basically Denodo Support team didn't/couldn't help. My code is below user = #### pasw ...

Answers: 1

JDBC Python

Differentiated Stages in Denodo Query Execution_1
answered 19-11-2019 11:38:44 -0500

Hi Team, just want to understand, how denodo can plan the exquery excecution. which is the right process? 1.Query parsing, optiomization, integration and excuting the query or 2.Query parsing,static optimization, dynamic optiomization and excuting the ...

Answers: 1

Denodo Query Exceqution Plan

Differentiated Stages in Denodo Query Execution
answered 19-11-2019 11:35:47 -0500

Hi Team, just want to understand, how denodo can plan the exquery excecution. which is the right process? 1.Query parsing, optiomization, integration and excuting the query or 2.Query parsing,static optimization, dynamic optiomization and excuting the ...

Answers: 1

Denodo Query Exceqution Plan