Q&A

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

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

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