Home / Q&A / All Questions

Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Maximum Job Limit Exceeded
answered 28-06-2019 04:04:50 -0400

We are unable to create more than one Job in out Denodo 7.0 Installer, is it limited because we downloaded through the Donwload Express. What is the process to increase the Job Limit

Answers: 1

#JOB #JobLimit#SchedulerJOB#NewJob

Get list of dates between two dates
answered 27-06-2019 05:45:54 -0400

How can I fetch all the list of dates between two dates ? Is there a system calendar that I can refer too ?

Answers: 1

Date

How to display three different tables(views) in a REST?
answered 26-06-2019 17:56:32 -0400

In our organization we are working in deploying a REST service, so I want to get three different tables by executing three different SQL SELECT statements in a single REST, but I was able to do REST for single view (i-e) for single SELECT statement, al...

Answers: 3

Push down not working in Dendo Version 7
answered 26-06-2019 08:31:56 -0400

we recently went though an upgrade from Denodo 6 to Denodo 7. We followed the migration guide provided by Denodo. All seemed to have worked. Data was flowing and users logging in. However, some users started placing queries that worked just fine in den...

Answers: 2

RANK Function Migration Rank QUERY_TIMEOUT Upgrade

offline datasource - dummy records?
answered 26-06-2019 07:48:39 -0400

If your connection is stale, or even worse when your connection to a datasource is offline/not available. But you do have views working on top of these datasources. Is it possible for Denodo to give you a "select X from dual()" dummy record back inst...

Answers: 1
Related to: Denodo JDBC Connection Pooling Implementation

dummy offline datasource DENODO

Load a Date Column using Scheduler
answered 26-06-2019 06:50:10 -0400

Hi , We tried creating a derived view which has a Date Type column and we are trying to load it to the database table which has a date type column in Oracle. Whenever we execute the job to load the data from Derived view to the table , we get the below...

Answers: 1

#Timestamp #DataLoad#SchedulerDataLoad#ScheduleDate#DateType

Denodo with Spark
answered 26-06-2019 06:47:21 -0400

Hi, I need to connect Denodo with Spark which is on Yarn. How to connect it? This Spark is not Database.

Answers: 2

How to get result in array or registered ?
answered 26-06-2019 02:06:07 -0400

SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...

Answers: 3

XPATH XML

Failure when using Denodo Testing Tool
answered 25-06-2019 12:41:30 -0400

I am trying to test denodo testing tool on one of the base views I have created on a local orable db installed on my pc. Everytime I try to run it, I am getting below error Test FAILED. Test raised an unexpected com.zaxxer.hikari.pool.HikariPool$PoolI...

Answers: 1

#Denodo #denodotestingtool #testingtool #denodo

Connecting to Denodo Server running in Azure with VDP Admin Tool not working
answered 25-06-2019 10:46:08 -0400

I can get ODBC and Restful connections to work fine (yay!) but the minute I try to use a JDBC or VDP Admin tool connection, I get a connection timeout. Any ideas why ODBC and restful connections work, but JDBC doesn't? I opened up ports 9090 and 9996...

Answers: 2