Q&A

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

Connecting to data lake gen2 with a free trial
answered 19-10-2020 11:42:52 -0400

Would like to download The Distributed File System Custom Wrapper to connect to a data lake store gen2 in Azure. I cannot download the file from support.denodo.com as I have a trial license only. How can I get the wrapper, my trial is running out, so ...

Answers: 3

Azure Data Lake Storage Gen2

Losing connectivity for Denodo user
answered 19-10-2020 06:39:19 -0400

When I provision the Denodo AMI as an EC2 instance, I follow the directions to get it going and everything is fine. However, if I stop that instance (e.g. working on something else for a while) and then restart it, all of a sudden the Denodo user can'...

Answers: 1

AWS Login time out AWS

Fetching View's underlying query
answered 16-10-2020 08:53:59 -0400

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Answers: 1

Base view Stored Procedures query logs Denodo view

Full Caching mode
answered 16-10-2020 07:41:32 -0400

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.

Answers: 1

caching

Caching issue while sending data to MYSQL workbench.
answered 16-10-2020 07:03:15 -0400

Hello, I have a problem with caching the data I got an error : Finished with error: Error loading cache: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Loading local data is disabled; this must be enabled on both the client and server sid...

Answers: 1

caching

Use Denodo Web Service as a Data Source in Denodo
answered 16-10-2020 06:30:28 -0400

Hi, Is it possible to creat a Data source on a Denodo REST web service ? We have a requirement where we want the Denodo Web service to be utilized as a Data Source .

Answers: 1

Time zone differences and daylight savings
answered 16-10-2020 05:30:41 -0400

I need to account for Daylight Saving Time with the data I am processing. One of the rows has a date time of '01-Nov-2009 01:59:00'. When I set the Locale value to us_cst: English (United States) via the Denodo Administration/Admin Tools Preferences op...

Answers: 1

Denodo 7.0 Date time stamp

Query optimization
answered 16-10-2020 05:23:32 -0400

Hi Denodo community, We have a big tree-view and multiple branch of the tree use same source/query. As is, Denodo reexecute the same query many times during the same execution.I understand that caching might be a solution but I understand too that cach...

Answers: 1

Flattening a Mongo Array
answered 15-10-2020 08:09:58 -0400

I have a Mongo connection that returns data similar to the following: _id : VARCHAR, ticket: { status : VARCHAR, recipient : VARCHAR, request_type : VARCHAR }, stages: { supplier: { status : VARCHAR, eta : VARCHAR }, recipient: { status : VARCHAR, eta...

Answers: 1